Package org.apache.tuscany.das.rdb

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

79
80
81
82
83
84
85
86
87
88
89
        CommandGroup commandGroup = CommandGroup.FACTORY
                .createCommandGroup(getConfig("CompanyEmployeeConfig.xml"));

        Command read = commandGroup.getCommand("get companies with employee of the month");
        DataObject root = read.executeQuery();
        DataObject company = root.getDataObject("COMPANY[1]");
        company.setDataObject("company->employee_opposite", null);
        assertNull(company.getDataObject("company->employee_opposite"));
  
        //Flush changes
View Full Code Here
88
89
90
91
92
93
94
95
96
97
98
  
        //Flush changes
        commandGroup.getApplyChangesCommand().execute(root);

        //Verify
        root = read.executeQuery();
        company = root.getDataObject("COMPANY[1]");
        assertNull(company.getDataObject("company->employee_opposite"));
    }
   
    /**
 
View Full Code Here
102
103
104
105
106
107
108
109
110
111
112
        CommandGroup commandGroup = CommandGroup.FACTORY
                .createCommandGroup(getConfig("CompanyEmployeeConfig.xml"));

        Command read = commandGroup.getCommand("get companies with employee of the month");
        DataObject root = read.executeQuery();
        DataObject company = root.getDataObject("COMPANY[1]");
        DataObject employee = company.getDataObject("company->employee_opposite");
        employee.delete();
        assertNull(company.getDataObject("company->employee_opposite"));
  
View Full Code Here
112
113
114
115
116
117
118
119
120
121
122
  
        //Flush changes
        commandGroup.getApplyChangesCommand().execute(root);

        //Verify
        root = read.executeQuery();
        company = root.getDataObject("COMPANY[1]");
        assertNull(company.getDataObject("company->employee_opposite"));
    }
   
    /**
 
View Full Code Here
126
127
128
129
130
131
132
133
134
135
136
        CommandGroup commandGroup = CommandGroup.FACTORY
                .createCommandGroup(getConfig("CompanyEmployeeConfig.xml"));

        Command read = commandGroup.getCommand("get companies with employee of the month");
        DataObject root = read.executeQuery();
        DataObject company = root.getDataObject("COMPANY[1]");
       
        //Create a new employee
        DataObject employee = root.createDataObject("EMPLOYEE");
        employee.setString ("NAME", "Joe Hotshot");
View Full Code Here
142
143
144
145
146
147
148
149
150
151
152
        
        //Flush changes
        commandGroup.getApplyChangesCommand().execute(root);

        //Verify
        root = read.executeQuery();
        company = root.getDataObject("COMPANY[1]");
       
        employee = root.getDataObject("COMPANY[1]/company->employee_opposite");

        assertEquals("Joe Hotshot", employee.getString("NAME"));
View Full Code Here
46
47
48
49
50
51
52
53
54
55
56
    select.setParameterValue("LASTNAME", "Williams");
    TypeHelper helper = TypeHelper.INSTANCE;
   
    select.setDataObjectModel(helper.getType(DataGraphRoot.class));
   
    DataGraphRoot root = (DataGraphRoot) select.executeQuery();
   
    Collection customers = root.getCustomers();
    assertEquals(4, customers.size());
  }
View Full Code Here
89
90
91
92
93
94
95
96
97
98
99
    Type[] types = { SDODataTypes.INTEGEROBJECT, SDODataTypes.DATE, SDODataTypes.STRING };
    ResultSetShape shape = new ResultSetShape(tables, columns, types);
    read.setResultSetShape(shape);
           
    //Read
    DataObject root = read.executeQuery();
   
    //Verify
    assertEquals(kbday, root.getDate("CUSTOMER[1]/LASTNAME"));
   
    //Modify
View Full Code Here
102
103
104
105
106
107
108
109
110
111
112
    ApplyChangesCommand write = Command.FACTORY.createApplyChangesCommand(getConfig("CustomerConfigWithConverter.xml"));
    write.setConnection(getConnection());
    write.execute(root);
   
    //Read
    root = read.executeQuery();

    //Verify
    assertEquals(tbday, root.getDate("CUSTOMER[1]/LASTNAME"));
   
  }
View Full Code Here
58
59
60
61
62
63
64
65
66
67
68
    //Create and initialize command to read customers
    Command readCustomers = Command.FACTORY.createCommand("select * from CUSTOMER where ID = 1"); 
    readCustomers.setConnection(getConnection());

    //Read
    DataObject root = readCustomers.executeQuery();
   
    //Verify
    assertEquals(1, root.getInt("CUSTOMER[1]/ID"));
  }
 
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.