@Test
public void testParseSQL_LineHasEnterChar() {
String line =
"insert into tdd_user(id,first_name,last_name,my_date,sarary)\n"
+ "values(3,'name\n3','last3','2011-03-20',2336);";
String statement =
"insert into tdd_user(id,first_name,last_name,my_date,sarary) values(3,'name\n3','last3','2011-03-20',2336)";
String[] statments = DBHelper.parseSQL(line);
want.array(statments).sizeEq(1);
want.string(statments[0]).isEqualTo(statement);
}
@Test
public void testParseSQL_SINGLE_LINE_NOTE_REGEX() {
String line =
"insert into tdd_user(id,first_name,last_name,my_date,sarary)--本行注释\n"
+ "values(3,'name3','last3','2011-03-20',2336);";
String[] statments = DBHelper.parseSQL(line);
want.array(statments)
.sizeEq(1)
.hasItems(
"insert into tdd_user(id,first_name,last_name,my_date,sarary) values(3,'name3','last3','2011-03-20',2336)");
}
@Test
public void testParseSQL_MULTI_LINE_NOTE_REGEX() {
String line =
"insert into tdd_user(id,first_name,last_name,my_date,sarary)\n"
+ "values(2,'name2','last2',/**插入注释**/'2011-03-19',2335);";
String[] statments = DBHelper.parseSQL(line);
want.array(statments)
.sizeEq(1)
.hasItems(
"insert into tdd_user(id,first_name,last_name,my_date,sarary) values(2,'name2','last2','2011-03-19',2335)");
}
@Test
public void testParseSQL() throws FileNotFoundException {
String lines = ResourceHelper.readFromFile("org/test4j/module/database/util/testParseSQL.sql");
String[] statments = DBHelper.parseSQL(lines);
want.array(statments).sizeEq(6);
}