{"id":91148,"date":"2020-08-09T01:42:48","date_gmt":"2020-08-08T23:42:48","guid":{"rendered":"https:\/\/prohoster.info\/blog\/administrirovanie\/moi-pozhelaniya-k-subd-budushhego-a-takzhe-k-rosreestru-v-chasti-tranzakczionnosti"},"modified":"2020-08-09T01:42:48","modified_gmt":"2020-08-08T23:42:48","slug":"moi-pozhelaniya-k-subd-budushhego-a-takzhe-k-rosreestru-v-chasti-tranzakczionnosti","status":"publish","type":"post","link":"https:\/\/prohoster.info\/et\/blog\/administrirovanie\/moi-pozhelaniya-k-subd-budushhego-a-takzhe-k-rosreestru-v-chasti-tranzakczionnosti","title":{"rendered":"Minu soovid tuleviku andmebaasidele ja ka Rosreestrile seoses tehingute teostamisega","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

\"Minu
\nKlient suhtleb andmebaasiga.
\nVeebisaidilt http:\/\/corchaosis.ru<\/a><\/noindex>, kunstniku Jonathan Tiong.<\/p>\n

Lisaks sellele, et olen programmeerija (peamiselt Delphi + erinevad andmebaasid, viimasel ajal ORACLE, + natuke PHP), on mul hobi \u2014 kinnisvara ostmine ja m\u00fc\u00fcmine. Ostsin korteri ehitusj\u00e4rgus usaldusv\u00e4\u00e4rselt arendajalt t\u00f5eliselt hea hinnaga (n\u00e4iteks, praegu on selline arendaja Samoljet, korterid m. Nekrasovka l\u00e4hedal m\u00fc\u00fcgis), ootan hoone valmimist (tihti kaks aastat hiljem, odavate pakkumiste korral juhtub see) ja teen seal remonti ning m\u00fc\u00fcn seej\u00e4rel korteri 95-100% turuhinnast.<\/p>\n

Nii et ma (nagu k\u00f5ik) silmitsi probleemiga, et Rosreestr ei paku tehingute \u00fclesehitust.<\/p>\n

Rosreestri tehingute \u00fclesehituse puudumine<\/b><\/p>\n

Programmeeringus on 'Tehing', aga kinnisvaras on see 'Alternatiivi tehing' (nagu ka selle osa, 'Panga rakenduse leping'), ja seal on k\u00f5ik natuke keerulisem. R\u00e4\u00e4gin sellest.<\/p>\n

Vasja tuli vaatama korterit, mida m\u00fc\u00fcb Petja. Ja Vasjale meeldis k\u00f5ik v\u00e4ga, sealhulgas hind, aga Vasjal pole raha. Nii algabki meie lugu.<\/a><\/noindex><\/p>\n

Vasjal on oma kinnisvara, millel on m\u00f5ned tema jaoks mitte eriti vajalikud omadused \u2014 naabermajas elas Lomonosov, lae k\u00f5rgus on seitse ja pool meetrit, l\u00e4hedal on puu- ja k\u00f6\u00f6giviljade hulkjaam ning turu Sadood, jalutusk\u00e4iguga p\u00e4\u00e4seb Aeroflexisse, korteri all on 1-meetrine keldri k\u00f5rgus ja korteri kohal on p\u00f6\u00f6ning, mis sobib astronoomiliste vaatlusteks. Vasja m\u00f5istab, et need omadused t\u00f5stavad tema korteri hinda, kuid mitte tema jaoks. Ja ta otsustab osta Petja korteri, kuid m\u00fc\u00fca oma korteri just selleks, et osta Petja korter, mitte lihtsalt sedasi. Kinnisvara maaklerite keeles nimetatakse seda \u2014 'Alternatiiv on valitud'.<\/p>\n

N\u00fc\u00fcd vaatame seda olukorda Petja vaatepunktist. Asi on selles, et Petjale ei ole samuti huvitav istuda devalveeritud rahadega, ta m\u00fc\u00fcb korteri selleks, et osta endale korter elfi linnas Valinor, aga millise t\u00e4pselt \u2014 ei ole veel vaadanud. Kinnisvara maaklerite keeles nimetatakse seda \u2014 'Alternatiivi tehing'.<\/p>\n

Kaks Keskmaa haldjat, Maglor ja Maedros, omavad sobivat (Petja kriteeriumitele) kinnisvara Valinori linnas, mille nad kiirelt m\u00fc\u00fcvad, kuna nad s\u00f5idavad teenima Melkori. Kinnisvara m\u00fc\u00fcgis kasutatakse seda terminina - \"Vaba m\u00fc\u00fck\".<\/p>\n

Nii et Vassja leiab kliendi Sere\u017eat. N\u00fc\u00fcd leiab Petja kaks sobivat varianti Valinoris. Liigume lepingut vormistama. Oletame liialdavalt, et lepingus osalejatest keegi ei kasuta h\u00fcpoteeki ega ole alaealiste kaasomanik. Seega peavad n\u00fc\u00fcd toimuma j\u00e4rgmised toimingud:
\n1. Sere\u017ea annab Petjale raha.
\n2. Vassja annab oma korteri Sere\u017eale.
\n3. Petja annab oma korteri Vassjale.
\n4. \u00dcksk\u00f5ik kummagi, kas Maglor v\u00f5i Maedros, annab oma korteri Valinoris Petjale ja saab Sere\u017ealt raha.
\n5. Malkor ja Maedros l\u00e4hevad Mordori teenima Melkori.<\/p>\n

Ideaalne oleks edastada j\u00e4rgmine skript Rosreestrile:<\/p>\n

ALUSTA TEHINGUT
\nVassja korter anda Sere\u017eale.
\nPetja korter anda Vassjale.
\nbegin
\nMalkoori korter anda Petjale.
\nSere\u017ea raha anda Malkorile.
\nKUI_VIGA:
\nMaedrose korter anda Petjale.
\nSere\u017ea raha anda Maedrosile.
\nl\u00f5peta
\nKOMMIT TEHINGUT\n<\/p><\/blockquote>\n

\nSee on lihtsustatud tehinguskript alternatiivi korral, mis eeldab, et k\u00f5ikidel korteritel on \u00fcks t\u00e4iskasvanu (ja teov\u00f5imeline) omanik, et nende v\u00e4\u00e4rtused on v\u00f5rdsed ning et maaklerite tasud (kui neid on) makstakse eraldi tehingu etappidest.<\/p>\n

Kuid Rosregister ei toeta tehingulist l\u00e4henemist. K\u00f5ik toimingud viiakse l\u00e4bi j\u00e4rjestikku ja iseseisvalt, \u00fcks teise j\u00e4rel, ilma, et tehingu t\u00fchistamine toimuks, kui \u00fckski neist ei ole t\u00e4idetud. Maksimum, mida on v\u00f5imalik saavutada - arvestades, et Rosregister ja MFC ei tegele raha\u00fclekannetega - on see, et raha pannakse panga seifi, millele p\u00e4\u00e4sevad ligi Vassja, Petja, Sere\u017ea (kui tehingut ei ole registreeritud) ja teised osalejad, esitades registreeritud Rosregisteri lepingud. (Ja muide, pangad ei kontrolli lepingute autentsust iseseisvalt, seega usaldavad nad tehingu osaliste dokumentide ehtsust.)<\/p>\n

Lisaks tehingu mittet\u00e4ieliku t\u00e4itmise riskidele, on teine probleem see, et kui teised osalised saavad siseneda oma uutesse elukohtadesse, ootamata t\u00e4ielikku vormistust (tere, kommunaalmaksete alamaksmise k\u00fcsimus!), siis Maglor ja Maedhros ei l\u00e4he varsti teenima Melkori, ja v\u00f5ib-olla ei suuda Maglor sildile hoida silmarilli, ta lihtsalt ei j\u00f5ua. Kinnisvaratehingud viiakse l\u00e4bi j\u00e4rk-j\u00e4rgult ning iga tehingu vormistamine kestab v\u00e4hemalt 9 t\u00f6\u00f6p\u00e4eva.<\/p>\n

Lisaks sellele ei toeta Rosreestr ehitustegevuse koormamist DDU alusel, kuigi v\u00f5iks, see on elementaarne toiming seoses lihtsa tulevikulepinguga.<\/p>\n

N\u00fc\u00fcd liigume puuduste ja minu soovide juurde andmebaasihalduse s\u00fcsteemi kohta.<\/b><\/p>\n

1) Esiteks \u2014 see on versioonikontrolli s\u00fcsteemi puudumine. Kui Delphi poolt arendades teen oma muudatusi liivakastis ja need ei j\u00f5ua teiste programmeerijateni enne nende commitimist, siis andmebaasihalduse s\u00fcsteemi puhul ei ole see nii. Ja isegi kui mulle usaldatakse t\u00e4ielik (v\u00e4hemalt selle \u00fclesande t\u00e4itmiseks vajalik) juurdep\u00e4\u00e4s tootmisandmebaasile, mis juhtub m\u00f5nikord, ei saa ma sellel arendada. Seni, kuni ma silun, k\u00f5ik laguneb. Mis see on, kiviaeg??? Looge arendajatele liivakast.<\/p>\n

2) Teiseks \u2014 see on standardsete tabelite puudumine, mis kirjeldavad reaalset maailma. Igas firmas, kus ma olen t\u00f6\u00f6tanud, on oma tabeli formaat, mis kirjeldab nimede (vene ja (v\u00e4hemalt) inglise keeles, vene keele erinevates k\u00e4\u00e4ndes) kaheteistk\u00fcmne kuu kohta!<\/p>\n

