Examples of DAS

Examples of org.apache.tuscany.das.rdb.DAS

52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
    protected void tearDown() throws Exception {
        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();

        DataObject atlanta = root.createDataObject("CITIES");
        atlanta.setString("NAME", "Atlanta");
        atlanta.setInt("ID", 6);

        // Create a new Company
        DataObject georgia = root.createDataObject("STATES");
        georgia.setInt("ID", 4);
        georgia.setString("NAME", "GA");

        georgia.getList("cities").add(atlanta);

        das.applyChanges(root);

        root = select.executeQuery();
        assertEquals(numberOfCities + 1, root.getList("CITIES").size());
        assertEquals(numberOfStates + 1, root.getList("STATES").size());
    }
View Full Code Here

Examples of org.apache.tuscany.das.rdb.DAS

78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
        assertEquals(numberOfCities + 1, root.getList("CITIES").size());
        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");

        List cityNames = new ArrayList();
        Iterator i = firstState.getList("cities").iterator();
        while (i.hasNext()) {
            DataObject firstCity = (DataObject) i.next();
            cityNames.add(firstCity.getString("NAME"));
            firstCity.delete();
        }
        firstState.delete();

        das.applyChanges(root);

        root = select.executeQuery();

        Iterator iter = root.getList("STATES").iterator();
        while (iter.hasNext()) {
View Full Code Here

Examples of org.apache.tuscany.das.rdb.DAS

46
47
48
49
50
51
52
53
54
55
56
    }

    //Read list of companies
    public void testReadCompanies() throws Exception {

        DAS das = DAS.FACTORY.createDAS(getConfig("CompanyConfig.xml"), getConnection());
        Command read = das.getCommand("all companies");
        DataObject root = read.executeQuery();
        assertEquals(3, root.getList("COMPANY").size());

    }
View Full Code Here

Examples of org.apache.tuscany.das.rdb.DAS

56
57
58
59
60
61
62
63
64
65
66
67
    }

    //Read list of companies
    public void testReadCompaniesWithDepartments() throws Exception {

        DAS das = DAS.FACTORY.createDAS(getConfig("CompanyConfig.xml"), getConnection());
        Command read = das.getCommand("all companies and departments");
        DataObject root = read.executeQuery();

        Iterator i = root.getList("COMPANY").iterator();
        while (i.hasNext()) {
            DataObject d = (DataObject) i.next();
View Full Code Here

Examples of org.apache.tuscany.das.rdb.DAS

75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
    }

    public void testddDepartmentToFirstCompany() throws Exception {

        DAS das = DAS.FACTORY.createDAS(getConfig("CompanyConfig.xml"), getConnection());
        Command read = das.getCommand("all companies and departments");
        DataObject root = read.executeQuery();
        DataObject firstCustomer = root.getDataObject("COMPANY[1]");
        int deptCount = firstCustomer.getList("departments").size();

        DataObject newDepartment = root.createDataObject("DEPARTMENT");
        firstCustomer.getList("departments").add(newDepartment);

        das.applyChanges(root);

        //verify
        root = read.executeQuery();
        firstCustomer = root.getDataObject("COMPANY[1]");
        assertEquals(deptCount + 1, firstCustomer.getList("departments").size());
View Full Code Here

Examples of org.apache.tuscany.das.rdb.DAS

41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
    protected void tearDown() throws Exception {
        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]");
        // 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);

        root = readCustomers.executeQuery();

        // If partial update was not used, LASTNAME would not be 'modified'
        customer = root.getDataObject("CUSTOMER[1]");
View Full Code Here

Examples of org.apache.tuscany.das.rdb.DAS

68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
        assertEquals("modified", customer.getString("LASTNAME"));
        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
        DataObject newCust = root.createDataObject("CUSTOMER");
        newCust.set("ID", Integer.valueOf(100));
        newCust.set("ADDRESS", "5528 Wells Fargo Drive");
        // 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

Examples of org.apache.tuscany.das.rdb.DAS

43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
    }

    // Uses dynamic SDOs but user provides the model
    public void testUserProvidedModelDynamic() throws SQLException {

        DAS das = DAS.FACTORY.createDAS(getConfig("staticCustomerOrder.xml"), getConnection());

        Command select = das.getCommand("Customer and Orders");

        SDOUtil.registerStaticTypes(CustomerFactory.class);

        // Parameterize the command
        select.setParameter(1, Integer.valueOf(1));

        // Get the graph - DataGraphRoot is from the typed package
        DataObject root = select.executeQuery();

        // Modify a customer
        Customer customer = (Customer) root.getDataObject("Customer[1]");
        customer.setLastName("Pavick");

        // Modify an order
        AnOrder order = (AnOrder) customer.getOrders().get(0);
        order.setProduct("Kitchen Sink 001");

        // Flush changes
        das.applyChanges((DataObject) root);

    }
View Full Code Here

Examples of org.apache.tuscany.das.rdb.DAS

34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
        new PartData(getAutoConnection()).refresh();
    }

    public void testReadEngineParts() throws Exception {

        DAS das = DAS.FACTORY.createDAS(getConfig("PartsConfig.xml"), getConnection());
        // Table definition
        // CREATE TABLE PART (ID INT PRIMARY KEY NOT NULL, NAME VARCHAR(50), QUANTITY INT, PARENT_ID INT );

        Command select = das.getCommand("readEngineParts");

        // Need to set the key explicitly. The aggregate of columns not working
        // because of null values
        DataObject root = select.executeQuery();
View Full Code Here

Examples of org.apache.tuscany.das.rdb.DAS

51
52
53
54
55
56
57
58
59
60
61
62
    public void testRelationshipAlreadyDefined() throws Exception {
        ConfigHelper helper = new ConfigHelper();
        Relationship r = helper.addRelationship("CUSTOMER.ID", "ANORDER.CUSTOMER_ID");
        r.setName("definedRelationship");

        DAS das = DAS.FACTORY.createDAS(helper.getConfig(), getConnection());
        Command select = das.createCommand("select * from CUSTOMER left join ANORDER "
                + "ON CUSTOMER.ID = ANORDER.CUSTOMER_ID");

        DataObject root = select.executeQuery();
        DataObject cust = root.getDataObject("CUSTOMER[1]");
        Iterator i = cust.getType().getProperties().iterator();
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.