{"id":36795,"date":"2019-10-31T22:13:50","date_gmt":"2019-10-31T19:13:50","guid":{"rendered":"https:\/\/prohoster.info\/blog\/kak-perestat-delat-odno-i-to-zhe\/"},"modified":"2019-10-31T22:13:50","modified_gmt":"2019-10-31T19:13:50","slug":"kak-perestat-delat-odno-i-to-zhe","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sk\/blog\/administrirovanie\/kak-perestat-delat-odno-i-to-zhe","title":{"rendered":"Ako presta\u0165 robi\u0165 to ist\u00e9","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

Nem\u00e1te radi neust\u00e1le opakova\u0165 rutinn\u00e9 oper\u00e1cie? Ani ja nie. Ale zaka\u017ed\u00fdm pri pr\u00e1ci s \u00falo\u017eiskom Rostelecom v SQL klientovi som musel ru\u010dne zap\u00edsa\u0165 v\u0161etky spojenia medzi tabu\u013ekami. A to aj napriek tomu, \u017ee v 90% pr\u00edpadov sa polia a podmienky spojenia tabuliek zhodovali od po\u017eiadavky k po\u017eiadavke! Zdalo by sa, \u017ee ka\u017ed\u00fd SQL klient m\u00e1 funkcie automatick\u00e9ho dopl\u0148ovania, ale pre \u00falo\u017eisk\u00e1 to nie v\u017edy funguje: zriedka sa zav\u00e1dzaj\u00fa unique constraint a foreign key za \u00fa\u010delom zv\u00fd\u0161enia v\u00fdkonu, a bez toho program nevie, ako s\u00fa entity navz\u00e1jom prepojen\u00e9 a \u010do ti m\u00f4\u017ee pon\u00faknu\u0165.<\/p>\n

\"Ako<\/a><\/noindex><\/p>\n

Po prechode cez popieranie, hnev, vyjedn\u00e1vanie, depresiu a bl\u00ed\u017eiac sa k akcept\u00e1cii, som sa rozhodol - pre\u010do si to s\u00e1m nesk\u00fasi\u0165 implementova\u0165 automatick\u00e9 dopl\u0148ovanie s blackjackom a poriadne? Pou\u017e\u00edvam klienta dbeaver, nap\u00edsan\u00e9ho v jave, m\u00e1 verziu komunity s otvoren\u00fdm zdrojov\u00fdm k\u00f3dom. Vymyslel som jednoduch\u00fd pl\u00e1n:
\n<\/a><\/noindex><\/p>\n

    \n
  1. N\u00e1js\u0165 v zdrojovom k\u00f3de triedy zodpovedaj\u00face za automatick\u00e9 dopl\u0148ovanie<\/li>\n
  2. Preorientova\u0165 ich na pr\u00e1cu s extern\u00fdmi metad\u00e1tami a \u0165aha\u0165 odtia\u013e inform\u00e1cie o spojeniach<\/li>\n
  3. ??????<\/li>\n
  4. PROFIT<\/li>\n<\/ol>\n

    \nS prv\u00fdm bodom som sa dos\u0165 r\u00fdchlo vyrovnal - na\u0161iel som v bugtrackeri po\u017eiadavku na opravu automatick\u00e9ho dopl\u0148ovania a v s\u00favisiacom komite<\/a><\/noindex> som objavil triedu SQLCompletionAnalyzer. Pozrel som sa na k\u00f3d - presne to, \u010do potrebujem. Zostalo len prep\u00edsa\u0165 ho tak, aby v\u0161etko fungovalo. \u010cakal som na vo\u013en\u00fd ve\u010der a za\u010dal prem\u00fd\u0161\u013ea\u0165 nad realiz\u00e1ciou. Pravidl\u00e1 spojen\u00ed tabuliek (metad\u00e1ta) som sa rozhodol uchov\u00e1va\u0165 v json. Nemal som praktick\u00e9 sk\u00fasenosti s t\u00fdmto form\u00e1tom a aktu\u00e1lna \u00faloha sa mi javila ako pr\u00edle\u017eitos\u0165 tento nedostatok napravi\u0165. <\/p>\n

    Na pr\u00e1cu s json som sa rozhodol pou\u017ei\u0165 kni\u017enicu json-simple<\/a><\/noindex> od Googlu. Tu za\u010dali prekvapenia. Ako sa uk\u00e1zalo, dbeaver, ako prav\u00e9 aplik\u00e1cie, je nap\u00edsan\u00fd na platforme Eclipse s pou\u017eit\u00edm OSGi r\u00e1mca. Pre sk\u00fasen\u00fdch v\u00fdvoj\u00e1rov t\u00e1to vec poskytuje pohodlie spr\u00e1vy z\u00e1vislost\u00ed, ale pre m\u0148a vyzerala sk\u00f4r ako \u010dierna m\u00e1gia, na ktor\u00fa som nebol v\u00f4bec pripraven\u00fd: ako obvykle som uviedol import potrebn\u00fdch tried z kni\u017enice json-simple na za\u010diatku upravovanej triedy, uviedol ju do pom.xml, po \u010dom projekt kateg\u00f3ricky odmietal norm\u00e1lne sa zostavi\u0165 a padal s chybami. <\/p>\n

    Opravenie ch\u00fdb pri zostavovan\u00ed skon\u010dilo takto: kni\u017enicu som zap\u00edsal nie do pom.xml, ale do manifestu manifest.mf, ako to vy\u017eaduje OSGI, pri\u010dom som ju uviedol ako import-package. Nie je to najkraj\u0161ie rie\u0161enie, ale funguje. Tu sa objavil \u010fal\u0161\u00ed prekvapenie. Ak vyv\u00edjate v intellij idea, nem\u00f4\u017eete len tak spusti\u0165 ladenie svojho projektu zalo\u017een\u00e9ho na platforme eclipse: nezku\u0161en\u00fd v\u00fdvoj\u00e1r by mal trpie\u0165 rovnako, ako analytik bez automatick\u00e9ho doplnenia dotazov. Na pomoc pri\u0161li sami v\u00fdvoj\u00e1ri bobra, ktor\u00ed uviedli na wiki v\u0161etky tance s bubnom, ktor\u00e9 treba vykona\u0165. Najviac mrz\u00ed, \u017ee aj po v\u0161etk\u00fdch t\u00fdchto presed\u00e1vaniach sa projekt nechcel spusti\u0165 v laden\u00ed s pripojenou kni\u017enicou json cez import-package (pritom, \u017ee v fin\u00e1lnom produkte sa aj na\u010falej \u00faspe\u0161ne zostavoval). <\/p>\n

    V tom \u010dase som u\u017e c\u00edtil nekomfortnos\u0165 pou\u017e\u00edvania json pre moju \u00falohu \u2013 nakoniec, metadata sa pl\u00e1novali upravova\u0165 ru\u010dne a na to form\u00e1t xml lep\u0161ie vyhovuje. Druh\u00fdm argumentom v prospech xml bolo, \u017ee v JDK s\u00fa v\u0161etky potrebn\u00e9 triedy, \u010do mi umo\u017enilo presta\u0165 bojova\u0165 s externou kni\u017enicou. S ve\u013ek\u00fdm pote\u0161en\u00edm som preniesol v\u0161etky metadata z json do xml a pustil sa do \u00faprav logiky automatick\u00e9ho doplnenia. <\/p>\n

    Pr\u00edklad metad\u00e1t<\/b><\/p>\n

    dim_account\n        dim_partner\n        \n        \n    \n    \n        dim_account\n        dim_branch<\/code><\/pre>\n
    V d\u00f4sledku toho som vykonal zmeny<\/a><\/noindex> v triedach SQLUtils a SQLCompletionAnalyzer. My\u0161lienka je tak\u00e1: ak sa programu nepodar\u00ed priradi\u0165 vhodn\u00e9 n\u00e1vrhy automatick\u00e9ho doplnenia pod\u013ea z\u00e1kladnej logiky, skontroluje pr\u00edtomnos\u0165 mo\u017en\u00fdch spojen\u00ed pod\u013ea extern\u00e9ho s\u00faboru xml. V samotnom s\u00fabore s\u00fa ulo\u017een\u00e9 p\u00e1ry tabuliek so \u0161pecifikovan\u00fdmi poliami, pod\u013ea ktor\u00fdch je potrebn\u00e9 tieto tabu\u013eky prepoji\u0165. Obmedzenia na technick\u00e9 d\u00e1ta \u00fa\u010dinnosti z\u00e1znamov eff_dttm a exp_dttm a prapor logick\u00e9ho vymazania deleted_ind sa pritom nastavuj\u00fa predvolene.<\/p>\n
    Ke\u010f boli do k\u00f3du zapracovan\u00e9 \u00fapravy, objavila sa ot\u00e1zka \u2014 kto napln\u00ed s\u00fabor s metad\u00e1tami? V \u00falo\u017eisku je ve\u013ea ent\u00edt, ru\u010dne zapisova\u0165 v\u0161etky v\u00e4zby by bolo n\u00e1ro\u010dn\u00e9. Nakoniec som sa rozhodol zveri\u0165 t\u00fato \u00falohu svojim kolegom analytikom. S\u00fabor metad\u00e1t som zverejnil v svn, odkia\u013e sa rob\u00ed checkout do lok\u00e1lneho adres\u00e1ra s programom. Princ\u00edp je tak\u00fd: objavila sa v \u00falo\u017eisku nov\u00e1 entita? Jeden analytik prid\u00e1 mo\u017en\u00e9 joiny do s\u00faboru, commitne zmeny, ostatn\u00ed si urobia checkout a u\u017e\u00edvaj\u00fa si funkciu automatick\u00e9ho vyplnenia: komunita, akumul\u00e1cia vedomost\u00ed a tak \u010falej. Urobil som workshop pre kolegov o pou\u017e\u00edvan\u00ed programu, nap\u00edsal som \u010dl\u00e1nok do Confluence \u2014 teraz m\u00e1 spolo\u010dnos\u0165 jeden pohodln\u00fd n\u00e1stroj navy\u0161e.<\/p>\n
    Pr\u00e1ca na tejto funkcii mi dala pochopenie, \u017ee sa nemus\u00edme b\u00e1\u0165 sk\u00fama\u0165 open-source projekty \u2014 zvy\u010dajne maj\u00fa jasn\u00fa architekt\u00faru a na experimenty sta\u010d\u00ed aj z\u00e1kladn\u00e1 znalos\u0165 jazyka. A s ur\u010ditou d\u00e1vkou vytrvalosti je mo\u017en\u00e9 zbavi\u0165 sa nen\u00e1viden\u00fdch rutinn\u00fdch oper\u00e1ci\u00ed, \u010do u\u0161etr\u00ed \u010das na nov\u00e9 experimenty.
    \n
    Zdroj:     habr.com<\/a><\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"
    \u0412\u044b \u043b\u044e\u0431\u0438\u0442\u0435 \u0438\u0437 \u0440\u0430\u0437\u0430 \u0432 \u0440\u0430\u0437 \u043f\u043e\u0432\u0442\u043e\u0440\u044f\u0442\u044c \u0440\u0443\u0442\u0438\u043d\u043d\u044b\u0435 \u043e\u043f\u0435\u0440\u0430\u0446\u0438\u0438? \u0412\u043e\u0442 \u0438 \u044f \u043d\u0435\u0442. \u041d\u043e \u043a\u0430\u0436\u0434\u044b\u0439 \u0440\u0430\u0437 \u0432 SQL-\u043a\u043b\u0438\u0435\u043d\u0442\u0435 \u043f\u0440\u0438 \u0440\u0430\u0431\u043e\u0442\u0435 \u0441 \u0445\u0440\u0430\u043d\u0438\u043b\u0438\u0449\u0435\u043c \u0420\u043e\u0441\u0442\u0435\u043b\u0435\u043a\u043e\u043c\u0430 \u043f\u0440\u0438\u0445\u043e\u0434\u0438\u043b\u043e\u0441\u044c \u043f\u0440\u043e\u043f\u0438\u0441\u044b\u0432\u0430\u0442\u044c \u0432\u0441\u0435 \u0434\u0436\u043e\u0439\u043d\u044b \u043c\u0435\u0436\u0434\u0443 \u0442\u0430\u0431\u043b\u0438\u0446\u0430\u043c\u0438 \u0440\u0443\u0447\u043a\u0430\u043c\u0438. \u0418 \u044d\u0442\u043e \u043f\u0440\u0438\u0442\u043e\u043c, \u0447\u0442\u043e \u0432 90% \u0441\u043b\u0443\u0447\u0430\u0435\u0432 \u043f\u043e\u043b\u044f \u0438 \u0443\u0441\u043b\u043e\u0432\u0438\u044f \u0441\u043e\u0435\u0434\u0438\u043d\u0435\u043d\u0438\u044f \u0442\u0430\u0431\u043b\u0438\u0446 \u0441\u043e\u0432\u043f\u0430\u0434\u0430\u043b\u0438 \u043e\u0442 \u0437\u0430\u043f\u0440\u043e\u0441\u0430 \u043a \u0437\u0430\u043f\u0440\u043e\u0441\u0443! \u041a\u0430\u0437\u0430\u043b\u043e\u0441\u044c \u0431\u044b, \u043b\u044e\u0431\u043e\u0439 SQL-\u043a\u043b\u0438\u0435\u043d\u0442 \u0438\u043c\u0435\u0435\u0442 \u0444\u0443\u043d\u043a\u0446\u0438\u0438 \u0430\u0432\u0442\u043e\u0437\u0430\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u044f, \u043d\u043e […]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":27562,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-36795","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-administrirovanie"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\n","aioseo_head_json":{"title":"\ud83e\udd47Ako presta\u0165 robi\u0165 st\u00e1le to ist\u00e9 | ProHoster","description":"Radi opakujete rutinn\u00e9 oper\u00e1cie st\u00e1le dookola? Ja ur\u010dite nie. Ale zaka\u017ed\u00fdm v SQL kliens, pri pr\u00e1ci s \u00falo\u017eiskom Rostelecom, som musel ru\u010dne zapisova\u0165 v\u0161etky joiny medzi tabu\u013ekami.","canonical_url":"https:\/\/prohoster.info\/sk\/blog\/administrirovanie\/kak-perestat-delat-odno-i-to-zhe","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"sk_SK","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47\u041a\u0430\u043a \u043f\u0435\u0440\u0435\u0441\u0442\u0430\u0442\u044c \u0434\u0435\u043b\u0430\u0442\u044c \u043e\u0434\u043d\u043e \u0438 \u0442\u043e \u0436\u0435 | ProHoster","og:description":"\u0412\u044b \u043b\u044e\u0431\u0438\u0442\u0435 \u0438\u0437 \u0440\u0430\u0437\u0430 \u0432 \u0440\u0430\u0437 \u043f\u043e\u0432\u0442\u043e\u0440\u044f\u0442\u044c \u0440\u0443\u0442\u0438\u043d\u043d\u044b\u0435 \u043e\u043f\u0435\u0440\u0430\u0446\u0438\u0438? \u0412\u043e\u0442 \u0438 \u044f \u043d\u0435\u0442. \u041d\u043e \u043a\u0430\u0436\u0434\u044b\u0439 \u0440\u0430\u0437 \u0432 SQL-\u043a\u043b\u0438\u0435\u043d\u0442\u0435 \u043f\u0440\u0438 \u0440\u0430\u0431\u043e\u0442\u0435 \u0441 \u0445\u0440\u0430\u043d\u0438\u043b\u0438\u0449\u0435\u043c \u0420\u043e\u0441\u0442\u0435\u043b\u0435\u043a\u043e\u043c\u0430 \u043f\u0440\u0438\u0445\u043e\u0434\u0438\u043b\u043e\u0441\u044c \u043f\u0440\u043e\u043f\u0438\u0441\u044b\u0432\u0430\u0442\u044c \u0432\u0441\u0435 \u0434\u0436\u043e\u0439\u043d\u044b \u043c\u0435\u0436\u0434\u0443 \u0442\u0430\u0431\u043b\u0438\u0446\u0430\u043c\u0438 \u0440\u0443\u0447\u043a\u0430\u043c\u0438.","og:url":"https:\/\/prohoster.info\/sk\/blog\/administrirovanie\/kak-perestat-delat-odno-i-to-zhe","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2019-10-31T19:13:50+00:00","article:modified_time":"2019-10-31T19:13:50+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"36795","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":"2026-01-22 04:53:19","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-03-01 01:38:24","updated":"2026-01-22 04:53:19","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/posts\/36795","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/comments?post=36795"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/posts\/36795\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/media\/27562"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/media?parent=36795"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/categories?post=36795"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/tags?post=36795"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}