Package org.voltdb.compiler

Examples of org.voltdb.compiler.VoltProjectBuilder.addProcedures()

667
668
669
670
671
672
673
674
675
676
677
        project.addSchema(TestPlansGroupBy.class
                .getResource("testplans-groupby-ddl.sql"));
        project.addTablePartitionInfo("T1", "PKEY");
        project.addTablePartitionInfo("F", "F_PKEY");
        project.addProcedures(PROCEDURES);
        project.addStmtProcedure("T1Insert", "INSERT INTO T1 VALUES (?, ?);");
       
        boolean success;
       
        /////////////////////////////////////////////////////////////
View Full Code Here
435
436
437
438
439
440
441
442
443
444
445
            new MultiConfigSuiteBuilder(TestSqlAggregateSuite.class);

        VoltProjectBuilder project = new VoltProjectBuilder("aggregate");
        project.addSchema(Insert.class.getResource("aggregate-sql-ddl.sql"));
        project.addTablePartitionInfo("P1", "ID");
        project.addProcedures(PROCEDURES);
       
        boolean success;
       
        /////////////////////////////////////////////////////////////
        // CONFIG #1: 1 Local Site/Partition
View Full Code Here
342
343
344
345
346
347
348
349
350
351
352
        project.addTablePartitionInfo("NEW_ORDER", "NO_W_ID");
        project.addTablePartitionInfo("ORDER_LINE", "OL_W_ID");
        project.addTablePartitionInfo("FIVEK_STRING", "P");
        project.addTablePartitionInfo("FIVEK_STRING_WITH_INDEX", "ID");
        project.addTablePartitionInfo("MANY_COLUMNS", "P");
        project.addProcedures(PROCEDURES);
        project.addStmtProcedure("InsertOrderLine",
                "INSERT INTO ORDER_LINE VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?);");
        project.addStmtProcedure("InsertNewOrder",
                "INSERT INTO NEW_ORDER VALUES (?, ?, ?);", "NEW_ORDER.NO_W_ID: 2");
View Full Code Here
206
207
208
209
210
211
212
213
214
215
216
            new MultiConfigSuiteBuilder(TestSqlUpdateSuite.class);

        VoltProjectBuilder project = new VoltProjectBuilder("fixed");
        project.addSchema(Insert.class.getResource("fixed-sql-ddl.sql"));
        project.addTablePartitionInfo("P1", "ID");
        project.addProcedures(PROCEDURES);

        config = new LocalSingleProcessServer("sqlupdate-onesite.jar", 1, BackendTarget.NATIVE_EE_JNI);
        config.setConfParameter("site.exec_adhoc_sql", true);
        config.compile(project);
        builder.addServerConfig(config);
View Full Code Here
1072
1073
1074
1075
1076
1077
1078
1079
1080
1081
1082
        project.addTablePartitionInfo("WITH_DEFAULTS", "PKEY");
        project.addTablePartitionInfo("WITH_NULL_DEFAULTS", "PKEY");
        project.addTablePartitionInfo("EXPRESSIONS_WITH_NULLS", "PKEY");
        project.addTablePartitionInfo("EXPRESSIONS_NO_NULLS", "PKEY");
        project.addTablePartitionInfo("JUMBO_ROW", "PKEY");
        project.addProcedures(PROCEDURES);


/*     // CONFIG #1: Local Site/Partitions running on IPC backend
        config = new LocalSingleProcessServer("sqltypes-onesite.jar", 1, BackendTarget.NATIVE_EE_IPC);
        config.compile(project);
View Full Code Here
346
347
348
349
350
351
352
353
354
355
356
        VoltProjectBuilder project = new VoltProjectBuilder("matview");
        //project.setBackendTarget(BackendTarget.NATIVE_EE_IPC);
        project.addSchema(schemaPath);
        project.addTablePartitionInfo("PEOPLE", "PARTITION");
        project.addTablePartitionInfo("OVERFLOWTEST", "COL_1");
        project.addProcedures(PROCEDURES);

        // build the jarfile
        config.compile(project);

        // add this config to the set of tests to run
View Full Code Here
135
136
137
138
139
140
141
142
143
144
145
        project.addStmtProcedure("InsertMultiPartRepl",
                                 "INSERT INTO R1 VALUES (?, ?, ?, ?);");
        project.addStmtProcedure("SelectMultiPartRepl", "SELECT * FROM R1");
        project.addStmtProcedure("UpdateMultiPartRepl",
                                 "UPDATE R1 SET R1.NUM = ?");
        project.addProcedures(PROCEDURES);

        /////////////////////////////////////////////////////////////
        // CLUSTER, two hosts, each with two sites, replication of 1
        /////////////////////////////////////////////////////////////
        config = new LocalCluster(PREFIX+"-1-cluster.jar", 2, 2, 1, BackendTarget.NATIVE_EE_JNI);
View Full Code Here
526
527
528
529
530
531
532
533
534
535
536
        VoltProjectBuilder project = new VoltProjectBuilder("indexes");
        project.addSchema(Insert.class.getResource("indexes-ddl.sql"));
        project.addTablePartitionInfo("P1", "ID");
        project.addTablePartitionInfo("P2", "ID");
        project.addTablePartitionInfo("P3", "ID");
        project.addProcedures(PROCEDURES);
       
        for (String tableName : ALL_TABLES) {
            String procName = "Eng397LimitIndex" + tableName;
            String sql = String.format("SELECT * FROM %s WHERE %s.ID > 2 LIMIT ?", tableName, tableName);
            project.addStmtProcedure(procName, sql);
View Full Code Here
447
448
449
450
451
452
453
454
455
456
457
        project.addSchema(DivideByZero.class.getResource("failures-ddl.sql"));
        project.addTablePartitionInfo("NEW_ORDER", "NO_W_ID");
        project.addTablePartitionInfo("FIVEK_STRING", "P");
        project.addTablePartitionInfo("FIVEK_STRING_WITH_INDEX", "ID");
        project.addTablePartitionInfo("WIDE", "P");
        project.addProcedures(PROCEDURES);
        project.addStmtProcedure("InsertNewOrder", "INSERT INTO NEW_ORDER VALUES (?, ?, ?);", "NEW_ORDER.NO_W_ID: 2");
        // build the jarfile
        if (!config.compile(project))
            fail();
View Full Code Here
972
973
974
975
976
977
978
979
980
981
982
        project.addSchema(Insert.class.getResource("fixed-sql-ddl.sql"));
        project.addTablePartitionInfo("P1", "ID");
        project.addTablePartitionInfo("P2", "ID");
        project.addTablePartitionInfo("ASSET", "ASSET_ID");
        project.addTablePartitionInfo("OBJECT_DETAIL", "OBJECT_DETAIL_ID");
        project.addProcedures(PROCEDURES);
        project.addStmtProcedure("Eng397Limit1", "Select P1.NUM from P1 order by P1.NUM limit ?;");
       
        // TODO: Hardcoded procedures for ad-hoc queries
        project.addStmtProcedure("Ticket309P1", "select count(*), P1.NUM from P1 group by P1.NUM");
        project.addStmtProcedure("Ticket309R1", "select count(*), R1.NUM from R1 group by R1.NUM");
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.