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();
|