{"id":586,"date":"2025-04-10T07:37:12","date_gmt":"2025-04-10T07:37:12","guid":{"rendered":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/?page_id=586"},"modified":"2025-04-10T10:15:46","modified_gmt":"2025-04-10T10:15:46","slug":"andmebaas-triggers","status":"publish","type":"page","link":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/ru\/andmebaas-triggers\/","title":{"rendered":"Andmebaas – Triggers"},"content":{"rendered":"\n

Logitabeli ja trigger’ite loomine autoriregistri muutuste logimiseks<\/strong><\/p>\n\n\n\n

\u00dclesanne:<\/strong>
Luua tabel logitabel(id, toiming, aeg, autoAndmed)<\/code>, mis fikseerib muudatused autoreregister<\/code> tabelis. Samuti tuleb luua autoreregister<\/code> tabel koos v\u00e4lja m\u00f5eldud veergudega ning teha triggerid, mis logivad INSERT, UPDATE ja DELETE toiminguid logitabel<\/code> tabelisse. Kontrollida, kas triggerid t\u00f6\u00f6tavad.<\/p>\n\n\n\n

\ud83d\udd39 1. Tabeli autoreregister<\/code> loomine<\/h3>\n\n\n\n

L\u00f5in tabeli, kuhu salvestatakse auto andmed. V\u00e4ljad, mille valisin:<\/p>\n\n\n\n

    \n
  • id<\/code> \u2013 unikaalne ID (AUTO_INCREMENT)<\/li>\n\n\n\n
  • reg_number<\/code> \u2013 registreerimisnumber<\/li>\n\n\n\n
  • owner_name<\/code> \u2013 omaniku nimi<\/li>\n\n\n\n
  • car_make<\/code> \u2013 automark<\/li>\n\n\n\n
  • car_model<\/code> \u2013 automudel<\/li>\n\n\n\n
  • year<\/code> \u2013 tootmisaasta<\/li>\n<\/ul>\n\n\n
    \nCREATE TABLE autoreregister (\n    id INT AUTO_INCREMENT PRIMARY KEY,\n    reg_number VARCHAR(20) NOT NULL UNIQUE,\n    owner_name VARCHAR(100) NOT NULL,\n    car_make VARCHAR(50) NOT NULL,\n    car_model VARCHAR(50) NOT NULL,\n    year INT NOT NULL\n);\n\n<\/pre><\/div>\n\n\n
    \"\"<\/figure>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    \ud83d\udd39 2. Tabeli logitabel<\/code> loomine<\/h3>\n\n\n\n
    See tabel salvestab k\u00f5ik muudatused, mis toimuvad autoreregister<\/code> tabelis. V\u00e4ljad:<\/p>\n\n\n\n
      \n
    • id<\/code> \u2013 logikirje ID<\/li>\n\n\n\n
    • toiming<\/code> \u2013 INSERT, UPDATE v\u00f5i DELETE<\/li>\n\n\n\n
    • aeg<\/code> \u2013 muudatuse toimumise aeg (automaatselt)<\/li>\n\n\n\n
    • autoAndmed<\/code> \u2013 muudatuse kirjeldus tekstina<\/li>\n<\/ul>\n\n\n
      \nCREATE TABLE logitabel (\n    id INT AUTO_INCREMENT PRIMARY KEY,\n    toiming VARCHAR(10) NOT NULL,\n    aeg DATETIME DEFAULT CURRENT_TIMESTAMP,\n    autoAndmed TEXT\n);\n\n<\/pre><\/div>\n\n\n
      \"\"<\/figure>\n\n\n\n
      \"\"<\/figure>\n\n\n\n
      \ud83d\udd39 3. Triggerite loomine<\/strong><\/h3>\n\n\n\n
      L\u00f5in kolm triggerit, mis lisavad muudatuse logitabel<\/code> tabelisse.<\/p>\n\n\n\n
      \u2705 INSERT Trigger<\/strong><\/p>\n\n\n
      \nBEGIN\n  INSERT INTO logitabel (toiming, autoAndmed)\n  VALUES ('INSERT', CONCAT('Lisati auto: ', NEW.reg_number, ', ', NEW.owner_name, ', ', NEW.car_make, ', ', NEW.car_model, ', ', NEW.year));\nEND;\n\n<\/pre><\/div>\n\n\n
      \"\"<\/figure>\n\n\n\n
      \u2705 UPDATE Trigger<\/strong><\/h4>\n\n\n\n
      <\/pre>\n\n\n
      \nCREATE TRIGGER log_update\nAFTER UPDATE ON autoreregister\nFOR EACH ROW\nBEGIN\n  INSERT INTO logitabel (toiming, autoAndmed)\n  VALUES ('UPDATE', CONCAT('Muudeti auto: ', OLD.reg_number, ', uus omanik: ', NEW.owner_name));\nEND;\n\n<\/pre><\/div>\n\n\n
      \"\"<\/figure>\n\n\n\n
      \u2705 DELETE Trigger<\/strong><\/h4>\n\n\n\n
      <\/pre>\n\n\n
      \nBEGIN\n  INSERT INTO logitabel (toiming, autoAndmed)\n  VALUES ('DELETE', CONCAT('Kustutati auto: ', OLD.reg_number, ', ', OLD.owner_name, ', ', OLD.car_make, ', ', OLD.car_model, ', ', OLD.year));\nEND;\n\n\n<\/pre><\/div>\n\n\n
      \"\"<\/figure>\n\n\n\n
      \ud83d\udd39 4. Kontrollimine (Testimine)<\/strong><\/h3>\n\n\n\n
      Testisin, et k\u00f5ik t\u00f6\u00f6tab korralikult:<\/p>\n\n\n\n
        \n
      1. Sisestamine<\/strong>:<\/li>\n<\/ol>\n\n\n\n
        <\/pre>\n\n\n
        \nINSERT INTO autoreregister (reg_number, owner_name, car_make, car_model, year)\nVALUES ('EST123', 'Mari Maasikas', 'Toyota', 'Yaris', 2020);\n\n<\/pre><\/div>\n\n\n
        \"\"<\/figure>\n\n\n\n
        2. Muutmine<\/strong>:<\/p>\n\n\n
        \nUPDATE autoreregister\nSET owner_name = 'J\u00fcri \u00d5unapuu'\nWHERE reg_number = 'EST123';\n\n<\/pre><\/div>\n\n\n
        \"\"<\/figure>\n\n\n\n
          \n
        1. Kustutamine<\/strong>:<\/li>\n<\/ol>\n\n\n\n
          <\/pre>\n\n\n
          \nDELETE FROM autoreregister\nWHERE reg_number = 'EST123';\n\n<\/pre><\/div>\n\n\n
          \"\"<\/figure>\n\n\n\n
            \n
          1. Logi kontrollimine<\/strong>:<\/li>\n<\/ol>\n\n\n\n
            <\/pre>\n\n\n
            \nSELECT * FROM logitabel ORDER BY aeg DESC;\n\n<\/pre><\/div>\n\n\n
            \"\"<\/figure>\n\n\n\n
            Lisasime seotud tabeli owners<\/code> tabelile autoreregister<\/code><\/strong>, et hallata autode omanike andmeid.<\/h3>\n\n\n\n
            Muudeti triggerite toimingud<\/strong> nii, et andmed tabelist owners<\/code><\/strong> kajastuvad ka logitabelis logitabel<\/code><\/strong> iga lisamise, uuendamise ja kustutamise korral autoreregister<\/code><\/strong> tabelis.<\/p>\n\n\n\n
            1. Lisasime seotud tabeli owners<\/code>:<\/strong><\/h3>\n\n\n\n
            Tabel owners<\/code><\/strong> sisaldab auto omaniku andmeid, mis on seotud tabeliga autoreregister<\/code><\/strong>.<\/p>\n\n\n\n
            Tabeli owners<\/code> loomine:<\/strong><\/h4>\n\n\n
            \nCREATE TABLE owners (\n    id INT AUTO_INCREMENT PRIMARY KEY,\n    name VARCHAR(255) NOT NULL,\n    contact_info VARCHAR(255)\n);\n\n<\/pre><\/div>\n\n\n
            Tabeli autoreregister<\/code> muutmine ja v\u00e4lisv\u00f5tme lisamine:<\/strong><\/h4>\n\n\n\n
            <\/pre>\n\n\n
            \nALTER TABLE autoreregister\nADD COLUMN owner_id INT,\nADD CONSTRAINT fk_owner\nFOREIGN KEY (owner_id) REFERENCES owners(id);\n\n<\/pre><\/div>\n\n\n
            \"\"<\/figure>\n\n\n\n
            \"\"<\/figure>\n\n\n\n
            Triggerid:<\/strong><\/p>\n\n\n\n
            \"\"<\/figure>\n\n\n\n
            <\/p>\n\n\n\n
            <\/p>\n\n\n\n
            [SQL Server] \u00dche tabeli triggeri loomine harjutus<\/strong><\/pre>\n\n\n
            \nCREATE DATABASE autotools;\nUSE autotools;\n\nCREATE TABLE owner (\n    ownerID INT identity(1,1) PRIMARY KEY,\n    ownerName VARCHAR(100),\n    contactInfo VARCHAR(100)\n);\n\nCREATE TABLE carRegistration (\n    carID INT identity(1,1) PRIMARY KEY,\n    carName VARCHAR(50),\n    year INT,\n    licensePlate VARCHAR(10),\n    ownerID INT,\n    CONSTRAINT FK_owner FOREIGN KEY (ownerID) REFERENCES owner(ownerID)\n);\n\nCREATE TABLE actionLog (\n    logID INT identity(1,1) PRIMARY KEY,\n    timestamp DATETIME,\n    action VARCHAR(100),\n    carDetails TEXT,\n    username VARCHAR(25)\n);\n<\/pre><\/div>\n\n\n
            \"\"<\/figure>\n\n\n\n
            Sisestan andmed:<\/strong><\/p>\n\n\n
            \nINSERT INTO owner (ownerName, contactInfo) VALUES\n('John Doe', '123-456-789'),\n('Jane Smith', '987-654-321');\n\n\nINSERT INTO carRegistration (carName, year, licensePlate, ownerID) VALUES\n('Mitsubishi', 2008, '286MGE', 1),\n('Toyota', 1996, '361MGW', 2);\n<\/pre><\/div>\n\n\n
            \"\"<\/figure>\n\n\n\n
            Eemaldan andmed<\/strong>:<\/p>\n\n\n
            \ndelete from autoregister where autoID=1\n<\/pre><\/div>\n\n\n
            \"\"<\/figure>\n\n\n\n
            \"\"<\/figure>\n\n\n\n
            Uuendan andmed<\/strong>:<\/p>\n\n\n
            \nUPDATE carRegistration\nSET licensePlate = '794RDT'\nWHERE carID = 2;\n\n<\/pre><\/div>\n\n\n
            \"\"<\/figure>\n\n\n\n
            Tehtud tegevused logi tabelis<\/strong>:<\/p>\n\n\n\n
            \"\"<\/figure>\n\n\n\n
            Triggerite loomine<\/strong><\/p>\n\n\n
            \n-- Trigger for INSERT operation\nCREATE TRIGGER afterCarInsert\nON carRegistration\nAFTER INSERT\nAS \nBEGIN\n    INSERT INTO actionLog (timestamp, action, carDetails, username)\n    SELECT \n        GETDATE(),\n        'INSERT operation executed',\n        CONCAT('Car Name: ', carRegistration.carName, \n               ', Year: ', carRegistration.year, \n               ', License Plate: ', carRegistration.licensePlate),\n        SUSER_NAME()\n    FROM carRegistration\n    WHERE carID = (SELECT carID FROM inserted);\nEND;\n\n-- Trigger for DELETE operation\nCREATE TRIGGER afterCarDelete\nON carRegistration\nAFTER DELETE\nAS \nBEGIN\n    INSERT INTO actionLog (timestamp, action, carDetails, username)\n    SELECT \n        GETDATE(),\n        'DELETE operation executed',\n        CONCAT('Car Deleted: ', deleted.licensePlate),\n        SUSER_NAME()\n    FROM deleted;\nEND;\n\n-- Trigger for UPDATE operation\nCREATE TRIGGER afterCarUpdate\nON carRegistration\nAFTER UPDATE\nAS \nBEGIN\n    INSERT INTO actionLog (timestamp, action, carDetails, username)\n    SELECT \n        GETDATE(),\n        'UPDATE operation executed',\n        CONCAT('Old Data - Car Name: ', deleted.carName, ', Year: ', deleted.year, ', License Plate: ', deleted.licensePlate,\n               ' | New Data - Car Name: ', inserted.carName, ', Year: ', inserted.year, ', License Plate: ', inserted.licensePlate),\n        SUSER_NAME()\n    FROM inserted\n    INNER JOIN deleted ON inserted.carID = deleted.carID;\nEND;\n\n<\/pre><\/div>\n\n\n
            [SQL Server] Harjutus kahe tabelite seosete (on loodud tabel 'omanik')<\/strong><\/pre>\n\n\n\n
            <\/p>\n\n\n
            \nCREATE TABLE omanik (\n    omanikID int identity(1,1) PRIMARY KEY,\n    nimi varchar(50)\n)\n<\/pre><\/div>\n\n
            \nINSERT INTO omanik (nimi) VALUES\n('Bob'), ('Oleg');\n<\/pre><\/div>\n\n
            \nCREATE TRIGGER afterCarInsert\nON carRegistration\nAFTER INSERT\nAS \nBEGIN\n    INSERT INTO actionLog (timestamp, action, carDetails, username)\n    SELECT \n        GETDATE(),\n        'INSERT operation executed',\n        CONCAT('Car Name: ', carRegistration.carName, \n               ', Year: ', carRegistration.year, \n               ', License Plate: ', carRegistration.licensePlate,\n               ', Owner Name: ', owner.nimi),\n        SUSER_NAME()\n    FROM carRegistration\n    INNER JOIN owner ON carRegistration.ownerID = owner.ownerID\n    INNER JOIN inserted ON carRegistration.carID = inserted.carID;\nEND;\n\n\n<\/pre><\/div>\n\n
            \nCREATE TRIGGER afterCarUpdate\nON carRegistration\nAFTER UPDATE\nAS \nBEGIN\n    INSERT INTO actionLog (timestamp, action, carDetails, username)\n    SELECT \n        GETDATE(),\n        'UPDATE operation executed',\n        CONCAT('Old Data - Car Name: ', deleted.carName, ', Year: ', deleted.year, ', License Plate: ', deleted.licensePlate,\n               ' | New Data - Car Name: ', inserted.carName, ', Year: ', inserted.year, ', License Plate: ', inserted.licensePlate),\n        SUSER_NAME()\n    FROM inserted\n    INNER JOIN deleted ON inserted.carID = deleted.carID;\nEND;\n\n<\/pre><\/div>\n\n
            \nCREATE TRIGGER afterCarDelete\nON carRegistration\nAFTER DELETE\nAS \nBEGIN\n    INSERT INTO actionLog (timestamp, action, carDetails, username)\n    SELECT \n        GETDATE(),\n        'DELETE operation executed',\n        CONCAT('Car Deleted: ', deleted.licensePlate),\n        SUSER_NAME()\n    FROM deleted;\nEND;\n\n\n<\/pre><\/div>\n\n\n
            \"\"<\/figure>\n\n\n\n
            \"\"<\/figure>\n\n\n\n
            <\/p>\n\n\n\n
            <\/p>\n","protected":false},"excerpt":{"rendered":"
            Logitabeli ja trigger’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’)<\/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-586","page","type-page","status-publish","hentry"],"yoast_head":"\nAndmebaas - Triggers - Alex's Arsenal (Shop)<\/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:\/\/aleksanderbekasov24.thkit.ee\/wp\/ru\/andmebaas-triggers\/\" \/>\n<meta property=\"og:locale\" content=\"ru_RU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Andmebaas - Triggers - Alex's Arsenal (Shop)\" \/>\n<meta property=\"og:description\" content=\"Logitabeli ja trigger’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')\" \/>\n<meta property=\"og:url\" content=\"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/ru\/andmebaas-triggers\/\" \/>\n<meta property=\"og:site_name\" content=\"Alex's Arsenal (Shop)\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-10T10:15:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/04\/t1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1918\" \/>\n\t<meta property=\"og:image:height\" content=\"392\" \/>\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=\"\u041f\u0440\u0438\u043c\u0435\u0440\u043d\u043e\u0435 \u0432\u0440\u0435\u043c\u044f \u0434\u043b\u044f \u0447\u0442\u0435\u043d\u0438\u044f\" \/>\n\t<meta name=\"twitter:data1\" content=\"5 \u043c\u0438\u043d\u0443\u0442\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/aleksanderbekasov24.thkit.ee\\\/wp\\\/andmebaas-triggers\\\/\",\"url\":\"https:\\\/\\\/aleksanderbekasov24.thkit.ee\\\/wp\\\/andmebaas-triggers\\\/\",\"name\":\"Andmebaas - Triggers - Alex's Arsenal (Shop)\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/aleksanderbekasov24.thkit.ee\\\/wp\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/aleksanderbekasov24.thkit.ee\\\/wp\\\/andmebaas-triggers\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/aleksanderbekasov24.thkit.ee\\\/wp\\\/andmebaas-triggers\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/aleksanderbekasov24.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2025\\\/04\\\/t1-1024x209.png\",\"datePublished\":\"2025-04-10T07:37:12+00:00\",\"dateModified\":\"2025-04-10T10:15:46+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/aleksanderbekasov24.thkit.ee\\\/wp\\\/andmebaas-triggers\\\/#breadcrumb\"},\"inLanguage\":\"ru-RU\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/aleksanderbekasov24.thkit.ee\\\/wp\\\/andmebaas-triggers\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ru-RU\",\"@id\":\"https:\\\/\\\/aleksanderbekasov24.thkit.ee\\\/wp\\\/andmebaas-triggers\\\/#primaryimage\",\"url\":\"https:\\\/\\\/aleksanderbekasov24.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2025\\\/04\\\/t1-1024x209.png\",\"contentUrl\":\"https:\\\/\\\/aleksanderbekasov24.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2025\\\/04\\\/t1-1024x209.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/aleksanderbekasov24.thkit.ee\\\/wp\\\/andmebaas-triggers\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/aleksanderbekasov24.thkit.ee\\\/wp\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Andmebaas – Triggers\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/aleksanderbekasov24.thkit.ee\\\/wp\\\/#website\",\"url\":\"https:\\\/\\\/aleksanderbekasov24.thkit.ee\\\/wp\\\/\",\"name\":\"Alex's Arsenal (Shop) \u00a9 2025 All rights reserved.\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/aleksanderbekasov24.thkit.ee\\\/wp\\\/#\\\/schema\\\/person\\\/3b5a2663a9eba24938a504553bfddac8\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/aleksanderbekasov24.thkit.ee\\\/wp\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ru-RU\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/aleksanderbekasov24.thkit.ee\\\/wp\\\/#\\\/schema\\\/person\\\/3b5a2663a9eba24938a504553bfddac8\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ru-RU\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/89ec08a71657132fe138df1f49857196ebc20c1d30c12bddb082e6bc8abb224d?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/89ec08a71657132fe138df1f49857196ebc20c1d30c12bddb082e6bc8abb224d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/89ec08a71657132fe138df1f49857196ebc20c1d30c12bddb082e6bc8abb224d?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"logo\":{\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/89ec08a71657132fe138df1f49857196ebc20c1d30c12bddb082e6bc8abb224d?s=96&d=mm&r=g\"},\"sameAs\":[\"https:\\\/\\\/aleksanderbekasov24.thkit.ee\\\/wp\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Andmebaas - Triggers - Alex's Arsenal (Shop)","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:\/\/aleksanderbekasov24.thkit.ee\/wp\/ru\/andmebaas-triggers\/","og_locale":"ru_RU","og_type":"article","og_title":"Andmebaas - Triggers - Alex's Arsenal (Shop)","og_description":"Logitabeli ja trigger’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')","og_url":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/ru\/andmebaas-triggers\/","og_site_name":"Alex's Arsenal (Shop)","article_modified_time":"2025-04-10T10:15:46+00:00","og_image":[{"width":1918,"height":392,"url":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/04\/t1.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"\u041f\u0440\u0438\u043c\u0435\u0440\u043d\u043e\u0435 \u0432\u0440\u0435\u043c\u044f \u0434\u043b\u044f \u0447\u0442\u0435\u043d\u0438\u044f":"5 \u043c\u0438\u043d\u0443\u0442"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/andmebaas-triggers\/","url":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/andmebaas-triggers\/","name":"Andmebaas - Triggers - Alex's Arsenal (Shop)","isPartOf":{"@id":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/andmebaas-triggers\/#primaryimage"},"image":{"@id":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/andmebaas-triggers\/#primaryimage"},"thumbnailUrl":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/04\/t1-1024x209.png","datePublished":"2025-04-10T07:37:12+00:00","dateModified":"2025-04-10T10:15:46+00:00","breadcrumb":{"@id":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/andmebaas-triggers\/#breadcrumb"},"inLanguage":"ru-RU","potentialAction":[{"@type":"ReadAction","target":["https:\/\/aleksanderbekasov24.thkit.ee\/wp\/andmebaas-triggers\/"]}]},{"@type":"ImageObject","inLanguage":"ru-RU","@id":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/andmebaas-triggers\/#primaryimage","url":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/04\/t1-1024x209.png","contentUrl":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/wp-content\/uploads\/2025\/04\/t1-1024x209.png"},{"@type":"BreadcrumbList","@id":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/andmebaas-triggers\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/"},{"@type":"ListItem","position":2,"name":"Andmebaas – Triggers"}]},{"@type":"WebSite","@id":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/#website","url":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/","name":"Alex's Arsenal (Shop) \u00a9 2025 All rights reserved.","description":"","publisher":{"@id":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/#\/schema\/person\/3b5a2663a9eba24938a504553bfddac8"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ru-RU"},{"@type":["Person","Organization"],"@id":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/#\/schema\/person\/3b5a2663a9eba24938a504553bfddac8","name":"admin","image":{"@type":"ImageObject","inLanguage":"ru-RU","@id":"https:\/\/secure.gravatar.com\/avatar\/89ec08a71657132fe138df1f49857196ebc20c1d30c12bddb082e6bc8abb224d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/89ec08a71657132fe138df1f49857196ebc20c1d30c12bddb082e6bc8abb224d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/89ec08a71657132fe138df1f49857196ebc20c1d30c12bddb082e6bc8abb224d?s=96&d=mm&r=g","caption":"admin"},"logo":{"@id":"https:\/\/secure.gravatar.com\/avatar\/89ec08a71657132fe138df1f49857196ebc20c1d30c12bddb082e6bc8abb224d?s=96&d=mm&r=g"},"sameAs":["https:\/\/aleksanderbekasov24.thkit.ee\/wp"]}]}},"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/ru\/wp-json\/wp\/v2\/pages\/586","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/ru\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/ru\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/ru\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/ru\/wp-json\/wp\/v2\/comments?post=586"}],"version-history":[{"count":79,"href":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/ru\/wp-json\/wp\/v2\/pages\/586\/revisions"}],"predecessor-version":[{"id":719,"href":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/ru\/wp-json\/wp\/v2\/pages\/586\/revisions\/719"}],"wp:attachment":[{"href":"https:\/\/aleksanderbekasov24.thkit.ee\/wp\/ru\/wp-json\/wp\/v2\/media?parent=586"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}