{"id":1652,"date":"2025-03-25T18:16:16","date_gmt":"2025-03-25T18:16:16","guid":{"rendered":"https:\/\/annaoleks24.thkit.ee\/wp\/?page_id=1652"},"modified":"2025-03-28T16:11:51","modified_gmt":"2025-03-28T16:11:51","slug":"trigger","status":"publish","type":"page","link":"https:\/\/annaoleks24.thkit.ee\/wp\/trigger\/","title":{"rendered":"Trigger"},"content":{"rendered":"\n
<\/div>\n\n\n\n

Triger on protsess, mille abil selles salvestatud tegevused t\u00e4idetakse automaatselt.<\/p>\n\n\n\n

<\/div>\n\n\n\n
\n
\n

T\u00f6\u00f6tamine vallandajaga SQLis:
<\/h3>\n<\/div>\n\n\n\n
\n

T\u00f6\u00f6tamine vallandajaga XAMPPis:
<\/h3>\n<\/div>\n<\/div>\n\n\n\n
<\/div>\n\n\n\n

Luua andmebaas ja tabelid (meil on autod ja logi (kus salvestatakse tegevused tabelitega, mis t\u00e4idetakse automaatselt trigerite abil)).<\/p>\n\n\n\n

<\/div>\n\n\n\n
\n
\nCREATE DATABASE AutoRegister\n<\/pre><\/div>\n\n\n
<\/div>\n\n\n\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n
<\/div>\n\n\n
\nCREATE TABLE autod(\nautoID int PRIMARY KEY IDENTITY(1,1),\nregistreerimismark varchar(6) NOT NULL,\nmark varchar(30),\nesmaneRegistreerimine DATE,\nkere varchar(30),\nvarvus varchar(30),\nvoimsuskW int,\nkutus varchar(30),\nkaigukast varchar(30),\nomanik varchar(30));\n<\/pre><\/div>\n\n\n
<\/div>\n\n\n\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n
<\/div>\n\n\n\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n
<\/div>\n\n\n
\nCREATE TABLE logi(\nid int PRIMARY KEY IDENTITY(1,1),\naeg DATETIME,\ntoiming varchar(100),\nandmed TEXT,\nkasutaja varchar(30));\n<\/pre><\/div>\n\n\n
<\/div>\n\n\n\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n
<\/div>\n\n\n\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n<\/div>\n\n\n\n
\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n
<\/div>\n\n\n\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n
<\/div>\n\n\n
\nCREATE TABLE autod(\nautoID int PRIMARY KEY AUTO_INCREMENT,\nregistreerimismark varchar(6) NOT NULL,\nmark varchar(30),\nesmaneRegistreerimine DATE,\nkere varchar(30),\nvarvus varchar(30),\nvoimsuskW int,\nkutus varchar(30),\nkaigukast varchar(30),\nomanik varchar(30));\n<\/pre><\/div>\n\n\n
<\/div>\n\n\n\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n
<\/div>\n\n\n
\nCREATE TABLE logi(\nid int PRIMARY KEY AUTO_INCREMENT,\naeg DATETIME,\ntoiming varchar(100),\nandmed TEXT,\nkasutaja varchar(30));\n<\/pre><\/div>\n\n\n
<\/div>\n\n\n\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n
<\/div>\n\n\n\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n<\/div>\n<\/div>\n\n\n\n
<\/div>\n\n\n\n
Loo triger lisatud andmete j\u00e4lgimiseks:<\/strong><\/p>\n\n\n\n
\n
\nCREATE TRIGGER autoLisamine\nON autod\nFOR INSERT\nAS\nINSERT INTO logi(aeg, toiming, andmed, kasutaja)\nSELECT GETDATE(),\n'uus auto on lisatud',\nCONCAT ('registreerimismark: ', inserted.registreerimismark, ' \/ mark: ', inserted.mark, ' \/ omanik: ', inserted.omanik),\nSUSER_NAME()\nFROM inserted;\n<\/pre><\/div>\n\n\n
<\/div>\n\n\n\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n
<\/div>\n\n\n\n
Kontrollimine:<\/p>\n\n\n
\nINSERT INTO autod (registreerimismark, mark, esmaneRegistreerimine, kere, varvus, voimsuskW, kutus, kaigukast, omanik)  \nVALUES \n('123ABC', 'Toyota Corolla', '2018-05-12', 'Sedaan', 'Sinine', 85, 'Bensiin', 'Automaat', 'Jaan Tamm'),  \n('456DEF', 'Volkswagen Golf', '2020-08-25', 'Luukp\u00e4ra', 'Must', 96, 'Diisel', 'Manuaal', 'Mari Mets'),  \n('789GHI', 'BMW X5', '2019-03-17', 'Maastur', 'Valge', 195, 'Bensiin', 'Automaat', 'Peeter P\u00f5ld'),  \n('321JKL', 'Audi A4', '2017-11-30', 'Sedaan', 'Hall', 110, 'Diisel', 'Automaat', 'Laura Kask'),  \n('654MNO', 'Honda Civic', '2021-06-14', 'Luukp\u00e4ra', 'Punane', 90, 'Bensiin', 'Manuaal', 'Karl Kivi'),  \n('987PQR', 'Ford Focus', '2016-09-05', 'Universaal', 'Sinine', 74, 'Bensiin', 'Automaat', 'Anna Saar'),  \n('135STU', 'Mercedes-Benz C200', '2019-12-20', 'Sedaan', 'Must', 150, 'Diisel', 'Automaat', 'Erik Leht'),  \n('246VWX', '\u0160koda Octavia', '2015-04-08', 'Luukp\u00e4ra', 'Roheline', 77, 'Diisel', 'Manuaal', 'Piret Maasik'),  \n('357YZA', 'Nissan Qashqai', '2022-01-15', 'Maastur', 'Hall', 103, 'H\u00fcbriid', 'Automaat', 'Toomas Ruut'),  \n('468BCD', 'Tesla Model 3', '2023-07-10', 'Sedaan', 'Valge', 283, 'Elektri', 'Automaat', 'Kati Kask');  \n \nSELECT * FROM autod;\nSELECT * FROM logi;\n<\/pre><\/div>\n\n\n
<\/div>\n\n\n\n
L\u00f5pptulemus:<\/p>\n\n\n\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n<\/div>\n\n\n\n
\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n
<\/div>\n\n\n\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n
<\/div>\n\n\n\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n
<\/div>\n\n\n\n
Kontrollimine:<\/p>\n\n\n\n
<\/div>\n\n\n\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n
<\/div>\n\n\n\n
L\u00f5pptulemus:<\/p>\n\n\n\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n
<\/div>\n\n\n\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n
<\/div>\n<\/div>\n<\/div>\n\n\n\n
<\/div>\n\n\n\n
Looge triger, et j\u00e4lgida uuendatud andmeid:<\/strong><\/p>\n\n\n\n
\n
\nCREATE TRIGGER autoUuendamine\nON autod\nFOR UPDATE\nAS\nINSERT INTO logi(aeg, toiming, andmed, kasutaja)\nSELECT\nGETDATE(),\n'andmete uuendamine',\nCONCAT('Vanad andmed: registreerimismark:', deleted.registreerimismark, ', mark: ', deleted.mark, ', esmane registreerimine: ', deleted.esmaneRegistreerimine, ', kere: ', deleted.kere, ', varvus: ', deleted.varvus, ', voimsus (kW)', deleted.voimsuskW, ', kutus: ', deleted.kutus, ', kaigukast: ', deleted.kaigukast, ', omanik: ', deleted.omanik, ' \/ Uued andmed: registreerimismark: ', inserted.registreerimismark, ', mark: ', inserted.mark, ', esmane registreerimine: ', inserted.esmaneRegistreerimine, ', kere: ', inserted.kere, ', varvus: ', inserted.varvus, ', voimsus (kW)', inserted.voimsuskW, ', kutus: ', inserted.kutus, ', kaigukast: ', inserted.kaigukast, ', omanik: ', inserted.omanik),\nSUSER_NAME()\nFROM deleted\nINNER JOIN inserted\nON deleted.autoID=inserted.autoID\n<\/pre><\/div>\n\n\n
<\/div>\n\n\n\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n
<\/div>\n\n\n\n
Kontrollimine:<\/p>\n\n\n
\nUPDATE autod\nSET omanik='Anna Oleks'\nWHERE autoID=3;\n \nSELECT * FROM autod;\nSELECT * FROM logi;\n<\/pre><\/div>\n\n\n
<\/div>\n\n\n\n
L\u00f5pptulemus:<\/p>\n\n\n\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n<\/div>\n\n\n\n
\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n
<\/div>\n\n\n\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n
<\/div>\n\n\n\n
Kontrollimine:<\/p>\n\n\n
\nUPDATE autod\nSET omanik='Anna Oleks'\nWHERE autoID=3;\n<\/pre><\/div>\n\n\n
<\/div>\n\n\n\n
L\u00f5pptulemus:<\/p>\n\n\n\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n
<\/div>\n\n\n\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n<\/div>\n<\/div>\n\n\n\n
<\/div>\n\n\n\n
Loo p\u00e4\u00e4stik kustutatud andmete j\u00e4lgimiseks:<\/strong><\/p>\n\n\n\n
\n
\nCREATE TRIGGER autoKustutamine\nON autod\nFOR DELETE\nAS\nINSERT INTO logi(aeg, toiming, andmed, kasutaja)\nSELECT\nGETDATE(),\n'andmete kustutamine',\nCONCAT ('registreerimismark: ', deleted.registreerimismark, ' \/ mark: ', deleted.mark, ' \/ omanik: ', deleted.omanik),\nSUSER_NAME()\nFROM deleted;\n<\/pre><\/div>\n\n\n
<\/div>\n\n\n\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n
<\/div>\n\n\n\n
Kontrollimine:<\/p>\n\n\n
\nDELETE FROM autod\nWHERE autoID=7;\n \nSELECT * FROM autod;\nSELECT * FROM logi;\n<\/pre><\/div>\n\n\n
<\/div>\n\n\n\n
L\u00f5pptulemus:<\/p>\n\n\n\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n<\/div>\n\n\n\n
\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n
<\/div>\n\n\n\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n
<\/div>\n\n\n\n
Kontrollimine:<\/p>\n\n\n
\nDELETE FROM autod\nWHERE autoID=7;\n<\/pre><\/div>\n\n\n
<\/div>\n\n\n\n
L\u00f5pptulemus:<\/p>\n\n\n\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n
<\/div>\n\n\n\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n<\/div>\n<\/div>\n\n\n\n
<\/div>\n\n\n\n
Trigerid SQLis kahe seotud tabeli p\u00f5hjal.<\/h3>\n\n\n\n
<\/div>\n\n\n\n
Lisame tabeli<\/strong><\/p>\n\n\n\n
<\/div>\n\n\n\n
\n
\ncreate table trahvid(\ntrahvID int primary key identity(1,1),\nautoID int, \ntrahviKuupaev date,\ntyyp varchar(50),\nsumma decimal(10,2),\ntasutud varchar(3) not null);\n<\/pre><\/div><\/div>\n\n\n\n
\ncreate table trahvid(\ntrahvID int primary key AUTO_INCREMENT,\nautoID int, \ntrahviKuupaev date,\ntyyp varchar(50),\nsumma decimal(10,2),\ntasutud varchar(3) not null);\n<\/pre><\/div><\/div>\n<\/div>\n\n\n\n
<\/div>\n\n\n\n
Lisame FOREIGN KEY<\/strong><\/p>\n\n\n\n
<\/div>\n\n\n\n
\n
\nALTER TABLE trahvid ADD CONSTRAINT fk_autod\nFOREIGN KEY (autoID) References autod(autoID) \n<\/pre><\/div><\/div>\n\n\n\n
\nALTER TABLE trahv ADD CONSTRAINT fk_autod\nFOREIGN KEY (autoID) References autod(autoID) \n<\/pre><\/div><\/div>\n<\/div>\n\n\n\n
<\/div>\n\n\n\n
Lisame andmed tabelisse<\/strong><\/p>\n\n\n\n
<\/div>\n\n\n\n
\n
\nINSERT INTO trahvid (autoID, trahviKuupaev, tyyp, summa, tasutud) \nVALUES \n(1, '2024-01-15', 'Kiiruse \u00fcletamine', 120.50, 'ei'),\n(2, '2024-02-05', 'Vale parkimine', 50.00, 'jah'),\n(3, '2024-03-10', 'Punase tule eiramine', 200.00, 'ei'),\n(4, '2024-03-20', 'Turvav\u00f6\u00f6 mittekasutamine', 40.00, 'jah'),\n(5, '2024-04-01', 'Mobiili kasutamine s\u00f5idu ajal', 80.00, 'ei'),\n(1, '2024-04-05', 'Vale m\u00f6\u00f6das\u00f5it', 150.00, 'ei'),\n(2, '2024-04-10', 'Dokumentide puudumine', 60.00, 'jah'),\n(3, '2024-04-15', 'Alkoholi joove', 500.00, 'ei'),\n(4, '2024-04-20', 'Kiiruse \u00fcletamine', 90.00, 'jah'),\n(5, '2024-04-25', 'Jalgratturi mitteandmine teed', 70.00, 'ei');\n\nSELECT * FROM autod;\nSELECT * FROM trahvid;\n<\/pre><\/div><\/div>\n\n\n\n
\nINSERT INTO trahv (autoID, trahviKuupaev, tyyp, summa, tasutud) \nVALUES \n(1, '2024-01-15', 'Kiiruse \u00fcletamine', 120.50, 'ei'),\n(2, '2024-02-05', 'Vale parkimine', 50.00, 'jah'),\n(3, '2024-03-10', 'Punase tule eiramine', 200.00, 'ei'),\n(4, '2024-03-20', 'Turvav\u00f6\u00f6 mittekasutamine', 40.00, 'jah'),\n(5, '2024-04-01', 'Mobiili kasutamine s\u00f5idu ajal', 80.00, 'ei'),\n(1, '2024-04-05', 'Vale m\u00f6\u00f6das\u00f5it', 150.00, 'ei'),\n(2, '2024-04-10', 'Dokumentide puudumine', 60.00, 'jah'),\n(3, '2024-04-15', 'Alkoholi joove', 500.00, 'ei'),\n(4, '2024-04-20', 'Kiiruse \u00fcletamine', 90.00, 'jah'),\n(5, '2024-04-25', 'Jalgratturi mitteandmine teed', 70.00, 'ei');\n<\/pre><\/div><\/div>\n<\/div>\n\n\n\n
<\/div>\n\n\n\n
Triger INSERT<\/strong><\/p>\n\n\n\n
<\/div>\n\n\n\n
\n
\nCREATE TRIGGER trahvilisamine\nON trahvid\nFOR INSERT\nAS INSERT INTO logi(aeg, toiming, andmed, kasutaja)\nSELECT \nGETDATE(),\n'on tehtud INSERT',\nCONCAT('Trahvide tabel: Auto: ', a.registreerimismark, ', Kuup\u00e4ev: ', inserted.trahviKuupaev, ', T\u00fc\u00fcp: ', inserted.tyyp, ', Summa: ', inserted.summa, ', Tasutud: ', inserted.tasutud),\nSUSER_NAME()\nFROM inserted\nINNER JOIN autod a \nON a.autoID=inserted.autoID;\n<\/pre><\/div>\n\n\n
<\/div>\n\n\n\n
Kontrollimine:<\/p>\n\n\n\n
<\/div>\n\n\n
\nINSERT INTO trahvid (autoID, trahviKuupaev, tyyp, summa, tasutud) \nVALUES \n(6, '2024-05-05', 'Kiiruse \u00fcletamine', 110.00, 'ei'),\n(2, '2024-05-12', 'Vale parkimine', 45.00, 'jah'),\n(8, '2024-05-18', 'Punase tule eiramine', 180.00, 'ei'),\n(9, '2024-05-22', 'Turvav\u00f6\u00f6 mittekasutamine', 35.00, 'jah'),\n(10, '2024-06-01', 'Mobiili kasutamine s\u00f5idu ajal', 75.00, 'ei');\n\nSELECT * FROM autod;\nSELECT * FROM trahvid;\nSELECT * FROM logi;\n<\/pre><\/div>\n\n\n
<\/div>\n\n\n\n
L\u00f5pptulemus:<\/p>\n\n\n\n
<\/div>\n\n\n\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n<\/div>\n\n\n\n
\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n
<\/div>\n\n\n\n
Kontrollimine:<\/p>\n\n\n\n
<\/div>\n\n\n
\nINSERT INTO trahv (autoID, trahviKuupaev, tyyp, summa, tasutud) \nVALUES \n(6, '2024-05-05', 'Kiiruse \u00fcletamine', 110.00, 'ei'),\n(7, '2024-05-12', 'Vale parkimine', 45.00, 'jah')\n<\/pre><\/div>\n\n\n
<\/div>\n\n\n\n
L\u00f5pptulemus:<\/p>\n\n\n\n
<\/div>\n\n\n\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n<\/div>\n<\/div>\n\n\n\n
<\/div>\n\n\n\n
Triger UPDATE<\/strong><\/p>\n\n\n\n
<\/div>\n\n\n\n
\n
\nCREATE TRIGGER trahviuuendamine\nON trahvid\nFOR UPDATE\nAS INSERT INTO logi(aeg, toiming, andmed, kasutaja)\nSELECT \nGETDATE(),\n'on tehtud UPDATE',\nCONCAT('vanad andmed: ', a1.registreerimismark,', ', a1.omanik, ', ', deleted.trahviKuupaev, ', ', deleted.tyyp,', ', deleted.summa, ', ', deleted.tasutud, 'uued andmed: ', a2.registreerimismark,', ', a2.omanik, ', ', inserted.trahviKuupaev, ', ', inserted.tyyp,', ', inserted.summa, ', ', inserted.tasutud),\nSUSER_NAME()\nFROM deleted\nINNER JOIN inserted ON deleted.trahvID=inserted.trahvID\nINNER JOIN autod a1 ON a1.autoID=deleted.autoID\nINNER JOIN autod a2 ON a2.autoID=inserted.autoID;\n<\/pre><\/div>\n\n\n
<\/div>\n\n\n\n
Kontrollimine:<\/p>\n\n\n\n
<\/div>\n\n\n
\nUPDATE trahvid SET autoID=5\nWHERE trahvID=1;\n\nSELECT * FROM autod;\nSELECT * FROM trahvid;\nSELECT * FROM logi;\n<\/pre><\/div>\n\n\n
<\/div>\n\n\n\n
L\u00f5pptulemus:<\/p>\n\n\n\n
<\/div>\n\n\n\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n<\/div>\n\n\n\n
\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n
<\/div>\n\n\n\n
Kontrollimine:<\/p>\n\n\n\n
<\/div>\n\n\n
\nUPDATE trahv SET autoID=5\nWHERE trahvID=2;\n<\/pre><\/div>\n\n\n
<\/div>\n\n\n\n
L\u00f5pptulemus:<\/p>\n\n\n\n
<\/div>\n\n\n\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n<\/div>\n<\/div>\n\n\n\n
<\/div>\n\n\n\n
Triger DELETE<\/strong><\/p>\n\n\n\n
<\/div>\n\n\n\n
\n
\nCREATE TRIGGER trahvikustutamine\nON trahvid\nFOR DELETE\nAS INSERT INTO logi(aeg, toiming, andmed, kasutaja)\nSELECT \nGETDATE(),\n'on tehtud DELETE',\nCONCAT('Trahvide tabel: Auto: ', a.registreerimismark, ', Kuup\u00e4ev: ', deleted.trahviKuupaev, ', T\u00fc\u00fcp: ', deleted.tyyp, ', Summa: ', deleted.summa, ', Tasutud: ', deleted.tasutud),\nSUSER_NAME()\nFROM deleted\nINNER JOIN autod a \nON a.autoID=deleted.autoID;\n<\/pre><\/div>\n\n\n
<\/div>\n\n\n\n
Kontrollimine:<\/p>\n\n\n\n
<\/div>\n\n\n
\nDELETE FROM trahvid\nWHERE trahvID=6;\n\nSELECT * FROM trahvid;\nSELECT * FROM logi;\n<\/pre><\/div>\n\n\n
<\/div>\n\n\n\n
L\u00f5pptulemus:<\/p>\n\n\n\n
<\/div>\n\n\n\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n<\/div>\n\n\n\n
\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n
<\/div>\n\n\n\n
Kontrollimine:<\/p>\n\n\n\n
<\/div>\n\n\n
\nDELETE FROM trahv\nWHERE trahvID=3;\n<\/pre><\/div>\n\n\n
<\/div>\n\n\n\n
L\u00f5pptulemus:<\/p>\n\n\n\n
<\/div>\n\n\n\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n<\/div>\n<\/div>\n\n\n\n
<\/div>\n\n\n\n
Kasutaja loomine:<\/strong><\/p>\n\n\n\n
\n
\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n
<\/div>\n\n\n\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n
<\/div>\n\n\n\n
\u00d5iguste andmine:<\/strong><\/p>\n\n\n\n
<\/div>\n\n\n
\nGRANT SELECT, INSERT, UPDATE, DELETE ON autod TO Kasutaja;\nGRANT SELECT, INSERT, UPDATE, DELETE ON trahvid TO Kasutaja;\n\nDENY ALTER ON autod TO Kasutaja;\nDENY ALTER ON trahvid TO Kasutaja;\n\nDENY SELECT, INSERT, UPDATE, DELETE ON logi TO Kasutaja;\n<\/pre><\/div>\n\n\n
<\/div>\n\n\n\n
Kasutaja kontost logi tabeli vaatamine:<\/strong><\/p>\n\n\n\n
<\/div>\n\n\n
\nselect*from logi\n<\/pre><\/div>\n\n\n
<\/div>\n\n\n\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n
<\/div>\n\n\n\n
Kasutaja kontost trahvide lisamine:<\/strong><\/p>\n\n\n\n
<\/div>\n\n\n
\nINSERT INTO trahvid (autoID, trahviKuupaev, tyyp, summa, tasutud) \nVALUES \n(3, '2024-03-10', 'Punase tule eiramine', 200.00, 'ei'),\n(4, '2024-03-20', 'Turvav\u00f6\u00f6 mittekasutamine', 40.00, 'jah'),\n(5, '2024-04-01', 'Mobiili kasutamine s\u00f5idu ajal', 80.00, 'ei'),\n(1, '2024-04-05', 'Vale m\u00f6\u00f6das\u00f5it', 150.00, 'ei')\n<\/pre><\/div>\n\n\n
<\/div>\n\n\n\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n
<\/div>\n\n\n\n
Kasutaja kontost trahvide uuendamine:<\/strong><\/p>\n\n\n\n
<\/div>\n\n\n
\nUPDATE trahvid SET autoID=9\nWHERE trahvID=1;\n<\/pre><\/div>\n\n\n
<\/div>\n\n\n\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n
<\/div>\n\n\n\n
Kasutaja kontost trahvide kustutamine:<\/strong><\/p>\n\n\n\n
<\/div>\n\n\n
\nDELETE FROM trahvid\nWHERE trahvID=4;\n<\/pre><\/div>\n\n\n
<\/div>\n\n\n\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n
<\/div>\n\n\n\n
Root kontost logi tabeli vaatamine:<\/strong><\/p>\n\n\n\n
<\/div>\n\n\n
\nSELECT*FROM logi\n<\/pre><\/div>\n\n\n
<\/div>\n\n\n\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n<\/div>\n\n\n\n
\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n
<\/div>\n\n\n\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n
<\/div>\n\n\n\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n
<\/div>\n\n\n\n
\u00d5iguste andmine:<\/strong><\/p>\n\n\n\n
<\/div>\n\n\n\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n
<\/div>\n\n\n\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n
<\/div>\n\n\n\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n
<\/div>\n\n\n\n
Kasutaja kontost tabelite vaatamine:<\/strong><\/p>\n\n\n\n
<\/div>\n\n\n\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n
<\/div>\n\n\n\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n
<\/div>\n\n\n\n
Kasutaja kontost trahvide lisamine:<\/strong><\/p>\n\n\n\n
<\/div>\n\n\n\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n
<\/div>\n\n\n\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n
<\/div>\n\n\n\n
Kasutaja kontost trahvide uuendamine:<\/strong><\/p>\n\n\n\n
<\/div>\n\n\n\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n
<\/div>\n\n\n\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n
<\/div>\n\n\n\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n
<\/div>\n\n\n\n
Kasutaja kontost trahvide kustutamine:<\/strong><\/p>\n\n\n\n
<\/div>\n\n\n\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n
<\/div>\n\n\n\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n
<\/div>\n\n\n\n
Root kontost logi tabeli vaatamine:<\/strong><\/p>\n\n\n\n
<\/div>\n\n\n\n
\"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n<\/div>\n<\/div>\n\n\n\n
\n
<\/div>\n<\/div>\n\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
Triger on protsess, mille abil selles salvestatud tegevused t\u00e4idetakse automaatselt. T\u00f6\u00f6tamine vallandajaga SQLis: T\u00f6\u00f6tamine vallandajaga XAMPPis: Luua andmebaas ja tabelid (meil on autod ja logi (kus salvestatakse tegevused tabelitega, mis t\u00e4idetakse automaatselt trigerite abil)). Loo triger lisatud andmete j\u00e4lgimiseks: Kontrollimine: L\u00f5pptulemus: Kontrollimine: L\u00f5pptulemus: Looge triger, et j\u00e4lgida uuendatud andmeid: Kontrollimine: L\u00f5pptulemus: Kontrollimine: L\u00f5pptulemus: Loo p\u00e4\u00e4stik […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-1652","page","type-page","status-publish","hentry"],"yoast_head":"\nTrigger - Anna Oleks ÕPIMAPP<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/annaoleks24.thkit.ee\/wp\/trigger\/\" \/>\n<meta property=\"og:locale\" content=\"et_EE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Trigger - Anna Oleks ÕPIMAPP\" \/>\n<meta property=\"og:description\" content=\"Triger on protsess, mille abil selles salvestatud tegevused t\u00e4idetakse automaatselt. T\u00f6\u00f6tamine vallandajaga SQLis: T\u00f6\u00f6tamine vallandajaga XAMPPis: Luua andmebaas ja tabelid (meil on autod ja logi (kus salvestatakse tegevused tabelitega, mis t\u00e4idetakse automaatselt trigerite abil)). Loo triger lisatud andmete j\u00e4lgimiseks: Kontrollimine: L\u00f5pptulemus: Kontrollimine: L\u00f5pptulemus: Looge triger, et j\u00e4lgida uuendatud andmeid: Kontrollimine: L\u00f5pptulemus: Kontrollimine: L\u00f5pptulemus: Loo p\u00e4\u00e4stik […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/annaoleks24.thkit.ee\/wp\/trigger\/\" \/>\n<meta property=\"og:site_name\" content=\"Anna Oleks ÕPIMAPP\" \/>\n<meta property=\"article:modified_time\" content=\"2025-03-28T16:11:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/annaoleks24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/image-28.png\" \/>\n\t<meta property=\"og:image:width\" content=\"203\" \/>\n\t<meta property=\"og:image:height\" content=\"83\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"14 minutit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/annaoleks24.thkit.ee\/wp\/trigger\/\",\"url\":\"https:\/\/annaoleks24.thkit.ee\/wp\/trigger\/\",\"name\":\"Trigger - Anna Oleks ÕPIMAPP\",\"isPartOf\":{\"@id\":\"https:\/\/annaoleks24.thkit.ee\/wp\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/annaoleks24.thkit.ee\/wp\/trigger\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/annaoleks24.thkit.ee\/wp\/trigger\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/annaoleks24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/image-28.png\",\"datePublished\":\"2025-03-25T18:16:16+00:00\",\"dateModified\":\"2025-03-28T16:11:51+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/annaoleks24.thkit.ee\/wp\/trigger\/#breadcrumb\"},\"inLanguage\":\"et\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/annaoleks24.thkit.ee\/wp\/trigger\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"et\",\"@id\":\"https:\/\/annaoleks24.thkit.ee\/wp\/trigger\/#primaryimage\",\"url\":\"https:\/\/annaoleks24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/image-28.png\",\"contentUrl\":\"https:\/\/annaoleks24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/image-28.png\",\"width\":203,\"height\":83},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/annaoleks24.thkit.ee\/wp\/trigger\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u0413\u043b\u0430\u0432\u043d\u0430\u044f \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0430\",\"item\":\"https:\/\/annaoleks24.thkit.ee\/wp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Trigger\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/annaoleks24.thkit.ee\/wp\/#website\",\"url\":\"https:\/\/annaoleks24.thkit.ee\/wp\/\",\"name\":\"Anna Oleks ÕPIMAPP\",\"description\":\"Portfolio\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/annaoleks24.thkit.ee\/wp\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"et\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Trigger - Anna Oleks ÕPIMAPP","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:\/\/annaoleks24.thkit.ee\/wp\/trigger\/","og_locale":"et_EE","og_type":"article","og_title":"Trigger - Anna Oleks ÕPIMAPP","og_description":"Triger on protsess, mille abil selles salvestatud tegevused t\u00e4idetakse automaatselt. T\u00f6\u00f6tamine vallandajaga SQLis: T\u00f6\u00f6tamine vallandajaga XAMPPis: Luua andmebaas ja tabelid (meil on autod ja logi (kus salvestatakse tegevused tabelitega, mis t\u00e4idetakse automaatselt trigerite abil)). Loo triger lisatud andmete j\u00e4lgimiseks: Kontrollimine: L\u00f5pptulemus: Kontrollimine: L\u00f5pptulemus: Looge triger, et j\u00e4lgida uuendatud andmeid: Kontrollimine: L\u00f5pptulemus: Kontrollimine: L\u00f5pptulemus: Loo p\u00e4\u00e4stik […]","og_url":"https:\/\/annaoleks24.thkit.ee\/wp\/trigger\/","og_site_name":"Anna Oleks ÕPIMAPP","article_modified_time":"2025-03-28T16:11:51+00:00","og_image":[{"width":203,"height":83,"url":"https:\/\/annaoleks24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/image-28.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"14 minutit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/annaoleks24.thkit.ee\/wp\/trigger\/","url":"https:\/\/annaoleks24.thkit.ee\/wp\/trigger\/","name":"Trigger - Anna Oleks ÕPIMAPP","isPartOf":{"@id":"https:\/\/annaoleks24.thkit.ee\/wp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/annaoleks24.thkit.ee\/wp\/trigger\/#primaryimage"},"image":{"@id":"https:\/\/annaoleks24.thkit.ee\/wp\/trigger\/#primaryimage"},"thumbnailUrl":"https:\/\/annaoleks24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/image-28.png","datePublished":"2025-03-25T18:16:16+00:00","dateModified":"2025-03-28T16:11:51+00:00","breadcrumb":{"@id":"https:\/\/annaoleks24.thkit.ee\/wp\/trigger\/#breadcrumb"},"inLanguage":"et","potentialAction":[{"@type":"ReadAction","target":["https:\/\/annaoleks24.thkit.ee\/wp\/trigger\/"]}]},{"@type":"ImageObject","inLanguage":"et","@id":"https:\/\/annaoleks24.thkit.ee\/wp\/trigger\/#primaryimage","url":"https:\/\/annaoleks24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/image-28.png","contentUrl":"https:\/\/annaoleks24.thkit.ee\/wp\/wp-content\/uploads\/2025\/03\/image-28.png","width":203,"height":83},{"@type":"BreadcrumbList","@id":"https:\/\/annaoleks24.thkit.ee\/wp\/trigger\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u0413\u043b\u0430\u0432\u043d\u0430\u044f \u0441\u0442\u0440\u0430\u043d\u0438\u0446\u0430","item":"https:\/\/annaoleks24.thkit.ee\/wp\/"},{"@type":"ListItem","position":2,"name":"Trigger"}]},{"@type":"WebSite","@id":"https:\/\/annaoleks24.thkit.ee\/wp\/#website","url":"https:\/\/annaoleks24.thkit.ee\/wp\/","name":"Anna Oleks ÕPIMAPP","description":"Portfolio","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/annaoleks24.thkit.ee\/wp\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"et"}]}},"_links":{"self":[{"href":"https:\/\/annaoleks24.thkit.ee\/wp\/wp-json\/wp\/v2\/pages\/1652","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/annaoleks24.thkit.ee\/wp\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/annaoleks24.thkit.ee\/wp\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/annaoleks24.thkit.ee\/wp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/annaoleks24.thkit.ee\/wp\/wp-json\/wp\/v2\/comments?post=1652"}],"version-history":[{"count":26,"href":"https:\/\/annaoleks24.thkit.ee\/wp\/wp-json\/wp\/v2\/pages\/1652\/revisions"}],"predecessor-version":[{"id":1778,"href":"https:\/\/annaoleks24.thkit.ee\/wp\/wp-json\/wp\/v2\/pages\/1652\/revisions\/1778"}],"wp:attachment":[{"href":"https:\/\/annaoleks24.thkit.ee\/wp\/wp-json\/wp\/v2\/media?parent=1652"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}