{"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\/et\/blog\/administrirovanie\/kak-perestat-delat-odno-i-to-zhe","title":{"rendered":"Kuidas l\u00f5petada sama asja tegemine","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

Kas sa armastad rutiinseid toiminguid j\u00e4rjestikku kordama? Mina kindlasti mitte. Kuid iga kord, kui t\u00f6\u00f6tasin Rostelecomi andmebaasis SQL-kliendis, pidin kirjutama k\u00f5ik tabelite \u00fchendused k\u00e4sitsi. Ja sellegipoolest, 90% juhtudest olid tabelite \u00fchendamise v\u00e4ljad ja tingimused iga p\u00e4ringu puhul samad! Tundub, et igal SQL-kliendil on automaatse t\u00e4itmise funktsioonid, kuid andmebaasides ei t\u00f6\u00f6ta see alati: seal on harva unikaalsed piirangud ja v\u00e4lisv\u00f5tmed tulemuslikkuse suurendamiseks, ning ilma nendeta ei tea programm, kuidas entiteedid omavahel seotud on ja mida ta sulle pakkuda saab.<\/p>\n

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

P\u00e4rast eitamist, viha, kauplemist, depressiooni ja l\u00e4henemist aktsepteerimisele otsustasin \u2014 miks mitte proovida automatiseeritud t\u00e4itmist mustade kaartide ja k\u00f5igi asjadega? Kasutan Java-s kirjutatud dbeaveri klienti, millel on avatud l\u00e4htekoodiga kogukonna versioon. Olin v\u00e4lja m\u00f5elnud lihtsa plaani:
\n<\/a><\/noindex><\/p>\n

    \n
  1. Leida avatud koodi klassid, mis vastutavad automaatse t\u00e4itmise eest<\/li>\n
  2. Suunata need t\u00f6\u00f6tama v\u00e4liste metaandmete kallal ja t\u00f5mmata sealt \u00fchenduste kohta teavet<\/li>\n
  3. ??????<\/li>\n
  4. PROFIT<\/li>\n<\/ol>\n

    \nEsimese punktiga sain piisavalt kiiresti hakkama \u2014 leidsin veaaruandest soovi automaatse t\u00e4itmise kohandamiseks ja seotud commit'ist<\/a><\/noindex> avastasin klassi SQLCompletionAnalyzer. Vaatasin koodi \u2014 t\u00e4pselt see, mida vajan. J\u00e4i \u00fcle see \u00fcmber kirjutada, et k\u00f5ik t\u00f6\u00f6taks. Ootasin vaba \u00f5htut ja hakkasin teostust l\u00e4bi m\u00f5tlema. Tabelite seosereeglid (metaandmed) otsustasin viia json-formaadis. Mul ei olnud selle formaadi suhtes praktilisi kogemusi ja praegune \u00fclesanne tundus v\u00f5imalus selle puuduj\u00e4\u00e4gi parandamiseks. <\/p>\n

    JSON-i t\u00f6\u00f6tlemiseks otsustasin kasutada teeki json-simple<\/a><\/noindex> Googlest. Siin hakkasid \u00fcllatused pihta. Kuidas selgus, on dbeaver, nagu t\u00f5eline rakendus, kirjutatud Eclipse'i platvormil kasutades OSGi raamistikku. Kogemustega arendajatele pakub see mugavust s\u00f5ltuvuste haldamisel, ent minu jaoks n\u00e4is see rohkem tumeda maagia sarnane, millega ma kindlasti ei olnud valmis tegelema: tavaliselt kirjutan vajalike klasside impordi json-simple teegist redigeeritava klassi pealkirja, m\u00e4\u00e4ran selle pom.xml-is, kuid seej\u00e4rel keeldub projekt normaalselt kogunemast ja kukub vigadega kokku. <\/p>\n

    Kohandmine ehitusvigu l\u00f5puks selgus: ma registreerisin teegi mitte pom.xml-is, vaid manifest.mf-is, nagu n\u00f5uab OSGI, m\u00e4rkides selle import-package'ina. See pole k\u00f5ige kaunim lahendus, aga t\u00f6\u00f6tab. Siin ilmus j\u00e4rgmine \u00fcllatus. Kui sa teed arendust intellij idea's, ei saa lihtsalt niisama v\u00f5tta ja k\u00e4ivitada oma projekti h\u00e4\u00e4lestust, mis p\u00f5hineb eclipse'i platvormil: kogenematu arendaja peab kannatama mitte v\u00e4hem kui anal\u00fc\u00fctik ilma automaatse p\u00e4ringu t\u00e4iendamiseta. Appi tulid isegi bobri arendajad, kes on wikis v\u00e4lja toonud k\u00f5ik nende tantsud, mida on vaja teha. K\u00f5ige kurvem on see, et isegi p\u00e4rast k\u00f5iki neid h\u00fcppeid ei soovinud projekt k\u00e4ivituda h\u00e4\u00e4lestuses import-package kaudu laaditud json teegiga (kuigi valmis toode kogunes endiselt edukalt). <\/p>\n

    Sel hetkel olin juba tundnud ebamugavust json'i kasutamisest minu \u00fclesande jaoks \u2014 l\u00f5puks pidi metaandmeid k\u00e4sitsi redigeerima, ja selleks sobib xml formaat paremini. Teiseks argumendiks xml kasuks oli vajalikud klassid, mis olid olemas JDK-s, mis v\u00f5imaldas l\u00f5petada v\u00e4lise teegi v\u00f5itluse. Suure r\u00f5\u00f5muga kolisin k\u00f5ik metaandmed json'ist xml'i ja hakkasin autofill loogika redigeerimisega tegelema. <\/p>\n

    Metaandmete n\u00e4ide<\/b><\/p>\n

    dim_account\n        dim_partner\n        \n        \n    \n    \n        dim_account\n        dim_branch<\/code><\/pre>\n
    Kokkuv\u00f5ttes ma sain muudatused tehtud<\/a><\/noindex> SQLUtils ja SQLCompletionAnalyzer klassidesse. Idee on j\u00e4rgmine: kui programm ei suutnud leida sobivaid autofill ettepanekuid aluselogi j\u00e4rgi, kontrollib see v\u00f5imalike \u00fchenduste olemasolu v\u00e4lises xml failis. Failis hoitakse tabelite paare koos v\u00e4lja nimedega, mille kaudu need tabelid tuleb seostada. Tehniliste kuup\u00e4evade piirangud registreerimise eff_dttm ja exp_dttm ning loogilise kustutamise flaga deleted_ind on seejuures vaikimisi seadistatud.<\/p>\n
    Kui koodimuudatused on tehtud, tekkis k\u00fcsimus - kes hakkab t\u00e4itma metadata faili? Andmehoidlas on palju objekte ja k\u00f5iki seoseid ise \u00fcles kirjutada on t\u00fclikas. L\u00f5puks otsustasin selle \u00fclesande oma kolleegidele anal\u00fc\u00fctikutele anda. Metaandmete faili panin svn-i, kust tehakse checkout kohalikku kausta programmiga. P\u00f5him\u00f5te on selline: kui andmehoidlas tekib uus objekt? \u00dcks anal\u00fc\u00fctik lisab faili v\u00f5imalikud seosed, kommitab muudatused, teised teevad checkout enda juurde ja naudivad t\u00f6\u00f6tavat automaatset t\u00e4itmist: kogukond, teadmiste kogumine ja k\u00f5ik selline. Kolleegidele tegin t\u00f6\u00f6toa programmi kasutamiseks, kirjutasin artikli Confluence'i - n\u00fc\u00fcd on firmas \u00fcks mugavam t\u00f6\u00f6riist rohkem.<\/p>\n
    T\u00f6\u00f6 selle funktsiooni kallal andis mulle aru, et ei tasu karta avatud l\u00e4htekoodiga projektides nurgataguste kaevamist - tavaliselt on neil arusaadav arhitektuur ja isegi baaskeele teadmised on katsetamiseks piisavad. Ja teatud m\u00e4\u00e4ral visadust kasutades saab lahti unustatud rutiinsetest operatsioonidest, s\u00e4\u00e4stes aega uute katsetuste jaoks.
    \n
    Allikas:     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\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\udd47Kuidas l\u00f5petada sama asja tegemine | ProHoster","description":"Kas teile meeldib pidevalt rutiinseid operatsioone korrata? Mulle k\u00fcll mitte. Kuid iga kord SQL-klientis t\u00f6\u00f6tades Rostelecomi andmehoidlaga tuli k\u00f5ik tabelite vaheajad k\u00e4sitsi \u00fcles kirjutada.","canonical_url":"https:\/\/prohoster.info\/et\/blog\/administrirovanie\/kak-perestat-delat-odno-i-to-zhe","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"et_EE","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\/et\/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\/et\/wp-json\/wp\/v2\/posts\/36795","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/comments?post=36795"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts\/36795\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/media\/27562"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/media?parent=36795"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/categories?post=36795"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/tags?post=36795"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}