How to use

values

method

in

com.querydsl.sql.dml.SQLInsertClause

private void reset() throws SQLException {
  delete(survey).execute();
  insert(survey).values(1, "Hello World", "Hello").execute();
}

@Test
@IncludeIn({CUBRID, H2, MYSQL, ORACLE, SQLSERVER})
public void delete_limit() {
  insert(survey).values(2, "A","B").execute();
  insert(survey).values(3, "B","C").execute();
  insert(survey).values(4, "D","E").execute();
  assertEquals(2, delete(survey).limit(2).execute());
}

@After
public void tearDown() throws SQLException {
  delete(survey).execute();
  insert(survey).values(1, "Hello World", "Hello").execute();
}

@Test
public void insert_null_with_columns() {
  assertEquals(1, insert(survey)
      .columns(survey.id, survey.name)
      .values(3, null).execute());
}

@Test
public void insert_with_columns() {
  assertEquals(1, insert(survey)
      .columns(survey.id, survey.name)
      .values(3, "Hello").execute());
}

@Test
@ExcludeIn(FIREBIRD) // too slow
public void insert_without_columns() {
  assertEquals(1, insert(survey).values(4, "Hello", "World").execute());
}

@Test
@ExcludeIn({DB2, DERBY})
public void insert_null_without_columns() {
  assertEquals(1, insert(survey)
      .values(4, null, null).execute());
}

private void reset() throws SQLException {
  delete(survey).execute();
  insert(survey).values(1, "Hello World", "Hello").execute();
  delete(QDateTest.qDateTest).execute();
}

private void reset() throws SQLException {
  delete(survey).where(survey.name.isNotNull()).execute();
  insert(survey).values(1, "Hello World", "Hello").execute();
}

@Test
@IncludeIn({CUBRID, H2, MYSQL, ORACLE, SQLSERVER})
public void update_limit() {
  assertEquals(1, insert(survey).values(2, "A","B").execute());
  assertEquals(1, insert(survey).values(3, "B","C").execute());
  assertEquals(2, update(survey).set(survey.name, "S").limit(2).execute());
}

@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
public void batch() throws SQLException {
  insert(survey).values(2, "A","B").execute();
  insert(survey).values(3, "B","C").execute();
  SQLDeleteClause delete = delete(survey);
  delete.where(survey.name.eq("A")).addBatch();
  assertEquals(1, delete.getBatchCount());
  delete.where(survey.name.eq("B")).addBatch();
  assertEquals(2, delete.getBatchCount());
  assertEquals(2, delete.execute());
}

@Test
@ExcludeIn({CUBRID, SQLITE})
public void batch_templates() throws SQLException {
  insert(survey).values(2, "A","B").execute();
  insert(survey).values(3, "B","C").execute();
  SQLDeleteClause delete = delete(survey);
  delete.where(survey.name.eq(Expressions.stringTemplate("'A'"))).addBatch();
  delete.where(survey.name.eq(Expressions.stringTemplate("'B'"))).addBatch();
  assertEquals(2, delete.execute());
}

@Test
public void like() {
  insert(survey).values(11, "Hello World", "a\\b").execute();
  assertEquals(1L, query().from(survey).where(survey.name2.contains("a\\b")).fetchCount());
}

@Before
public void setUp() throws Exception {
  new CreateTableClause(connection, configuration, "quoting")
      .column("from", String.class).size(30)
      .column("all", Boolean.class)
      .execute();
  execute(insert(quoting)
      .columns(quoting.from, quoting.all)
      .values("from", true));
}

@Test
public void batch_templates() throws SQLException {
  assertEquals(1, insert(survey).values(2, "A","B").execute());
  assertEquals(1, insert(survey).values(3, "B","C").execute());
  SQLUpdateClause update = update(survey);
  update.set(survey.name, "AA").where(survey.name.eq(Expressions.stringTemplate("'A'"))).addBatch();
  update.set(survey.name, "BB").where(survey.name.eq(Expressions.stringTemplate("'B'"))).addBatch();
  assertEquals(2, update.execute());
}

@Test
public void update4() {
  assertEquals(1, insert(survey).values(2, "A","B").execute());
  assertEquals(1, update(survey).set(survey.name, "AA").where(survey.name.eq("A")).execute());
}

@Test
public void update5() {
  assertEquals(1, insert(survey).values(3, "B","C").execute());
  assertEquals(1, update(survey).set(survey.name, "BB").where(survey.name.eq("B")).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());
}

@Test
public void batch() throws SQLException {
  assertEquals(1, insert(survey).values(2, "A","B").execute());
  assertEquals(1, insert(survey).values(3, "B","C").execute());
  SQLUpdateClause update = update(survey);
  update.set(survey.name, "AA").where(survey.name.eq("A")).addBatch();
  assertEquals(1, update.getBatchCount());
  update.set(survey.name, "BB").where(survey.name.eq("B")).addBatch();
  assertEquals(2, update.getBatchCount());
  assertEquals(2, update.execute());
}