This is an automated email from the ASF dual-hosted git repository. gstein pushed a commit to branch trunk in repository https://gitbox.apache.org/repos/asf/steve.git
commit 06813c3ef52461b94546be7e5658173f9d3e8cb3 Author: Greg Stein <[email protected]> AuthorDate: Wed Oct 8 23:46:22 2025 -0500 Set open/close times at state transition. --- v3/queries.yaml | 10 ++++++++-- 1 file changed, 8 insertions(+), 2 deletions(-) diff --git a/v3/queries.yaml b/v3/queries.yaml index 750a7f7..450cf2d 100644 --- a/v3/queries.yaml +++ b/v3/queries.yaml @@ -25,8 +25,14 @@ election: c_salt_mayvote: UPDATE mayvote SET salt = ? WHERE _ROWID_ = ? - c_open: UPDATE election SET salt = ?, opened_key = ? WHERE eid = ? - c_close: UPDATE election SET closed = 1 WHERE eid = ? + c_open: | + UPDATE election + SET salt = ?, opened_key = ?, open_at = unixepoch('now') + WHERE eid = ? + c_close: | + UPDATE election + SET closed = 1, close_at = unixepoch('now') + WHERE eid = ? c_add_issue: | INSERT INTO issue VALUES (?, ?, ?, ?, ?, ?) ON CONFLICT DO UPDATE SET
