Package org.apache.tuscany.das.rdb

Examples of org.apache.tuscany.das.rdb.DAS.createCommand()

246
247
248
249
250
251
252
253
254
255
256
    public void testReadModifyApplyWithAssumedID() throws Exception {

        DAS das = DAS.FACTORY.createDAS(getConnection());
        // Read customer with particular ID
        Command select = das.createCommand("Select * from CUSTOMER");
        DataObject root = select.executeQuery();

        DataObject customer = root.getDataObject("CUSTOMER[1]");

        // Modify customer
View Full Code Here
274
275
276
277
278
279
280
281
282
283
284
    }

    public void testReadModifyApplyWithAssumedIDFailure() throws Exception {
        DAS das = DAS.FACTORY.createDAS(getConnection());
        Command select = das.createCommand("Select * from ORDERDETAILS");

        DataObject root = select.executeQuery();

        DataObject od = root.getDataObject("ORDERDETAILS[1]");

View Full Code Here
296
297
298
299
300
301
302
303
304
305
306
    }

    public void testReadModifyApplyWithAssumedIDFailure2() throws Exception {
        DAS das = DAS.FACTORY.createDAS(getConnection());
        Command select = das.createCommand("Select * from ORDERDETAILS");
        DataObject root = select.executeQuery();

        DataObject od = root.getDataObject("ORDERDETAILS[1]");
        od.delete();

View Full Code Here
315
316
317
318
319
320
321
322
323
324
325
    }

    public void testReadModifyApplyWithAssumedIDFailure3() throws Exception {
        DAS das = DAS.FACTORY.createDAS(getConnection());
        Command select = das.createCommand("Select * from ORDERDETAILS");
        DataObject root = select.executeQuery();

        DataObject od = root.createDataObject("ORDERDETAILS");

        // Modify customer
View Full Code Here
53
54
55
56
57
58
59
60
61
62
63
        super.tearDown();
    }

    public void testInsert() throws Exception {
        DAS das = DAS.FACTORY.createDAS(getConfig("cityStates.xml"), getConnection());
        Command select = das.createCommand("Select * from STATES inner join CITIES on STATES.ID = CITIES.STATE_ID");
        DataObject root = select.executeQuery();

        int numberOfStates = root.getList("STATES").size();
        int numberOfCities = root.getList("CITIES").size();

View Full Code Here
79
80
81
82
83
84
85
86
87
88
89
        assertEquals(numberOfStates + 1, root.getList("STATES").size());
    }

    public void testDeletes() throws Exception {
        DAS das = DAS.FACTORY.createDAS(getConfig("cityStates.xml"), getConnection());
        Command select = das.createCommand("Select * from STATES inner join CITIES on STATES.ID = CITIES.STATE_ID");
        DataObject root = select.executeQuery();

        DataObject firstState = root.getDataObject("STATES[1]");
        String stateName = firstState.getString("NAME");

View Full Code Here
42
43
44
45
46
47
48
49
50
51
52
        super.tearDown();
    }

    public void testPartialUpdate() throws SQLException {
        DAS das = DAS.FACTORY.createDAS(getConnection());
        Command readCustomers = das.createCommand("select * from CUSTOMER where ID = 1");

        // Read
        DataObject root = readCustomers.executeQuery();

        DataObject customer = root.getDataObject("CUSTOMER[1]");
View Full Code Here
51
52
53
54
55
56
57
58
59
60
61
        DataObject customer = root.getDataObject("CUSTOMER[1]");
        // Verify
        assertEquals(1, customer.getInt("ID"));

        Command update = das.createCommand("update CUSTOMER set LASTNAME = 'modified' where ID = 1");
        update.execute();

        customer.setString("ADDRESS", "main street");

        das.applyChanges(root);
View Full Code Here
69
70
71
72
73
74
75
76
77
78
79
        assertEquals("main street", customer.getString("ADDRESS"));
    }

    public void testPartialInsert() throws SQLException {
        DAS das = DAS.FACTORY.createDAS(getConnection());
        Command readCustomers = das.createCommand("select * from CUSTOMER where ID = 1");

        // Read
        DataObject root = readCustomers.executeQuery();

        // Create a new customer
View Full Code Here
83
84
85
86
87
88
89
90
91
92
93
        // Purposely do not set lastname to let it default to 'Garfugengheist'
        // newCust.set("LASTNAME", "Gerkin" );

        das.applyChanges(root);

        Command readNewCust = das.createCommand("select * from CUSTOMER where ID = 100");
        root = readNewCust.executeQuery();

        // If partial insert was not used, LASTNAME would not be
        // 'Garfugengheist'
        newCust = root.getDataObject("CUSTOMER[1]");
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.