From 2b3fdea994b41e1eb0bb0554ee4c76043f5d5753 Mon Sep 17 00:00:00 2001
From: =?utf8?q?Mauricio=20Fern=C3=A1ndez?= <mfp@acm.org>
Date: Tue, 9 Nov 2021 23:09:10 +0100
Subject: [PATCH] add tests for IN @foo codegen

---
 test/inargument.sql     | 33 ++++++++++++++++++++++
 test/out/inargument.xml | 75 +++++++++++++++++++++++++++++++++++++++++++++++++
 2 files changed, 108 insertions(+)
 create mode 100644 test/inargument.sql
 create mode 100644 test/out/inargument.xml

diff --git a/test/inargument.sql b/test/inargument.sql
new file mode 100644
index 0000000..d9ac292
--- /dev/null
+++ b/test/inargument.sql
@@ -0,0 +1,33 @@
+-- @create_table_foo
+CREATE TABLE foo(
+    id INTEGER PRIMARY KEY,
+    foo TEXT NULL
+);
+
+-- @create_table_bar
+CREATE TABLE bar(
+    foo_id INTEGER NOT NULL,
+    baz TEXT NOT NULL
+);
+
+-- @find
+SELECT * FROM foo
+WHERE id IN @ids;
+
+-- @get
+SELECT * FROM foo
+WHERE id IN @ids
+LIMIT 1;
+
+-- @find2
+SELECT * FROM foo
+WHERE id IN @ids AND foo NOT IN @foos;
+
+-- @get2
+SELECT * FROM foo
+WHERE id IN @ids AND foo NOT IN @foos;
+
+-- @join
+SELECT *
+FROM foo f JOIN bar b ON f.id = b.foo_id
+WHERE b.baz IN @bazz AND b.baz NOT IN @notbazz AND LENGTH(f.foo) IN @lengths;
diff --git a/test/out/inargument.xml b/test/out/inargument.xml
new file mode 100644
index 0000000..ccad405
--- /dev/null
+++ b/test/out/inargument.xml
@@ -0,0 +1,75 @@
+<?xml version="1.0"?>
+
+<sqlgg>
+ <stmt name="create_table_foo" sql="CREATE TABLE foo(&#x0A;    id INTEGER PRIMARY KEY,&#x0A;    foo TEXT NULL&#x0A;)" category="DDL" kind="create" target="foo" cardinality="0">
+  <in/>
+  <out/>
+ </stmt>
+ <stmt name="create_table_bar" sql="CREATE TABLE bar(&#x0A;    foo_id INTEGER NOT NULL,&#x0A;    baz TEXT NOT NULL&#x0A;)" category="DDL" kind="create" target="bar" cardinality="0">
+  <in/>
+  <out/>
+ </stmt>
+ <stmt name="find" sql="SELECT * FROM foo&#x0A;WHERE id IN @@_sqlgg_ids" category="DQL" kind="select" cardinality="n">
+  <in>
+   <value name="ids" type="(Tuple Int)"/>
+  </in>
+  <out>
+   <value name="id" type="Int"/>
+   <value name="foo" type="Text" nullable="true"/>
+  </out>
+ </stmt>
+ <stmt name="get" sql="SELECT * FROM foo&#x0A;WHERE id IN @@_sqlgg_ids&#x0A;LIMIT 1" category="DQL" kind="select" cardinality="0,1">
+  <in>
+   <value name="ids" type="(Tuple Int)"/>
+  </in>
+  <out>
+   <value name="id" type="Int"/>
+   <value name="foo" type="Text" nullable="true"/>
+  </out>
+ </stmt>
+ <stmt name="find2" sql="SELECT * FROM foo&#x0A;WHERE id IN @@_sqlgg_ids AND foo NOT IN @@_sqlgg_foos" category="DQL" kind="select" cardinality="n">
+  <in>
+   <value name="ids" type="(Tuple Int)"/>
+   <value name="foos" type="(Tuple Text)"/>
+  </in>
+  <out>
+   <value name="id" type="Int"/>
+   <value name="foo" type="Text" nullable="true"/>
+  </out>
+ </stmt>
+ <stmt name="get2" sql="SELECT * FROM foo&#x0A;WHERE id IN @@_sqlgg_ids AND foo NOT IN @@_sqlgg_foos" category="DQL" kind="select" cardinality="n">
+  <in>
+   <value name="ids" type="(Tuple Int)"/>
+   <value name="foos" type="(Tuple Text)"/>
+  </in>
+  <out>
+   <value name="id" type="Int"/>
+   <value name="foo" type="Text" nullable="true"/>
+  </out>
+ </stmt>
+ <stmt name="join" sql="SELECT *&#x0A;FROM foo f JOIN bar b ON f.id = b.foo_id&#x0A;WHERE b.baz IN @@_sqlgg_bazz AND b.baz NOT IN @@_sqlgg_notbazz AND LENGTH(f.foo) IN @@_sqlgg_lengths" category="DQL" kind="select" cardinality="n">
+  <in>
+   <value name="bazz" type="(Tuple Text)"/>
+   <value name="notbazz" type="(Tuple Text)"/>
+   <value name="lengths" type="(Tuple Int)"/>
+  </in>
+  <out>
+   <value name="id" type="Int"/>
+   <value name="foo" type="Text" nullable="true"/>
+   <value name="foo_id" type="Int"/>
+   <value name="baz" type="Text"/>
+  </out>
+ </stmt>
+ <table name="bar">
+  <schema>
+   <value name="foo_id" type="Int"/>
+   <value name="baz" type="Text"/>
+  </schema>
+ </table>
+ <table name="foo">
+  <schema>
+   <value name="id" type="Int"/>
+   <value name="foo" type="Text" nullable="true"/>
+  </schema>
+ </table>
+</sqlgg>
-- 
2.11.4.GIT