1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
|
CREATE PROCEDURE delete_user(code Integer(11), user Integer(11))
READS SQL DATA
begin
DECLARE nb_user_op integer(5);
if(code IS not null AND user IS not null) then
SET @sql = CONCAT('SELECT count(*) INTO nb_user_op FROM JOURNAL WHERE jo_user_fk = ', code, ';');
PREPARE cmd FROM @sql;
EXECUTE cmd;
if(nb_user_op <=0) then
SET @sql = CONCAT('DELETE FROM UTILISATEUR WHERE ut_code_pk = ', code,';');
PREPARE cmd FROM @sql;
EXECUTE cmd;
SET @sql = CONCAT('INSERT INTO journal(jo_user_fk, jo_type, jo_date, jo_table, jo_key) values (' ,
user, ',', CHAR(39),'D',CHAR(39), ',', CHAR(39),now(),CHAR(39), ',', CHAR(39),'UTILISATEUR',CHAR(39), ',', code, ');');
PREPARE cmd FROM @sql;
EXECUTE cmd;
DEALLOCATE PREPARE cmd;
end if;
end if;
end |
Partager