Package org.apache.tuscany.das.rdb

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

51
52
53
54
55
56
57
58
59
60
61
    // Read a customer
    Command select = Command.FACTORY.createCommand(
        "SELECT * FROM CUSTOMER WHERE CUSTOMER.ID = 1", getConfig("customerMapping.xml"));
    select.setConnection(getConnection());

    DataObject root = select.executeQuery();
    DataObject customer = root.getDataObject("Customer[1]");
    assertEquals(1, customer.getInt("id"));
    assertEquals("1212 foobar lane", customer.getString("address"));
    assertEquals("Williams", customer.getString("lastname"));
   
View Full Code Here
53
54
55
56
57
58
59
60
61
62
63
        try {

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

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

            // Modify customer
            customer.set("LASTNAME", "Pavick");
View Full Code Here
68
69
70
71
72
73
74
75
76
77
78
            // Flush changes
            apply.execute(root);

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

            // Since the DAS is not managing tx boundaries, I must
        } catch (Exception e) {
            c.rollback();
View Full Code Here
46
47
48
49
50
51
52
53
54
55
56
    //Read list of companies
    public void testReadCompanies() throws Exception {

        CommandGroup commandGroup = CommandGroup.FACTORY.createCommandGroup(getConfig("CompanyConfig.xml"));
        Command read = commandGroup.getCommand("all companies");
        DataObject root = read.executeQuery();
        assertEquals(3, root.getList("COMPANY").size());

    }
   
    //Read list of companies
View Full Code Here
56
57
58
59
60
61
62
63
64
65
66
    //Read list of companies
    public void testReadCompaniesWithDepartments() throws Exception {

        CommandGroup commandGroup = CommandGroup.FACTORY.createCommandGroup(getConfig("CompanyConfig.xml"));
        Command read = commandGroup.getCommand("all companies and departments");
        DataObject root = read.executeQuery();
        DataObject firstCompany = root.getDataObject("COMPANY[1]");
        List departments = firstCompany.getList("departments");
        assertEquals(0, departments.size());

    } 
View Full Code Here
67
68
69
70
71
72
73
74
75
76
77
   
    public void testddDepartmentToFirstCompany() throws Exception {
       
        CommandGroup commandGroup = CommandGroup.FACTORY.createCommandGroup(getConfig("CompanyConfig.xml"));
        Command read = commandGroup.getCommand("all companies and departments");
        DataObject root = read.executeQuery();
        DataObject firstCustomer = root.getDataObject("COMPANY[1]");
        int deptCount = firstCustomer.getList("departments").size();
       
        DataObject newDepartment = root.createDataObject("DEPARTMENT");
        firstCustomer.getList("departments").add(newDepartment);
View Full Code Here
78
79
80
81
82
83
84
85
86
87
88
       
        ApplyChangesCommand apply = commandGroup.getApplyChangesCommand();
        apply.execute(root);
       
        //verify
        root = read.executeQuery();
        firstCustomer = root.getDataObject("COMPANY[1]");
        assertEquals (deptCount + 1, firstCustomer.getList("departments").size());
    } 
   
    /**
 
View Full Code Here
92
93
94
95
96
97
98
99
100
101
102
    public void testFlushCreateHeirarchy() throws Exception {

        CommandGroup commandGroup = CommandGroup.FACTORY.createCommandGroup(getConfig("CompanyConfig.xml"));
        Command select = commandGroup.getCommand("all companies and departments");
        select.setConnection(getConnection());
        DataObject root = select.executeQuery();

        // Create a new Company
        DataObject company = root.createDataObject("COMPANY");
        company.setString("NAME", "Do-rite Pest Control");
View Full Code Here
122
123
124
125
126
127
128
129
130
131
132
        // Verify the change

        select = commandGroup.getCommand("company by id with departments");
        select.setParameterValue("ID", id);
        root = select.executeQuery();
        assertEquals("Do-rite Pest Control", root.getDataObject("COMPANY[1]")
                .getString("NAME"));

    }
   
View Full Code Here
138
139
140
141
142
143
144
145
146
147
148
        CommandGroup commandGroup = CommandGroup.FACTORY.createCommandGroup(getConfig("CompanyConfig.xml"));

        Command select = commandGroup.getCommand("company by id with departments");
        Integer idOfNoExistingCompany = new Integer(-1);
        select.setParameterValue("ID", idOfNoExistingCompany);
        DataObject root = select.executeQuery();
       
        //Will fail if there is no property named "COMPANY"
        assertEquals(0, root.getList("COMPANY").size());

    }
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.