private void reset() throws SQLException { delete(survey).execute(); insert(survey).values(1, "Hello World", "Hello").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(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()); }