@Test
public void test2() {
DruidSequenceHandler handler = new DruidSequenceHandler(SystemConfig.SEQUENCEHANDLER_LOCALFILE);
String sql =
"/* APPLICATIONNAME=DBEAVER 3.3.2 - MAIN CONNECTION */ SELECT NEXT VALUE FOR MYCATSEQ_XXXX"
.toUpperCase();
String tableName = handler.getTableName(sql);
assertEquals(tableName, "XXXX");
}
@Test
public void test() {
DruidSequenceHandler handler = new DruidSequenceHandler(SystemConfig.SEQUENCEHANDLER_LOCALFILE);
String sql = "select next value for mycatseq_xxxx".toUpperCase();
String tableName = handler.getTableName(sql);
assertEquals(tableName, "XXXX");
sql = " insert into test(id,sid)values(next value for MYCATSEQ_TEST,1)".toUpperCase();
tableName = handler.getTableName(sql);
assertEquals(tableName, "TEST");
sql = " insert into test(id,sid)values(next value for MYCATSEQ_TEST ,1)".toUpperCase();
tableName = handler.getTableName(sql);
assertEquals(tableName, "TEST");
sql = " insert into test(id)values(next value for MYCATSEQ_TEST )".toUpperCase();
tableName = handler.getTableName(sql);
assertEquals(tableName, "TEST");
}