protected void insertProperty(Revision revision, PropertyPath path, Object value, VersionStatus status) { if (!options.versionTableProperties.containsKey(path)) { propertyBatch .set(options.property.revision, revision) .set(options.property.path, path.toString()) .set(options.property.status, status); setValue(path, value); propertyBatch.addBatch(); } }
protected void insertEntity(Id docId, VersionNode<PropertyPath, Object, M> version) { entityCreateBatch .set(options.entity.id, docId) .addBatch(); }
@Override protected void insertVersion(Id docId, VersionNode<PropertyPath, Object, M> version) { versionBatch.set(options.version.localOrdinal, nextLocalOrdinal(docId)); super.insertVersion(docId, version); }
private long insertProvider() { return querydslSupport.execute((connection, configuration) -> { QOAuth2Provider qoAuth2Provider = QOAuth2Provider.oAuth2Provider; return new SQLInsertClause(connection, configuration, qoAuth2Provider) .set(qoAuth2Provider.providerName, providerName) .executeWithKey(qoAuth2Provider.oauth2ProviderId); }); }
@Before public void setUp() throws SQLException { delete(survey).execute(); SQLInsertClause insert = insert(survey); insert.set(survey.id, 5).set(survey.name, "aaa").addBatch(); insert.set(survey.id, 6).set(survey.name, "a_").addBatch(); insert.set(survey.id, 7).set(survey.name, "a%").addBatch(); insert.execute(); }
@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(); }
@Test public void insert_batch_Templates() { SQLInsertClause insert = insert(survey) .set(survey.id, 5) .set(survey.name, Expressions.stringTemplate("'55'")) .addBatch(); insert.set(survey.id, 6) .set(survey.name, Expressions.stringTemplate("'66'")) .addBatch(); assertEquals(2, insert.execute()); assertEquals(1L, query().from(survey).where(survey.name.eq("55")).fetchCount()); assertEquals(1L, query().from(survey).where(survey.name.eq("66")).fetchCount()); }
@Test @ExcludeIn({CUBRID, SQLSERVER}) public void insert_with_keys_Projected() throws SQLException { assertNotNull(insert(survey).set(survey.name, "Hello you").executeWithKey(survey.id)); }
@Test @ExcludeIn(FIREBIRD) // too slow public void insert_with_subQuery_Via_Constructor() { int count = (int) query().from(survey).fetchCount(); SQLInsertClause insert = insert(survey, query().from(survey2)); insert.set(survey.id, survey2.id.add(20)); insert.set(survey.name, survey2.name); assertEquals(count, insert.execute()); }
@Test @ExcludeIn({CUBRID, SQLSERVER}) public void insert_with_keys_Projected2() throws SQLException { Path<Object> idPath = ExpressionUtils.path(Object.class, "id"); Object id = insert(survey).set(survey.name, "Hello you").executeWithKey(idPath); assertNotNull(id); }
@Test @ExcludeIn({DERBY, FIREBIRD, POSTGRESQL}) public void number_as_boolean() { QNumberTest numberTest = QNumberTest.numberTest; delete(numberTest).execute(); insert(numberTest).set(numberTest.col1Boolean, true).execute(); insert(numberTest).set(numberTest.col1Number, (byte) 1).execute(); assertEquals(2, query().from(numberTest).select(numberTest.col1Boolean).fetch().size()); assertEquals(2, query().from(numberTest).select(numberTest.col1Number).fetch().size()); }
@Test @IncludeIn(H2) public void merge_with_keys_and_subQuery() { assertEquals(1, insert(survey).set(survey.id, 6).set(survey.name, "H").execute()); // keys + subquery QSurvey survey2 = new QSurvey("survey2"); assertEquals(2, merge(survey).keys(survey.id).select( query().from(survey2).select(survey2.id.add(1), survey2.name, survey2.name2)).execute()); }
@Test @IncludeIn({H2, POSTGRESQL}) @SkipForQuoted public void uuids() { delete(QUuids.uuids).execute(); QUuids uuids = QUuids.uuids; UUID uuid = UUID.randomUUID(); insert(uuids).set(uuids.field, uuid).execute(); assertEquals(uuid, query().from(uuids).select(uuids.field).fetchFirst()); }
@Test public void clear() { QEmployee emp1 = new QEmployee("emp1"); SQLInsertClause insert = new SQLInsertClause(null, SQLTemplates.DEFAULT, emp1); insert.set(emp1.id, 1); insert.addBatch(); assertEquals(1, insert.getBatchCount()); insert.clear(); assertEquals(0, insert.getBatchCount()); }
@Test @ExcludeIn({ORACLE}) public void xml() { delete(QXmlTest.xmlTest).execute(); QXmlTest xmlTest = QXmlTest.xmlTest; String contents = "<html><head>a</head><body>b</body></html>"; insert(xmlTest).set(xmlTest.col, contents).execute(); assertEquals(contents, query().from(xmlTest).select(xmlTest.col).fetchFirst()); }