{"id":1638,"date":"2024-03-13T10:39:07","date_gmt":"2024-03-13T10:39:07","guid":{"rendered":"https:\/\/darjaportnova23.thkit.ee\/wp\/?p=1638"},"modified":"2024-03-17T21:47:49","modified_gmt":"2024-03-17T21:47:49","slug":"trigger-independent-task","status":"publish","type":"post","link":"https:\/\/darjaportnova23.thkit.ee\/wp\/blog\/2024\/03\/13\/trigger-independent-task\/","title":{"rendered":"Trigger – independent task"},"content":{"rendered":"\n

This SQL code is for making two tables in a database. These tables can be used for keeping track of cars and their owners, and for logging different actions with these cars.<\/p>\n\n\n\n

\n
\n

Autoregister- is for keeping info about registered cars.<\/p>\n\n\n

\nCreate table autoregister(\nid INT PRIMARY KEY IDENTITY(1,1),\nnumber varchar(15),\nmark varchar(100),\nvarv varchar(50),\nomanik varchar(200));\n<\/pre><\/div><\/div>\n\n\n\n
\n
    \n
  • IDENTITY(1,1) means the values will automatically generate, starting from 1 and increasing by 1 with each new entry<\/li>\n\n\n\n
  • number – a string with a maximum length of 15 characters<\/li>\n\n\n\n
  • mark – a string, but with a max len of 100 characters<\/li>\n\n\n\n
  • varv (color) – a string with a max len of 50 characters<\/li>\n\n\n\n
  • omanik (owner) – a string with a max len of 200 characters<\/li>\n<\/ul>\n<\/div>\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
    \"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n
    \"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n<\/figure>\n\n\n\n
    \n
    \n
    Table “logitabel”: is for keeping logs or records of different actions done with the cars.<\/p>\n\n\n
    \nCreate table logitabel(\nid INT PRIMARY KEY IDENTITY(1,1),\naeg DATETIME,\ntoiming varchar(100),\nautoAndmed TEXT);\n<\/pre><\/div><\/div>\n\n\n\n
    \n
      \n
    • aeg (time) – data type DATETIME<\/li>\n\n\n\n
    • toiming (action) – description of the action, a string with a max len of 100 characters<\/li>\n\n\n\n
    • autoAndmed (car data) – data about the car related to the action. The data type TEXT allows storing large text data<\/li>\n<\/ul>\n<\/div>\n<\/div>\n\n\n\n
      \n
      \n
      phpMyAdmin:<\/h4>\n\n\n
      \nCreate table autoregister(\nid int AUTO_INCREMENT PRIMARY KEY,\nnumber varchar(15),\nmark varchar(100),\nvarv varchar(50),\nomanik varchar(200));\n\nCreate table logitabel(\nid int AUTO_INCREMENT PRIMARY KEY,\naeg DATETIME,\ntoiming varchar(100),\nautoAndmed TEXT);\n<\/pre><\/div><\/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<\/div>\n<\/div>\n\n\n\n
      Auto lisamine:<\/h2>\n\n\n\n
      \n
      \n
      Creating a trigger named ‘autoLisamine’ for the table ‘autoregister’<\/p>\n\n\n
      \nCREATE TRIGGER autoLisamine\nON autoregister\nAFTER INSERT\nAS\nBEGIN\n-- Inserting a new record into 'logitabel' table\n\tINSERT INTO logitabel(aeg, toiming, autoAndmed)\n-- Setting the current date and time for the log, the action as 'Car added'\n-- concatenating car details into a string for the 'autoAndmed' field\n\tSELECT GETDATE(), 'Auto on lisatud',\n\tCONCAT('Auto number: ', number, ', Mark: ', mark, ', V\u00e4rv: ', varv, ', Omanik: ', omanik)\n\tFROM inserted;\n-- 'inserted' is a special table used in triggers that holds the newly inserted rows\nEND\n<\/pre><\/div>\n\n\n
      This is a check section to insert a new car into ‘autoregister’ and see the trigger in action<\/p>\n\n\n\n
      Inserting a new car record into ‘autoregister’ table<\/p>\n\n\n\n
      Selecting all records from ‘autoregister’ to check the inserted car record and from ‘logitabel’ to check the log entry<\/p>\n\n\n
      \nINSERT INTO autoregister(number, mark, varv, omanik)\nValues ('910 NJY', 'Toyota', 'gray', 'DS');\nSELECT * FROM autoregister;\nSELECT * FROM logitabel;\n<\/pre><\/div><\/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
      \"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\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
      \"\"\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
      Auto Kustutamine:<\/h2>\n\n\n\n
      \n
      \n
      Creating a trigger named ‘autoKustutamine’ for the ‘autoregister’ table<\/p>\n\n\n
      \nCREATE TRIGGER autoKustutamine\nON autoregister\nAFTER DELETE\nAS\nBEGIN\n-- Inserting a new record into 'logitabel' table\n\tINSERT INTO logitabel(aeg, toiming, autoAndmed)\n-- Setting the current date and time for the log\n\tSELECT GETDATE(), 'Auto on kustutatud',\n\tdeleted.number\n\tFROM deleted;\n-- 'deleted' is a table used in triggers that holds the deleted rows\nEND\n<\/pre><\/div>\n\n
      \nDELETE FROM autoregister Where id = 4;\nSELECT * FROM autoregister;\nSELECT * FROM logitabel;\n<\/pre><\/div><\/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
      \"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\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
      \"\"\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
      Tabeli Uuendamine:<\/h2>\n\n\n\n
      \n
      \n
      Adding a new column ‘kasutaja’ to the ‘logitabel’ table to store the username of the user performing the action<\/p>\n\n\n
      \nALTER TABLE logitabel ADD kasutaja varchar(100);\nSELECT * FROM logitabel;\n<\/pre><\/div>\n\n\n
      Creating a trigger named ‘autoUuendamine’ on the ‘autoregister’ table<\/p>\n\n\n
      \nCREATE TRIGGER autoUuendamine\nON autoregister\nFOR UPDATE\nAS\nBEGIN\n\tINSERT INTO logitabel(aeg, kasutaja, toiming, autoAndmed)\n\tSELECT GETDATE(),\n-- USER - to get the username of the person performing the update\n\tUSER,\n-- Specifying the action as 'Car data updated'\n\t'Auto andmed on uuednatud',\n\tCONCAT('Vanad andmed: ', d.number, ', ' , d.mark, ', ' , d.varv, ', ' , d.omanik,\n\t'Uued andmed: ', i.number, ', ' , i.mark, ', ' , i.varv, ', ' , i.omanik)\n\tFROM deleted d\n-- Joining 'deleted' and 'inserted' to compare old and new values\n\tINNER JOIN inserted i\n\tON i.id = d.id;\nEND\n<\/pre><\/div>\n\n\n
      This command updates the record with id = 2<\/code> in the “autoregister<\/code>” table<\/p>\n\n\n
      \nUPDATE autoregister SET number = '528 HDE', mark = 'BMW', varv = 'white', omanik = 'Deniss'\nWHERE id = 2;\nSELECT * FROM autoregister;\nSELECT * FROM logitabel;\n<\/pre><\/div><\/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
      \"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\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
      \"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
      This SQL code is for making two tables in a database. These tables can be used for keeping track of cars and their owners, and for logging different actions with these cars. Autoregister- is for keeping info about registered cars. Table “logitabel”: is for keeping logs or records of different actions done with the cars. phpMyAdmin: Auto lisamine: Creating a trigger named ‘autoLisamine’ for the table ‘autoregister’ This is a check section to insert a new car into ‘autoregister’ and see the trigger in action Inserting a new car record into ‘autoregister’ table Selecting all records from ‘autoregister’ to check<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[26],"tags":[28,27,25],"class_list":["post-1638","post","type-post","status-publish","format-standard","hentry","category-database","tag-database","tag-sql","tag-trigger"],"yoast_head":"\nTrigger - independent task - Darja Suhhanova (Portnova) - Portfolio<\/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:\/\/darjaportnova23.thkit.ee\/wp\/blog\/2024\/03\/13\/trigger-independent-task\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Trigger - independent task - Darja Suhhanova (Portnova) - Portfolio\" \/>\n<meta property=\"og:description\" content=\"This SQL code is for making two tables in a database. These tables can be used for keeping track of cars and their owners, and for logging different actions with these cars. Autoregister- is for keeping info about registered cars. Table “logitabel”: is for keeping logs or records of different actions done with the cars. phpMyAdmin: Auto lisamine: Creating a trigger named ‘autoLisamine’ for the table ‘autoregister’ This is a check section to insert a new car into ‘autoregister’ and see the trigger in action Inserting a new car record into ‘autoregister’ table Selecting all records from ‘autoregister’ to check\" \/>\n<meta property=\"og:url\" content=\"https:\/\/darjaportnova23.thkit.ee\/wp\/blog\/2024\/03\/13\/trigger-independent-task\/\" \/>\n<meta property=\"og:site_name\" content=\"Darja Suhhanova (Portnova) - Portfolio\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-13T10:39:07+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-17T21:47:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/darjaportnova23.thkit.ee\/wp\/wp-content\/uploads\/2024\/03\/image-8.png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/darjaportnova23.thkit.ee\\\/wp\\\/blog\\\/2024\\\/03\\\/13\\\/trigger-independent-task\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/darjaportnova23.thkit.ee\\\/wp\\\/blog\\\/2024\\\/03\\\/13\\\/trigger-independent-task\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/darjaportnova23.thkit.ee\\\/wp\\\/#\\\/schema\\\/person\\\/461c1001ef7f55c0532a6c7d62801873\"},\"headline\":\"Trigger – independent task\",\"datePublished\":\"2024-03-13T10:39:07+00:00\",\"dateModified\":\"2024-03-17T21:47:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/darjaportnova23.thkit.ee\\\/wp\\\/blog\\\/2024\\\/03\\\/13\\\/trigger-independent-task\\\/\"},\"wordCount\":267,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/darjaportnova23.thkit.ee\\\/wp\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/darjaportnova23.thkit.ee\\\/wp\\\/blog\\\/2024\\\/03\\\/13\\\/trigger-independent-task\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/darjaportnova23.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/image-8.png\",\"keywords\":[\"database\",\"sql\",\"trigger\"],\"articleSection\":[\"database\"],\"inLanguage\":\"en\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/darjaportnova23.thkit.ee\\\/wp\\\/blog\\\/2024\\\/03\\\/13\\\/trigger-independent-task\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/darjaportnova23.thkit.ee\\\/wp\\\/blog\\\/2024\\\/03\\\/13\\\/trigger-independent-task\\\/\",\"url\":\"https:\\\/\\\/darjaportnova23.thkit.ee\\\/wp\\\/blog\\\/2024\\\/03\\\/13\\\/trigger-independent-task\\\/\",\"name\":\"Trigger - independent task - Darja Suhhanova (Portnova) - Portfolio\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/darjaportnova23.thkit.ee\\\/wp\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/darjaportnova23.thkit.ee\\\/wp\\\/blog\\\/2024\\\/03\\\/13\\\/trigger-independent-task\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/darjaportnova23.thkit.ee\\\/wp\\\/blog\\\/2024\\\/03\\\/13\\\/trigger-independent-task\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/darjaportnova23.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/image-8.png\",\"datePublished\":\"2024-03-13T10:39:07+00:00\",\"dateModified\":\"2024-03-17T21:47:49+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/darjaportnova23.thkit.ee\\\/wp\\\/blog\\\/2024\\\/03\\\/13\\\/trigger-independent-task\\\/#breadcrumb\"},\"inLanguage\":\"en\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/darjaportnova23.thkit.ee\\\/wp\\\/blog\\\/2024\\\/03\\\/13\\\/trigger-independent-task\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en\",\"@id\":\"https:\\\/\\\/darjaportnova23.thkit.ee\\\/wp\\\/blog\\\/2024\\\/03\\\/13\\\/trigger-independent-task\\\/#primaryimage\",\"url\":\"https:\\\/\\\/darjaportnova23.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/image-8.png\",\"contentUrl\":\"https:\\\/\\\/darjaportnova23.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/image-8.png\",\"width\":242,\"height\":188},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/darjaportnova23.thkit.ee\\\/wp\\\/blog\\\/2024\\\/03\\\/13\\\/trigger-independent-task\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/darjaportnova23.thkit.ee\\\/wp\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Trigger – independent task\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/darjaportnova23.thkit.ee\\\/wp\\\/#website\",\"url\":\"https:\\\/\\\/darjaportnova23.thkit.ee\\\/wp\\\/\",\"name\":\"Darja Suhhanova (Portnova) - Portfolio\",\"description\":\"Junior Software Developer\",\"publisher\":{\"@id\":\"https:\\\/\\\/darjaportnova23.thkit.ee\\\/wp\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/darjaportnova23.thkit.ee\\\/wp\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/darjaportnova23.thkit.ee\\\/wp\\\/#organization\",\"name\":\"Darja Suhhanova (Portnova) - Portfolio\",\"url\":\"https:\\\/\\\/darjaportnova23.thkit.ee\\\/wp\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en\",\"@id\":\"https:\\\/\\\/darjaportnova23.thkit.ee\\\/wp\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/darjaportnova23.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2023\\\/11\\\/logoDP-7.png\",\"contentUrl\":\"https:\\\/\\\/darjaportnova23.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2023\\\/11\\\/logoDP-7.png\",\"width\":551,\"height\":568,\"caption\":\"Darja Suhhanova (Portnova) - Portfolio\"},\"image\":{\"@id\":\"https:\\\/\\\/darjaportnova23.thkit.ee\\\/wp\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/darjaportnova23.thkit.ee\\\/wp\\\/#\\\/schema\\\/person\\\/461c1001ef7f55c0532a6c7d62801873\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7888d058a8070e4ef46f779d20444cfbccc437dc0f77abd79dd9f8828786a681?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7888d058a8070e4ef46f779d20444cfbccc437dc0f77abd79dd9f8828786a681?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/7888d058a8070e4ef46f779d20444cfbccc437dc0f77abd79dd9f8828786a681?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"https:\\\/\\\/darjaportnova23.thkit.ee\\\/wp\"],\"url\":\"https:\\\/\\\/darjaportnova23.thkit.ee\\\/wp\\\/blog\\\/author\\\/admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Trigger - independent task - Darja Suhhanova (Portnova) - Portfolio","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:\/\/darjaportnova23.thkit.ee\/wp\/blog\/2024\/03\/13\/trigger-independent-task\/","og_locale":"en_US","og_type":"article","og_title":"Trigger - independent task - Darja Suhhanova (Portnova) - Portfolio","og_description":"This SQL code is for making two tables in a database. These tables can be used for keeping track of cars and their owners, and for logging different actions with these cars. Autoregister- is for keeping info about registered cars. Table “logitabel”: is for keeping logs or records of different actions done with the cars. phpMyAdmin: Auto lisamine: Creating a trigger named ‘autoLisamine’ for the table ‘autoregister’ This is a check section to insert a new car into ‘autoregister’ and see the trigger in action Inserting a new car record into ‘autoregister’ table Selecting all records from ‘autoregister’ to check","og_url":"https:\/\/darjaportnova23.thkit.ee\/wp\/blog\/2024\/03\/13\/trigger-independent-task\/","og_site_name":"Darja Suhhanova (Portnova) - Portfolio","article_published_time":"2024-03-13T10:39:07+00:00","article_modified_time":"2024-03-17T21:47:49+00:00","og_image":[{"url":"https:\/\/darjaportnova23.thkit.ee\/wp\/wp-content\/uploads\/2024\/03\/image-8.png","type":"","width":"","height":""}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/darjaportnova23.thkit.ee\/wp\/blog\/2024\/03\/13\/trigger-independent-task\/#article","isPartOf":{"@id":"https:\/\/darjaportnova23.thkit.ee\/wp\/blog\/2024\/03\/13\/trigger-independent-task\/"},"author":{"name":"admin","@id":"https:\/\/darjaportnova23.thkit.ee\/wp\/#\/schema\/person\/461c1001ef7f55c0532a6c7d62801873"},"headline":"Trigger – independent task","datePublished":"2024-03-13T10:39:07+00:00","dateModified":"2024-03-17T21:47:49+00:00","mainEntityOfPage":{"@id":"https:\/\/darjaportnova23.thkit.ee\/wp\/blog\/2024\/03\/13\/trigger-independent-task\/"},"wordCount":267,"commentCount":0,"publisher":{"@id":"https:\/\/darjaportnova23.thkit.ee\/wp\/#organization"},"image":{"@id":"https:\/\/darjaportnova23.thkit.ee\/wp\/blog\/2024\/03\/13\/trigger-independent-task\/#primaryimage"},"thumbnailUrl":"https:\/\/darjaportnova23.thkit.ee\/wp\/wp-content\/uploads\/2024\/03\/image-8.png","keywords":["database","sql","trigger"],"articleSection":["database"],"inLanguage":"en","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/darjaportnova23.thkit.ee\/wp\/blog\/2024\/03\/13\/trigger-independent-task\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/darjaportnova23.thkit.ee\/wp\/blog\/2024\/03\/13\/trigger-independent-task\/","url":"https:\/\/darjaportnova23.thkit.ee\/wp\/blog\/2024\/03\/13\/trigger-independent-task\/","name":"Trigger - independent task - Darja Suhhanova (Portnova) - Portfolio","isPartOf":{"@id":"https:\/\/darjaportnova23.thkit.ee\/wp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/darjaportnova23.thkit.ee\/wp\/blog\/2024\/03\/13\/trigger-independent-task\/#primaryimage"},"image":{"@id":"https:\/\/darjaportnova23.thkit.ee\/wp\/blog\/2024\/03\/13\/trigger-independent-task\/#primaryimage"},"thumbnailUrl":"https:\/\/darjaportnova23.thkit.ee\/wp\/wp-content\/uploads\/2024\/03\/image-8.png","datePublished":"2024-03-13T10:39:07+00:00","dateModified":"2024-03-17T21:47:49+00:00","breadcrumb":{"@id":"https:\/\/darjaportnova23.thkit.ee\/wp\/blog\/2024\/03\/13\/trigger-independent-task\/#breadcrumb"},"inLanguage":"en","potentialAction":[{"@type":"ReadAction","target":["https:\/\/darjaportnova23.thkit.ee\/wp\/blog\/2024\/03\/13\/trigger-independent-task\/"]}]},{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/darjaportnova23.thkit.ee\/wp\/blog\/2024\/03\/13\/trigger-independent-task\/#primaryimage","url":"https:\/\/darjaportnova23.thkit.ee\/wp\/wp-content\/uploads\/2024\/03\/image-8.png","contentUrl":"https:\/\/darjaportnova23.thkit.ee\/wp\/wp-content\/uploads\/2024\/03\/image-8.png","width":242,"height":188},{"@type":"BreadcrumbList","@id":"https:\/\/darjaportnova23.thkit.ee\/wp\/blog\/2024\/03\/13\/trigger-independent-task\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/darjaportnova23.thkit.ee\/wp\/"},{"@type":"ListItem","position":2,"name":"Trigger – independent task"}]},{"@type":"WebSite","@id":"https:\/\/darjaportnova23.thkit.ee\/wp\/#website","url":"https:\/\/darjaportnova23.thkit.ee\/wp\/","name":"Darja Suhhanova (Portnova) - Portfolio","description":"Junior Software Developer","publisher":{"@id":"https:\/\/darjaportnova23.thkit.ee\/wp\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/darjaportnova23.thkit.ee\/wp\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en"},{"@type":"Organization","@id":"https:\/\/darjaportnova23.thkit.ee\/wp\/#organization","name":"Darja Suhhanova (Portnova) - Portfolio","url":"https:\/\/darjaportnova23.thkit.ee\/wp\/","logo":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/darjaportnova23.thkit.ee\/wp\/#\/schema\/logo\/image\/","url":"https:\/\/darjaportnova23.thkit.ee\/wp\/wp-content\/uploads\/2023\/11\/logoDP-7.png","contentUrl":"https:\/\/darjaportnova23.thkit.ee\/wp\/wp-content\/uploads\/2023\/11\/logoDP-7.png","width":551,"height":568,"caption":"Darja Suhhanova (Portnova) - Portfolio"},"image":{"@id":"https:\/\/darjaportnova23.thkit.ee\/wp\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/darjaportnova23.thkit.ee\/wp\/#\/schema\/person\/461c1001ef7f55c0532a6c7d62801873","name":"admin","image":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/secure.gravatar.com\/avatar\/7888d058a8070e4ef46f779d20444cfbccc437dc0f77abd79dd9f8828786a681?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/7888d058a8070e4ef46f779d20444cfbccc437dc0f77abd79dd9f8828786a681?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/7888d058a8070e4ef46f779d20444cfbccc437dc0f77abd79dd9f8828786a681?s=96&d=mm&r=g","caption":"admin"},"sameAs":["https:\/\/darjaportnova23.thkit.ee\/wp"],"url":"https:\/\/darjaportnova23.thkit.ee\/wp\/blog\/author\/admin\/"}]}},"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/darjaportnova23.thkit.ee\/wp\/wp-json\/wp\/v2\/posts\/1638","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/darjaportnova23.thkit.ee\/wp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/darjaportnova23.thkit.ee\/wp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/darjaportnova23.thkit.ee\/wp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/darjaportnova23.thkit.ee\/wp\/wp-json\/wp\/v2\/comments?post=1638"}],"version-history":[{"count":30,"href":"https:\/\/darjaportnova23.thkit.ee\/wp\/wp-json\/wp\/v2\/posts\/1638\/revisions"}],"predecessor-version":[{"id":1893,"href":"https:\/\/darjaportnova23.thkit.ee\/wp\/wp-json\/wp\/v2\/posts\/1638\/revisions\/1893"}],"wp:attachment":[{"href":"https:\/\/darjaportnova23.thkit.ee\/wp\/wp-json\/wp\/v2\/media?parent=1638"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/darjaportnova23.thkit.ee\/wp\/wp-json\/wp\/v2\/categories?post=1638"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/darjaportnova23.thkit.ee\/wp\/wp-json\/wp\/v2\/tags?post=1638"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}