3) Kolmandaks \u2014 ja siin kasutan Oracle'i terminoloogiat \u2014 puudub v\u00f5imalus kutsuda lihtsat Insert v\u00f5i Update skripti, mis kasutab Returningut, just nagu me kutsume Selecti. V\u00f5ib-olla ei ole see Oracle'i probleem, vaid Delphi + Oracle'i vahelise \u00fchenduse probleem.<\/p>\n

4) Neljas on vajadus m\u00e4\u00e4rata loodud protseduuridele ja funktsioonidele volitused seal, kus ma seda teha ei soovi. Ma ei soovi m\u00e4\u00e4rata ja seej\u00e4rel muuta kasutajate volitusi protseduuris ja funktsioonis. Miks, kui ma ei ole selgelt m\u00e4\u00e4ranud Grant'e, ei v\u00f5iks s\u00fcsteem ise vaadata kaasatud objekte ja vastavalt \u00f5igustele nende tegevustele anda v\u00f5i mitte anda teatud kasutajatele \u00f5igust funktsiooni kutsumiseks? Olen valmis selleks kirjutama \u00fche v\u00f5tmes\u00f5na protseduuride ja funktsioonide kirjutamisel. V\u00f5i veel parem, las kasutaja alustab t\u00e4itmist, ja kui algoritmi haru viib teda p\u00e4ringule, milleks tal pole \u00f5iguseid, siis viskab s\u00fcsteem vea.
\n
Allikas: habr.com<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"

