Changeset: ba61ee2f2650 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=ba61ee2f2650
Added Files:
sql/test/in-value-list/Tests/init-db.py
Branch: in-value-list
Log Message:
Add template python db-init script.
diffs (51 lines):
diff --git a/sql/test/in-value-list/Tests/init-db.py
b/sql/test/in-value-list/Tests/init-db.py
new file mode 100644
--- /dev/null
+++ b/sql/test/in-value-list/Tests/init-db.py
@@ -0,0 +1,46 @@
+import os, sys
+try:
+ from MonetDBtesting import process
+except ImportError:
+ import process
+
+def server_start(args):
+ sys.stderr.write('#mserver: "%s"\n' % ' '.join(args))
+ sys.stderr.flush()
+ srv = process.server(args = args, stdin = process.PIPE,
+ stdout = process.PIPE, stderr = process.PIPE)
+ return srv
+
+def client(lang, file):
+ sys.stderr.write('#client: "%s"\n' % file)
+ sys.stderr.flush()
+ clt = process.client(lang.lower(), stdin = open(file),
+ stdout = process.PIPE, stderr = process.PIPE)
+ return clt.communicate()
+
+def delete_where_in_mega_value_list_query_statement(size, period):
+ values = [str(x) for x in range(0, size-1) if x % period == 0]
+
+ return "delete from table1 where id in ({});".format(','.join(values))
+
+def main():
+ srv = server_start([])
+
+ out, err = client('SQL',
+ os.path.join(os.getenv('RELSRCDIR'),
+ 'create-and-fill-table.sql'))
+ sys.stdout.write(out)
+ sys.stderr.write(err)
+
+ c = process.client('sql', stdin = process.PIPE, stdout = process.PIPE,
stderr = process.PIPE)
+
+ out, err =
c.communicate(delete_where_in_mega_value_list_query_statement(1000000, 5))
+
+ sys.stdout.write(out)
+ sys.stderr.write(err)
+
+ out, err = srv.communicate()
+ sys.stdout.write(out)
+ sys.stderr.write(err)
+
+main()
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
