Package org.apache.tuscany.das.rdb

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

52
53
54
55
56
57
58
59
60
61
62
        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
74
75
76
77
78
79
80
81
82
83
84
     * @throws Exception
     */
    public void testAddNewOrder() throws Exception {
        DAS das = DAS.FACTORY.createDAS(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]");
View Full Code Here
99
100
101
102
103
104
105
106
107
108
109
        // Build apply changes command
        das.applyChanges(root);

        // verify cust1 relationship updates
        select = das.createCommand("SELECT * FROM CUSTOMER LEFT JOIN ANORDER ON CUSTOMER.ID = ANORDER.CUSTOMER_ID "
                 + "where CUSTOMER.ID = ?");

        select.setParameter(1, Integer.valueOf(custID));
        root = select.executeQuery();

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

    public void testMultipleResultSets() throws Exception {
        DAS das = DAS.FACTORY.createDAS(getConnection());
        Command read = das.createCommand("{call GETALLCUSTOMERSANDORDERS()}");

        DataObject root = read.executeQuery();

        // Verify
        assertEquals(5, root.getList("CUSTOMER").size());
View Full Code Here
54
55
56
57
58
59
60
61
62
63
64
    }

    // Call a simple stored proc to read all companies
    public void testGetCompanies() throws Exception {
        DAS das = DAS.FACTORY.createDAS(getConnection());
        Command read = das.createCommand("{call GETALLCOMPANIES()}");

        DataObject root = read.executeQuery();

        // Verify
        assertEquals(3, root.getList("COMPANY").size());
View Full Code Here
66
67
68
69
70
71
72
73
74
75
76
    }

    public void testGetNamedCompany() throws Exception {
        DAS das = DAS.FACTORY.createDAS(getConnection());
        Command read = das.createCommand("{call GETNAMEDCOMPANY(?)}");

        read.setParameter(1, "MegaCorp");
        DataObject root = read.executeQuery();

        assertEquals("MegaCorp", root.getString("COMPANY[1]/NAME"));
View Full Code Here
77
78
79
80
81
82
83
84
85
86
87
    }

    public void testGetNamedCompanyByName() throws Exception {
        DAS das = DAS.FACTORY.createDAS(getConnection());
        Command read = das.createCommand("{call GETNAMEDCOMPANY(?)}");

        read.setParameter(1, "MegaCorp");
        DataObject root = read.executeQuery();

        assertEquals("MegaCorp", root.getString("COMPANY[1]/NAME"));
View Full Code Here
88
89
90
91
92
93
94
95
96
97
98
    }

    // Retreive heirarchy using a stored proc ... new programming model
    public void testGetCustomersAndOrder() throws Exception {
        DAS das = DAS.FACTORY.createDAS(getConfig("CustomersOrdersConfig.xml"), getConnection());
        Command read = das.createCommand("{call getCustomerAndOrders(?)}");
        read.setParameter(1, Integer.valueOf(1));

        DataObject root = read.executeQuery();

        DataObject customer = (DataObject) root.getList("CUSTOMER").get(0);
View Full Code Here
126
127
128
129
130
131
132
133
134
135
136
    // re-enable this test

    // Simplest possible SP write
    public void testDelete() throws Exception {
        DAS das = DAS.FACTORY.createDAS(getConnection());
        Command delete = das.createCommand("{call DELETECUSTOMER(?)}");
        delete.setParameter(1, Integer.valueOf(1));
        delete.execute();

        // Verify DELETE
        Command select = das.createCommand("Select * from CUSTOMER where ID = 1");
View Full Code Here
131
132
133
134
135
136
137
138
139
140
141
        Command delete = das.createCommand("{call DELETECUSTOMER(?)}");
        delete.setParameter(1, Integer.valueOf(1));
        delete.execute();

        // Verify DELETE
        Command select = das.createCommand("Select * from CUSTOMER where ID = 1");
        DataObject root = select.executeQuery();
        assertTrue(root.getList("CUSTOMER").isEmpty());

    }

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.