Examples of addProcedures()

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

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

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

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

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

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

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

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

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

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

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

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

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

466
467
468
469
470
471
472
473
474
475
476
        builder.setGlobalConfParameter("site.specexec_enable", false);
       
        VoltProjectBuilder project = new VoltProjectBuilder("testorderby");
        project.addSchema(TestOrderBySuite.class.getResource("testorderby-ddl.sql"));
        project.addTablePartitionInfo("O1", "PKEY");
        project.addProcedures(PROCEDURES);

        config = new LocalSingleProcessServer("testorderby-onesite.jar",
                1, BackendTarget.NATIVE_EE_JNI);
        config.compile(project);
        builder.addServerConfig(config);
View Full Code Here

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

121
122
123
124
125
126
127
128
129
130
131
        // build up a project builder for the workload
        VoltProjectBuilder project = new VoltProjectBuilder("sneaky");
        project.addSchema(MultiPartition.class.getResource("sneaky-ddl.sql"));
        project.addTablePartitionInfo("P1", "P");
        project.addProcedures(PROCEDURES);

        /////////////////////////////////////////////////////////////
        // CONFIG #1: 1 Local Site/Partition running on HSQL backend
        /////////////////////////////////////////////////////////////
View Full Code Here

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

759
760
761
762
763
764
765
766
767
768
769
                TestGroupBySuite.class);
        VoltProjectBuilder project = new VoltProjectBuilder();

        project.addSchema(TestPlansGroupBy.class
                .getResource("testplans-groupby-ddl.sql"));
        project.addProcedures(PROCEDURES);
        project.addStmtProcedure("T1Insert", "INSERT INTO T1 VALUES (?, ?);");
        project.addStmtProcedure("BInsert", "INSERT INTO B VALUES (?, ?);");

        // config = new LocalSingleProcessServer("plansgroupby-ipc.jar", 1, BackendTarget.NATIVE_EE_IPC);
        // config.compile(project);
View Full Code Here

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

1765
1766
1767
1768
1769
1770
1771
1772
1773
1774
1775
        project.addStmtProcedure("CONCAT3", "select id, CONCAT(DESC,?,?) from P1 where id = ?");
        project.addStmtProcedure("CONCAT4", "select id, CONCAT(DESC,?,?,?) from P1 where id = ?");
        project.addStmtProcedure("CONCAT5", "select id, CONCAT(DESC,?,?,?,cast(ID as VARCHAR)) from P1 where id = ?");
        project.addStmtProcedure("ConcatOpt", "select id, DESC || ? from P1 where id = ?");

        project.addProcedures(GotBadParamCountsInJava.class);
        // CONFIG #1: Local Site/Partition running on JNI backend
        config = new LocalCluster("fixedsql-onesite.jar", 1, 1, 0, BackendTarget.NATIVE_EE_JNI);
        success = config.compile(project);
        assertTrue(success);
        builder.addServerConfig(config);
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.