Changeset: e73ba0cef16c for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/e73ba0cef16c
Modified Files:
        documentation/source/developers_handbook.rst
Branch: default
Log Message:

adding some documentation for sqllogic multiple connections


diffs (40 lines):

diff --git a/documentation/source/developers_handbook.rst 
b/documentation/source/developers_handbook.rst
--- a/documentation/source/developers_handbook.rst
+++ b/documentation/source/developers_handbook.rst
@@ -89,7 +89,35 @@ sqllogic protocol a bit further::
     hash-threshold number
     halt
 
-Alternatively ``.sql`` scripts can be converted to sqllogic tests (.test) with 
``Mconvert.py``.
+Consider the following single client connection example::
+
+    statement ok
+    create table foo(a int)
+
+    statement ok
+    insert into foo values (1), (2), (3)
+
+    query I rowsort
+    select sum(a) from foo
+    ----
+    6
+
+, the same assertions could be made from multiple clients as follows::
+
+    statement ok
+    create table foo(a int)
+
+    @connection(id=1, username=monetdb, password=monetdb)
+    statement ok
+    insert into foo values (1), (2), (3)
+
+    @connection(id=2, username=monetdb, password=monetdb)
+    query I rowsort
+    select sum(a) from foo
+    ----
+    6
+
+Alternatively existing ``.sql`` scripts can be converted to sqllogic tests 
(.test) with ``Mconvert.py``.
 For example::
 
     $Mconvert.py  --auto <module>/Tests <convert_me>.sql
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to