Changeset: 62d550bb0991 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=62d550bb0991
Modified Files:
monetdb5/extras/jaql/Tests/All
monetdb5/extras/jaql/Tests/expand00.mal
monetdb5/extras/jaql/Tests/expand00.stable.err
monetdb5/extras/jaql/Tests/expand00.stable.out
monetdb5/extras/jaql/Tests/filter00.mal
monetdb5/extras/jaql/Tests/filter00.stable.err
monetdb5/extras/jaql/Tests/filter00.stable.out
monetdb5/extras/jaql/Tests/plan00.mal
monetdb5/extras/jaql/Tests/plan00.stable.err
monetdb5/extras/jaql/Tests/plan00.stable.out
monetdb5/extras/jaql/Tests/variable00.mal
monetdb5/extras/jaql/Tests/variable00.stable.err
monetdb5/extras/jaql/Tests/variable00.stable.out
Branch: jacqueline
Log Message:
jaql: add some simple Tests
diffs (truncated from 358 to 300 lines):
diff --git a/monetdb5/extras/jaql/Tests/All b/monetdb5/extras/jaql/Tests/All
new file mode 100644
--- /dev/null
+++ b/monetdb5/extras/jaql/Tests/All
@@ -0,0 +1,4 @@
+expand00
+filter00
+variable00
+plan00
diff --git a/monetdb5/extras/jaql/Tests/expand00.mal
b/monetdb5/extras/jaql/Tests/expand00.mal
new file mode 100644
--- /dev/null
+++ b/monetdb5/extras/jaql/Tests/expand00.mal
@@ -0,0 +1,2 @@
+jaql.x("[ [3,65,8,72], [5,98,2,65,[]] ] -> expand each arr;");
+jaql.x("[ {\"name\":\"Jon Doe\", \"movie_ids\":[3,65,8,72]}, {\"name\":\"Jane
Dean\",\"movie_ids\":[5,98,2]} ] -> expand $.movie_ids;");
diff --git a/monetdb5/extras/jaql/Tests/expand00.stable.err
b/monetdb5/extras/jaql/Tests/expand00.stable.err
new file mode 100644
--- /dev/null
+++ b/monetdb5/extras/jaql/Tests/expand00.stable.err
@@ -0,0 +1,31 @@
+stderr of test 'expand00` in directory 'extras/jaql` itself:
+
+
+# 21:15:09 >
+# 21:15:09 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set"
"gdk_dbfarm=/net/sofia.ins.cwi.nl/export/scratch1/fabian/tmp/mtest-jacqueline-sofia.ins.cwi.nl/five/dbfarm"
"--set" "mapi_open=true" "--set" "mapi_port=33495" "--set" "monet_prompt="
"--trace" "--forcemito" "--set" "mal_listing=2" "--dbname=mTests_extras_jaql"
"expand00.mal"
+# 21:15:09 >
+
+# builtin opt gdk_dbname = demo
+# builtin opt gdk_dbfarm =
/ufs/fabian/scratch/ssd/monetdb/jacqueline/program-x86_64/var/lib/monetdb5/dbfarm
+# builtin opt gdk_debug = 0
+# builtin opt gdk_alloc_map = no
+# builtin opt gdk_vmtrim = yes
+# builtin opt monet_prompt = >
+# builtin opt monet_daemon = no
+# builtin opt mapi_port = 50000
+# builtin opt mapi_open = false
+# builtin opt mapi_autosense = false
+# builtin opt sql_optimizer = default_pipe
+# builtin opt sql_debug = 0
+# cmdline opt gdk_nr_threads = 0
+# cmdline opt gdk_dbfarm =
/net/sofia.ins.cwi.nl/export/scratch1/fabian/tmp/mtest-jacqueline-sofia.ins.cwi.nl/five/dbfarm
+# cmdline opt mapi_open = true
+# cmdline opt mapi_port = 33495
+# cmdline opt monet_prompt =
+# cmdline opt mal_listing = 2
+# cmdline opt gdk_dbname = mTests_extras_jaql
+
+# 21:15:09 >
+# 21:15:09 > "Done."
+# 21:15:09 >
+
diff --git a/monetdb5/extras/jaql/Tests/expand00.stable.out
b/monetdb5/extras/jaql/Tests/expand00.stable.out
new file mode 100644
--- /dev/null
+++ b/monetdb5/extras/jaql/Tests/expand00.stable.out
@@ -0,0 +1,29 @@
+stdout of test 'expand00` in directory 'extras/jaql` itself:
+
+
+# 21:15:09 >
+# 21:15:09 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set"
"gdk_dbfarm=/net/sofia.ins.cwi.nl/export/scratch1/fabian/tmp/mtest-jacqueline-sofia.ins.cwi.nl/five/dbfarm"
"--set" "mapi_open=true" "--set" "mapi_port=33495" "--set" "monet_prompt="
"--trace" "--forcemito" "--set" "mal_listing=2" "--dbname=mTests_extras_jaql"
"expand00.mal"
+# 21:15:09 >
+
+# MonetDB 5 server v11.8.0 "jacqueline-65159548356e+"
+# Serving database 'mTests_extras_jaql', using 8 threads
+# Compiled for x86_64-pc-linux-gnu/64bit with 64bit OIDs dynamically linked
+# Found 15.662 GiB available main-memory.
+# Copyright (c) 1993-July 2008 CWI.
+# Copyright (c) August 2008-2012 MonetDB B.V., all rights reserved
+# Visit http://www.monetdb.org/ for further information
+# Listening for connection requests on mapi:monetdb://sofia.ins.cwi.nl:33495/
+# MonetDB/GIS module loaded
+# MonetDB/SQL module loaded
+# MonetDB/DataCell module not loaded: MALException:jaql.context:JAQL
environment not found
+function user.main():void;
+ jaql.x("[ [3,65,8,72], [5,98,2,65,[]] ] -> expand each arr;");
+ jaql.x("[ {\"name\":\"Jon Doe\", \"movie_ids\":[3,65,8,72]},
{\"name\":\"Jane Dean\",\"movie_ids\":[5,98,2]} ] -> expand $.movie_ids;");
+end main;
+[ 3, 65, 8, 72, 5, 98, 2, 65, [ ] ]
+[ 3, 65, 8, 72, 5, 98, 2 ]
+
+# 21:15:09 >
+# 21:15:09 > "Done."
+# 21:15:09 >
+
diff --git a/monetdb5/extras/jaql/Tests/filter00.mal
b/monetdb5/extras/jaql/Tests/filter00.mal
new file mode 100644
--- /dev/null
+++ b/monetdb5/extras/jaql/Tests/filter00.mal
@@ -0,0 +1,5 @@
+jaql.x("[ {\"id\":1, \"dept\":1, \"income\":12000},{\"id\":2, \"dept\":2,
\"income\":13000} ] -> filter $.dept == 1;");
+jaql.x("[ {\"id\":1, \"dept\":1, \"income\":12000},{\"id\":2, \"dept\":2,
\"income\":13000} ] -> filter $.dept < 2;");
+jaql.x("[ {\"id\":1, \"dept\":1, \"income\":12000},{\"id\":2, \"dept\":2,
\"income\":13000} ] -> filter $.dept == $.id;");
+jaql.x("[ {\"id\":1, \"dept\":1, \"income\":12000},{\"id\":2, \"dept\":2,
\"income\":13000} ] -> filter $.dept != $.id;");
+jaql.x("[ {\"id\":1, \"dept\":1, \"income\":12000},{\"id\":2, \"dept\":2,
\"income\":13000} ] -> filter $.dept > $.id;");
diff --git a/monetdb5/extras/jaql/Tests/filter00.stable.err
b/monetdb5/extras/jaql/Tests/filter00.stable.err
new file mode 100644
--- /dev/null
+++ b/monetdb5/extras/jaql/Tests/filter00.stable.err
@@ -0,0 +1,31 @@
+stderr of test 'filter00` in directory 'extras/jaql` itself:
+
+
+# 21:51:22 >
+# 21:51:22 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set"
"gdk_dbfarm=/net/sofia.ins.cwi.nl/export/scratch1/fabian/tmp/mtest-jacqueline-sofia.ins.cwi.nl/five/dbfarm"
"--set" "mapi_open=true" "--set" "mapi_port=31617" "--set" "monet_prompt="
"--trace" "--forcemito" "--set" "mal_listing=2" "--dbname=mTests_extras_jaql"
"filter00.mal"
+# 21:51:22 >
+
+# builtin opt gdk_dbname = demo
+# builtin opt gdk_dbfarm =
/ufs/fabian/scratch/ssd/monetdb/jacqueline/program-x86_64/var/lib/monetdb5/dbfarm
+# builtin opt gdk_debug = 0
+# builtin opt gdk_alloc_map = no
+# builtin opt gdk_vmtrim = yes
+# builtin opt monet_prompt = >
+# builtin opt monet_daemon = no
+# builtin opt mapi_port = 50000
+# builtin opt mapi_open = false
+# builtin opt mapi_autosense = false
+# builtin opt sql_optimizer = default_pipe
+# builtin opt sql_debug = 0
+# cmdline opt gdk_nr_threads = 0
+# cmdline opt gdk_dbfarm =
/net/sofia.ins.cwi.nl/export/scratch1/fabian/tmp/mtest-jacqueline-sofia.ins.cwi.nl/five/dbfarm
+# cmdline opt mapi_open = true
+# cmdline opt mapi_port = 31617
+# cmdline opt monet_prompt =
+# cmdline opt mal_listing = 2
+# cmdline opt gdk_dbname = mTests_extras_jaql
+
+# 21:51:22 >
+# 21:51:22 > "Done."
+# 21:51:22 >
+
diff --git a/monetdb5/extras/jaql/Tests/filter00.stable.out
b/monetdb5/extras/jaql/Tests/filter00.stable.out
new file mode 100644
--- /dev/null
+++ b/monetdb5/extras/jaql/Tests/filter00.stable.out
@@ -0,0 +1,35 @@
+stdout of test 'filter00` in directory 'extras/jaql` itself:
+
+
+# 21:51:22 >
+# 21:51:22 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set"
"gdk_dbfarm=/net/sofia.ins.cwi.nl/export/scratch1/fabian/tmp/mtest-jacqueline-sofia.ins.cwi.nl/five/dbfarm"
"--set" "mapi_open=true" "--set" "mapi_port=31617" "--set" "monet_prompt="
"--trace" "--forcemito" "--set" "mal_listing=2" "--dbname=mTests_extras_jaql"
"filter00.mal"
+# 21:51:22 >
+
+# MonetDB 5 server v11.8.0 "jacqueline-65159548356e+"
+# Serving database 'mTests_extras_jaql', using 8 threads
+# Compiled for x86_64-pc-linux-gnu/64bit with 64bit OIDs dynamically linked
+# Found 15.662 GiB available main-memory.
+# Copyright (c) 1993-July 2008 CWI.
+# Copyright (c) August 2008-2012 MonetDB B.V., all rights reserved
+# Visit http://www.monetdb.org/ for further information
+# Listening for connection requests on mapi:monetdb://sofia.ins.cwi.nl:31617/
+# MonetDB/GIS module loaded
+# MonetDB/SQL module loaded
+# MonetDB/DataCell module not loaded: MALException:jaql.context:JAQL
environment not found
+function user.main():void;
+ jaql.x("[ {\"id\":1, \"dept\":1, \"income\":12000},{\"id\":2, \"dept\":2,
\"income\":13000} ] -> filter $.dept == 1;");
+ jaql.x("[ {\"id\":1, \"dept\":1, \"income\":12000},{\"id\":2, \"dept\":2,
\"income\":13000} ] -> filter $.dept < 2;");
+ jaql.x("[ {\"id\":1, \"dept\":1, \"income\":12000},{\"id\":2, \"dept\":2,
\"income\":13000} ] -> filter $.dept == $.id;");
+ jaql.x("[ {\"id\":1, \"dept\":1, \"income\":12000},{\"id\":2, \"dept\":2,
\"income\":13000} ] -> filter $.dept != $.id;");
+ jaql.x("[ {\"id\":1, \"dept\":1, \"income\":12000},{\"id\":2, \"dept\":2,
\"income\":13000} ] -> filter $.dept > $.id;");
+end main;
+[ { "id": 1, "dept": 1, "income": 12000 } ]
+[ { "id": 1, "dept": 1, "income": 12000 } ]
+[ { "id": 1, "dept": 1, "income": 12000 }, { "id": 2, "dept": 2, "income":
13000 } ]
+[ ]
+[ ]
+
+# 21:51:22 >
+# 21:51:22 > "Done."
+# 21:51:22 >
+
diff --git a/monetdb5/extras/jaql/Tests/plan00.mal
b/monetdb5/extras/jaql/Tests/plan00.mal
new file mode 100644
--- /dev/null
+++ b/monetdb5/extras/jaql/Tests/plan00.mal
@@ -0,0 +1,12 @@
+jaql.x("plan A = B;");
+jaql.x("plan test -> filter $.mgr;");
+jaql.x("plan test -> filter each emp emp.mgr;");
+jaql.x("plan e -> filter $.mgr or $.income > 30000;");
+jaql.x("plan emps = [ {id:1, dept:1, income:12000},{id:2, dept:1,
income:13000} ];");
+jaql.x("plan [ {id:1, dept:1, income:12000},{id:2, dept:1, income:13000} ] ->
filter $.dept == 1;");
+#jaql.x("plan [ 1, 2, 3 ] -> transform {\"value\":$};");
+jaql.x("plan [ [3,65,8,72], [5,98,2,65] ] -> expand each arr;");
+jaql.x("plan [ {\"name\":\"Jon Doe\", \"movie_ids\":[3,65,8,72]},
{\"name\":\"Jane Dean\",\"movie_ids\":[5,98,2]} ] -> expand $.movie_ids;");
+#jaql.x("plan A -> expand -> transform $ * 2;");
+jaql.x("plan A -> expand $.ids;");
+
diff --git a/monetdb5/extras/jaql/Tests/plan00.stable.err
b/monetdb5/extras/jaql/Tests/plan00.stable.err
new file mode 100644
--- /dev/null
+++ b/monetdb5/extras/jaql/Tests/plan00.stable.err
@@ -0,0 +1,32 @@
+stderr of test 'plan00` in directory 'extras/jaql` itself:
+
+
+# 21:19:49 >
+# 21:19:49 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set"
"gdk_dbfarm=/net/sofia.ins.cwi.nl/export/scratch1/fabian/tmp/mtest-jacqueline-sofia.ins.cwi.nl/five/dbfarm"
"--set" "mapi_open=true" "--set" "mapi_port=33566" "--set" "monet_prompt="
"--trace" "--forcemito" "--set" "mal_listing=2" "--dbname=mTests_extras_jaql"
"plan00.mal"
+# 21:19:49 >
+
+# builtin opt gdk_dbname = demo
+# builtin opt gdk_dbfarm =
/ufs/fabian/scratch/ssd/monetdb/jacqueline/program-x86_64/var/lib/monetdb5/dbfarm
+# builtin opt gdk_debug = 0
+# builtin opt gdk_alloc_map = no
+# builtin opt gdk_vmtrim = yes
+# builtin opt monet_prompt = >
+# builtin opt monet_daemon = no
+# builtin opt mapi_port = 50000
+# builtin opt mapi_open = false
+# builtin opt mapi_autosense = false
+# builtin opt sql_optimizer = default_pipe
+# builtin opt sql_debug = 0
+# cmdline opt gdk_nr_threads = 0
+# cmdline opt gdk_dbfarm =
/net/sofia.ins.cwi.nl/export/scratch1/fabian/tmp/mtest-jacqueline-sofia.ins.cwi.nl/five/dbfarm
+# cmdline opt mapi_open = true
+# cmdline opt mapi_port = 33566
+# cmdline opt monet_prompt =
+# cmdline opt mal_listing = 2
+# cmdline opt gdk_dbname = mTests_extras_jaql
+
+
+# 21:19:49 >
+# 21:19:49 > "Done."
+# 21:19:49 >
+
diff --git a/monetdb5/extras/jaql/Tests/plan00.stable.out
b/monetdb5/extras/jaql/Tests/plan00.stable.out
new file mode 100644
--- /dev/null
+++ b/monetdb5/extras/jaql/Tests/plan00.stable.out
@@ -0,0 +1,45 @@
+stdout of test 'plan00` in directory 'extras/jaql` itself:
+
+
+# 21:19:49 >
+# 21:19:49 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set"
"gdk_dbfarm=/net/sofia.ins.cwi.nl/export/scratch1/fabian/tmp/mtest-jacqueline-sofia.ins.cwi.nl/five/dbfarm"
"--set" "mapi_open=true" "--set" "mapi_port=33566" "--set" "monet_prompt="
"--trace" "--forcemito" "--set" "mal_listing=2" "--dbname=mTests_extras_jaql"
"plan00.mal"
+# 21:19:49 >
+
+# MonetDB 5 server v11.8.0 "jacqueline-65159548356e+"
+# Serving database 'mTests_extras_jaql', using 8 threads
+# Compiled for x86_64-pc-linux-gnu/64bit with 64bit OIDs dynamically linked
+# Found 15.662 GiB available main-memory.
+# Copyright (c) 1993-July 2008 CWI.
+# Copyright (c) August 2008-2012 MonetDB B.V., all rights reserved
+# Visit http://www.monetdb.org/ for further information
+# Listening for connection requests on mapi:monetdb://sofia.ins.cwi.nl:33566/
+# MonetDB/GIS module loaded
+# MonetDB/SQL module loaded
+# MonetDB/DataCell module not loaded: MALException:jaql.context:JAQL
environment not found
+function user.main():void;
+ jaql.x("plan A = B;");
+ jaql.x("plan test -> filter $.mgr;");
+ jaql.x("plan test -> filter each emp emp.mgr;");
+ jaql.x("plan e -> filter $.mgr or $.income > 30000;");
+ jaql.x("plan emps = [ {id:1, dept:1, income:12000},{id:2, dept:1,
income:13000} ];");
+ jaql.x("plan [ {id:1, dept:1, income:12000},{id:2, dept:1, income:13000} ]
-> filter $.dept == 1;");
+#jaql.x("plan [ 1, 2, 3 ] -> transform {\"value\":$};");
+ jaql.x("plan [ [3,65,8,72], [5,98,2,65] ] -> expand each arr;");
+ jaql.x("plan [ {\"name\":\"Jon Doe\", \"movie_ids\":[3,65,8,72]},
{\"name\":\"Jane Dean\",\"movie_ids\":[5,98,2]} ] -> expand $.movie_ids;");
+#jaql.x("plan A -> expand -> transform $ * 2;");
+ jaql.x("plan A -> expand $.ids;");
+end main;
+B => A
+test as $ -> filter: $.mgr == true => <result>
+test as emp -> filter: emp.mgr == true => <result>
+e as $ -> filter: ( $.mgr == true || $.income > 30000 ) => <result>
+[ {id:1, dept:1, income:12000},{id:2, dept:1, income:13000} ] => emps
+[ {id:1, dept:1, income:12000},{id:2, dept:1, income:13000} ] as $ -> filter:
$.dept == 1 => <result>
+[ [3,65,8,72], [5,98,2,65] ] as arr -> expand: arr => <result>
+[ {"name":"Jon Doe", "movie_ids":[3,65,8,72]}, {"name":"Jane
Dean","movie_ids":[5,98,2]} ] as $ -> expand: $.movie_ids => <result>
+A as $ -> expand: $.ids => <result>
+
+# 21:19:49 >
+# 21:19:49 > "Done."
+# 21:19:49 >
+
diff --git a/monetdb5/extras/jaql/Tests/variable00.mal
b/monetdb5/extras/jaql/Tests/variable00.mal
new file mode 100644
--- /dev/null
+++ b/monetdb5/extras/jaql/Tests/variable00.mal
@@ -0,0 +1,4 @@
+jaql.x("A = [1,2,4,{\"a\": 5}];");
+jaql.x("A;");
+jaql.x("A -> filter $ <= 2;");
+jaql.x("A -> filter each v v.a >= 5;");
diff --git a/monetdb5/extras/jaql/Tests/variable00.stable.err
b/monetdb5/extras/jaql/Tests/variable00.stable.err
new file mode 100644
--- /dev/null
+++ b/monetdb5/extras/jaql/Tests/variable00.stable.err
@@ -0,0 +1,31 @@
+stderr of test 'variable00` in directory 'extras/jaql` itself:
+
+
+# 21:12:04 >
+# 21:12:04 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set"
"gdk_dbfarm=/net/sofia.ins.cwi.nl/export/scratch1/fabian/tmp/mtest-jacqueline-sofia.ins.cwi.nl/five/dbfarm"
"--set" "mapi_open=true" "--set" "mapi_port=30179" "--set" "monet_prompt="
"--trace" "--forcemito" "--set" "mal_listing=2" "--dbname=mTests_extras_jaql"
"variable00.mal"
+# 21:12:04 >
+
+# builtin opt gdk_dbname = demo
+# builtin opt gdk_dbfarm =
/ufs/fabian/scratch/ssd/monetdb/jacqueline/program-x86_64/var/lib/monetdb5/dbfarm
+# builtin opt gdk_debug = 0
_______________________________________________
Checkin-list mailing list
[email protected]
http://mail.monetdb.org/mailman/listinfo/checkin-list
