Exposed icon indicating copy to clipboard operation
Exposed copied to clipboard

Published 20 hours ago • verified publisher icon JetBrains

Feature request: Support adding triggers

Open Aditya94A opened this issue 5 years ago • 9 comments

Would be pretty good if we had a way to register SQL triggers within Kotlin. Is this feasible @Tapac? Or is there some other way that you recommend?

Aditya94A avatar Nov 18 '19 10:11 Aditya94A

Not yet as different dialects have their own trigger declaration syntax. Moreover, it's not obvious how to handle triggers modifications and verifications.

Tapac avatar Nov 18 '19 19:11 Tapac

+1 for this feature.

@Tapac could you please provide best practice example of how you would currently implement a trigger with raw sql or any other functionality (SchemaUtils option?)

mairs8 avatar May 29 '23 13:05 mairs8

+1 for this feature.

NikolsyBoss avatar Jul 16 '23 09:07 NikolsyBoss

+1 for this feature.

ceryle avatar Jul 17 '23 13:07 ceryle

+1

Moozart avatar Feb 20 '24 12:02 Moozart

+1 for this feature.

mirjalal avatar Mar 13 '24 06:03 mirjalal

+2

jonbrew avatar Mar 28 '24 22:03 jonbrew

++

Stephcraft avatar Apr 10 '24 20:04 Stephcraft

+1 for this feature.

@Tapac could you please provide best practice example of how you would currently implement a trigger with raw sql or any other functionality (SchemaUtils option?)

@mairs8 Please check testDatabaseGeneratedValues in EntityTests.kt to see how to do that.

joc-a avatar Jul 31 '24 12:07 joc-a