{"version":"1.0","provider_name":"Alex's Arsenal (Shop)","provider_url":"https:\/\/aleksanderbekasov24.thkit.ee\/wp","author_name":"admin","author_url":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/blog\/author\/admin\/","title":"Andmebaas - Triggers - Alex's Arsenal (Shop)","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"QeUIPJiC5L\"><a href=\"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/andmebaas-triggers\/\">Andmebaas &#8211; Triggers<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/andmebaas-triggers\/embed\/#?secret=QeUIPJiC5L\" width=\"600\" height=\"338\" title=\"&#8220;Andmebaas &#8211; Triggers&#8221; &#8212; Alex&#039;s Arsenal (Shop)\" data-secret=\"QeUIPJiC5L\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script>\n\/*! This file is auto-generated *\/\n!function(d,l){\"use strict\";l.querySelector&&d.addEventListener&&\"undefined\"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!\/[^a-zA-Z0-9]\/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),o=l.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),c=new RegExp(\"^https?:$\",\"i\"),i=0;i<o.length;i++)o[i].style.display=\"none\";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute(\"style\"),\"height\"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):\"link\"===t.message&&(r=new URL(s.getAttribute(\"src\")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener(\"message\",d.wp.receiveEmbedMessage,!1),l.addEventListener(\"DOMContentLoaded\",function(){for(var e,t,s=l.querySelectorAll(\"iframe.wp-embedded-content\"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute(\"data-secret\"))||(t=Math.random().toString(36).substring(2,12),e.src+=\"#?secret=\"+t,e.setAttribute(\"data-secret\",t)),e.contentWindow.postMessage({message:\"ready\",secret:t},\"*\")},!1)))}(window,document);\n\/\/# sourceURL=https:\/\/aleksanderbekasov24.thkit.ee\/wp\/wp-includes\/js\/wp-embed.min.js\n<\/script>\n","description":"Logitabeli ja trigger&#8217;ite loomine autoriregistri muutuste logimiseks \u00dclesanne:Luua tabel logitabel(id, toiming, aeg, autoAndmed), mis fikseerib muudatused autoreregister tabelis. Samuti tuleb luua autoreregister tabel koos v\u00e4lja m\u00f5eldud veergudega ning teha triggerid, mis logivad INSERT, UPDATE ja DELETE toiminguid logitabel tabelisse. Kontrollida, kas triggerid t\u00f6\u00f6tavad. \ud83d\udd39 1. Tabeli autoreregister loomine L\u00f5in tabeli, kuhu salvestatakse auto andmed. V\u00e4ljad, mille valisin: \ud83d\udd39 2. Tabeli logitabel loomine See tabel salvestab k\u00f5ik muudatused, mis toimuvad autoreregister tabelis. V\u00e4ljad: \ud83d\udd39 3. Triggerite loomine L\u00f5in kolm triggerit, mis lisavad muudatuse logitabel tabelisse. \u2705 INSERT Trigger \u2705 UPDATE Trigger \u2705 DELETE Trigger \ud83d\udd39 4. Kontrollimine (Testimine) Testisin, et k\u00f5ik t\u00f6\u00f6tab korralikult: 2. Muutmine: Lisasime seotud tabeli owners tabelile autoreregister, et hallata autode omanike andmeid. Muudeti triggerite toimingud nii, et andmed tabelist owners kajastuvad ka logitabelis logitabel iga lisamise, uuendamise ja kustutamise korral autoreregister tabelis. 1. Lisasime seotud tabeli owners: Tabel owners sisaldab auto omaniku andmeid, mis on seotud tabeliga autoreregister. Tabeli owners loomine: Tabeli autoreregister muutmine ja v\u00e4lisv\u00f5tme lisamine: Triggerid: [SQL Server] \u00dche tabeli triggeri loomine harjutus Sisestan andmed: Eemaldan andmed: Uuendan andmed: Tehtud tegevused logi tabelis: Triggerite loomine [SQL Server] Harjutus kahe tabelite seosete (on loodud tabel 'omanik')","thumbnail_url":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/04\/t1.png","thumbnail_width":1918,"thumbnail_height":392}