{"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 pidevalt rutiinseid toiminguid korrata? Mina mitte. Kuid iga kord, kui t\u00f6\u00f6tasin Rostelecomi andmebaasiga SQL-kliendiga, pidin ma k\u00e4sitsi kirjutama k\u00f5ik tabelite liitmisoperatsioonid. Ja see vaatamata sellele, et 90% juhtudel olid v\u00e4ljad ja liitmistingimused samad igas p\u00e4ringus! Tundub, et iga SQL-kliendi puhul on auto t\u00e4itmise funktsioon olemas, kuid andmebaaside puhul see alati ei t\u00f6\u00f6ta: nendes harva kasutatakse unikaalseid constraint'e ja v\u00e4lisv\u00f5tmeid j\u00f5udluse t\u00f5stmiseks, ilma milleta programm ei tea, kuidas olendid omavahel seotud on ja mida ta sulle pakkuda saab.<\/p>\n

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

P\u00e4rast eitamise, viha, kauplemise, masenduse l\u00e4bimist ja aktsepteerimise l\u00e4henemist otsustasin \u2014 miks mitte proovida ise autot\u00e4idet luua blackjacki ja korralikult? Kasutan dbeaveri klienti, mis on kirjutatud java keeles, sellel on avatud koodiga kogukonna versioon. Kokku k\u00fcpsenud plaan:
\n<\/a><\/noindex><\/p>\n

    \n
  1. Leida l\u00e4htekoodis klassid, mis vastutavad auto t\u00e4itmise eest<\/li>\n
  2. Taas suunata need t\u00f6\u00f6tama v\u00e4listest metaandmetest ja tuua sealt teavet liitumiste kohta<\/li>\n
  3. ??????<\/li>\n
  4. PROFIT<\/li>\n<\/ol>\n

    \nEsimese punktiga sain kiiresti hakkama \u2014 leidsin veahaldusest sisendi automaatse t\u00e4itmise parendamiseks ja seotud commit'i<\/a><\/noindex> leiutati SQLCompletionAnalyzer klass. Vaatasin koodi \u2014 just niinagu vaja. J\u00e4\u00e4nud oli see \u00fcmber kirjutada nii, et k\u00f5ik toimiks. Oodates vabakutset \u00f5htul, hakkasin ellu viima plaani. Otsustasin, et salvestan tabelite seosereeglid (metainformatsiooni) json-formaadis. Mul ei olnud praktilist kogemust selle formaadiga ning hetke\u00fclesanne tundus v\u00f5imalus seda puuduj\u00e4\u00e4ki t\u00e4ita. <\/p>\n

    Jsoniga t\u00f6\u00f6tamiseks otsustasin kasutada json-simple'i<\/a><\/noindex> Google'ilt. Siit hakkasid \u00fcllatused. Selgus, et dbeaver, t\u00f5eliselt rakendus, on kirjutatud Eclipse platvormil OSGi raamistikuga. Kogenud arendajatele toob see mugavuse s\u00f5ltuvuste haldamisel, kuid mulle oli see pigem nagu must maagia, milleks ma ei olnud ilmselgelt valmis: nagu alati, kirjutasin importi vajalikke klasse json-simple'ist redigeeritava klassi pealkirjas, m\u00e4rkisin selle pom.xml failis, p\u00e4rast mida projekt kategooriliselt keeldus normaalselt kokkutoomast ja kukkus vigadega. <\/p>\n

    Kompileerimisvead said lahendatud: teisinga teegi ei lisatud pom.xml faili, vaid manifeesti manifest.mf, nagu OSGI n\u00f5uab, m\u00e4rkides selle import-package'ina. Ei ole k\u00f5ige elegantsem lahendus, kuid t\u00f6\u00f6tab. Siis tuli j\u00e4rgmine \u00fcllatus. Kui te arendate IntelliJ IDEA's, ei saa te lihtsalt nii v\u00f5tta ja k\u00e4ivitada oma projekti silumist, mis p\u00f5hineb Eclipse'i platvormil: kogenematu arendaja peab kannatama sama palju, kui anal\u00fc\u00fctik, kellel pole automaatset t\u00e4iendamist. Appi tulid arendajad ise, kes t\u00f5id wiki's v\u00e4lja k\u00f5ik tantsud, mis tuleb l\u00e4bi viia. K\u00f5ige rohkem h\u00e4irib see, et isegi p\u00e4rast k\u00f5iki neid pingutusi ei soovinud projekt k\u00e4ivituda silumisre\u017eiimis, koos import-package'iga \u00fchendatud JSON teegiga (kuigi valmistoode kompileerus endiselt edukalt). <\/p>\n

    Selle ajaks olin juba kogenud JSON-i kasutamise ebamugavust oma \u00fclesande jaoks \u2014 l\u00f5ppude l\u00f5puks pidi metaandmeid k\u00e4sitsi redigeerima ja selleks sobib XML formaat paremini. Teiseks argumendiks XML-i kasuks oli JDK-s olemasolevate vajalike klasside hulk, mis andis v\u00f5imaluse l\u00f5petada v\u00f5itlus v\u00e4lise teegiga. Suure heameelega t\u00f5in k\u00f5ik metaandmed JSON-ist XML-i ja alustasin automaatse t\u00e4itmise loogika muutmist. <\/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
    Tulemuseks oli, et ma tegin muudatusi<\/a><\/noindex> klassides SQLUtils ja SQLCompletionAnalyzer. Idee on j\u00e4rgmine: kui programm ei suuda p\u00f5hiloogika kohaselt leida sobivaid automaatse t\u00e4itmise ettepanekuid, kontrollib ta, kas v\u00e4listest XML-failidest on v\u00f5imalik liitumisi. Failis hoitakse tabelite paare, m\u00e4rkides, milliste v\u00e4ljade j\u00e4rgi neid tabeleid siduda. Kande tehniliste kehtivuse kuup\u00e4evade eff_dttm ja exp_dttm piirangud ning loogilise kustutamise lipp deleted_ind m\u00e4\u00e4ratakse vaikimisi.<\/p>\n
    Kui koodis muudatused tehti, tuli k\u00fcsimus \u2014 kes t\u00e4idab metaandmete faili? Kataloogis on palju s\u00fcstemaatilisi \u00fcksusi ja nende k\u00f5igi sidumine on vaevan\u00f5udev. L\u00f5puks otsustasin selle \u00fclesande anda oma kolleegidele-anal\u00fc\u00fctikutele. Metaandmete faili panin svn-i, kust see t\u00f5mmatakse kohalikku kataloogi programmiga. Prinsip on j\u00e4rgmine: kui kataloogis on uus \u00fcksus? \u00dcks anal\u00fc\u00fctik lisab faili v\u00f5imalikke \u00fchendusi, paneb muudatused toime, teised t\u00f5mbavad endale ja naudivad t\u00f6\u00f6tavat automaatset t\u00e4itmist: kogukond, teadmiste kogumine ja k\u00f5ik muud head asjad. Viisin kolleegidele l\u00e4bi t\u00f6\u00f6tuba programmi kasutamisest, kirjutasin artikli Confluence'i \u2014 n\u00fc\u00fcd on ettev\u00f5ttes veel \u00fcks mugav t\u00f6\u00f6riist olemas.<\/p>\n
    T\u00f6\u00f6 selle funktsiooni kallal andis mulle arusaama, et ei tasu karta avatud allika projekte \u2014 \u00fcldiselt on nende arhitektuur arusaadav ja isegi p\u00f5hiteadmised keelest on katsetamiseks piisavad. Ja teatud sihikindluses suudab isegi vabaneda vihatud rutiinsetest operatsioonidest, s\u00e4\u00e4stes end 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 teha rutiinseid toiminguid? Mulle ei meeldi. Kuid iga kord, kui t\u00f6\u00f6tasin Rostelecomi andmebaasi SQL-klientis, pidin k\u00f5ik tabelite \u00fchendused k\u00e4sitsi kirjutama. Ja see vaatamata sellele, et 90% juhtudest olid tabelite v\u00e4ljad ja \u00fchendustingimused igas p\u00e4ringus samad! Tundub, et iga SQL-klientil on automaatse t\u00e4itmise funktsioonid, aga","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. \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","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"},"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}]}}