Wothandizira amalumikizana ndi database.
Kuchokera patsamba , ndi Jonathan Tiong.
Kuphatikiza pa mfundo yakuti ndine wolemba mapulogalamu (makamaka Delphi + mitundu yonse ya ma DBMS osiyanasiyana, posachedwapa ORACLE, + PHP pang'ono), ndili ndi chizolowezi - kugula ndi kugulitsa nyumba. Ndimagula nyumba panthawi yomanga kuchokera kwa wopanga odalirika kwambiri pamtengo wabwino (mwachitsanzo, Samolet tsopano ndi wopanga, zipinda pafupi ndi siteshoni ya metro ya Nekrasovka zikugulitsidwa), dikirani kuti nyumbayo iperekedwe (nthawi zambiri ziwiri). patapita zaka, izi zimachitika ndi zotsika mtengo), ndimakonzanso ndikuzigulitsa 95-100% ya mtengo wake wamsika.
Kotero, ine (monga wina aliyense) ndinakumana ndi vuto la kusowa kwa RosReestr kwa transactionality.
Vuto la kusowa kwa Rosreestr kwa zochitika zamalonda
Pamapulogalamu ndi "Transaction", ndipo m'malo ogulitsa nyumba ndi "Transaction ndi Njira Zina" (komanso, monga gawo lake, "Safe Deposit Box Agreement"), ndipo ndizovuta kwambiri. Ine ndikukuuzani inu.
Vasya adabwera kudzawona nyumba yomwe Petya amagulitsa. Ndipo Vasya ankakonda kwambiri chirichonse, kuphatikizapo mtengo, koma Vasya alibe ndalama. Umu ndi momwe nkhani yathu imayambira.
Vasya ali ndi malo ake omwe ali ndi makhalidwe omwe sali ofunika kwambiri kwa iye - Lomonosov ankakhala m'nyumba yoyandikana nayo, kutalika kwa denga ndi mamita asanu ndi awiri ndi theka, pali zipatso ndi masamba ndi msika wa Sadovod. pafupi, mutha kuyenda pa Aeroexpress, pansi pa nyumbayo pali chipinda chapansi chokhala ndi kutalika kwa mita 1, pali chapamwamba pamwamba pa nyumbayo yabwino kuwonera zakuthambo. Vasya amamvetsetsa kuti zinthu izi zimawonjezera mtengo wa nyumba yake, koma osati kwa iye. Ndipo adaganiza zogula nyumba ya Petya ndikugulitsa nyumba yake. Koma kugulitsa ndendende kuti mugule nyumba ya Petya, osati chabe. M'chinenero cha ogulitsa, izi zimatchedwa "Njira ina yasankhidwa."
Tsopano tiyeni tiwone izi kuchokera kumbali ya Petya. Chowonadi ndi chakuti Petya nayenso safuna kukhala pamtengo wotsika mtengo, akugulitsa nyumbayo kuti adzigule nyumba mumzinda wa Elven wa Valinor, koma sanayang'ane kuti ndi iti. M'chilankhulo cha ogulitsa, izi zimatchedwa "Kuthana ndi njira ina."
Ma elves awiri a Middle-earth, Maglor ndi Maedhros, ali ndi malo oyenera (molingana ndi Petya) mumzinda wa Valinor, womwe umagulitsidwa mwachangu, chifukwa akupita kukatumikira Melkor. M'chinenero cha ogulitsa izi zimatchedwa "Kugulitsa Kwaulere".
Choncho, Vasya amapeza kasitomala, Seryozha. Tsopano, Petya amapeza njira ziwiri zoyenera kwa iye mumzinda wa Valinor. Tatsala pang'ono kumaliza mgwirizano. Tiyerekeze kuti m'modzi mwa omwe akuchita nawo bizinesiyo sagwiritsa ntchito ngongole yanyumba ndipo alibe ana ngati eni ake. Chifukwa chake, zotsatirazi ziyenera kuchitidwa:
1. Seryozha amapereka ndalama kwa Petya.
2. Vasya amapereka nyumba yake kwa Seryozha.
3. Petya amapereka nyumba yake kwa Vasya.
4. Maglor kapena Maedhros amasamutsa nyumba yawo ku Valinor kupita ku Peta ndikulandira ndalama za Seryozha.
5. Malkor ndi Maedhros amapita ku Mordor kukatumikira Melkor.
Zingakhale zabwino kupereka malemba otsatirawa kwa Rosreestr kuti aphedwe:
YAMBANI NTCHITO
Perekani nyumba ya Vasya ku Seryozha.
Perekani nyumba ya Petya kwa Vasya.
yamba
Perekani nyumba ya Malkor kwa Petya
Perekani ndalama za Seryozha ku Malkor
IF_ERROR:
Perekani nyumba ya Maedhros kwa Petya
Perekani ndalama za Seryozha kwa Maedhros
TSIRIZA
PANGANI NTCHITO
Ichi ndi script chosavuta chogulitsira ndi njira ina, yomwe imaganiza kuti zipinda zonse zili ndi mwiniwake wamkulu (ndi wokhoza), kuti mtengo wawo ndi wofanana, komanso kuti ogulitsa (ngati alipo) amalipidwa mosasamala kanthu za magawo a malondawo.
Komabe, Rosreestr sagwirizana ndi zochitika. Zochita zonse zidzachitidwa motsatizana komanso modziyimira pawokha, chimodzi pambuyo pa chimzake, popanda kubweza ntchitoyo yonse ngati imodzi yalephera. Kuchuluka komwe kungapezeke - kupatsidwa kuti Rosreestr ndi MFC sagwira ntchito ndi kusamutsidwa kwa ndalama - ndikuyika ndalamazo m'bokosi lotetezedwa, ndi zikhalidwe zopezera izo ndi Vasya, Petya, Seryozha (ngati palibe ntchito. amalembetsedwa konse), ndi ochita zisudzo ena, pakuwonetsa mapangano olembetsedwa ndi Rosreestr. (Ndipo mwa njira, mabanki samatsimikizira paokha kutsimikizika kwa makontrakitala, ndiko kuti, amakhulupirira zowona za mapepala a maphwando ochitapo kanthu).
Kupatula kuopsa kwa kusamalizidwa kosakwanira kwa malondawo, vuto lina ndiloti ngati ena atha kusamukira ku nyumba yawo yatsopano popanda kuyembekezera kulembetsa kwathunthu (moni, nkhani ya kubweza ndalama zolipirira ndalama zothandizira!), Maglor ndi Maedhros posachedwapa sapita kutumikira Melkor, ndipo mwina Maglor sadzatha sadzakhala ndi nthawi kugwira Silmarils m'manja mwake. Kugulitsa nyumba ndi nyumba kumachitika motsatizana, ndipo kuchita chilichonse kumatenga masiku osachepera 9.
Kuonjezera apo, Rosreestr sichigwirizana ndi zovuta za nyumba zomwe zimamangidwa pansi pa DDU, koma zingatheke, ichi ndi chinthu choyambirira chokhudzana ndi tsogolo losavuta.
Tsopano tiyeni tipitirire ku zofooka ndi zofuna zanga za DBMS
1) Choyamba ndi kusowa kwa njira yoyendetsera mtundu. Ngati kumbali ya Delphi ndimapanga mu sandbox yanga, ndipo zosintha zomwe ndimapanga sizidzawoneka kwa olemba mapulogalamu ena mpaka atadzipereka, ndiye kuti sizili choncho ndi DBMS. Ndipo ngakhale nditadaliridwa mokwanira (osachepera pazomwe ndikufunika pa ntchito yomwe ndapatsidwa) kupeza malo omenyera nkhondo, ndipo izi zimachitika, sindingathe kukulitsa. Pamene ndikukonza zolakwika, zonse zidzagwa. Ndi Stone Age yotani iyi??? Pangani sandbox kwa omanga.
2) Chachiwiri ndi kusowa kwa matebulo okhazikika omwe amafotokozera dziko lenileni. Kampani iliyonse yomwe ndidagwirapo ntchito ili ndi mawonekedwe ake a tebulo omwe amafotokoza mayina (mu Chirasha ndi (osachepera) Chingerezi, m'malo osiyanasiyana achi Russia) a miyezi khumi ndi iwiri!
3) Chachitatu - ndipo apa ndidzagwiritsa ntchito mawu akuti Oracle - palibe njira yotchulira chosavuta Choyika kapena Kusintha script yomwe imagwiritsa ntchito Kubwerera, momwemonso timatcha Sankhani. Mwina izi sizovuta za Oracle, koma zovuta pamawonekedwe a Delphi + Oracle.
4) Chachinayi - kufunikira kopereka mphamvu kumayendedwe ndi ntchito zomwe ndimapanga pomwe sindikufuna kuchita izi. Sindikufuna kukhazikitsa ndikusintha zilolezo za ogwiritsa ntchito ndi magwiridwe antchito. Chifukwa chiyani, ngati sindinalembe momveka bwino Grants, kodi dongosololi silingathe kuyang'ana zinthu zomwe zikukhudzidwa, ndipo, molingana ndi ufulu wochita nawo, perekani kapena ayi kwa ogwiritsa ntchito ena ufulu woyimbira ntchito? Ndine wokonzeka kulemba liwu limodzi lofunikira pa izi polemba ntchito ndi njira. Kapena, ngakhale bwino, lolani wogwiritsa ntchito ayambe kuphedwa, ndipo ngati nthambi ya algorithm imamutsogolera ku pempho lomwe wogwiritsa ntchito alibe ufulu, adzaliponya ndi cholakwika.
Source: www.habr.com