@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());
}
@Test
public void insertIgnore() {
SQLInsertClause clause = queryFactory.insertIgnore(QSurvey.survey);
assertEquals("insert ignore into SURVEY\nvalues ()", clause.toString());
}
@Test
public void insert() {
assertNotNull(queryFactory.insert(QSurvey.survey));
}
@Test
public void delete() {
assertNotNull(queryFactory.delete(QSurvey.survey));
}
@Test
public void from() {
assertNotNull(queryFactory.from(QSurvey.survey));
}
@Test
public void query() {
assertNotNull(queryFactory.query());
}
@Test
public void merge() {
assertNotNull(queryFactory.merge(QSurvey.survey));
}
@Test
public void update() {
assertNotNull(queryFactory.update(QSurvey.survey));
}
@Test
public void replace() {
assertNotNull(queryFactory.replace(QSurvey.survey));
}
