document hopes and dreams

[dbsrgits/SQL-Abstract.git] / t / 11unparse.t

diff --git a/t/11unparse.t b/t/11unparse.t
new file mode 100644 (file)
index 0000000..0d080f6
--- /dev/null
+++ b/t/11unparse.t
@@ -0,0 +1,26 @@
+use strict;
+use warnings;
+
+use SQL::Abstract::Tree;
+
+{
+   my $sql = "SELECT a, b, c
+   FROM foo WHERE foo.a =1 and foo.b LIKE 'station'";
+
+   print "$sql\n";
+   print SQL::Abstract::Tree::unparse(SQL::Abstract::Tree::parse($sql)) . "\n";
+}
+
+{
+   my $sql = "SELECT *
+   FROM (SELECT * FROM foobar) WHERE foo.a =1 and foo.b LIKE 'station'";
+
+   print "$sql\n";
+   print SQL::Abstract::Tree::unparse(SQL::Abstract::Tree::parse($sql)) . "\n";
+}
+
+# stuff we want:
+#    Nested indentation
+#    Max Width
+#    Color coding (console)
+#    Color coding (html)