Examples of createCommand()

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

49
50
51
52
53
54
55
56
57
58
59
    public void testSimple() throws Exception {

        DAS das = DAS.FACTORY.createDAS(getConnection());

        // Build the select command
        Command selectCommand = das.createCommand("select * from DOG");

        // Get the graph
        DataObject root = selectCommand.executeQuery();

        assertEquals(3, root.getList("DOG").size());
View Full Code Here

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

63
64
65
66
67
68
69
70
71
72
73
    public void testSimple2() throws Exception {

        DAS das = DAS.FACTORY.createDAS(getConnection());

        // Build the select command
        Command selectCommand = das.createCommand("select * from OWNER");

        // Get the graph
        DataObject root = selectCommand.executeQuery();

        assertEquals(3, root.getList("OWNER").size());
View Full Code Here

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

77
78
79
80
81
82
83
84
85
86
87
    public void testSimple3() throws Exception {

        DAS das = DAS.FACTORY.createDAS(getConnection());

        // Build the select command
        Command selectCommand = das.createCommand("select * from OWNER, DOG "
                + "where DOG.OWNER_ID = OWNER.ID and OWNER.NAME = 'Fanny'");

        // Get the graph
        DataObject root = selectCommand.executeQuery();
       
View Full Code Here

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

94
95
96
97
98
99
100
101
102
103
104
    public void testSimple4() throws Exception {

        DAS das = DAS.FACTORY.createDAS(getConnection());

        // Build the select command
        Command selectCommand = das.createCommand("select * from KENNEL");

        // Get the graph
        DataObject root = selectCommand.executeQuery();
       
        assertEquals(3, root.getList("KENNEL").size());
View Full Code Here

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

108
109
110
111
112
113
114
115
116
117
118
    public void testSimple5() throws Exception {

        DAS das = DAS.FACTORY.createDAS(getConnection());

        // Build the select command
        Command selectCommand = das.createCommand("select * from VISIT");

        // Get the graph
        DataObject root = selectCommand.executeQuery();
       
        assertEquals(3, root.getList("VISIT").size());
View Full Code Here

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

61
62
63
64
65
66
67
68
69
70
71
     * Dilton's bug for adding new child data object
     */
    public void testAddNewOrder() throws Exception {
        DAS das = DAS.FACTORY.createDAS(getConfig("CustomersOrdersConfig.xml"), getConnection());
        // Read some customers and related orders
        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

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

86
87
88
89
90
91
92
93
94
95
96
        // 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

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

106
107
108
109
110
111
112
113
114
115
116
        // String sql = "insert into conmgt.serverstatus (managedserverid,
        // timestamp) values (316405209, '2005-11-23 19:29:52.636')";
        String sql = "insert into conmgt.serverstatus (managedserverid, timestamp) values (?, ?)";

        DAS das = DAS.FACTORY.createDAS(getConnection());
        Command insert = das.createCommand(sql);
        insert.setParameter(1, Integer.valueOf(316405209));
        insert.setParameter(2, "2005-11-23 19:29:52.636");
        insert.execute();

        // Verify
View Full Code Here

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

112
113
114
115
116
117
118
119
120
121
122
        insert.setParameter(1, Integer.valueOf(316405209));
        insert.setParameter(2, "2005-11-23 19:29:52.636");
        insert.execute();

        // Verify
        Command select = das.createCommand("Select * from conmgt.SERVERSTATUS");
        DataObject root = select.executeQuery();
        assertEquals(1, root.getList("SERVERSTATUS").size());

    }

View Full Code Here

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

150
151
152
153
154
155
156
157
158
159
160
     * Should be able to explicitly set a parameter to null. But, should require
     * that the parameter type is set.
     */
    public void testDiltonsNullParameterBug1() throws Exception {
        DAS das = DAS.FACTORY.createDAS(getConnection());
        Command insert = das.createCommand("insert into CUSTOMER values (?, ?, ?)");
        insert.setParameter(1, Integer.valueOf(10));
        insert.setParameter(2, null);
        insert.setParameter(3, "5528 Wells Fargo Dr");
        insert.execute();

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.