mssql: support event triggers

[0x777]

Similar to what we have for Postgres

[0x777]

Notes from @nicuveo :

---

(Documentation for event triggers: https://hasura.io/docs/latest/graphql/core/event-triggers/index.html.)

This is likely to be a long task. First, the code for event triggers need to be generalized (it is Vanilla Postgres only for now);

• API types are declared in Hasura/RQL/Types/EventTrigger
• the API itself is in Hasura/RQL/DDL/EventTrigger
• the invocation code is in Hasura/Eventing

There already are a few functions related to them in BackendMetadata, but I don't know to which extent we've moved the process to the class.

[sassela]

Related issues:
OSS issue
user request

[m4ttheweric]

+1 for this! we love to see sql server support.

[MiteshDhiranAllscripts]

• 1 for this!

[jmarbutt]

Also can't wait to see this.

[chrisknu]

+1 for this!

[ecthiender]

This is now implemented and merged to main via abb57e5. It will be available in the upcoming release. Note that console work is still pending.

cc @tirumaraiselvan @Naveenaidu

[chrisknu]

Most excellent, thanks!

[jmarbutt]

@ecthiender so can we start using it without the console work in the next release?

[tirumaraiselvan]

@jmarbutt Yeah, it will work without console. Pls do try it out in the next major beta (2.7) !

[jmarbutt]

When will the next major release be available in beta?

[Deluxo]

In release notes of 2.7 I see that MSSQL Event Trigger support is mentioned, but I cannot select MSSQL while creating an Event Trigger (my primary database is PG, MSSQL is a +1).

Is this by design or a bug?

[tirumaraiselvan]

Console support is still pending and hence we haven't officially released it. It is slated for 2.9 release.

…

On Thu, Jun 9, 2022, 3:42 PM Deluxo ***@***.***> wrote: In release notes of 2.7 I see that MSSQL Event Trigger support is mentioned, but I cannot select MSSQL while creating an Event Trigger (my primary database is PG, MSSQL is a +1). Is this by design or a bug? — Reply to this email directly, view it on GitHub <#7228 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ACCDEEXWNLS4GTBXFAZR5J3VOG7Q3ANCNFSM5AJJLREQ> . You are receiving this because you were mentioned.Message ID: ***@***.***>

[Deluxo]

Does this mean it's still possible to use it in mssql? Like via API or other ways? @tirumaraiselvan

[tirumaraiselvan]

@Deluxo Yes, you can use the APIs: https://hasura.io/docs/latest/graphql/core/api-reference/metadata-api/event-triggers/#metadata-mssql-create-event-trigger