Examples of DAS

opendap.dap.DAS
org.apache.tuscany.das.rdb.DAS
A CommandGroup represents a set of {@link Command} and single {@link ApplyChangesCommand} that are created from a common config file.

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

     * His example build a update statement and sets one parameter value to be
     * 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();


        // 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

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

        // Provide updatecommand programmatically via config
        ConfigHelper helper = new ConfigHelper();
        Table customerTable = helper.addTable("CUSTOMER", "CUSTOMER");
        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
        customer.set("LASTNAME", "Pavick");


        das.applyChanges(root);


        //Verify changes
        root = select.executeQuery();
        assertEquals("Pavick", root.getString("CUSTOMER[1]/LASTNAME"));

View Full Code Here

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

        assertEquals("Pavick", root.getString("CUSTOMER[1]/LASTNAME"));


    }


    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
        customer.set("LASTNAME", "Pavick");


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


        //Verify changes
        root = select.executeQuery();
        assertEquals("Pavick", root.getString("CUSTOMER[1]/LASTNAME"));

View Full Code Here

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

        // String sql = "insert into conmgt.serverstatus (statusid,
        // 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();
        assertEquals(1, root.getList("conmgt.serverstatus").size());


    }

View Full Code Here

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


    }


    public void testUpdateChildThatHasGeneratedKey() throws Exception {


        DAS das = DAS.FACTORY.createDAS(getConfig("CompanyConfig.xml"));


        //Read a specific company based on the known ID
        Command readCust = das.getCommand("all companies and departments");
        DataObject root = readCust.executeQuery();
        DataObject lastCustomer = root.getDataObject("COMPANY[3]");
        Iterator i = lastCustomer.getList("departments").iterator();
        Random generator = new Random();
        int random = generator.nextInt(1000) + 1;
        DataObject department;
        while (i.hasNext()) {
            department = (DataObject) i.next();
            System.out.println("Modifying department: " + department.getString("NAME"));
            department.setString("NAME", "Dept-" + random);
            random = random + 1;
        }


        das.applyChanges(root);


    }

View Full Code Here

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

    /**
     * Test ability to handle multiple changes to the graph including Creates/Updates/Deletes Employs generated CUD
     */
    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);


        // Modify a customer
        cust1.set("LASTNAME", "Pavick");
        int cust1ID = cust1.getInt("ID");


        // Save IDs before delete
        int cust2ID = cust2.getInt("ID");
        int cust3ID = cust3.getInt("ID");
        // Delete a couple
        cust2.delete();
        cust3.delete();


        // Create a new customer
        DataObject cust4 = root.createDataObject("CUSTOMER");
        cust4.set("ID", Integer.valueOf(100));
        cust4.set("ADDRESS", "5528 Wells Fargo Drive");
        cust4.set("LASTNAME", "Gerkin");


        // 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

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


    }


    public void testReadModifyApplyWithAssumedID() throws Exception {


        DAS das = DAS.FACTORY.createDAS(getConnection());
        // Read customer with particular ID
        Command select = das.createCommand("Select * from CUSTOMER");
        DataObject root = select.executeQuery();


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


        // Modify customer
        customer.set("LASTNAME", "Pavick");


        DataObject customerForDelete = getCustomerByLastName(root, "Daniel");
        customerForDelete.delete();


        DataObject newCustomer = root.createDataObject("CUSTOMER");
        newCustomer.set("LASTNAME", "NewCustomer");
        newCustomer.setInt("ID", 9000);


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


        // Verify the change
        root = select.executeQuery();
        assertEquals("Pavick", getCustomerByLastName(root, "Pavick").getString("LASTNAME"));
        assertEquals("NewCustomer", getCustomerByLastName(root, "NewCustomer").getString("LASTNAME"));

View Full Code Here

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

        assertNull(getCustomerByLastName(root, "Daniel"));


    }


    public void testReadModifyApplyWithAssumedIDFailure() throws Exception {
        DAS das = DAS.FACTORY.createDAS(getConnection());
        Command select = das.createCommand("Select * from ORDERDETAILS");


        DataObject root = select.executeQuery();


        DataObject od = root.getDataObject("ORDERDETAILS[1]");


        // Modify customer
        od.setInt("PRODUCTID", 72);


        // Flush changes -- This should fail because Order Details does not have
        // a column that
        // we can assume to be an ID
        try {
            das.applyChanges(root);
        } catch (RuntimeException ex) {
            assertTrue(ex.getMessage().contains("changed in the DataGraph but is not present in the Config"));
        }


    }

View Full Code Here

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

        }


    }


    public void testReadModifyApplyWithAssumedIDFailure2() throws Exception {
        DAS das = DAS.FACTORY.createDAS(getConnection());
        Command select = das.createCommand("Select * from ORDERDETAILS");
        DataObject root = select.executeQuery();


        DataObject od = root.getDataObject("ORDERDETAILS[1]");
        od.delete();


        // Flush changes -- This should fail because Order Details does not have
        // a column that
        // we can assume to be an ID
        try {
            das.applyChanges(root);
        } catch (RuntimeException ex) {
            assertTrue(ex.getMessage().contains("changed in the DataGraph but is not present in the Config"));
        }


    }

View Full Code Here

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

        }


    }


    public void testReadModifyApplyWithAssumedIDFailure3() throws Exception {
        DAS das = DAS.FACTORY.createDAS(getConnection());
        Command select = das.createCommand("Select * from ORDERDETAILS");
        DataObject root = select.executeQuery();


        DataObject od = root.createDataObject("ORDERDETAILS");


        // Modify customer
        od.setInt("PRODUCTID", 72);
        od.setInt("ORDERID", 500);


        // Flush changes -- This should fail because Order Details does not have
        // a column that
        // we can assume to be an ID
        try {
            das.applyChanges(root);
        } catch (RuntimeException ex) {
            assertTrue(ex.getMessage().contains("changed in the DataGraph but is not present in the Config"));
        }


    }

View Full Code Here

0 1 2 3 4 5

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.