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