Package org.apache.tuscany.das.rdb

Examples of org.apache.tuscany.das.rdb.Command.execute()

174
175
176
177
178
179
180
181
182
183
184
        Command insert = commandGroup.getCommand("insert customer");
        insert.setParameterValue("ID", new Integer(10));
        insert.setParameterValue("LASTNAME", "Williams");
        insert.setParameterValue("ADDRESS", null);
        insert.execute();

        // Verify
        Command select = commandGroup.getCommand("read customer 10");
        DataObject root = select.executeQuery();
        assertEquals(1, root.getList("CUSTOMER").size());
View Full Code Here
199
200
201
202
203
204
205
206
207
208
209
        insert.setConnection(getConnection());
        insert.setParameterValue("ID", new Integer(10));
        insert.setParameterValue("LASTNAME", null);
        insert.setParameterType("LASTNAME", SDODataTypes.STRING);
        insert.setParameterValue("ADDRESS", "5528 Wells Fargo Dr");
        insert.execute();

        //Verify
        Command select = Command.FACTORY.createCommand("Select * from CUSTOMER where ID = 10");
        select.setConnection(getConnection());
        DataObject root = select.executeQuery();   
View Full Code Here
223
224
225
226
227
228
229
230
231
232
233
        insert.setParameterValue("ID", new Integer(10));
//        insert.setParameterValue("LASTNAME", null);
        insert.setParameterValue("ADDRESS", "5528 Wells Fargo Dr");
       
        try {
            insert.execute();
            fail();
        }
        catch (RuntimeException e) {
            //Expected since "LASTNAME" parameter not set
        }
View Full Code Here
161
162
163
164
165
166
167
168
169
170
171
    Command insert = Command.FACTORY.createCommand("insert into CUSTOMER values (:ID, :LASTNAME, :ADDRESS)"); 
    insert.setConnection(getConnection());
    insert.setParameterValue("ID", new Integer(10));
    insert.setParameterValue("LASTNAME", "Williams");
    insert.setParameterValue("ADDRESS", "5528 Wells Fargo Dr");
    insert.execute();

    //Verify
    Command select = Command.FACTORY.createCommand("Select * from CUSTOMER where ID = 10");
    select.setConnection(getConnection());
    DataObject root = select.executeQuery(); 
View Full Code Here
184
185
186
187
188
189
190
191
192
193
194
    assertEquals(1, root.getList("CUSTOMER").size()); 
   
    //Create and execute the delete command
    Command delete = Command.FACTORY.createCommand("delete from CUSTOMER where ID = 1");
    delete.setConnection(getConnection());
    delete.execute();
   
    //Verify delete by reusing the original select command
    root = select.executeQuery(); 
    assertEquals(0, root.getList("CUSTOMER").size());
   
View Full Code Here
203
204
205
206
207
208
209
210
211
212
213
    DataObject root = select.executeQuery(); 
    assertFalse(root.get("CUSTOMER[1]/LASTNAME").equals("Pavick"));

    Command update = Command.FACTORY.createCommand("update CUSTOMER set LASTNAME = 'Pavick' where ID = 1"); 
    update.setConnection(getConnection());
    update.execute();
   
    //Verify update - reuse select command
    root = select.executeQuery(); 
    assertEquals("Pavick", root.get("CUSTOMER[1]/LASTNAME"));
   
View Full Code Here
223
224
225
226
227
228
229
230
231
232
233
   
    Command update = Command.FACTORY.createCommand("update CUSTOMER set LASTNAME = :LASTNAME where ID = :ID"); 
    update.setConnection(getConnection());
    update.setParameterValue("LASTNAME", "Pavick");
    update.setParameterValue("ID", new Integer(1));
    update.execute();
   
    //Verify update - reuse select command
    root = select.executeQuery(); 
    assertEquals("Pavick", root.get("CUSTOMER[1]/LASTNAME"));
   
View Full Code Here
243
244
245
246
247
248
249
250
251
252
253
       
        Command update = Command.FACTORY.createCommand("update CUSTOMER set LASTNAME = ? where ID = ?"); 
        update.setConnection(getConnection());
        update.setParameterValue(1, "Pavick");
        update.setParameterValue(2, new Integer(1));
        update.execute();
       
        //Verify update - reuse select command
        root = select.executeQuery();  
        assertEquals("Pavick", root.get("CUSTOMER[1]/LASTNAME"));
       
View Full Code Here
48
49
50
51
52
53
54
55
56
57
58
    public void testInsert() throws Exception {

        Command insert = Command.FACTORY.createCommand("insert into COMPANY (NAME) values (:NAME)");
        insert.setConnection(getConnection());
        insert.setParameterValue("NAME", "AAA Rental");
        insert.execute();

        // Verify insert
        // Verify
        Command select = Command.FACTORY.createCommand("Select ID, NAME from COMPANY");
        select.setConnection(getConnection());
View Full Code Here
67
68
69
70
71
72
73
74
75
76
77
    public void testInsert2() throws Exception {

        Command insert = Command.FACTORY.createCommand("insert into COMPANY (NAME) values (:NAME)");
        insert.setConnection(getConnection());
        insert.setParameterValue("NAME", "AAA Rental");
        insert.execute();

        // insert another using same command
        insert.setParameterValue("NAME", "BBB Rental");
        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.