{"id":1566,"date":"2025-10-27T10:49:42","date_gmt":"2025-10-27T08:49:42","guid":{"rendered":"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/?p=1566"},"modified":"2025-11-13T14:37:17","modified_gmt":"2025-11-13T12:37:17","slug":"arvestustoo","status":"publish","type":"post","link":"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/andmebaasid\/1566\/","title":{"rendered":"Arvestust\u00f6\u00f6"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-light-blue ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Lehe Sisukord<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/andmebaasid\/1566\/#Tabelite_loomine_ja_seostamine\" >Tabelite loomine ja seostamine<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/andmebaasid\/1566\/#Kasutaja_loomine_ja_oiguste_haldamine_andmebaasis\" >Kasutaja loomine ja \u00f5iguste haldamine andmebaasis<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/andmebaasid\/1566\/#Logi_tabeli_ja_triggerite_loomine\" >Logi tabeli ja triggerite loomine<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/andmebaasid\/1566\/#Triggerite_too_kontrollimine\" >Triggerite t\u00f6\u00f6 kontrollimine<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/andmebaasid\/1566\/#Kasutaja_oiguste_piiramine\" >Kasutaja \u00f5iguste piiramine<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/andmebaasid\/1566\/#Andmebaasi_protseduuri_loomine\" >Andmebaasi protseduuri loomine<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/andmebaasid\/1566\/#Andmebaasi_transaktsioon_ja_SAVEPOINT\" >Andmebaasi transaktsioon ja SAVEPOINT<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/andmebaasid\/1566\/#Lisa_oma_andmebaasi_tegevus_KlassiStatistika_vaade\" >Lisa oma andmebaasi tegevus: KlassiStatistika vaade<\/a><\/li><\/ul><\/nav><\/div>\n\n<p>K\u00e4esolev postitus k\u00e4sitleb <strong>Andmebaasi Arvestust\u00f6\u00f6<\/strong> raames tehtud tegevusi ja loodud lahendusi. Alustame andmebaasi loomisest ja tabelite seadistamisest.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; gutter: false; title: ; quick-code: false; notranslate\" title=\"\">\nCREATE DATABASE kool;\n<\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Tabelite_loomine_ja_seostamine\"><\/span>Tabelite loomine ja seostamine<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Loomata on <strong>Opetaja<\/strong> tabel.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; gutter: false; title: ; quick-code: false; notranslate\" title=\"\">\nCREATE TABLE Opetaja(\n    OpetajaID INT PRIMARY KEY AUTO_INCREMENT,\n    OpetajaNimi VARCHAR(60) UNIQUE,\n    Aine VARCHAR(60)\n);\n<\/pre><\/div>\n\n\n<p>Seej\u00e4rel loome <strong>Klass<\/strong> tabeli, lisades ka v\u00f5\u00f5rv\u00f5tme seose (foreign key).<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; gutter: false; title: ; quick-code: false; notranslate\" title=\"\">\nCREATE TABLE Klass(\n    KlassID INT PRIMARY KEY AUTO_INCREMENT,\n    KlassNimi VARCHAR(60) UNIQUE,\n    OpetajaID INT,\n    OpilasteArv INT,\n    FOREIGN KEY (OpetajaID) REFERENCES Opetaja(OpetajaID)\n);\n<\/pre><\/div>\n\n\n<p>Viimasena loome <strong>Opilane<\/strong> tabeli koos v\u00f5\u00f5rv\u00f5tmega, mis viitab Klass tabelile.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; gutter: false; title: ; quick-code: false; notranslate\" title=\"\">\nCREATE TABLE Opilane(\n    OpilaneID INT PRIMARY KEY AUTO_INCREMENT,\n    OpilaneNimi VARCHAR(60) UNIQUE,\n    KlassID INT,\n    FOREIGN KEY (KlassID) REFERENCES Klass(KlassID)\n);\n<\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Kasutaja_loomine_ja_oiguste_haldamine_andmebaasis\"><\/span>Kasutaja loomine ja \u00f5iguste haldamine andmebaasis<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Loome uue kasutaja nimega &#8216;test&#8217; ja m\u00e4\u00e4rame talle parooli.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; gutter: false; title: ; quick-code: false; notranslate\" title=\"\">\nCREATE USER &#039;test&#039;@&#039;localhost&#039;\nIDENTIFIED VIA mysql_native_password\nUSING &#039;1111&#039;;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/68D09DFE-903A-48DF-9361-D681B8E0A36D.png\"><img loading=\"lazy\" decoding=\"async\" width=\"580\" height=\"340\" src=\"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/68D09DFE-903A-48DF-9361-D681B8E0A36D.png\" alt=\"Kasutaja 'test' loomine\" class=\"wp-image-1569\" srcset=\"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/68D09DFE-903A-48DF-9361-D681B8E0A36D.png 580w, https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/68D09DFE-903A-48DF-9361-D681B8E0A36D-300x176.png 300w, https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/68D09DFE-903A-48DF-9361-D681B8E0A36D-150x88.png 150w\" sizes=\"auto, (max-width: 580px) 100vw, 580px\" \/><\/a><\/figure>\n\n\n\n<p>Anname kasutajale &#8216;opilaneNimi&#8217; \u00f5igused <strong>andmete vaatamiseks ja lisamiseks<\/strong> &#8220;kool&#8221; andmebaasi tabelites <strong>Klass, Opetaja<\/strong> ja <strong>Opilane<\/strong>.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; gutter: false; title: ; quick-code: false; notranslate\" title=\"\">\nGRANT SELECT, INSERT ON `kool`.`klass` TO &#039;test&#039;@&#039;localhost&#039;;\nGRANT SELECT, INSERT ON `kool`.`opetaja` TO &#039;test&#039;@&#039;localhost&#039;;\nGRANT SELECT, INSERT ON `kool`.`opilane` TO &#039;test&#039;@&#039;localhost&#039;;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/44C538D5-DC21-4827-8506-4331B16DAD13.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"290\" src=\"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/44C538D5-DC21-4827-8506-4331B16DAD13-1024x290.png\" alt=\"Kasutaja \u00f5iguste m\u00e4\u00e4ramine\" class=\"wp-image-1572\" srcset=\"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/44C538D5-DC21-4827-8506-4331B16DAD13-1024x290.png 1024w, https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/44C538D5-DC21-4827-8506-4331B16DAD13-300x85.png 300w, https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/44C538D5-DC21-4827-8506-4331B16DAD13-768x218.png 768w, https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/44C538D5-DC21-4827-8506-4331B16DAD13-150x42.png 150w, https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/44C538D5-DC21-4827-8506-4331B16DAD13.png 1059w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p>Kuvatakse, mida kasutaja <strong>opilaneNimi<\/strong> n\u00e4eb p\u00e4rast \u00f5iguste andmist.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/09F8A476-E807-45A8-B055-9F1BEFE90195.png\"><img loading=\"lazy\" decoding=\"async\" width=\"236\" height=\"232\" src=\"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/09F8A476-E807-45A8-B055-9F1BEFE90195.png\" alt=\"Kasutaja vaade p\u00e4rast \u00f5iguste andmist\" class=\"wp-image-1601\" srcset=\"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/09F8A476-E807-45A8-B055-9F1BEFE90195.png 236w, https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/09F8A476-E807-45A8-B055-9F1BEFE90195-150x147.png 150w\" sizes=\"auto, (max-width: 236px) 100vw, 236px\" \/><\/a><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Logi_tabeli_ja_triggerite_loomine\"><\/span>Logi tabeli ja triggerite loomine<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Loo tabel <strong>logi<\/strong>, et j\u00e4lgida andmebaasi tegevusi.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; gutter: false; title: ; quick-code: false; notranslate\" title=\"\">\nCREATE TABLE logi(\n    id INT PRIMARY KEY AUTO_INCREMENT,\n    kasutaja VARCHAR(80),\n    kuupaev DATETIME,\n    tegevus VARCHAR(90),\n    andmed TEXT\n);\n<\/pre><\/div>\n\n\n<p>Loome triggeri, mis logib andmete <strong>kustutamise<\/strong> tabelis <strong>klass<\/strong>.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; gutter: false; title: ; quick-code: false; notranslate\" title=\"\">\nDELIMITER \/\/\nCREATE TRIGGER tr_klass_delete\nAFTER DELETE ON Klass\nFOR EACH ROW\nBEGIN\n    INSERT INTO logi(kasutaja, kuupaev, tegevus, andmed)\n    VALUES (USER(), NOW(), &#039;Klassi kustutamine&#039;, CONCAT(&#039;Kustutatud klass: &#039;, OLD.KlassNimi, &#039;, ID: &#039;, OLD.KlassID));\nEND;\n\/\/\nDELIMITER ;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/47A0E203-EB23-454A-AC83-8CDB680177AA.png\"><img loading=\"lazy\" decoding=\"async\" width=\"697\" height=\"455\" src=\"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/47A0E203-EB23-454A-AC83-8CDB680177AA.png\" alt=\"Trigger 'tr_klass_delete' loomine\" class=\"wp-image-1575\" srcset=\"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/47A0E203-EB23-454A-AC83-8CDB680177AA.png 697w, https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/47A0E203-EB23-454A-AC83-8CDB680177AA-300x196.png 300w, https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/47A0E203-EB23-454A-AC83-8CDB680177AA-150x98.png 150w\" sizes=\"auto, (max-width: 697px) 100vw, 697px\" \/><\/a><\/figure>\n\n\n\n<p>See trigger j\u00e4lgib andmete <strong>lisamist<\/strong> tabelisse <strong>klass<\/strong> ja logib selle &#8220;logi&#8221; tabelisse.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; gutter: false; title: ; quick-code: false; notranslate\" title=\"\">\nDELIMITER \/\/\nCREATE TRIGGER tr_klass_insert\nAFTER INSERT ON Klass\nFOR EACH ROW\nBEGIN\n    INSERT INTO logi(kasutaja, kuupaev, tegevus, andmed)\n    VALUES (USER(), NOW(), &#039;Klassi lisamine&#039;, CONCAT(&#039;Lisatud klass: &#039;, NEW.KlassNimi, &#039;, ID: &#039;, NEW.KlassID));\nEND;\n\/\/\nDELIMITER ;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/44279CE1-2FAD-491E-972D-1556C48F36E9.png\"><img loading=\"lazy\" decoding=\"async\" width=\"692\" height=\"446\" src=\"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/44279CE1-2FAD-491E-972D-1556C48F36E9.png\" alt=\"Trigger 'tr_klass_insert' loomine\" class=\"wp-image-1576\" srcset=\"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/44279CE1-2FAD-491E-972D-1556C48F36E9.png 692w, https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/44279CE1-2FAD-491E-972D-1556C48F36E9-300x193.png 300w, https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/44279CE1-2FAD-491E-972D-1556C48F36E9-150x97.png 150w\" sizes=\"auto, (max-width: 692px) 100vw, 692px\" \/><\/a><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Triggerite_too_kontrollimine\"><\/span>Triggerite t\u00f6\u00f6 kontrollimine<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Kontrollime, et andmed luuakse tabelisse <strong>logi<\/strong>, kui lisame midagi <strong>klass<\/strong> tabelisse.<\/p>\n\n\n\n<p><strong>Teeme n\u00e4idisandmed:<\/strong><\/p>\n\n\n\n<p>Opetaja:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; gutter: false; title: ; quick-code: false; notranslate\" title=\"\">\nINSERT INTO `opetaja` (`OpetajaNimi`, `Aine`)\nVALUES (&#039;Mari Speek&#039;, &#039;Sotsiaalained&#039;);\n<\/pre><\/div>\n\n\n<p>Klass:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; gutter: false; title: ; quick-code: false; notranslate\" title=\"\">\nINSERT INTO `klass` (`KlassNimi`, `OpetajaID`, `OpilasteArv`)\nVALUES (&#039;TARpv24&#039;, 2, 15);\n<\/pre><\/div>\n\n\n<p><strong>Logi tabel p\u00e4rast lisamist:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/39E63ABA-DD48-4589-916A-55E5CD9DADDB.png\"><img loading=\"lazy\" decoding=\"async\" width=\"985\" height=\"80\" src=\"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/39E63ABA-DD48-4589-916A-55E5CD9DADDB.png\" alt=\"Logi tabel p\u00e4rast klassi lisamist\" class=\"wp-image-1578\" srcset=\"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/39E63ABA-DD48-4589-916A-55E5CD9DADDB.png 985w, https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/39E63ABA-DD48-4589-916A-55E5CD9DADDB-300x24.png 300w, https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/39E63ABA-DD48-4589-916A-55E5CD9DADDB-768x62.png 768w, https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/39E63ABA-DD48-4589-916A-55E5CD9DADDB-150x12.png 150w\" sizes=\"auto, (max-width: 985px) 100vw, 985px\" \/><\/a><\/figure>\n\n\n\n<p>Kontrollime, et andmed luuakse tabelisse <strong>logi<\/strong>, kui kustutame midagi <strong>klass<\/strong> tabelist.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; gutter: false; title: ; quick-code: false; notranslate\" title=\"\">\nDELETE FROM klass\nWHERE KlassNimi = &#039;TARpv24&#039;;\n<\/pre><\/div>\n\n\n<p><strong>Logi tabel p\u00e4rast kustutamist:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/1F3A4CB3-AF87-4B65-ABCD-C402343DFA38.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1012\" height=\"72\" src=\"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/1F3A4CB3-AF87-4B65-ABCD-C402343DFA38.png\" alt=\"Logi tabel p\u00e4rast klassi kustutamist\" class=\"wp-image-1579\" srcset=\"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/1F3A4CB3-AF87-4B65-ABCD-C402343DFA38.png 1012w, https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/1F3A4CB3-AF87-4B65-ABCD-C402343DFA38-300x21.png 300w, https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/1F3A4CB3-AF87-4B65-ABCD-C402343DFA38-768x55.png 768w, https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/1F3A4CB3-AF87-4B65-ABCD-C402343DFA38-150x11.png 150w\" sizes=\"auto, (max-width: 1012px) 100vw, 1012px\" \/><\/a><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Kasutaja_oiguste_piiramine\"><\/span>Kasutaja \u00f5iguste piiramine<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Kontrollime, et kasutaja <strong>opilaneNimi<\/strong> ei saa teha tegevusi, mis talle ei ole lubatud, n\u00e4iteks andmete muutmine v\u00f5i uute tabelite loomine.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; gutter: false; title: ; quick-code: false; notranslate\" title=\"\">\nUPDATE opetaja\nSET OpetajaNimi = &#039;Alina&#039;\nWHERE OpetajaID = 2;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/2732986F-67FF-4C93-81EF-F4CEE1043077.png\"><img loading=\"lazy\" decoding=\"async\" width=\"833\" height=\"111\" src=\"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/2732986F-67FF-4C93-81EF-F4CEE1043077.png\" alt=\"Katsutakse uuendada \u00f5petaja nime ilma vajalike \u00f5igusteta\" class=\"wp-image-1581\" srcset=\"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/2732986F-67FF-4C93-81EF-F4CEE1043077.png 833w, https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/2732986F-67FF-4C93-81EF-F4CEE1043077-300x40.png 300w, https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/2732986F-67FF-4C93-81EF-F4CEE1043077-768x102.png 768w, https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/2732986F-67FF-4C93-81EF-F4CEE1043077-150x20.png 150w\" sizes=\"auto, (max-width: 833px) 100vw, 833px\" \/><\/a><\/figure>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; gutter: false; title: ; quick-code: false; notranslate\" title=\"\">\nCREATE TABLE test(\n    testID INT PRIMARY KEY AUTO_INCREMENT,\n    kiri VARCHAR(200)\n);\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/7422ABD1-001F-46D7-B0CB-57E4B3C9F772.png\"><img loading=\"lazy\" decoding=\"async\" width=\"798\" height=\"94\" src=\"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/7422ABD1-001F-46D7-B0CB-57E4B3C9F772.png\" alt=\"Katsutakse luua tabelit ilma vajalike \u00f5igusteta\" class=\"wp-image-1582\" srcset=\"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/7422ABD1-001F-46D7-B0CB-57E4B3C9F772.png 798w, https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/7422ABD1-001F-46D7-B0CB-57E4B3C9F772-300x35.png 300w, https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/7422ABD1-001F-46D7-B0CB-57E4B3C9F772-768x90.png 768w, https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/7422ABD1-001F-46D7-B0CB-57E4B3C9F772-150x18.png 150w\" sizes=\"auto, (max-width: 798px) 100vw, 798px\" \/><\/a><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Andmebaasi_protseduuri_loomine\"><\/span>Andmebaasi protseduuri loomine<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Loome protseduuri, mis kuvab k\u00f5ik <strong>klassid ja nende \u00f5pilased<\/strong>, kes on seotud <strong>kindla<\/strong> \u00f5petajaga.<\/p>\n\n\n\n<p>Lisame uue <strong>\u00f5pilase<\/strong> protseduuri testimiseks:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; gutter: false; title: ; quick-code: false; notranslate\" title=\"\">\nINSERT INTO `opilane` (`OpilaneNimi`, `KlassID`)\nVALUES (&#039;Maksim&#039;, 5);\n<\/pre><\/div>\n\n\n<p><strong>Protseduuri definitsioon:<\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; gutter: false; title: ; quick-code: false; notranslate\" title=\"\">\nDELIMITER \/\/\nCREATE PROCEDURE GetKlassidJaOpilasedByOpetaja(IN opetaja_id INT)\nBEGIN\n    SELECT\n        o.OpetajaNimi,\n        k.KlassNimi,\n        p.OpilaneNimi\n    FROM Opetaja o\n    LEFT JOIN Klass k ON o.OpetajaID = k.OpetajaID\n    LEFT JOIN Opilane p ON k.KlassID = p.KlassID\n    WHERE o.OpetajaID = opetaja_id;\nEND \/\/\nDELIMITER ;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/2E370100-0AA0-4231-8AFA-E8FCF1B7B7A8.png\"><img loading=\"lazy\" decoding=\"async\" width=\"864\" height=\"427\" src=\"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/2E370100-0AA0-4231-8AFA-E8FCF1B7B7A8.png\" alt=\"Protseduuri 'GetKlassidJaOpilasedByOpetaja' loomine\" class=\"wp-image-1587\" srcset=\"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/2E370100-0AA0-4231-8AFA-E8FCF1B7B7A8.png 864w, https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/2E370100-0AA0-4231-8AFA-E8FCF1B7B7A8-300x148.png 300w, https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/2E370100-0AA0-4231-8AFA-E8FCF1B7B7A8-768x380.png 768w, https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/2E370100-0AA0-4231-8AFA-E8FCF1B7B7A8-150x74.png 150w\" sizes=\"auto, (max-width: 864px) 100vw, 864px\" \/><\/a><\/figure>\n\n\n\n<p><strong>Protseduuri k\u00e4ivitamine ja tulemus:<\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; gutter: false; title: ; quick-code: false; notranslate\" title=\"\">\nCALL GetKlassidJaOpilasedByOpetaja(2);\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/EDB79D26-F387-492F-9DFA-03E0060935A8.png\"><img loading=\"lazy\" decoding=\"async\" width=\"559\" height=\"244\" src=\"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/EDB79D26-F387-492F-9DFA-03E0060935A8.png\" alt=\"Protseduuri 'GetKlassidJaOpilasedByOpetaja' tulemus\" class=\"wp-image-1588\" srcset=\"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/EDB79D26-F387-492F-9DFA-03E0060935A8.png 559w, https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/EDB79D26-F387-492F-9DFA-03E0060935A8-300x131.png 300w, https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/EDB79D26-F387-492F-9DFA-03E0060935A8-150x65.png 150w\" sizes=\"auto, (max-width: 559px) 100vw, 559px\" \/><\/a><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Andmebaasi_transaktsioon_ja_SAVEPOINT\"><\/span>Andmebaasi transaktsioon ja SAVEPOINT<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Loome transaktsiooni, mis v\u00f5imaldab <strong>sisestatud<\/strong> andmed vajadusel <strong>tagasi v\u00f5tta<\/strong>, kasutades <strong>SAVEPOINT<\/strong>&#8217;i. See on oluline osa andmebaasi arvestust\u00f6\u00f6st andmete terviklikkuse tagamiseks.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; gutter: false; title: ; quick-code: false; notranslate\" title=\"\">\nSTART TRANSACTION;\n\nSAVEPOINT esimene;\n\nINSERT INTO Opetaja (OpetajaNimi, Aine)\nVALUES (&#039;Tanne Kiik&#039;, &#039;Matemaatika&#039;);\n\nSELECT * FROM Opetaja;\nROLLBACK TO esimene;\nSELECT * FROM Opetaja;\n\nCOMMIT;\n<\/pre><\/div>\n\n\n<p><strong>Enne<\/strong> ROLLBACK&#8217;i, n\u00e4eme lisatud \u00f5petajat:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/A2FD7914-93F3-4C52-8CAD-DA8A81962D40.png\"><img loading=\"lazy\" decoding=\"async\" width=\"340\" height=\"170\" src=\"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/A2FD7914-93F3-4C52-8CAD-DA8A81962D40.png\" alt=\"\u00d5petaja tabel enne ROLLBACKi\" class=\"wp-image-1610\" srcset=\"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/A2FD7914-93F3-4C52-8CAD-DA8A81962D40.png 340w, https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/A2FD7914-93F3-4C52-8CAD-DA8A81962D40-300x150.png 300w, https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/A2FD7914-93F3-4C52-8CAD-DA8A81962D40-150x75.png 150w\" sizes=\"auto, (max-width: 340px) 100vw, 340px\" \/><\/a><\/figure>\n\n\n\n<p><strong>P\u00e4rast<\/strong> ROLLBACK&#8217;i, on lisatud \u00f5petaja kadunud:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/17C4B5FD-6F2B-4CF2-9609-57BDF5E7F9A9.png\"><img loading=\"lazy\" decoding=\"async\" width=\"335\" height=\"145\" src=\"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/17C4B5FD-6F2B-4CF2-9609-57BDF5E7F9A9.png\" alt=\"\u00d5petaja tabel p\u00e4rast ROLLBACKi\" class=\"wp-image-1611\" srcset=\"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/17C4B5FD-6F2B-4CF2-9609-57BDF5E7F9A9.png 335w, https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/17C4B5FD-6F2B-4CF2-9609-57BDF5E7F9A9-300x130.png 300w, https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/17C4B5FD-6F2B-4CF2-9609-57BDF5E7F9A9-150x65.png 150w\" sizes=\"auto, (max-width: 335px) 100vw, 335px\" \/><\/a><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Lisa_oma_andmebaasi_tegevus_KlassiStatistika_vaade\"><\/span>Lisa oma andmebaasi tegevus: KlassiStatistika vaade<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Lisame <strong>vaate<\/strong> nimega <strong>KlassiStatistika<\/strong>, mis kuvab iga \u00f5petaja \u00f5petatavad klassid koos \u00f5pilaste arvuga. See on kasulik funktsioon andmebaasi arvestust\u00f6\u00f6 kontekstis.<\/p>\n\n\n\n<p>See vaade on \u00e4\u00e4rmiselt kasulik, sest see n\u00e4itab <strong>koheselt<\/strong>, kui palju \u00f5pilasi <strong>igas<\/strong> klassis on, aidates kaasa kooli ressursside planeerimisele ja \u00fclevaate saamisele.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; gutter: false; title: ; quick-code: false; notranslate\" title=\"\">\nCREATE VIEW KlassiStatistika AS\nSELECT\n  o.OpetajaNimi AS Opetaja,\n  k.KlassNimi AS Klass,\n  COUNT(p.OpilaneID) AS OpilasteKokku\nFROM Opetaja o\nLEFT JOIN Klass k ON o.OpetajaID = k.OpetajaID\nLEFT JOIN Opilane p ON k.KlassID = p.KlassID\nGROUP BY o.OpetajaNimi, k.KlassNimi;\n<\/pre><\/div>\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; gutter: false; title: ; quick-code: false; notranslate\" title=\"\">\nSELECT * FROM `KlassiStatistika`;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/492CCACE-736D-4ACE-9534-44385A2C4466.png\"><img loading=\"lazy\" decoding=\"async\" width=\"297\" height=\"143\" src=\"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/492CCACE-736D-4ACE-9534-44385A2C4466.png\" alt=\"KlassiStatistika vaade ja selle tulemus\" class=\"wp-image-1595\" srcset=\"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/492CCACE-736D-4ACE-9534-44385A2C4466.png 297w, https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/492CCACE-736D-4ACE-9534-44385A2C4466-150x72.png 150w\" sizes=\"auto, (max-width: 297px) 100vw, 297px\" \/><\/a><\/figure>\n\n\n\n<p><strong>Miks LEFT JOIN?<\/strong> Kasutame LEFT JOIN-i selleks, et kuvada ka \u00f5petajad, kellel hetkel \u00fchtegi klassi pole. See tagab tervikliku \u00fclevaate k\u00f5ikidest \u00f5petajatest ja nende seostest klassidega, isegi kui seos puudub.<\/p>\n\n\n\n<p>Loodame, et see <strong>Andmebaasi Arvestust\u00f6\u00f6<\/strong> \u00fclevaade oli kasulik! Kui teil on k\u00fcsimusi andmebaasi haldamise kohta, v\u00f5tke julgelt \u00fchendust.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>K\u00e4esolev postitus k\u00e4sitleb Andmebaasi Arvestust\u00f6\u00f6 raames tehtud tegevusi ja loodud lahendusi. Alustame andmebaasi loomisest ja tabelite &hellip; <a title=\"Arvestust\u00f6\u00f6\" class=\"hm-read-more\" href=\"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/andmebaasid\/1566\/\"><span class=\"screen-reader-text\">Arvestust\u00f6\u00f6<\/span>Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23],"tags":[],"class_list":["post-1566","post","type-post","status-publish","format-standard","hentry","category-andmebaasid"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Arvestust\u00f6\u00f6 - Maksim Tsikvasvili Portfoolio<\/title>\n<meta name=\"description\" content=\"Kuidas luua ja hallata andmeid Andmebaasi Arvestust\u00f6\u00f6s, sealhulgas andmete kustutamise ja lisamise j\u00e4lgimine.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/andmebaasid\/1566\/\" \/>\n<meta property=\"og:locale\" content=\"et_EE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Arvestust\u00f6\u00f6 - Maksim Tsikvasvili Portfoolio\" \/>\n<meta property=\"og:description\" content=\"Kuidas luua ja hallata andmeid Andmebaasi Arvestust\u00f6\u00f6s, sealhulgas andmete kustutamise ja lisamise j\u00e4lgimine.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/andmebaasid\/1566\/\" \/>\n<meta property=\"og:site_name\" content=\"Maksim Tsikvasvili Portfoolio\" \/>\n<meta property=\"article:published_time\" content=\"2025-10-27T08:49:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-11-13T12:37:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/68D09DFE-903A-48DF-9361-D681B8E0A36D.png\" \/>\n<meta name=\"author\" content=\"maksimts\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"maksimts\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/maksimtsikvasvili24.thkit.ee\\\/wp\\\/andmebaasid\\\/1566\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/maksimtsikvasvili24.thkit.ee\\\/wp\\\/andmebaasid\\\/1566\\\/\"},\"author\":{\"name\":\"maksimts\",\"@id\":\"https:\\\/\\\/maksimtsikvasvili24.thkit.ee\\\/wp\\\/#\\\/schema\\\/person\\\/7cb6b74fb2201ba0d88c848f62c07d72\"},\"headline\":\"Arvestust\u00f6\u00f6\",\"datePublished\":\"2025-10-27T08:49:42+00:00\",\"dateModified\":\"2025-11-13T12:37:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/maksimtsikvasvili24.thkit.ee\\\/wp\\\/andmebaasid\\\/1566\\\/\"},\"wordCount\":367,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/maksimtsikvasvili24.thkit.ee\\\/wp\\\/#\\\/schema\\\/person\\\/7cb6b74fb2201ba0d88c848f62c07d72\"},\"image\":{\"@id\":\"https:\\\/\\\/maksimtsikvasvili24.thkit.ee\\\/wp\\\/andmebaasid\\\/1566\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/maksimtsikvasvili24.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2025\\\/10\\\/68D09DFE-903A-48DF-9361-D681B8E0A36D.png\",\"articleSection\":[\"Andmebaasid\"],\"inLanguage\":\"et\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/maksimtsikvasvili24.thkit.ee\\\/wp\\\/andmebaasid\\\/1566\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/maksimtsikvasvili24.thkit.ee\\\/wp\\\/andmebaasid\\\/1566\\\/\",\"url\":\"https:\\\/\\\/maksimtsikvasvili24.thkit.ee\\\/wp\\\/andmebaasid\\\/1566\\\/\",\"name\":\"Arvestust\u00f6\u00f6 - Maksim Tsikvasvili Portfoolio\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/maksimtsikvasvili24.thkit.ee\\\/wp\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/maksimtsikvasvili24.thkit.ee\\\/wp\\\/andmebaasid\\\/1566\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/maksimtsikvasvili24.thkit.ee\\\/wp\\\/andmebaasid\\\/1566\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/maksimtsikvasvili24.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2025\\\/10\\\/68D09DFE-903A-48DF-9361-D681B8E0A36D.png\",\"datePublished\":\"2025-10-27T08:49:42+00:00\",\"dateModified\":\"2025-11-13T12:37:17+00:00\",\"description\":\"Kuidas luua ja hallata andmeid Andmebaasi Arvestust\u00f6\u00f6s, sealhulgas andmete kustutamise ja lisamise j\u00e4lgimine.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/maksimtsikvasvili24.thkit.ee\\\/wp\\\/andmebaasid\\\/1566\\\/#breadcrumb\"},\"inLanguage\":\"et\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/maksimtsikvasvili24.thkit.ee\\\/wp\\\/andmebaasid\\\/1566\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"et\",\"@id\":\"https:\\\/\\\/maksimtsikvasvili24.thkit.ee\\\/wp\\\/andmebaasid\\\/1566\\\/#primaryimage\",\"url\":\"https:\\\/\\\/maksimtsikvasvili24.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2025\\\/10\\\/68D09DFE-903A-48DF-9361-D681B8E0A36D.png\",\"contentUrl\":\"https:\\\/\\\/maksimtsikvasvili24.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2025\\\/10\\\/68D09DFE-903A-48DF-9361-D681B8E0A36D.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/maksimtsikvasvili24.thkit.ee\\\/wp\\\/andmebaasid\\\/1566\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/maksimtsikvasvili24.thkit.ee\\\/wp\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Arvestust\u00f6\u00f6\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/maksimtsikvasvili24.thkit.ee\\\/wp\\\/#website\",\"url\":\"https:\\\/\\\/maksimtsikvasvili24.thkit.ee\\\/wp\\\/\",\"name\":\"Maksim Tsikvasvili Portfoolio\",\"description\":\"Noorem tarkvaraarendaja\",\"publisher\":{\"@id\":\"https:\\\/\\\/maksimtsikvasvili24.thkit.ee\\\/wp\\\/#\\\/schema\\\/person\\\/7cb6b74fb2201ba0d88c848f62c07d72\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/maksimtsikvasvili24.thkit.ee\\\/wp\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"et\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/maksimtsikvasvili24.thkit.ee\\\/wp\\\/#\\\/schema\\\/person\\\/7cb6b74fb2201ba0d88c848f62c07d72\",\"name\":\"maksimts\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"et\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/af5ea11f0ac162c91ad004672c1fbf053f94a9c44fa7dacb420d4c5b4a4f7c4a?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/af5ea11f0ac162c91ad004672c1fbf053f94a9c44fa7dacb420d4c5b4a4f7c4a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/af5ea11f0ac162c91ad004672c1fbf053f94a9c44fa7dacb420d4c5b4a4f7c4a?s=96&d=mm&r=g\",\"caption\":\"maksimts\"},\"logo\":{\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/af5ea11f0ac162c91ad004672c1fbf053f94a9c44fa7dacb420d4c5b4a4f7c4a?s=96&d=mm&r=g\"},\"sameAs\":[\"https:\\\/\\\/maksimtsikvasvili24.thkit.ee\\\/wp\"],\"url\":\"https:\\\/\\\/maksimtsikvasvili24.thkit.ee\\\/wp\\\/author\\\/admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Arvestust\u00f6\u00f6 - Maksim Tsikvasvili Portfoolio","description":"Kuidas luua ja hallata andmeid Andmebaasi Arvestust\u00f6\u00f6s, sealhulgas andmete kustutamise ja lisamise j\u00e4lgimine.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/andmebaasid\/1566\/","og_locale":"et_EE","og_type":"article","og_title":"Arvestust\u00f6\u00f6 - Maksim Tsikvasvili Portfoolio","og_description":"Kuidas luua ja hallata andmeid Andmebaasi Arvestust\u00f6\u00f6s, sealhulgas andmete kustutamise ja lisamise j\u00e4lgimine.","og_url":"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/andmebaasid\/1566\/","og_site_name":"Maksim Tsikvasvili Portfoolio","article_published_time":"2025-10-27T08:49:42+00:00","article_modified_time":"2025-11-13T12:37:17+00:00","og_image":[{"url":"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/68D09DFE-903A-48DF-9361-D681B8E0A36D.png","type":"","width":"","height":""}],"author":"maksimts","twitter_card":"summary_large_image","twitter_misc":{"Written by":"maksimts","Est. reading time":"5 minutit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/andmebaasid\/1566\/#article","isPartOf":{"@id":"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/andmebaasid\/1566\/"},"author":{"name":"maksimts","@id":"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/#\/schema\/person\/7cb6b74fb2201ba0d88c848f62c07d72"},"headline":"Arvestust\u00f6\u00f6","datePublished":"2025-10-27T08:49:42+00:00","dateModified":"2025-11-13T12:37:17+00:00","mainEntityOfPage":{"@id":"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/andmebaasid\/1566\/"},"wordCount":367,"commentCount":0,"publisher":{"@id":"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/#\/schema\/person\/7cb6b74fb2201ba0d88c848f62c07d72"},"image":{"@id":"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/andmebaasid\/1566\/#primaryimage"},"thumbnailUrl":"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/68D09DFE-903A-48DF-9361-D681B8E0A36D.png","articleSection":["Andmebaasid"],"inLanguage":"et","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/andmebaasid\/1566\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/andmebaasid\/1566\/","url":"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/andmebaasid\/1566\/","name":"Arvestust\u00f6\u00f6 - Maksim Tsikvasvili Portfoolio","isPartOf":{"@id":"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/andmebaasid\/1566\/#primaryimage"},"image":{"@id":"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/andmebaasid\/1566\/#primaryimage"},"thumbnailUrl":"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/68D09DFE-903A-48DF-9361-D681B8E0A36D.png","datePublished":"2025-10-27T08:49:42+00:00","dateModified":"2025-11-13T12:37:17+00:00","description":"Kuidas luua ja hallata andmeid Andmebaasi Arvestust\u00f6\u00f6s, sealhulgas andmete kustutamise ja lisamise j\u00e4lgimine.","breadcrumb":{"@id":"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/andmebaasid\/1566\/#breadcrumb"},"inLanguage":"et","potentialAction":[{"@type":"ReadAction","target":["https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/andmebaasid\/1566\/"]}]},{"@type":"ImageObject","inLanguage":"et","@id":"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/andmebaasid\/1566\/#primaryimage","url":"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/68D09DFE-903A-48DF-9361-D681B8E0A36D.png","contentUrl":"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-content\/uploads\/2025\/10\/68D09DFE-903A-48DF-9361-D681B8E0A36D.png"},{"@type":"BreadcrumbList","@id":"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/andmebaasid\/1566\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/"},{"@type":"ListItem","position":2,"name":"Arvestust\u00f6\u00f6"}]},{"@type":"WebSite","@id":"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/#website","url":"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/","name":"Maksim Tsikvasvili Portfoolio","description":"Noorem tarkvaraarendaja","publisher":{"@id":"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/#\/schema\/person\/7cb6b74fb2201ba0d88c848f62c07d72"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"et"},{"@type":["Person","Organization"],"@id":"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/#\/schema\/person\/7cb6b74fb2201ba0d88c848f62c07d72","name":"maksimts","image":{"@type":"ImageObject","inLanguage":"et","@id":"https:\/\/secure.gravatar.com\/avatar\/af5ea11f0ac162c91ad004672c1fbf053f94a9c44fa7dacb420d4c5b4a4f7c4a?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/af5ea11f0ac162c91ad004672c1fbf053f94a9c44fa7dacb420d4c5b4a4f7c4a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/af5ea11f0ac162c91ad004672c1fbf053f94a9c44fa7dacb420d4c5b4a4f7c4a?s=96&d=mm&r=g","caption":"maksimts"},"logo":{"@id":"https:\/\/secure.gravatar.com\/avatar\/af5ea11f0ac162c91ad004672c1fbf053f94a9c44fa7dacb420d4c5b4a4f7c4a?s=96&d=mm&r=g"},"sameAs":["https:\/\/maksimtsikvasvili24.thkit.ee\/wp"],"url":"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-json\/wp\/v2\/posts\/1566","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-json\/wp\/v2\/comments?post=1566"}],"version-history":[{"count":24,"href":"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-json\/wp\/v2\/posts\/1566\/revisions"}],"predecessor-version":[{"id":1683,"href":"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-json\/wp\/v2\/posts\/1566\/revisions\/1683"}],"wp:attachment":[{"href":"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-json\/wp\/v2\/media?parent=1566"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-json\/wp\/v2\/categories?post=1566"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/maksimtsikvasvili24.thkit.ee\/wp\/wp-json\/wp\/v2\/tags?post=1566"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}