@Test
public void insertOnDuplicateKeyUpdate2() {
SQLInsertClause clause =
queryFactory.insertOnDuplicateKeyUpdate(QSurvey.survey, QSurvey.survey.id.eq(2));
assertEquals(
"insert into SURVEY\nvalues () on duplicate key update SURVEY.ID = ?", clause.toString());
}
@Test
public void insertOnDuplicateKeyUpdate_null() {
SQLInsertClause clause =
queryFactory.insertOnDuplicateKeyUpdate(
QSurvey.survey, SQLExpressions.set(QSurvey.survey.name, (String) null));
assertEquals(
"insert into SURVEY\n" + "values () on duplicate key update SURVEY.NAME = null",
clause.toString());
}
@Test
public void insertOnDuplicateKeyUpdate_multiple() {
SQLInsertClause clause =
queryFactory.insertOnDuplicateKeyUpdate(
QSurvey.survey,
SQLExpressions.set(QSurvey.survey.id, 2),
SQLExpressions.set(QSurvey.survey.name, "B"));
assertEquals(
"insert into SURVEY\n" + "values () on duplicate key update SURVEY.ID = ?, SURVEY.NAME = ?",
clause.toString());
}
