Examples of DeleteBatchQuery

Examples of org.apache.cayenne.query.DeleteBatchQuery

51
52
53
54
55
56
57
58
59
60
61
                SoftTest.class).getDbEntity();

        List idAttributes = Collections.singletonList(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 = ?",
View Full Code Here

Examples of org.apache.cayenne.query.DeleteBatchQuery

69
70
71
72
73
74
75
76
77
78
79
        List idAttributes = Arrays.asList(entity.getAttribute("SOFT_TEST_ID"), entity
                .getAttribute("NAME"));

        Collection 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

91
92
93
94
95
96
97
98
99
100
101
            entity.getDataMap().setQuotingSQLIdentifiers(true);
            List idAttributes = Collections.singletonList(entity
                    .getAttribute("SOFT_TEST_ID"));

            DeleteBatchQuery deleteQuery = new DeleteBatchQuery(
                    entity,
                    idAttributes,
                    null,
                    1);
            JdbcAdapter adapter = (JdbcAdapter) getAccessStackAdapter().getAdapter();
View Full Code Here

Examples of org.apache.cayenne.query.DeleteBatchQuery

59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
        Collection nullAttributeNames = Collections.singleton("NAME");

        Map qualifierSnapshot = new HashMap();
        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

105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
        Collection nullAttributeNames = Collections.singleton("NAME");

        Map qualifierSnapshot = new HashMap();
        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

48
49
50
51
52
53
54
55
56
57
58
                SimpleLockingTestEntity.class).getDbEntity();

        List idAttributes = Collections.singletonList(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

66
67
68
69
70
71
72
73
74
75
76
        List idAttributes = Arrays.asList(entity.getAttribute("LOCKING_TEST_ID"), entity
                .getAttribute("NAME"));

        Collection 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

88
89
90
91
92
93
94
95
96
97
98
            entity.getDataMap().setQuotingSQLIdentifiers(true);
            List idAttributes = Collections.singletonList(entity
                    .getAttribute("LOCKING_TEST_ID"));

            DeleteBatchQuery deleteQuery = new DeleteBatchQuery(
                    entity,
                    idAttributes,
                    null,
                    1);
            JdbcAdapter adapter = (JdbcAdapter) getAccessStackAdapter().getAdapter();
View Full Code Here

Examples of org.apache.cayenne.query.DeleteBatchQuery

130
131
132
133
134
135
136
137
138
139
140
                    entity.getAttribute("LOCKING_TEST_ID"),
                    entity.getAttribute("NAME"));

            Collection nullAttributes = Collections.singleton("NAME");

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

Examples of org.apache.cayenne.query.DeleteBatchQuery

39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
        super(adapter);
    }

    @Override
    public String createSqlString(BatchQuery batch) {
        DeleteBatchQuery deleteBatch = (DeleteBatchQuery) batch;
        String table = batch.getDbEntity().getFullyQualifiedName();

        StringBuffer query = new StringBuffer("DELETE FROM ");
        query.append(table).append(" WHERE ");

        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.