Examples of DeleteBatchQuery

Examples of org.apache.cayenne.query.DeleteBatchQuery

66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
     */
    @Override
    public void bindParameters(PreparedStatement statement, BatchQuery query)
            throws SQLException, Exception {

        DeleteBatchQuery deleteBatch = (DeleteBatchQuery) query;

        int parameterIndex = 1;
        int i = 0;

        for (DbAttribute attribute : deleteBatch.getQualifierAttributes()) {
            Object value = query.getValue(i++);

            // skip null attributes... they are translated as "IS NULL"
            if (deleteBatch.isNull(attribute)) {
                continue;
            }

            adapter.bindParameter(
                    statement,
View Full Code Here

Examples of org.apache.cayenne.query.DeleteBatchQuery

57
58
59
60
61
62
63
64
65
66
67
                SimpleLockingTestEntity.class).getDbEntity();

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

        DeleteBatchQuery deleteQuery = new DeleteBatchQuery(entity, idAttributes, null, 1);
        DeleteBatchQueryBuilder builder = new DeleteBatchQueryBuilder(new JdbcAdapter());
        String generatedSql = builder.createSqlString(deleteQuery);
        assertNotNull(generatedSql);
        assertEquals(
                "DELETE FROM " + entity.getName() + " WHERE LOCKING_TEST_ID = ?",
View Full Code Here

Examples of org.apache.cayenne.query.DeleteBatchQuery

76
77
78
79
80
81
82
83
84
85
86
                .getAttribute("LOCKING_TEST_ID"), (DbAttribute) entity
                .getAttribute("NAME"));

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

        DeleteBatchQuery deleteQuery = new DeleteBatchQuery(
                entity,
                idAttributes,
                nullAttributes,
                1);
        DeleteBatchQueryBuilder builder = new DeleteBatchQueryBuilder(new JdbcAdapter());
View Full Code Here

Examples of org.apache.cayenne.query.DeleteBatchQuery

98
99
100
101
102
103
104
105
106
107
108
            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;
View Full Code Here

Examples of org.apache.cayenne.query.DeleteBatchQuery

140
141
142
143
144
145
146
147
148
149
150
                    .getAttribute("LOCKING_TEST_ID"), (DbAttribute) entity
                    .getAttribute("NAME"));

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

            DeleteBatchQuery deleteQuery = new DeleteBatchQuery(
                    entity,
                    idAttributes,
                    nullAttributes,
                    1);
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("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()
View Full Code Here

Examples of org.apache.cayenne.query.DeleteBatchQuery

85
86
87
88
89
90
91
92
93
94
95
        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();
View Full Code Here

Examples of org.apache.cayenne.query.DeleteBatchQuery

112
113
114
115
116
117
118
119
120
121
122
            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;
View Full Code Here

Examples of org.apache.cayenne.query.DeleteBatchQuery

70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
        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

118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
        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
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.