@Test public void insertIgnore() { SQLInsertClause clause = queryFactory.insertIgnore(QSurvey.survey); assertEquals("insert ignore into SURVEY\nvalues ()", clause.toString()); }
@Test public void insertOnDuplicateKeyUpdate() { SQLInsertClause clause = queryFactory.insertOnDuplicateKeyUpdate(QSurvey.survey, "c = c+1"); assertEquals("insert into SURVEY\nvalues () on duplicate key update c = c+1", 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 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_values() { SQLInsertClause clause = queryFactory.insertOnDuplicateKeyUpdate(QSurvey.survey, SQLExpressions.set(QSurvey.survey.name, QSurvey.survey.name)); assertEquals("insert into SURVEY\n" + "values () on duplicate key update SURVEY.NAME = values(SURVEY.NAME)", 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 insert() { SQLInsertClause insertClause = new SQLInsertClause(connection,SQLTemplates.DEFAULT,survey); insertClause.set(survey.id, 1); insertClause.set(survey.name, (String) null); assertEquals("insert into SURVEY (ID, NAME)\nvalues (?, ?)", insertClause.toString()); }
@Test @IncludeIn(MYSQL) @SkipForQuoted public void replace() { SQLInsertClause clause = mysqlReplace(survey); clause.columns(survey.id, survey.name) .values(3, "Hello"); assertEquals("replace into SURVEY (ID, NAME) values (?, ?)", clause.toString()); clause.execute(); }
@Test @IncludeIn(MYSQL) @SkipForQuoted public void insert_with_special_options() { SQLInsertClause clause = insert(survey) .columns(survey.id, survey.name) .values(3, "Hello"); clause.addFlag(Position.START_OVERRIDE, "insert ignore into "); assertEquals("insert ignore into SURVEY (ID, NAME) values (?, ?)", clause.toString()); assertEquals(1, clause.execute()); }