Package ra

Examples of ra.Term.execute()

186
187
188
189
190
191
192
193
194
195
196
        System.out.println("----------------------------------------------------");

        Utils.reset();
        t = groupBy(rel(10), 1, 2).min(3).max(4).sum(5).count(6, 7).avg(8).countDistinct(9, 10);
        System.out.println(t);
        r = t.execute();
        System.out.println(r.getResultRelation());
        System.out.println(r.getFormulas());
        ats.storeAlgebra("examples/test_groupBy4.xml", t);
        ats.writeExcel("examples/excel_groupBy4.xlsx", r);
        t = ats.readAlgebra("examples/test_groupBy4.xml");
View Full Code Here
199
200
201
202
203
204
205
206
207
208
209
        //no columns to group over
        Utils.reset();
        t = groupBy(rel(10)).min(3).max(4).sum(5).count(6, 7).avg(8).countDistinct(9, 10);
        System.out.println(t);
        r = t.execute();
        System.out.println(r.getResultRelation());
        System.out.println(r.getFormulas());
        ats.storeAlgebra("examples/test_groupBy4_no_columns_to_group_over.xml", t);
        ats.writeExcel("examples/excel_groupBy4_no_columns_to_group_over.xlsx", r);
        t = ats.readAlgebra("examples/test_groupBy4_no_columns_to_group_over.xml");
View Full Code Here
212
213
214
215
216
217
218
219
220
221
222
        //CartProd
        Utils.reset();
        t = cartProd(rel(1), rel(1));
        System.out.println(t);
        r = t.execute();
        System.out.println(r.getResultRelation());
        System.out.println(r.getFormulas());
        ats.storeAlgebra("examples/test_cartProd1.xml", t);
        ats.writeExcel("examples/excel_cartProd1.xlsx", r);
        t = ats.readAlgebra("examples/test_cartProd1.xml");
View Full Code Here
224
225
226
227
228
229
230
231
232
233
234
        System.out.println("----------------------------------------------------");

        Utils.reset();
        t = cartProd(rel(2), rel(2));
        System.out.println(t);
        r = t.execute();
        System.out.println(r.getResultRelation());
        System.out.println(r.getFormulas());
        ats.storeAlgebra("examples/test_cartProd2.xml", t);
        ats.writeExcel("examples/excel_cartProd2.xlsx", r);
        t = ats.readAlgebra("examples/test_cartProd2.xml");
View Full Code Here
236
237
238
239
240
241
242
243
244
245
246
        System.out.println("----------------------------------------------------");

        Utils.reset();
        t = cartProd(rel(3), rel(3));
        System.out.println(t);
        r = t.execute();
        System.out.println(r.getResultRelation());
        System.out.println(r.getFormulas());
        ats.storeAlgebra("examples/test_cartProd1.xml", t);
        ats.writeExcel("examples/excel_cartProd1.xlsx", r);
        t = ats.readAlgebra("examples/test_cartProd1.xml");
View Full Code Here
249
250
251
252
253
254
255
256
257
258
259
        //Difference
        Utils.reset();
        t = diffBag(rel(1), rel(1));
        System.out.println(t);
        r = t.execute();
        System.out.println(r.getResultRelation());
        System.out.println(r.getFormulas());
        ats.storeAlgebra("examples/test_difference_bag1.xml", t);
        ats.writeExcel("examples/excel_difference_bag1.xlsx", r);
        t = ats.readAlgebra("examples/test_difference_bag1.xml");
View Full Code Here
261
262
263
264
265
266
267
268
269
270
271
        System.out.println("----------------------------------------------------");

        Utils.reset();
        t = diffBag(rel(2), rel(2));
        System.out.println(t);
        r = t.execute();
        System.out.println(r.getResultRelation());
        System.out.println(r.getFormulas());
        ats.storeAlgebra("examples/test_difference_bag2.xml", t);
        ats.writeExcel("examples/excel_difference_bag2.xlsx", r);
        t = ats.readAlgebra("examples/test_difference_bag2.xml");
View Full Code Here
273
274
275
276
277
278
279
280
281
282
283
        System.out.println("----------------------------------------------------");

        Utils.reset();
        t = diffSet(rel(1), rel(1));
        System.out.println(t);
        r = t.execute();
        System.out.println(r.getResultRelation());
        System.out.println(r.getFormulas());
        ats.storeAlgebra("examples/test_difference_set1.xml", t);
        ats.writeExcel("examples/excel_difference_set1.xlsx", r);
        t = ats.readAlgebra("examples/test_difference_set1.xml");
View Full Code Here
131
132
133
134
135
136
137
138
139
140
141
                /* translating the first query, then writing the first spreadsheet file take longer time, so let's
                 * warm up here */
                Schema schema = Schemas.fromDDL(DEFAULT_SCHEMA_TEXT);
                try {
                    Term translated = Queries.getRaOf(schema, DEFAULT_QUERY_TEXT);
                    Result result = translated.execute();
                    try (OutputStream os = new OutputStream() {
                        @Override
                        public void write(int b) throws IOException {
                            // nop
                        }};
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.