Pre-Commit / Post Commit Hooks

[safaci2000]

I have a pattern where I'd like to say always insert a record into a database table when a transaction is active. I was wondering if there was any thing similar Bob's Hook patterns.

Example: https://bob.stephenafamo.com/docs/models/hooks

It seems like a very useful features and was curious if Jet had something similar.

[houtn11]

You should be able to write it yourself. Is this what you had in mind?

func Query(stmt Statement, db qrm.Queryable, dest any) error {
	// pre hook
	// .....
	err := stmt.Query(db, &dest)

	// post hook
	// .....

	return err
}

[safaci2000]

I think the idea of a hook is just having something that gets automatically invoked after every SQL operation or at least after every write on a given table for example. What you're showing me is two SQL statements unless I'm misreading that?

[houtn11]

What you're showing me is two SQL statements unless I'm misreading that?

From what I can see that's exactly how bob hooks works.