use of com.querydsl.core.testutil.ExcludeIn in project querydsl by querydsl.
the class InsertBase method insert_nulls_in_batch2.
@Test
@Ignore
@ExcludeIn({ DERBY })
public void insert_nulls_in_batch2() {
Mapper<Object> mapper = DefaultMapper.WITH_NULL_BINDINGS;
// QFoo f= QFoo.foo;
// SQLInsertClause sic = new SQLInsertClause(c, new H2Templates(), f);
// Foo f1=new Foo();
// sic.populate(f1).addBatch();
// f1=new Foo();
// f1.setC1(1);
// sic.populate(f1).addBatch();
// sic.execute();
QEmployee employee = QEmployee.employee;
SQLInsertClause sic = insert(employee);
Employee e = new Employee();
sic.populate(e, mapper).addBatch();
e = new Employee();
e.setFirstname("X");
sic.populate(e, mapper).addBatch();
assertEquals(0, sic.execute());
}
use of com.querydsl.core.testutil.ExcludeIn in project querydsl by querydsl.
the class InsertBase method insert_with_keys.
@Test
@ExcludeIn({ CUBRID, SQLSERVER })
public void insert_with_keys() throws SQLException {
ResultSet rs = insert(survey).set(survey.name, "Hello World").executeWithKeys();
assertTrue(rs.next());
assertTrue(rs.getObject(1) != null);
rs.close();
}
use of com.querydsl.core.testutil.ExcludeIn in project querydsl by querydsl.
the class InsertBase method insert_nulls_in_batch.
@Test
@ExcludeIn(ORACLE)
public void insert_nulls_in_batch() {
// QFoo f= QFoo.foo;
// SQLInsertClause sic = new SQLInsertClause(c, new H2Templates(), f);
// sic.columns(f.c1,f.c2).values(null,null).addBatch();
// sic.columns(f.c1,f.c2).values(null,1).addBatch();
// sic.execute();
SQLInsertClause sic = insert(survey);
sic.columns(survey.name, survey.name2).values(null, null).addBatch();
sic.columns(survey.name, survey.name2).values(null, "X").addBatch();
assertEquals(2, sic.execute());
}
use of com.querydsl.core.testutil.ExcludeIn in project querydsl by querydsl.
the class InsertBase method insertBatch_with_subquery.
@Test
// too slow
@ExcludeIn(FIREBIRD)
public void insertBatch_with_subquery() {
SQLInsertClause insert = insert(survey).columns(survey.id, survey.name).select(query().from(survey2).select(survey2.id.add(20), survey2.name)).addBatch();
insert(survey).columns(survey.id, survey.name).select(query().from(survey2).select(survey2.id.add(40), survey2.name)).addBatch();
assertEquals(1, insert.execute());
}
use of com.querydsl.core.testutil.ExcludeIn in project querydsl by querydsl.
the class UpdateBase method setNullEmptyRootPath.
@Test
@SkipForQuoted
@ExcludeIn({ DERBY })
public void setNullEmptyRootPath() {
StringPath name = Expressions.stringPath("name");
long count = query().from(survey).fetchCount();
assertEquals(count, execute(update(survey).setNull(name)));
}
Aggregations