{"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\/hu\/blog\/administrirovanie\/kak-perestat-delat-odno-i-to-zhe","title":{"rendered":"Hogyan sz\u00fcntess\u00fck meg az ism\u00e9tl\u0151d\u00e9st?","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

Szereted \u00fajra \u00e9s \u00fajra megism\u00e9telni a rutinos m\u0171veleteket? \u00c9n nem. De minden alkalommal, amikor a Rosztelkom t\u00e1rol\u00f3j\u00e1val dolgoztam az SQL-kliensben, minden egyes kapcsolatra k\u00e9zzel kellett megadnom a t\u00e1bl\u00e1k k\u00f6z\u00f6tti \u00f6sszek\u00f6ttet\u00e9seket. Pedig az esetek 90%-\u00e1ban a mez\u0151k \u00e9s a t\u00e1bl\u00e1k \u00f6sszekapcsol\u00e1s\u00e1nak felt\u00e9telei az egyes lek\u00e9rdez\u00e9sekb\u0151l ad\u00f3d\u00f3an megegyeztek! \u00dagy t\u0171nik, b\u00e1rmelyik SQL-kliens rendelkezik automatikus kit\u00f6lt\u00e9s funkci\u00f3val, de a t\u00e1rol\u00f3k eset\u00e9ben ez nem mindig m\u0171k\u00f6dik: ritk\u00e1n \u00e1ll\u00edtanak be unique constraintet \u00e9s foreign keyt a teljes\u00edtm\u00e9ny n\u00f6vel\u00e9se \u00e9rdek\u00e9ben, \u00e9s en\u00e9lk\u00fcl a program nem tudja, hogyan kapcsol\u00f3dnak egym\u00e1shoz az entit\u00e1sok, \u00e9s mit javasolhat neked.<\/p>\n

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

Miut\u00e1n \u00e1testem a tagad\u00e1son, a haragon, a v\u00e1s\u00e1ron, a depresszi\u00f3n, \u00e9s k\u00f6zeledve az elfogad\u00e1shoz, \u00fagy d\u00f6nt\u00f6ttem \u2013 mi\u00e9rt ne pr\u00f3b\u00e1ln\u00e1m meg \u00e9n is az automatikus kit\u00f6lt\u00e9st blackjackkel \u00e9s a megfelel\u0151 m\u00f3don? \u00c9n a dbeaver klienssel dolgozom, amely java nyelven k\u00e9sz\u00fclt, van egy k\u00f6z\u00f6ss\u00e9gi verzi\u00f3ja is ny\u00edlt forr\u00e1ssal. \u00d6ssze\u00e1llt egy egyszer\u0171 terv:
\n<\/a><\/noindex><\/p>\n

    \n
  1. Megkeresni a forr\u00e1sk\u00f3dban az automatikus kit\u00f6lt\u00e9s\u00e9rt felel\u0151s oszt\u00e1lyokat<\/li>\n
  2. \u00c1tir\u00e1ny\u00edtani \u0151ket, hogy k\u00fcls\u0151 metadadatokkal dolgozzanak, \u00e9s onnan h\u00fazz\u00e1k be az inform\u00e1ci\u00f3t a csatlakoz\u00e1sokr\u00f3l<\/li>\n
  3. ??????<\/li>\n
  4. NYERES\u00c9G<\/li>\n<\/ol>\n

    \nAz els\u0151 ponttal viszonylag gyorsan v\u00e9geztem \u2014 tal\u00e1ltam a hibak\u00f6vet\u0151ben egy k\u00e9r\u00e9st az automatikus kit\u00f6lt\u00e9s jav\u00edt\u00e1s\u00e1ra, \u00e9s a kapcsol\u00f3d\u00f3 commitben<\/a><\/noindex> felfedeztem az SQLCompletionAnalyzer oszt\u00e1lyt. \u00c1tn\u00e9ztem a k\u00f3dot \u2013 \u00e9ppen az, amire sz\u00fcks\u00e9gem volt. Csak \u00e1t kellett \u00edrnom \u00fagy, hogy minden m\u0171k\u00f6dj\u00f6n. V\u00e1rtam egy szabad est\u00e9t, \u00e9s elkezdtem kidolgozni a megval\u00f3s\u00edt\u00e1st. A t\u00e1bl\u00e1k k\u00f6z\u00f6tti kapcsolatok szab\u00e1lyait (metadadatokat) json form\u00e1tumban akartam t\u00e1rolni. Nem volt gyakorlatom ezzel a form\u00e1tummal, \u00e9s a jelenlegi feladat lehet\u0151s\u00e9get adott arra, hogy ezt a hi\u00e1nyoss\u00e1got p\u00f3toljam. <\/p>\n

    A json kezel\u00e9s\u00e9re a json-simple<\/a><\/noindex> bibliot\u00e9k\u00e1t szerettem volna haszn\u00e1lni a Googlet\u00f3l. Itt kezd\u0151dtek a meglepet\u00e9sek. Mint kider\u00fclt, a dbeaver, mint igazi alkalmaz\u00e1s, az Eclipse platformon k\u00e9sz\u00fclt OSGi keretrendszer haszn\u00e1lat\u00e1val. A tapasztalt fejleszt\u0151k sz\u00e1m\u00e1ra ez a dolog k\u00e9nyelmesen kezeli a f\u00fcgg\u0151s\u00e9geket, sz\u00e1momra viszont ink\u00e1bb s\u00f6t\u00e9t var\u00e1zslatnak t\u0171nt, amire egy\u00e9rtelm\u0171en nem voltam felk\u00e9sz\u00fclve: \u00e1ltal\u00e1ban egyszer\u0171en meg\u00edrom a sz\u00fcks\u00e9ges json-simple oszt\u00e1lyok importj\u00e1t a m\u00f3dos\u00edtand\u00f3 oszt\u00e1ly fejl\u00e9c\u00e9ben, megadom a pom.xml-ben, majd a projekt kategorikusan nem hajland\u00f3 norm\u00e1lisan \u00f6sszegy\u0171lni, \u00e9s hib\u00e1kkal \u00f6sszeomlik. <\/p>\n

    A build error was fixed: the library was declared not in pom.xml, but in the manifest manifest.mf, as required by OSGI, indicating it as an import-package. It's not the prettiest solution, but it works. Then a new surprise appeared. If you're developing in IntelliJ IDEA, you can't just run the debug of your project based on the Eclipse platform: an inexperienced developer must suffer as much as an analyst without query autocompletion. The Beaver developers helped by detailing the necessary steps in the wiki. The most frustrating part is that even after all this, the project refused to start in debug mode with the JSON library connected via import-package (even though it successfully built into the final product). <\/p>\n

    By that time, I had experienced the inconvenience of using JSON for my task \u2014 after all, the metadata was supposed to be edited manually, and the XML format fits that purpose better. A second argument for XML was the availability of all necessary classes in the JDK, which allowed me to stop struggling with the external library. I happily transferred all the metadata from JSON to XML and began editing the autocompletion logic. <\/p>\n

    Example of metadata<\/b><\/p>\n

    dim_account\n        dim_partner\n        \n        \n    \n    \n        dim_account\n        dim_branch<\/code><\/pre>\n
    As a result, I made changes<\/a><\/noindex> to the SQLUtils and SQLCompletionAnalyzer classes. The idea is this: if the program fails to find suitable autocompletion suggestions through its basic logic, it checks for possible joins based on the external XML file. The file contains pairs of tables with fields that need to be linked. By default, the technical date constraints for the records, eff_dttm and exp_dttm, and the logical deletion flag, deleted_ind, are set automatically.<\/p>\n
    Amikor a k\u00f3dba m\u00f3dos\u00edt\u00e1sokat v\u00e9geztek, felmer\u00fclt a k\u00e9rd\u00e9s \u2014 ki fogja kit\u00f6lteni a metaadatf\u00e1jlt? Az adatt\u00e1rban sok entit\u00e1s van, nem lenne gazdas\u00e1gos mindet manu\u00e1lisan \u00f6sszekapcsolni. V\u00e9g\u00fcl \u00fagy d\u00f6nt\u00f6ttem, hogy ezt a feladatot a koll\u00e9ga-analitikusaimra b\u00edzom. A metaadatf\u00e1jlt felt\u00f6lt\u00f6ttem az svn-re, ahonnan a program lok\u00e1lis mapp\u00e1j\u00e1ba t\u00f6rt\u00e9nik a checkout. Az elv a k\u00f6vetkez\u0151: megjelent egy \u00faj entit\u00e1s az adatt\u00e1rban? Egy analitikus bejegyzi a lehets\u00e9ges kapcsol\u00f3d\u00e1sokat a f\u00e1jlba, elk\u00f6telezi a v\u00e1ltoztat\u00e1sokat, a t\u00f6bbiek pedig checkout-ot v\u00e9geznek maguknak, \u00e9s \u00f6r\u00f6mmel \u00e9lvezik az automatikus kit\u00f6lt\u00e9st: k\u00f6z\u00f6ss\u00e9g, tud\u00e1s felhalmoz\u00e1s \u00e9s hasonl\u00f3k. Workshopot tartottam a koll\u00e9g\u00e1k sz\u00e1m\u00e1ra a program haszn\u00e1lat\u00e1r\u00f3l, \u00edrtam egy cikket a Confluence-be \u2014 most m\u00e1r van a c\u00e9gnek egy \u00faj, k\u00e9nyelmes eszk\u00f6ze.<\/p>\n
    A funkci\u00f3n val\u00f3 munka sor\u00e1n meg\u00e9rtettem, hogy nem \u00e9rdemes f\u00e9lni az open source projektek bogar\u00e1sz\u00e1s\u00e1t\u00f3l \u2014 \u00e1ltal\u00e1ban \u00e9rthet\u0151 architekt\u00far\u00e1val rendelkeznek, \u00e9s m\u00e9g a nyelv alapvet\u0151 ismeretei is elegend\u0151ek lesznek k\u00eds\u00e9rletez\u00e9shez. Ha pedig megvan a kell\u0151 kitart\u00e1s, ak\u00e1r a gy\u0171l\u00f6lt rutinfeladatokt\u00f3l is megszabadulhatunk, id\u0151t sp\u00f3rolva az \u00faj k\u00eds\u00e9rletekre.
    \n
    Forr\u00e1s:     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\udd47Hogyan hagyja abba az ism\u00e9tl\u0151d\u0151 m\u0171veletek v\u00e9grehajt\u00e1s\u00e1t | ProHoster","description":"\u00d6n is szeret rutinfeladatokat v\u00e9gezni \u00fajra \u00e9s \u00fajra? \u00c9n biztosan nem. De minden alkalommal, amikor a Rosztelekom adatt\u00e1r\u00e1val dolgoztam az SQL-\u00fcgyf\u00e9lben, mindent k\u00e9zzel kellett \u00f6sszekapcsolnom a t\u00e1bl\u00e1k k\u00f6z\u00f6tt.","canonical_url":"https:\/\/prohoster.info\/hu\/blog\/administrirovanie\/kak-perestat-delat-odno-i-to-zhe","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"hu_HU","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\/hu\/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\/hu\/wp-json\/wp\/v2\/posts\/36795","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/comments?post=36795"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/posts\/36795\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/media\/27562"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/media?parent=36795"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/categories?post=36795"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/tags?post=36795"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}