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
The following commit(s) were added to refs/heads/trunk by this push:
new 18bd2bf Experimental file for an upcoming asfpy change
18bd2bf is described below
commit 18bd2bf6b744edd54248405093db95a366424903
Author: Greg Stein <[email protected]>
AuthorDate: Wed Jun 19 00:21:08 2024 -0500
Experimental file for an upcoming asfpy change
---
v3/queries.yaml | 30 ++++++++++++++++++++++++++++++
1 file changed, 30 insertions(+)
diff --git a/v3/queries.yaml b/v3/queries.yaml
new file mode 100644
index 0000000..7df9597
--- /dev/null
+++ b/v3/queries.yaml
@@ -0,0 +1,30 @@
+queries:
+ salt_issue: UPDATE ISSUES SET salt = ? WHERE _ROWID_ = ?
+ salt_person: UPDATE PERSON SET salt = ? WHERE _ROWID_ = ?
+ open_election: UPDATE METADATA SET salt = ?, opened_key = ?
+ close_election: UPDATE METADATA SET closed = 1
+ add_issue: |
+ INSERT INTO ISSUES VALUES (?, ?, ?, ?, ?, ?)
+ ON CONFLICT DO UPDATE SET
+ title=excluded.title,
+ description=excluded.description,
+ type=excluded.type,
+ kv=excluded.kv
+ add_person: |
+ INSERT INTO PERSON VALUES (?, ?, ?, ?)
+ ON CONFLICT DO UPDATE SET
+ name=excluded.name,
+ email=excluded.email
+ delete_issue: DELETE FROM ISSUES WHERE iid = ?
+ delete_person: DELETE FROM PERSON WHERE pid = ?
+ add_vote: INSERT INTO VOTES VALUES (NULL, ?, ?, ?, ?)
+ has_voted: |
+ SELECT 1 FROM VOTES
+ WHERE person_token = ? AND issue_token = ?
+ LIMIT 1
+ metadata: SELECT * FROM METADATA
+ issues: SELECT * FROM ISSUES ORDER BY iid
+ person: SELECT * FROM PERSON ORDER BY pid
+ get_issue: SELECT * FROM ISSUES WHERE iid = ?
+ get_person: SELECT * FROM PERSON WHERE pid = ?
+ by_issue: SELECT * FROM VOTES WHERE issue_token = ? ORDER BY _ROWID_
