Examples of DeleteBatchQuery

Examples of org.apache.cayenne.query.DeleteBatchQuery

69
70
71
72
73
74
75
76
77
78
79
    public void testCreateSqlString() throws Exception {
        DbEntity entity = context.getEntityResolver().getObjEntity(SoftTest.class).getDbEntity();

        List<DbAttribute> idAttributes = Collections.singletonList((DbAttribute) entity.getAttribute("SOFT_TEST_ID"));

        DeleteBatchQuery deleteQuery = new DeleteBatchQuery(entity, idAttributes, null, 1);
        DeleteBatchQueryBuilder builder = createBuilder();
        String generatedSql = builder.createSqlString(deleteQuery);
        assertNotNull(generatedSql);
        assertEquals("UPDATE " + entity.getName() + " SET DELETED = ? WHERE SOFT_TEST_ID = ?", generatedSql);
    }
View Full Code Here

Examples of org.apache.cayenne.query.DeleteBatchQuery

84
85
86
87
88
89
90
91
92
93
94
        List<DbAttribute> idAttributes = Arrays.asList((DbAttribute) entity.getAttribute("SOFT_TEST_ID"),
                (DbAttribute) entity.getAttribute("NAME"));

        Collection<String> nullAttributes = Collections.singleton("NAME");

        DeleteBatchQuery deleteQuery = new DeleteBatchQuery(entity, idAttributes, nullAttributes, 1);
        DeleteBatchQueryBuilder builder = createBuilder();
        String generatedSql = builder.createSqlString(deleteQuery);
        assertNotNull(generatedSql);
        assertEquals("UPDATE " + entity.getName() + " SET DELETED = ? WHERE SOFT_TEST_ID = ? AND NAME IS NULL",
                generatedSql);
View Full Code Here

Examples of org.apache.cayenne.query.DeleteBatchQuery

101
102
103
104
105
106
107
108
109
110
111
            entity.getDataMap().setQuotingSQLIdentifiers(true);

            List<DbAttribute> idAttributes = Collections.singletonList((DbAttribute) entity
                    .getAttribute("SOFT_TEST_ID"));

            DeleteBatchQuery deleteQuery = new DeleteBatchQuery(entity, idAttributes, null, 1);
            JdbcAdapter adapter = (JdbcAdapter) this.adapter;
            DeleteBatchQueryBuilder builder = createBuilder(adapter);
            String generatedSql = builder.createSqlString(deleteQuery);

            String charStart = unitAdapter.getIdentifiersStartQuote();
View Full Code Here

Examples of org.apache.cayenne.query.DeleteBatchQuery

65
66
67
68
69
70
71
72
73
74
75
                .getDbEntity();

        List<DbAttribute> idAttributes = Collections
                .singletonList((DbAttribute) entity.getAttribute("LOCKING_TEST_ID"));

        DeleteBatchQuery deleteQuery = new DeleteBatchQuery(entity, idAttributes, null, 1);

        DbAdapter adapter = objectFactory.newInstance(DbAdapter.class, JdbcAdapter.class.getName());
        DeleteBatchQueryBuilder builder = new DeleteBatchQueryBuilder(adapter);
        String generatedSql = builder.createSqlString(deleteQuery);
        assertNotNull(generatedSql);
View Full Code Here

Examples of org.apache.cayenne.query.DeleteBatchQuery

83
84
85
86
87
88
89
90
91
92
93
        List<DbAttribute> idAttributes = Arrays.asList((DbAttribute) entity.getAttribute("LOCKING_TEST_ID"),
                (DbAttribute) entity.getAttribute("NAME"));

        Collection<String> nullAttributes = Collections.singleton("NAME");

        DeleteBatchQuery deleteQuery = new DeleteBatchQuery(entity, idAttributes, nullAttributes, 1);

        DbAdapter adapter = objectFactory.newInstance(DbAdapter.class, JdbcAdapter.class.getName());
        DeleteBatchQueryBuilder builder = new DeleteBatchQueryBuilder(adapter);
        String generatedSql = builder.createSqlString(deleteQuery);
        assertNotNull(generatedSql);
