[Sqlshell-svn] /devel/src/test/java/nl/improved/sqlclient/util

[SVN by r. <sv...@ca...>]

Author: roy
Date: 2010-07-25 12:01:52 +0200 (Sun, 25 Jul 2010)
New Revision: 478

Modified:
   src/test/java/nl/improved/sqlclient/util/SQLParserTest.java
Log:
more tests


Modified: src/test/java/nl/improved/sqlclient/util/SQLParserTest.java
===================================================================
--- src/test/java/nl/improved/sqlclient/util/SQLParserTest.java	2010-07-19 13:17:56 UTC (rev 477)
+++ src/test/java/nl/improved/sqlclient/util/SQLParserTest.java	2010-07-25 10:01:52 UTC (rev 478)
@@ -23,6 +23,23 @@
     }
 
 
+    public void testGetTableNames() {
+        List<SQLPart> result = SQLParser.parse("FROM a,b,c");
+        SQLPart part =result.get(0);//new SQLPart(SQLPart.SQLType.FROM, "FROM a,b,c");
+        List<String> tableNames = part.getTableNames();
+        assertEquals(tableNames.toString(), 3, tableNames.size());
+        assertTrue(tableNames.contains("a"));
+        assertTrue(tableNames.contains("b"));
+        assertTrue(tableNames.contains("c"));
+
+        result = SQLParser.parse("FROM a,b,c;");
+        part =result.get(0); //new SQLPart(SQLPart.SQLType.FROM, "FROM a,b,c;");
+        tableNames = part.getTableNames();
+        assertEquals(tableNames.toString(), 3, tableNames.size());
+        assertTrue(tableNames.contains("a"));
+        assertTrue(tableNames.contains("b"));
+        assertTrue(tableNames.contains("c"));
+    }
     public void testGetColumnNames() {
         SQLPart part =new SQLPart(SQLPart.SQLType.SELECT, "SELECT a,b,c");
         List<String> columnNames = part.getColumnNames();