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