@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());
 }
Esempio n. 4
0
 private void savePredictionHistory(
     Long predictorId, DateTime start, List<Prediction> predictions) {
   if (!predictions.isEmpty()) {
     final SQLInsertClause insert = queryFactory.insert(qPredictionHistory);
     predictions.forEach(
         p ->
             insert
                 .set(qPredictionHistory.predictorId, predictorId)
                 .set(
                     qPredictionHistory.forecastDistanceInMinutes,
                     ((int) new Duration(start, p.timestamp).getStandardMinutes()))
                 .set(qPredictionHistory.ts, p.timestamp)
                 .set(qPredictionHistory.spacesAvailable, p.spacesAvailable)
                 .addBatch());
     insert.execute();
   }
 }
 @Test
 public void insertIgnore() {
   SQLInsertClause clause = queryFactory.insertIgnore(QSurvey.survey);
   assertEquals("insert ignore into SURVEY\nvalues ()", clause.toString());
 }