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

org.apache.tuscany.das.rdb.DAS.createCommand()
Creates a Command based on the provided SQL statement @param sql The SQL statement @return returns a Command instance

    /**
     * Set parameter to empty string
     */
    public void testDiltonsNullParameterBug3() 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, "");
        insert.setParameter(3, "5528 Wells Fargo Dr");
        insert.execute();

View Full Code Here

        insert.setParameter(2, "");
        insert.setParameter(3, "5528 Wells Fargo Dr");
        insert.execute();


        // Verify
        Command select = das.createCommand("Select * from CUSTOMER where ID = 10");
        DataObject root = select.executeQuery();
        assertEquals(1, root.getList("CUSTOMER").size());
        assertEquals("5528 Wells Fargo Dr", root.get("CUSTOMER[1]/ADDRESS"));


    }

View Full Code Here

     * null. I will try to duplicate with an insert since that is simpler
     * 
     */
    public void testYingChen12162005() 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, "Williams");
        insert.setParameter(3, null);
        insert.execute();

View Full Code Here

        insert.setParameter(2, "Williams");
        insert.setParameter(3, null);
        insert.execute();


        // Verify
        Command select = das.createCommand("Select * from CUSTOMER where ID = 10");
        DataObject root = select.executeQuery();
        assertEquals(1, root.getList("CUSTOMER").size());
        assertNull(root.get("CUSTOMER[1]/ADDRESS"));


    }

View Full Code Here

        helper.addUpdateStatement(customerTable, "update CUSTOMER set LASTNAME = ? where ID = ?", "LASTNAME ID");


        DAS das = DAS.FACTORY.createDAS(helper.getConfig(), getConnection());


        //Read customer 1
        Command select = das.createCommand("Select * from CUSTOMER where ID = 1");
        DataObject root = select.executeQuery();


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


        //Modify customer

View Full Code Here

    }


    public void testReadModifyApply1() throws Exception {
        DAS das = DAS.FACTORY.createDAS(getConfig("basicCustomerMappingWithCUD2.xml"), getConnection());
        //Read customer 1
        Command select = das.createCommand("Select * from CUSTOMER where ID = 1");
        DataObject root = select.executeQuery();


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


        //Modify customer

View Full Code Here

        // managedserverid, timestamp) values (316405209, 316405209, '2005-11-23
        // 19:29:52.636')";
        String sql = "insert into conmgt.serverstatus (managedserverid, timestamp) " 
                + "values (316405209, '2005-11-23 19:29:52.636')";
        DAS das = DAS.FACTORY.createDAS(getConnection());
        Command insert = das.createCommand(sql);
        insert.execute();


        // Verify
        Command select = das.createCommand("Select * from conmgt.serverstatus where statusid = 316405209");
        DataObject root = select.executeQuery();

View Full Code Here

        DAS das = DAS.FACTORY.createDAS(getConnection());
        Command insert = das.createCommand(sql);
        insert.execute();


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


    }

View Full Code Here

     */
    public void testReadModifyDeleteInsertApply() throws Exception {


        DAS das = DAS.FACTORY.createDAS(getConfig("basicCustomerMapping.xml"), getConnection());
        // Read some customers
        Command select = das.createCommand("Select * from CUSTOMER where LASTNAME = 'Williams'");
        DataObject root = select.executeQuery();


        DataObject cust1 = (DataObject) root.getList("CUSTOMER").get(0);
        DataObject cust2 = (DataObject) root.getList("CUSTOMER").get(1);
        DataObject cust3 = (DataObject) root.getList("CUSTOMER").get(2);

View Full Code Here


        // Build apply changes command
        das.applyChanges(root);


        // Verify deletes
        select = das.createCommand("Select * from CUSTOMER where ID = ?");
        select.setParameter(1, Integer.valueOf(cust2ID));
        root = select.executeQuery();
        assertTrue(root.getList("CUSTOMER").isEmpty());
        // reparameterize same command
        select.setParameter(1, Integer.valueOf(cust3ID));

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

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.