From: SVN by r. <sv...@ca...> - 2009-02-28 13:42:11
|
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() { |
From: SVN by r. <sv...@ca...> - 2009-03-31 19:41:10
|
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() { |
From: SVN by r. <sv...@ca...> - 2010-07-25 10:02:02
|
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(); |