Õpimap norem tarkvararendaja, Aleksandr Nadvornõi

Triger — protses, mille abi tema sisse kirjutatud tegevused automatselt käivitakse

create database trigerTARpv23;
use trigerTARpv23;

create table toode(
toodeID int primary key identity(1,1),
toodeNimi varchar(50),
hind int);

create table logi(
id int primary key identity(1,1),
kasutaja varchar(100),
kuupaev datetime,
sisestatudAndmet text);

insert triger- triger mis jälgib andmete lisamine tabelisse ja teeb vastava kirje

create trigger toodeLisamine
on toode 
for insert
as 
insert into logi(kasutaja, kuupaev, sisestatudAndmet)
Select
user,
getdate(),
concat('lisatusd andmed', inserted.toodenimi, ', ', inserted.hind)
from inserted

insert into toode(toodeNimi, hind)
values('magus õun', 10);
insert into toode(toodeNimi, hind)
values('ilus pirn', 6);
Select * from toode
Select * from logi

create trigger toodeKustutamine
on toode 
for delete
as 
insert into logi(kasutaja, kuupaev, sisestatudAndmet)
Select
user,
getdate(),
concat('Kustutatud andmed: ', deleted.toodenimi, ', ', deleted.hind)
from deleted;

delete from toode 
where toodeID = 1;

Select * from toode
Select * from logi

create trigger toodeUuendamine
on toode 
for update
as 
insert into logi(kasutaja, kuupaev, sisestatudAndmet)
Select
user,
getdate(),
concat('Vanad andmed: ', deleted.toodenimi, ', ', deleted.hind,
' Uued andemed: ', inserted.toodeNimi, ', ', inserted.hind)
from deleted inner join inserted
on deleted.toodeID=inserted.toodeID

Select * from toode
update toode set toodeNimi='pink meloon '
where toodeID=2;
Select * from toode
Select * from logi

Triger Localhost

Päästik — trigger