document hopes and dreams

diff --git a/lib/SQL/Abstract/Tree.pm b/lib/SQL/Abstract/Tree.pm
index 73a034d..e1292f7 100644 (file)
--- a/lib/SQL/Abstract/Tree.pm
+++ b/lib/SQL/Abstract/Tree.pm
@@ -182,7 +182,7 @@ sub unparse {
     return join (" $tree->[0] ", map {unparse($_)} @{$tree->[1]});
   }
   else {
-    return sprintf '%s %s', $tree->[0], unparse ($tree->[1]);
+    return sprintf "%s %s\n", $tree->[0], unparse ($tree->[1]);
   }
 }
 

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)