View Full Code Here

Examples of org.apache.cayenne.query.DeleteBatchQuery

101
102
103
104
105
106
107
108
109
110
111
            entity.getDataMap().setQuotingSQLIdentifiers(true);
            List<DbAttribute> idAttributes = Collections.singletonList((DbAttribute) entity
                    .getAttribute("LOCKING_TEST_ID"));

            DeleteBatchQuery deleteQuery = new DeleteBatchQuery(entity, idAttributes, null, 1);
            JdbcAdapter adapter = (JdbcAdapter) this.adapter;
            DeleteBatchQueryBuilder builder = new DeleteBatchQueryBuilder(adapter);
            String generatedSql = builder.createSqlString(deleteQuery);

            String charStart = unitAdapter.getIdentifiersStartQuote();
View Full Code Here

Examples of org.apache.cayenne.query.DeleteBatchQuery

130
131
132
133
134
135
136
137
138
139
140
            List<DbAttribute> idAttributes = Arrays.asList((DbAttribute) entity.getAttribute("LOCKING_TEST_ID"),
                    (DbAttribute) entity.getAttribute("NAME"));

            Collection<String> nullAttributes = Collections.singleton("NAME");

            DeleteBatchQuery deleteQuery = new DeleteBatchQuery(entity, idAttributes, nullAttributes, 1);

            JdbcAdapter adapter = (JdbcAdapter) this.adapter;

            DeleteBatchQueryBuilder builder = new DeleteBatchQueryBuilder(adapter);
            String generatedSql = builder.createSqlString(deleteQuery);
View Full Code Here

Examples of org.apache.cayenne.query.DeleteBatchQuery

74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
        Collection<String> nullAttributeNames = Collections.singleton("NAME");

        Map<String, Object> qualifierSnapshot = new HashMap<String, Object>();
        qualifierSnapshot.put("LOCKING_TEST_ID", new Integer(1));

        DeleteBatchQuery batchQuery = new DeleteBatchQuery(
                dbEntity,
                qualifierAttributes,
                nullAttributeNames,
                5);
        batchQuery.setUsingOptimisticLocking(true);
        batchQuery.add(qualifierSnapshot);

        DeleteBatchQueryBuilder batchQueryBuilder = new DeleteBatchQueryBuilder(adapter);

        MockConnection mockConnection = new MockConnection();
        PreparedStatementResultSetHandler preparedStatementResultSetHandler = mockConnection
View Full Code Here

Examples of org.apache.cayenne.query.DeleteBatchQuery

122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
        Collection<String> nullAttributeNames = Collections.singleton("NAME");

        Map<String, Object> qualifierSnapshot = new HashMap<String, Object>();
        qualifierSnapshot.put("LOCKING_TEST_ID", new Integer(1));

        DeleteBatchQuery batchQuery = new DeleteBatchQuery(
                dbEntity,
                qualifierAttributes,
                nullAttributeNames,
                5);
        batchQuery.setUsingOptimisticLocking(true);
        batchQuery.add(qualifierSnapshot);

        DeleteBatchQueryBuilder batchQueryBuilder = new DeleteBatchQueryBuilder(adapter);

        MockConnection mockConnection = new MockConnection();
        PreparedStatementResultSetHandler preparedStatementResultSetHandler = mockConnection
View Full Code Here

Examples of org.apache.cayenne.query.DeleteBatchQuery

58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
     * Appends WHERE clause to SQL string
     */
    protected void applyQualifier(StringBuffer query, BatchQuery batch) {
        query.append(" WHERE ");
       
        DeleteBatchQuery deleteBatch = (DeleteBatchQuery) batch;
        Iterator<DbAttribute> i = deleteBatch.getQualifierAttributes().iterator();
        while (i.hasNext()) {
            DbAttribute attribute = i.next();
            appendDbAttribute(query, attribute);
            query.append(deleteBatch.isNull(attribute) ? " IS NULL" : " = ?");

            if (i.hasNext()) {
                query.append(" AND ");
            }
        }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.