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 41f0d64 Create helpful-sql.md
41f0d64 is described below
commit 41f0d64c9e3bde0f4a062e98b462116df3f670bf
Author: Greg Stein <[email protected]>
AuthorDate: Sat Oct 4 23:49:07 2025 -0500
Create helpful-sql.md
Start a little document about direct SQL manipulation/queries.
---
v3/docs/helpful-sql.md | 13 +++++++++++++
1 file changed, 13 insertions(+)
diff --git a/v3/docs/helpful-sql.md b/v3/docs/helpful-sql.md
new file mode 100644
index 0000000..6a867f8
--- /dev/null
+++ b/v3/docs/helpful-sql.md
@@ -0,0 +1,13 @@
+# Helpful SQL Statements
+
+There are a few times when you may want to interact directly with the database
+(typically `steve.db`) to perform bulk operations. Below are a few helpful
+statements.
+
+## Voter Management
+
+Add a Person as a voter on all issues in the database (eg. for dev/testing):
+```SQL
+INSERT OR IGNORE INTO mayvote (pid, iid)
+SELECT "alice", iid FROM issue
+```
