[steve] 01/03: show how to add schema via python

[gs...@apache.org]

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 97a9223953bc84df84e4b6818194d29fde1399d9
Author: Greg Stein <gs...@gmail.com>
AuthorDate: Sun Jun 5 17:12:41 2022 -0500

    show how to add schema via python
---
 v3/schema.sql | 11 ++++++++++-
 1 file changed, 10 insertions(+), 1 deletion(-)

diff --git a/v3/schema.sql b/v3/schema.sql
index 67e7a3c..bd9a3f2 100644
--- a/v3/schema.sql
+++ b/v3/schema.sql
@@ -19,7 +19,16 @@
 
 /* ### TBD DOCCO.  */
 
-/* ### $ sqlite3 testing.db < schema.sql  */
+/* ### $ sqlite3 testing.db < schema.sql
+   ###
+   ### OR:
+   ### >>> import sqlite3
+   ### >>> conn = sqlite3.connect('testing.db')
+   ### >>> conn.executescript('schema.sql')
+   ###
+   ### ? maybe: conn.commit() and/or conn.close() ... the DML statements
+   ### don't seem to require full closure of connection.
+   */
 
 
 /* --------------------------------------------------------------------- */