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 <[email protected]> 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. + */ /* --------------------------------------------------------------------- */
