{"id":1290,"date":"2025-05-14T12:05:01","date_gmt":"2025-05-14T10:05:01","guid":{"rendered":"https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/?page_id=1290"},"modified":"2025-05-16T11:51:50","modified_gmt":"2025-05-16T09:51:50","slug":"sql-transactions","status":"publish","type":"page","link":"https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/sql-transactions\/","title":{"rendered":"SQL Transactions"},"content":{"rendered":"\n<p>hinne 5 &#8211;&nbsp;https:\/\/www.youtube.com\/watch?v=shkt9Z5Gz-U<\/p>\n\n\n\n<p>\u0414\u0430\u043d\u043d\u0430\u044f \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u044f \u043e\u0431\u043d\u043e\u0432\u043b\u044f\u0435\u0442 Maakond \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u043d\u0430\u043f\u0438\u0441\u0430\u043d \u043d\u0435 \u0432\u0435\u0440\u043d\u043e \u0430 \u0442\u0430\u043a \u0436\u0435 \u0438\u0437\u043c\u0435\u043d\u044f\u0435\u0442 \u0444\u0430\u043c\u0438\u043b\u0438\u044e<\/p>\n\n\n\n<p>\u041d\u043e \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u044f \u043d\u0435 \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u0435\u0442\u0441\u044f \u043f\u043e\u0442\u043e\u043c\u0443 \u0447\u0442\u043e \u041f\u043e\u043b\u0435 PereNimi \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442 varchar(10) \u0430 \u0444\u0430\u043c\u0438\u043b\u0438\u044f \u043d\u0430 \u043a\u043e\u0442\u043e\u0440\u0443\u044e \u044f \u043f\u044b\u0442\u0430\u044e\u0441\u044c \u0438\u0437\u043c\u0435\u043d\u0438\u0442\u044c \u0431\u043e\u043b\u044c\u0448\u0435 \u0447\u0435\u043c 10 \u0431\u0443\u043a\u0432\u044b.<br>\u0412 \u0441\u0432\u044f\u0437\u0438 \u0441 \u044d\u0442\u0438\u043c \u0430\u043a\u0442\u0438\u0432\u0438\u0440\u0443\u0435\u0442\u0441\u044f \u0431\u043b\u043e\u043a Catch \u0432 \u043a\u043e\u0442\u043e\u0440\u043e\u043c \u043d\u0430\u0445\u043e\u0442\u044f\u0441\u044f rollback \u0438 \u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442 \u0442\u0430\u0431\u043b\u0438\u0446\u0443 Aadress \u0432 \u0442\u043e \u0441\u043e\u0441\u0442\u043e\u044f\u043d\u0438\u0435 \u043a\u043e\u0442\u043e\u0440\u043e\u0435 \u043e\u043d\u0430 \u0431\u044b\u043b\u0430 \u0434\u043e \u044d\u0442\u043e\u0433\u043e.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n--\u0421\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u0442\u0430\u0431\u043b\u0438\u0446\u044b\nCREATE TABLE Aadres(\nid int not null Primary key,\nMaakond varchar(40),\nTanav varchar(50),\nMajaNr int);\n\nCREATE TABLE Klient(\nid int not null Primary key,\nNimi varchar(30),\nPereNimi varchar(10));\n--\u0414\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0445\nINSERT INTO Aadres VALUES (1, &#039;Harjumaa&#039;, &#039;Viru&#039;, 22);\nINSERT INTO Aadres VALUES (2, &#039;Harjumaa&#039;, &#039;Viru&#039;, 99);\nINSERT INTO Aadres VALUES (3, &#039;HOrjumaa&#039;, &#039;Viru&#039;, 55);\nSELECT * FROM Aadres;\n\nINSERT INTO Klient VALUES (1, &#039;Anna&#039;, &#039;Oleks&#039;);\nINSERT INTO Klient VALUES (2, &#039;Nastja&#039;, &#039;Kostjuk&#039;);\nINSERT INTO Klient VALUES (3, &#039;Zhan-Gabriel&#039;, &#039;Gerke&#039;);\nSELECT * FROM Klient;\t\n--\u0421\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u041f\u0440\u043e\u0446\u0435\u0434\u0443\u0440\u044b \u0441 \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u0435\u0439 \u043a\u043e\u0442\u043e\u0440\u0430\u044f \u043d\u0435 \u0431\u0443\u0434\u0435\u0442 \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0430 \u0438\u0441\u0437\u0430 \u043e\u0448\u0438\u0431\u043a\u0438\nCreate Procedure spUpdateAddressNegativ\nas\nBegin\n\tBegin Try\n\t\tBegin Transaction -- \u041d\u0430\u0447\u0430\u043b\u043e \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u0438\n\t\t\tUpdate Aadres set Maakond = &#039;Harjumaa&#039;\n\t\t\twhere id = 3 and Tanav = &#039;Viru&#039;\n\n\t\t\tUpdate Klient set PereNimi = &#039;Reshetnikova&#039; -- \u0414\u0430\u043d\u043d\u0430\u044f \u0444\u0430\u043c\u0438\u043b\u0438\u044f \u0431\u043e\u043b\u044c\u0448\u0435 10 \u0431\u0443\u043a\u0432 \u043f\u043e\u044d\u0442\u043e\u043c\u0443 \u043e\u043d\u043e \u043d\u0435 \u0431\u0443\u0434\u0435\u0442 \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u043e\n\t\t\twhere id = 3 and PereNimi = &#039;Gerke&#039;\n\t\tCommit Transaction -- \u0444\u0438\u043a\u0441\u0438\u0440\u0443\u0435\u0442 \u0438\u0437\u043c\u0435\u043d\u0438\u043d\u0435\u043d\u0438\u044f \u043f\u0440\u0438 \u0443\u0441\u043f\u0435\u0448\u043d\u043e\u043c \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u0438 \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u0438\n\t\tPrint(&#039;Commit Transaction&#039;) -- \u041f\u0440\u0438\u043d\u0442\u0443\u0435\u0442 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044e \u0434\u0430\u043d\u043d\u044b\u0445 \u0442\u0435\u043a\u0441\u0442 \u043f\u0440\u0438 \u0443\u0441\u043f\u0435\u0448\u043d\u043e\u043c \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u0438\n\tEnd Try\n\tBegin Catch -- \u0411\u0443\u0434\u0435\u0442 \u0430\u043a\u0442\u0438\u0432\u0438\u0440\u043e\u0432\u0430\u043d \u044d\u0442\u043e\u0442 \u0431\u043b\u043e\u043a \u0435\u0441\u043b\u0438 \u043f\u0440\u043e\u0438\u0437\u043e\u0439\u0434\u0451\u0442 \u043a\u0430\u043a\u0430\u044f-\u0442\u043e \u043b\u0438\u0431\u043e \u043e\u0448\u0438\u0431\u043a\u0430 \u0432 \u0442\u0440\u0430\u043d\u0446\u0437\u0430\u043a\u0446\u0438\u0438\n\t\tRollback Transaction -- \u0412\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442 \u0432\u0441\u0451 \u0432 \u0438\u0441\u0445\u043e\u0434\u043d\u043e\u0435 \u0441\u043e\u0441\u0442\u043e\u044f\u043d\u0438\u0435\n\t\tPrint(&#039;Rollback&#039;) -- \u041f\u0440\u0438\u0432\u043d\u0443\u0435\u0442 \u0435\u0441\u043b\u0438 \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u044f \u043d\u0435 \u0431\u044b\u043b\u0430 \u0438\u0441\u043f\u043e\u043b\u043d\u0435\u043d\u0430\n\tEnd Catch\nEnd\n--\u0421\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u043f\u0440\u043e\u0446\u0435\u0434\u0443\u0440\u044b \u0441 \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u0435\u0439 \u043a\u043e\u0442\u043e\u0440\u0430\u044f \u0431\u0443\u0434\u0435\u0442 \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0430\nCreate Procedure spUpdateAddressPositiv\nas\nBegin\n\tBegin Try\n\t\tBegin Transaction -- \u041d\u0430\u0447\u0430\u043b\u0430 \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u0438\n\t\t\tUpdate Aadres set Maakond = &#039;Harjumaa&#039;\n\t\t\twhere id = 3 and Tanav = &#039;Viru&#039;\n\n\t\t\tUpdate Klient set PereNimi = &#039;Evertson&#039; -- \u0424\u0430\u043c\u0438\u043b\u0438\u044f \u043c\u0435\u043d\u044c\u0448\u0435 10 \u0431, \u0422\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u044f \u0431\u0443\u0434\u0435\u0442 \u0443\u0441\u043f\u0435\u0448\u043d\u0430\n\t\t\twhere id = 3 and PereNimi = &#039;Gerke&#039;\n\t\tCommit Transaction-- \u0444\u0438\u043a\u0441\u0438\u0440\u0443\u0435\u0442 \u0438\u0437\u043c\u0435\u043d\u0438\u043d\u0435\u043d\u0438\u044f \u043f\u0440\u0438 \u0443\u0441\u043f\u0435\u0448\u043d\u043e\u043c \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u0438 \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u0438\n\t\tPrint(&#039;Commit&#039;)-- \u041f\u0440\u0438\u043d\u0442\u0443\u0435\u0442 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044e \u0434\u0430\u043d\u043d\u044b\u0445 \u0442\u0435\u043a\u0441\u0442 \u043f\u0440\u0438 \u0443\u0441\u043f\u0435\u0448\u043d\u043e\u043c \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u0438\n\tEnd Try\n\tBegin Catch-- \u0411\u0443\u0434\u0435\u0442 \u0430\u043a\u0442\u0438\u0432\u0438\u0440\u043e\u0432\u0430\u043d \u044d\u0442\u043e\u0442 \u0431\u043b\u043e\u043a \u0435\u0441\u043b\u0438 \u043f\u0440\u043e\u0438\u0437\u043e\u0439\u0434\u0451\u0442 \u043a\u0430\u043a\u0430\u044f-\u0442\u043e \u043b\u0438\u0431\u043e \u043e\u0448\u0438\u0431\u043a\u0430 \u0432 \u0442\u0440\u0430\u043d\u0446\u0437\u0430\u043a\u0446\u0438\u0438\n\t\tRollback Transaction -- \u0412\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442 \u0432\u0441\u0451 \u0432 \u0438\u0441\u0445\u043e\u0434\u043d\u043e\u0435 \u0441\u043e\u0441\u0442\u043e\u044f\u043d\u0438\u0435\n\t\tPrint(&#039;Rollback&#039;)-- \u041f\u0440\u0438\u043d\u0442\u0443\u0435\u0442 \u0435\u0441\u043b\u0438 \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u044f \u043d\u0435 \u0431\u044b\u043b\u0430 \u0438\u0441\u043f\u043e\u043b\u043d\u0435\u043d\u0430\n\tEnd Catch\nEnd\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"408\" height=\"402\" src=\"https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-6.png\" alt=\"\" class=\"wp-image-1306\" srcset=\"https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-6.png 408w, https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-6-300x296.png 300w, https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-6-150x148.png 150w\" sizes=\"(max-width: 408px) 100vw, 408px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"995\" height=\"1024\" src=\"https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-7-995x1024.png\" alt=\"\" class=\"wp-image-1307\" srcset=\"https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-7-995x1024.png 995w, https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-7-291x300.png 291w, https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-7-768x791.png 768w, https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-7-146x150.png 146w, https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-7-1049x1080.png 1049w, https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-7.png 1055w\" sizes=\"(max-width: 995px) 100vw, 995px\" \/><\/figure>\n\n\n\n<p>\u0420\u0430\u0431\u043e\u0442\u0430\u044e\u0449\u0430\u044f \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u044f<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"809\" height=\"1024\" src=\"https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-8-809x1024.png\" alt=\"\" class=\"wp-image-1308\" srcset=\"https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-8-809x1024.png 809w, https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-8-237x300.png 237w, https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-8-768x972.png 768w, https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-8-118x150.png 118w, https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-8-853x1080.png 853w, https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-8.png 1195w\" sizes=\"(max-width: 809px) 100vw, 809px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"653\" height=\"666\" src=\"https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-9.png\" alt=\"\" class=\"wp-image-1309\" srcset=\"https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-9.png 653w, https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-9-294x300.png 294w, https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-9-147x150.png 147w\" sizes=\"(max-width: 653px) 100vw, 653px\" \/><\/figure>\n\n\n\n<p><strong>XAMPP<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"642\" src=\"https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-14-1024x642.png\" alt=\"\" class=\"wp-image-1321\" srcset=\"https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-14-1024x642.png 1024w, https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-14-300x188.png 300w, https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-14-768x482.png 768w, https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-14-150x94.png 150w, https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-14-1536x963.png 1536w, https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-14-2048x1284.png 2048w, https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-14-1722x1080.png 1722w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nBEGIN\n    DECLARE EXIT HANDLER FOR SQLEXCEPTION \n    BEGIN\n        ROLLBACK;\n        SELECT &#039;Rollback&#039; AS Message;\n    END;\n\n    START TRANSACTION;\n    -- \u041f\u0440\u043e\u0432\u0435\u0440\u043a\u0430 \u0434\u043b\u0438\u043d\u044b \u0441\u0442\u0440\u043e\u043a \u0434\u043e \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u044f\n    IF CHAR_LENGTH(UusPereNimi) &lt; 10 OR CHAR_LENGTH(UusMaakond) &lt; 40 THEN\n        SIGNAL SQLSTATE &#039;45000&#039; SET MESSAGE_TEXT = &#039;UusPereNimi or UusMaakond is too long&#039;;\n    END IF;\n    -- \u041e\u0431\u043d\u043e\u0432\u043b\u044f\u0435\u043c \u0442\u0430\u0431\u043b\u0438\u0446\u0443 Aadres\n    UPDATE Aadres\n    SET Maakond = UusMaakond\n    WHERE id = idOfRecord;\n    -- \u041e\u0431\u043d\u043e\u0432\u043b\u044f\u0435\u043c \u0442\u0430\u0431\u043b\u0438\u0446\u0443 Klient\n    UPDATE Klient \n    SET PereNimi = UusPereNimi\n    WHERE id = idOfRecord;\n    COMMIT;\n    SELECT &#039;Commit&#039; AS Message;\nEND\n<\/pre><\/div>\n\n\n<p>PS. \u0415\u0441\u043b\u0438 \u0431\u0435\u0437 IF \u0434\u0435\u043b\u0430\u0442\u044c \u0442\u043e \u043e\u043d \u043f\u0440\u043e\u0442\u0441\u0442\u043e \u0431\u0443\u0434\u0435\u0442 \u043e\u0431\u0440\u0430\u0437\u0430\u0442\u044c \u0434\u0430\u043d\u043d\u044b\u0435 \u0434\u043e \u043f\u043e\u0434\u0445\u043e\u0434\u044f\u0449\u0435\u0433\u043e \u043a\u043e\u043b-\u0432\u0430 \u0441\u0438\u043c\u0432\u043e\u043b\u043e\u0432<\/p>\n\n\n\n<p>\u041f\u0440\u043e\u0432\u0435\u0440\u043a\u0430 \u0440\u0430\u0431\u043e\u0442\u044b<\/p>\n\n\n\n<div class=\"wp-block-cover\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"400\" class=\"wp-block-cover__image-background wp-image-1316\" alt=\"\" src=\"https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-10-1024x400.png\" data-object-fit=\"cover\" srcset=\"https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-10-1024x400.png 1024w, https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-10-300x117.png 300w, https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-10-768x300.png 768w, https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-10-150x59.png 150w, https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-10-1536x600.png 1536w, https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-10.png 1538w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><span aria-hidden=\"true\" class=\"wp-block-cover__background has-background-dim\"><\/span><div class=\"wp-block-cover__inner-container is-layout-flow wp-block-cover-is-layout-flow\">\n<p class=\"has-text-align-center has-large-font-size\"><\/p>\n<\/div><\/div>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"704\" src=\"https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-12-1024x704.png\" alt=\"\" class=\"wp-image-1318\" srcset=\"https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-12-1024x704.png 1024w, https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-12-300x206.png 300w, https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-12-768x528.png 768w, https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-12-150x103.png 150w, https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-12.png 1128w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"672\" src=\"https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-13-1024x672.png\" alt=\"\" class=\"wp-image-1319\" srcset=\"https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-13-1024x672.png 1024w, https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-13-300x197.png 300w, https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-13-768x504.png 768w, https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-13-150x99.png 150w, https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-13.png 1241w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><strong>Rollback \u043f\u0440\u0438\u043c\u0435\u0440<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"365\" src=\"https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-18-1024x365.png\" alt=\"\" class=\"wp-image-1326\" srcset=\"https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-18-1024x365.png 1024w, https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-18-300x107.png 300w, https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-18-768x274.png 768w, https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-18-150x53.png 150w, https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-18.png 1513w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"652\" src=\"https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-16-1024x652.png\" alt=\"\" class=\"wp-image-1324\" srcset=\"https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-16-1024x652.png 1024w, https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-16-300x191.png 300w, https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-16-768x489.png 768w, https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-16-150x96.png 150w, https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-16.png 1113w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"787\" src=\"https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-17-1024x787.png\" alt=\"\" class=\"wp-image-1325\" srcset=\"https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-17-1024x787.png 1024w, https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-17-300x230.png 300w, https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-17-768x590.png 768w, https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-17-150x115.png 150w, https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-content\/uploads\/2025\/05\/image-17.png 1091w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>hinne 5 &#8211;&nbsp;https:\/\/www.youtube.com\/watch?v=shkt9Z5Gz-U \u0414\u0430\u043d\u043d\u0430\u044f \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u044f \u043e\u0431\u043d\u043e\u0432\u043b\u044f\u0435\u0442 Maakond \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u043d\u0430\u043f\u0438\u0441\u0430\u043d \u043d\u0435 \u0432\u0435\u0440\u043d\u043e \u0430 \u0442\u0430\u043a \u0436\u0435 \u0438\u0437\u043c\u0435\u043d\u044f\u0435\u0442 \u0444\u0430\u043c\u0438\u043b\u0438\u044e \u041d\u043e \u0442\u0440\u0430\u043d\u0437\u0430\u043a\u0446\u0438\u044f \u043d\u0435 \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u0435\u0442\u0441\u044f \u043f\u043e\u0442\u043e\u043c\u0443 \u0447\u0442\u043e \u041f\u043e\u043b\u0435 PereNimi \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442 varchar(10) \u0430 \u0444\u0430\u043c\u0438\u043b\u0438\u044f \u043d\u0430 \u043a\u043e\u0442\u043e\u0440\u0443\u044e \u044f \u043f\u044b\u0442\u0430\u044e\u0441\u044c \u0438\u0437\u043c\u0435\u043d\u0438\u0442\u044c \u0431\u043e\u043b\u044c\u0448\u0435 \u0447\u0435\u043c 10 \u0431\u0443\u043a\u0432\u044b.\u0412 \u0441\u0432\u044f\u0437\u0438 \u0441 \u044d\u0442\u0438\u043c \u0430\u043a\u0442\u0438\u0432\u0438\u0440\u0443\u0435\u0442\u0441\u044f \u0431\u043b\u043e\u043a Catch \u0432 \u043a\u043e\u0442\u043e\u0440\u043e\u043c \u043d\u0430\u0445\u043e\u0442\u044f\u0441\u044f rollback \u0438 \u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442 \u0442\u0430\u0431\u043b\u0438\u0446\u0443 Aadress \u0432 \u0442\u043e \u0441\u043e\u0441\u0442\u043e\u044f\u043d\u0438\u0435 \u043a\u043e\u0442\u043e\u0440\u043e\u0435 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"saved_in_kubio":false,"footnotes":""},"class_list":["post-1290","page","type-page","status-publish","hentry"],"kubio_ai_page_context":{"short_desc":"","purpose":"general"},"_links":{"self":[{"href":"https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-json\/wp\/v2\/pages\/1290","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-json\/wp\/v2\/comments?post=1290"}],"version-history":[{"count":20,"href":"https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-json\/wp\/v2\/pages\/1290\/revisions"}],"predecessor-version":[{"id":1328,"href":"https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-json\/wp\/v2\/pages\/1290\/revisions\/1328"}],"wp:attachment":[{"href":"https:\/\/zhan-gabrielgerke24.thkit.ee\/wp\/wp-json\/wp\/v2\/media?parent=1290"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}