[DEV] SQL procedures added

procedure
tar.gz
sql
Tags: #<Tag:0x00007fe7b1ac12f0> #<Tag:0x00007fe7b1ac10c0> #<Tag:0x00007fe7b1ac0f58>

#1

Hi folks,

A word to let you know I’ve just added two SQL procedures to the install script.

The first one is last_audit(N) providing you with a list of the N last audits executed (written years ago by @koj but never added).

For the second one, a bit of context first.

Sometimes an audit may be stuck (typically because you restarted Tomcat while audits were running, you silly :wink: ). This leaves an “eternal hourglass” next to your contract.

The new list_current_acts is an SQL procedure that gives you the IDs of the act(s) and the audit you may delete to wipe out the eternal hourglass. Nice isn’t it ? :sunglasses:


#2
  • not added to the tar.gz runner?
  • “acts” : what is it ?