\u041a\u043b\u0438\u0435\u043d\u0442 \u0432\u0437\u0430\u0438\u043c\u043e\u0434\u0435\u0439\u0441\u0442\u0432\u0443\u0435\u0442 \u0441 \u0431\u0430\u0437\u043e\u0439 \u0434\u0430\u043d\u043d\u044b\u0445. \u0421 \u0441\u0430\u0439\u0442\u0430 http:\/\/corchaosis.ru, \u0430\u0432\u0442\u043e\u0440 \u043a\u0430\u0440\u0442\u0438\u043d\u044b Jonathan Tiong. \u041f\u043e\u043c\u0438\u043c\u043e \u0442\u043e\u0433\u043e, \u0447\u0442\u043e \u044f \u044f\u0432\u043b\u044f\u044e\u0441\u044c \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u043c\u0438\u0441\u0442\u043e\u043c (\u043f\u0440\u0435\u0438\u043c\u0443\u0449\u0435\u0441\u0442\u0432\u0435\u043d\u043d\u043e, \u044d\u0442\u043e Delphi + \u0432\u0441\u044f\u043a\u0438\u0435 \u0440\u0430\u0437\u043d\u044b\u0435 \u0421\u0423\u0411\u0414, \u0432 \u043f\u043e\u0441\u043b\u0435\u0434\u043d\u0435\u0435 \u0432\u0440\u0435\u043c\u044f \u041e\u0420\u0410\u041a\u041b, + \u043d\u0435\u043c\u043d\u043e\u0433\u043e PHP), \u0443 \u043c\u0435\u043d\u044f \u0435\u0441\u0442\u044c \u0445\u043e\u0431\u0431\u0438 \u2014 \u044d\u0442\u043e \u043a\u0443\u043f\u043b\u044f \u0438 \u043f\u0440\u043e\u0434\u0430\u0436\u0430 \u043a\u0432\u0430\u0440\u0442\u0438\u0440. \u042f \u043f\u043e\u043a\u0443\u043f\u0430\u044e \u043a\u0432\u0430\u0440\u0442\u0438\u0440\u0443 \u043d\u0430 \u044d\u0442\u0430\u043f\u0435 \u0441\u0442\u0440\u043e\u0438\u0442\u0435\u043b\u044c\u0441\u0442\u0432\u0430 \u043e\u0442 \u0431\u043e\u043b\u0435\u0435 \u043c\u0435\u043d\u0435\u0435 \u043d\u0430\u0434\u0451\u0436\u043d\u043e\u0433\u043e \u0437\u0430\u0441\u0442\u0440\u043e\u0439\u0449\u0438\u043a\u0430 \u043f\u043e \u0432\u043a\u0443\u0441\u043d\u043e\u0439 […]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":91149,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-91148","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\udd47Minu soovid tulevasele andmebaasihalduss\u00fcsteemile, samuti Rosreestrile seoses tehingute teostamisega | ProHoster","description":"Klient.","canonical_url":"https:\/\/prohoster.info\/et\/blog\/administrirovanie\/moi-pozhelaniya-k-subd-budushhego-a-takzhe-k-rosreestru-v-chasti-tranzakczionnosti","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\u041c\u043e\u0438 \u043f\u043e\u0436\u0435\u043b\u0430\u043d\u0438\u044f \u043a \u0421\u0423\u0411\u0414 \u0431\u0443\u0434\u0443\u0449\u0435\u0433\u043e, \u0430 \u0442\u0430\u043a\u0436\u0435 \u043a \u0420\u043e\u0441\u0440\u0435\u0435\u0441\u0442\u0440\u0443 \u0432 \u0447\u0430\u0441\u0442\u0438 \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u043e\u043d\u043d\u043e\u0441\u0442\u0438 | ProHoster","og:description":"\u041a\u043b\u0438\u0435\u043d\u0442.","og:url":"https:\/\/prohoster.info\/et\/blog\/administrirovanie\/moi-pozhelaniya-k-subd-budushhego-a-takzhe-k-rosreestru-v-chasti-tranzakczionnosti","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":"2020-08-08T23:42:48+00:00","article:modified_time":"2020-08-08T23:42:48+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"91148","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":null,"breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-02-28 12:33:24","updated":"2022-09-30 22:07:47","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\/91148","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=91148"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts\/91148\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/media\/91149"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/media?parent=91148"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/categories?post=91148"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/tags?post=91148"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}