{"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\/sq\/blog\/administrirovanie\/kak-perestat-delat-odno-i-to-zhe","title":{"rendered":"Si t\u00eb ndaloni s\u00eb b\u00ebri t\u00eb nj\u00ebjt\u00ebn gj\u00eb","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

A e \u00ebmb\u00eblsoni t\u00eb p\u00ebrs\u00ebrisni operacione rutin\u00eb nga nj\u00eb her\u00eb n\u00eb tjetr\u00ebn? Edhe un\u00eb jo. Por \u00e7do her\u00eb n\u00eb klientin SQL, kur punoja me depozitat e Rostelecom, m\u00eb duhej t\u00eb shkruaja dorazi t\u00eb gjitha bashkimet midis tabelave. Dhe kjo, duke pasur parasysh se n\u00eb 90% t\u00eb rasteve fushat dhe kushtet e lidhjes s\u00eb tabelave p\u00ebrputheshin nga pyetja n\u00eb pyetje! Duke u par\u00eb, \u00e7do klient SQL ka funksione automatik t\u00eb plot\u00ebsimit, por p\u00ebr depozitat nuk funksionon gjithmon\u00eb: rrall\u00eb ndodhin unik\u00eb t\u00eb kufizimit dhe \u00e7eliku t\u00eb huaj me q\u00ebllim p\u00ebr t\u00eb rritur performanc\u00ebn, dhe pa k\u00ebt\u00eb, programi nuk mund t\u00eb dij\u00eb se si lidhen nj\u00ebsit\u00eb dhe \u00e7far\u00eb mund t\u00eb t\u00eb propozoj\u00eb.<\/p>\n

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

Pas kalimit p\u00ebrmes mohimit, zem\u00ebrimit, tregtis\u00eb, depresionit dhe duke i afruar pranimit, vendosa - pse t\u00eb mos provoj t\u00eb realizoj plot\u00ebsim automat me blackjack dhe si\u00e7 duhet? Un\u00eb p\u00ebrdor klientin dbeaver, i shkruar n\u00eb java, i cili ka nj\u00eb version komuniteti me kod t\u00eb hapur. Kisha nj\u00eb plan t\u00eb thjesht\u00eb:
\n<\/a><\/noindex><\/p>\n

    \n
  1. T\u00eb gjej n\u00eb kodin burimor klasat q\u00eb jan\u00eb p\u00ebrgjegj\u00ebse p\u00ebr plot\u00ebsimin automat<\/li>\n
  2. T'i riorientoj p\u00ebr t\u00eb punuar me metad\u00ebta t\u00eb jashtme dhe t\u00eb t\u00ebrheq informacionin p\u00ebr bashkimet nga aty<\/li>\n
  3. ??????<\/li>\n
  4. P\u00cbRFITIM<\/li>\n<\/ol>\n

    \nMe pik\u00ebn e par\u00eb u orientova mjaft shpejt - gjeta n\u00eb ndihm\u00ebn e gabimeve nj\u00eb k\u00ebrkes\u00eb p\u00ebr rregullimin e plot\u00ebsimit automat dhe n\u00eb lidhjen e saj n\u00eb komit<\/a><\/noindex> e gjeta klas\u00ebn SQLCompletionAnalyzer. E shihja kodin - ishte ashtu si\u00e7 duhej. Mbeta p\u00ebr t\u00eb shkruar at\u00eb q\u00eb t\u00eb gjitha t\u00eb funksiononin. Prisja nj\u00eb mbr\u00ebmje t\u00eb lir\u00eb dhe fillova t\u00eb planifikoj realizimin. Rregullat e lidhjeve t\u00eb tabelave (metadat\u00eb) vendosa t'i mbaj n\u00eb json. Nuk kisha p\u00ebrvoj\u00eb praktike n\u00eb pun\u00ebn me k\u00ebt\u00eb format dhe detyra aktuale dukej si nj\u00eb mund\u00ebsi p\u00ebr t\u00eb korrigjuar k\u00ebt\u00eb mang\u00ebsi. <\/p>\n

    P\u00ebr t\u00eb punuar me json vendosa t\u00eb p\u00ebrdor librarin\u00eb json-simple<\/a><\/noindex> nga gugl. K\u00ebtu filluan surprizat. Si\u00e7 u zbulua, dbeaver, si nj\u00eb aplikacion t\u00eb v\u00ebrtet\u00eb, \u00ebsht\u00eb shkruar n\u00eb platform\u00ebn e ekaliptit me p\u00ebrdorimin e korniz\u00ebs OSGi. P\u00ebr zhvilluesit e p\u00ebrvojsh\u00ebm ky gj\u00eb ofron leht\u00ebsira n\u00eb menaxhimin e var\u00ebsive, p\u00ebr mua ndjehej si magji e err\u00ebt, p\u00ebr t\u00eb cil\u00ebn nuk isha nj\u00ebmend i gatsh\u00ebm: si zakonisht e shkruaj importin e klasave q\u00eb m\u00eb nevojiten nga biblioteka json-simple n\u00eb krye t\u00eb klas\u00ebs s\u00eb redaktuar, e sh\u00ebnoj at\u00eb n\u00eb pom.xml, pas s\u00eb cil\u00ebs projekti refuzon kategorikisht t\u00eb nd\u00ebrtohet normalisht dhe shp\u00ebrb\u00ebhet me gabime. <\/p>\n

    Korrigjimi i gabimeve n\u00eb nd\u00ebrtim p\u00ebrfundimisht u realizua: e regjistrova bibliotek\u00ebn jo n\u00eb pom.xml, por n\u00eb manifestin manifest.mf, si\u00e7 k\u00ebrkon OSGI, duke e treguar at\u00eb si import-package. Nuk \u00ebsht\u00eb zgjidhje shum\u00eb e bukur, por funksionon. K\u00ebtu u shfaq nj\u00eb surpriz\u00eb tjet\u00ebr. N\u00ebse je duke zhvilluar n\u00eb intellij idea, nuk mund t\u00eb marr\u00ebsh thjesht dhe t\u00eb nis\u00ebsh debugin e projektit t\u00ebnd, i bazuar n\u00eb platform\u00ebn eclipse: zhvilluesi i paekspozuar duhet t\u00eb vuaj\u00eb po aq sa analisti pa plot\u00ebsimin automatik t\u00eb k\u00ebrkesave. N\u00eb ndihm\u00eb erdh\u00ebn vet\u00eb zhvilluesit e bobr\u00ebs, duke treguar n\u00eb wiki t\u00eb gjith\u00eb k\u00ebrcimet q\u00eb duhen b\u00ebr\u00eb. M\u00eb e m\u00ebrzitshmja \u00ebsht\u00eb se, edhe pas t\u00eb gjith\u00eb k\u00ebtyre p\u00ebrpjekjeve, projekti nuk donte t\u00eb niste n\u00eb debug me bibliotek\u00ebn json t\u00eb lidhur p\u00ebrmes import-package (nd\u00ebrsa, n\u00eb produktin p\u00ebrfundimtar, ai vazhdonte t\u00eb ndihmohej me sukses). <\/p>\n

    N\u00eb at\u00eb moment, un\u00eb kisha ndjer\u00eb shqet\u00ebsimin e p\u00ebrdorimit t\u00eb json p\u00ebr detyr\u00ebn time - megjithat\u00eb, metadat duhet t\u00eb redaktoheshin manualisht, dhe p\u00ebr k\u00ebt\u00eb formatin xml \u00ebsht\u00eb m\u00eb i p\u00ebrshtatsh\u00ebm. Argumenti i dyt\u00eb n\u00eb favor t\u00eb xml ishte prania n\u00eb JDK e t\u00eb gjitha klasave t\u00eb nevojshme, \u00e7ka e lejoi ndalimin e luft\u00ebs me bibliotek\u00ebn e jashtme. Me k\u00ebnaq\u00ebsi t\u00eb madhe, e transferova t\u00eb gjitha metadat nga json n\u00eb xml dhe fillova me ndryshimet n\u00eb logjik\u00ebn e plot\u00ebsimit automatik. <\/p>\n

    Shembulli i metadatat<\/b><\/p>\n

    dim_account\n        dim_partner\n        \n        \n    \n    \n        dim_account\n        dim_branch<\/code><\/pre>\n
    Si rezultat un\u00eb b\u00ebr\u00eb ndryshime<\/a><\/noindex> n\u00eb klasat SQLUtils dhe SQLCompletionAnalyzer. Ideja \u00ebsht\u00eb kjo: n\u00ebse programit nuk i doli e mundur t\u00eb gjej\u00eb propozonte t\u00eb p\u00ebrshtatshme p\u00ebr plot\u00ebsim automatik sipas logjik\u00ebs baz\u00eb, at\u00ebher\u00eb kontrollon pranin\u00eb e mundsh\u00ebm t\u00eb bashkimeve p\u00ebrmes nj\u00eb skedari xml t\u00eb jasht\u00ebm. N\u00eb vet\u00eb skedarin ruhen \u00e7iftet e tabelave me p\u00ebrshkrimin e fushave q\u00eb duhet t\u00eb lidhin k\u00ebto tabela. Kufizimet mbi datat teknike t\u00eb veprimit t\u00eb regjistrimeve eff_dttm dhe exp_dttm dhe flamuri i fshirjes logjike deleted_ind vendosen p\u00ebr default.<\/p>\n
    Kur t\u00eb b\u00ebhen ndryshimet n\u00eb kod, lind pyetja - kush do t\u00eb plot\u00ebsoj\u00eb skedarin me metadata? Ka shum\u00eb entitete n\u00eb depo, dhe t\u00eb shkruash vet\u00eb t\u00eb gjitha lidhjet \u00ebsht\u00eb e shtrenjt\u00eb. N\u00eb fund vendosa ta delegoj k\u00ebt\u00eb detyr\u00eb te koleg\u00ebt e mi analist\u00eb. Skedari i metadata u ngarkua n\u00eb svn, ku b\u00ebhet checkout n\u00eb direktorin\u00eb lokale me programin. Parimi \u00ebsht\u00eb i till\u00eb: ndonj\u00eb entitet i ri u shfaq n\u00eb depo? Nj\u00eb analist e shton mund\u00ebsit\u00eb e bashkimeve n\u00eb skedar, angazhon ndryshimet, t\u00eb tjer\u00ebt b\u00ebjn\u00eb checkout p\u00ebr vete dhe shijojn\u00eb autombushjen: komuniteti, grumbullimi i dijes dhe k\u00ebshtu me radh\u00eb. Mbajta nj\u00eb pun\u00ebtor n\u00eb lidhje me p\u00ebrdorimin e programit p\u00ebr koleg\u00ebt, shkrova nj\u00eb artikull n\u00eb Confluence - tani n\u00eb kompani kemi nj\u00eb mjet t\u00eb leht\u00eb m\u00eb shum\u00eb.<\/p>\n
    Puna mbi k\u00ebt\u00eb ve\u00e7ori m\u00eb dha kuptimin se nuk duhet t\u00eb friksohemi nga p\u00ebrpunimi i projekteve open source - zakonisht, ato kan\u00eb nj\u00eb arkitektur\u00eb t\u00eb kuptueshme, dhe madje njohurit\u00eb bazike t\u00eb gjuh\u00ebs do t\u00eb mjaftojn\u00eb p\u00ebr eksperimente. Dhe me nj\u00eb mas\u00eb t\u00eb caktuar p\u00ebrkushtimi, madje do t\u00eb arrish t\u00eb eliminosh operacionet rutin\u00eb q\u00eb nuk i don, duke kursyer koh\u00eb p\u00ebr eksperimente t\u00eb reja.
    \n
    Burimi:     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\udd47Si t\u00eb ndaloni t\u00eb b\u00ebni t\u00eb nj\u00ebjt\u00ebn gj\u00eb | ProHoster","description":"A e doni t\u00eb p\u00ebrs\u00ebrisni operacione rutin\u00eb her\u00eb pas here? Edhe un\u00eb jo. Por \u00e7do her\u00eb q\u00eb punoja me depozitat e Rostelecom n\u00eb SQL-client, duhej t\u00eb shkroja me dor\u00eb t\u00eb gjitha bashkimet midis tabelave.","canonical_url":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/kak-perestat-delat-odno-i-to-zhe","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"sq_AL","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\/sq\/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\/sq\/wp-json\/wp\/v2\/posts\/36795","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/comments?post=36795"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/36795\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media\/27562"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media?parent=36795"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/categories?post=36795"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/tags?post=36795"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}