Package org.apache.cayenne.query

Examples of org.apache.cayenne.query.DeleteBatchQuery

78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
     */
    @Override
    public void bindParameters(PreparedStatement statement, BatchQuery query)
            throws SQLException, Exception {

        DeleteBatchQuery deleteBatch = (DeleteBatchQuery) query;

        int parameterIndex = getFirstParameterIndex(query);
        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
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
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
72
73
74
75
76
77
78
79
80
81
82
                .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
92
93
94
95
96
97
98
99
100
101
102
        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
119
120
121
122
123
124
125
126
127
128
129
            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
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
                        }
                    }

                    Object batchKey = Arrays.asList(nullQualifierNames);

                    DeleteBatchQuery batch = (DeleteBatchQuery) batches.get(batchKey);
                    if (batch == null) {
                        batch = new DeleteBatchQuery(dbEntity, qualifierBuilder
                                .getAttributes(), nullQualifierNames, 27);
                        batch.setUsingOptimisticLocking(qualifierBuilder
                                .isUsingOptimisticLocking());
                        batches.put(batchKey, batch);
                    }

                    batch.add(qualifierSnapshot);
                }
            }

            queries.addAll(batches.values());
        }
View Full Code Here
63
64
65
66
67
68
69
70
71
72
73
                SimpleLockingTestEntity.class).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
84
85
86
87
88
89
90
91
92
93
94
                .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
108
109
110
111
112
113
114
115
116
117
118
            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
TOP

Related Classes of org.apache.cayenne.query.DeleteBatchQuery

  • org.apache.cayenne.access.DataDomainDeleteBucket
  • org.apache.cayenne.access.DataDomainFlattenedBucket
  • org.apache.cayenne.access.jdbc.BatchActionLockingTest
  • org.apache.cayenne.access.jdbc.SoftDeleteBatchQueryBuilderTest
  • org.apache.cayenne.access.trans.DeleteBatchQueryBuilder
  • org.apache.cayenne.access.trans.DeleteBatchQueryBuilderTest
  • org.apache.cayenne.map.DbAttribute
  • java.util.ArrayList
    • Copyright © 2018 www.massapicom. 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.