sqlshell-svn

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

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

Author: roy
Date: 2009-02-28 14:42:08 +0100 (Sat, 28 Feb 2009)
New Revision: 386

Modified:
   src/test/java/nl/improved/sqlclient/util/SQLParserTest.java
Log:
added test cases


Modified: src/test/java/nl/improved/sqlclient/util/SQLParserTest.java
===================================================================
--- src/test/java/nl/improved/sqlclient/util/SQLParserTest.java	2009-02-28 13:36:27 UTC (rev 385)
+++ src/test/java/nl/improved/sqlclient/util/SQLParserTest.java	2009-02-28 13:42:08 UTC (rev 386)
@@ -628,6 +628,24 @@
         matches = info.getPossibleMatches();
         assertTrue("=", matches.contains("="));
         assertEquals("", info.getStart());
+
+        sqlCommand = Arrays.asList(new String[]{"UPDATE A SET B "});
+        cursorPos = new Point(sqlCommand.get(0).length(),0);
+        info = SQLParser.getTabCompletionInfo(sqlCommand, cursorPos);
+        assertNotNull(info);
+        assertEquals(TabCompletionInfo.MatchType.SQL_KEYWORD, info.getMatchType());
+        matches = info.getPossibleMatches();
+        assertTrue("=", matches.contains("="));
+        assertEquals("", info.getStart());
+
+        sqlCommand = Arrays.asList(new String[]{"UPDATE A SET B = "});
+        cursorPos = new Point(sqlCommand.get(0).length(),0);
+        info = SQLParser.getTabCompletionInfo(sqlCommand, cursorPos);
+        assertNotNull(info);
+        assertEquals(TabCompletionInfo.MatchType.COLUMN_NAMES, info.getMatchType());
+        matches = info.getPossibleMatches();
+        assertTrue("A", matches.contains("A"));
+        assertEquals("", info.getStart());
     }
 
     public void testGetTableName() {

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

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

Author: roy
Date: 2009-03-31 21:41:04 +0200 (Tue, 31 Mar 2009)
New Revision: 401

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


Modified: src/test/java/nl/improved/sqlclient/util/SQLParserTest.java
===================================================================
--- src/test/java/nl/improved/sqlclient/util/SQLParserTest.java	2009-03-31 19:40:54 UTC (rev 400)
+++ src/test/java/nl/improved/sqlclient/util/SQLParserTest.java	2009-03-31 19:41:04 UTC (rev 401)
@@ -217,6 +217,16 @@
         matches = info.getPossibleMatches();
         assertEquals(0, matches.size());
         assertEquals("B", info.getStart());
+
+        sqlCommand = Arrays.asList(new String[]{"SELECT test FROM A"});
+        cursorPos = new Point("SELECT ".length(),0);
+        info = SQLParser.getTabCompletionInfo(sqlCommand, cursorPos);
+        assertNotNull(info);
+        assertEquals(TabCompletionInfo.MatchType.COLUMN_NAMES, info.getMatchType());
+        matches = info.getPossibleMatches();
+        assertEquals(1, matches.size());
+        assertTrue(matches.contains("A"));
+        assertEquals("", info.getStart());
     }
 
     public void testTabCompletionInfoFROM() {

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