create db triggers on db creation #7

New Issue

wanderer · 2021-01-26T15:41:06+01:00

wanderer commented

2021-01-26 15:41:06 +01:00

as #3 pointed, triggers for Updated attr had to be created in 1442a2a664.
those are, however, not present on db creation and we currently don't have a mechanism applying them automatically when they're not present, risking a situation where we're getting bogus values again.

we need a way to run our trigger creation script on apps first run or similar.

as #3 pointed, triggers for `Updated` attr had to be created in https://git.dotya.ml/wanderer/pwt-0x01-ng/commit/1442a2a664f9bd96c08d55330e10d39094cf0158. those are, however, not present on db creation and we currently don't have a mechanism applying them automatically when they're not present, risking a situation where we're getting bogus values again. we need a way to run our trigger creation script on apps first run or similar.

wanderer added the

enhancement

label 2021-01-26 15:41:06 +01:00

wanderer self-assigned this 2021-01-26 15:41:06 +01:00

wanderer added the

help wanted

label 2021-02-23 20:36:05 +01:00

wanderer added this to the 1.0 milestone 2021-02-27 01:48:49 +01:00

FunTom commented

2022-01-03 15:16:51 +01:00

This project might be the right solution
https://github.com/win7user10/Laraue.EfCoreTriggers
https://www.nuget.org/packages/Laraue.EfCoreTriggers.PostgreSql/1.1.1, respectively.
("EfCoreTriggers is the library to write native SQL triggers using EFCore model builder. Triggers are automatically translating into sql and adding to migrations.")

This project might be the right solution https://github.com/win7user10/Laraue.EfCoreTriggers https://www.nuget.org/packages/Laraue.EfCoreTriggers.PostgreSql/1.1.1, respectively. ("EfCoreTriggers is the library to write native SQL triggers using EFCore model builder. Triggers are automatically translating into sql and adding to migrations.")

🚀 1

wanderer commented

2022-01-04 03:28:50 +01:00

This project might be the right solution
https://github.com/win7user10/Laraue.EfCoreTriggers
https://www.nuget.org/packages/Laraue.EfCoreTriggers.PostgreSql/1.1.1, respectively.
("EfCoreTriggers is the library to write native SQL triggers using EFCore model builder. Triggers are automatically translating into sql and adding to migrations.")

thx, gotta look into that! @FunTom

> This project might be the right solution > https://github.com/win7user10/Laraue.EfCoreTriggers > https://www.nuget.org/packages/Laraue.EfCoreTriggers.PostgreSql/1.1.1, respectively. > ("EfCoreTriggers is the library to write native SQL triggers using EFCore model builder. Triggers are automatically translating into sql and adding to migrations.") > thx, gotta look into that! @FunTom

This repo is archived. You cannot comment on issues.