Laraue.EfCoreTriggers
Laraue.EfCoreTriggers copied to clipboard
Create idempotent scripts
I tried to create idempotent scripts with this library and I'm running into the problem that the script will be created properly, but when I want to execute the script this error message comes up:
Can't create a TRIGGER from within another stored routine
Is there a possiblity to enable this feature? I can imagine it could be tricky because it would be necessary to manipulate the generation of SQL there.
Also creating a non idempotent script results into the problem:
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 7
This can be fixed if I add a the delimiter keyword properly inside the sql file. But it doesn't get generated automatically.