Examples of HSQLInterface

Examples of org.hsqldb.HSQLInterface

47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
            "\"w_zip\" varchar(9) default NULL, " +
            "\"w_tax\" float default NULL, " +
            "PRIMARY KEY  (\"w_id\") " +
            ");";

        HSQLInterface hsql = HSQLInterface.loadHsqldb();

        hsql.runDDLCommand(ddl1);

        String xml = hsql.getXMLFromCatalog();
        System.out.println(xml);
        assertTrue(xml != null);

        hsql.close();
    }
View Full Code Here

Examples of org.hsqldb.HSQLInterface

76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
        String line;
        while ((line = br.readLine()) != null) {
            ddl1 += line + "\n";
        }

        HSQLInterface hsql = HSQLInterface.loadHsqldb();

        hsql.runDDLCommand(ddl1);

        String xml = hsql.getXMLFromCatalog();
        System.out.println(xml);
        assertTrue(xml != null);

        hsql.close();
    }
View Full Code Here

Examples of org.hsqldb.HSQLInterface

44
45
46
47
48
49
50
51
52
53
54
public abstract class CompilerUtil {

    public static AbstractPlanNode compileSQL(final Procedure catalog_proc, String name, String sql) throws Exception {
        VoltCompiler compiler = new VoltCompiler();
        HSQLInterface hsql = HSQLInterface.loadHsqldb();

        Database catalog_db = (Database) catalog_proc.getParent();
        Catalog catalog = catalog_db.getCatalog();
        Statement catalog_stmt = catalog_proc.getStatements().add(name);
View Full Code Here

Examples of org.hsqldb.HSQLInterface

72
73
74
75
76
77
78
79
80
81
82
83
84
85
     * @return
     * @throws Exception
     */
    public static Catalog compileCatalog(String schema_file) throws Exception {

        HSQLInterface hzsql = HSQLInterface.loadHsqldb();
        String xmlSchema = null;
        hzsql.runDDLFile(schema_file);
        xmlSchema = hzsql.getXMLFromCatalog(true);

        //
        // Setup fake database connection. Pass stuff to database to get catalog
        // objects
        //
View Full Code Here

Examples of org.hsqldb.HSQLInterface

307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
        //////////////////////
        // LOAD HSQL
        //////////////////////

        log("creating HSQLInterface");
        HSQLInterface hsql = HSQLInterface.loadHsqldb();
        String hexDDL = db.getSchema();
        String ddl = Encoder.hexDecodeToString(hexDDL);
        String[] commands = ddl.split(";");
        for (String command : commands) {
            command = command.trim();
            if (command.length() == 0)
                continue;
            try {
                hsql.runDDLCommand(command);
            } catch (HSQLParseException e) {
                // need a good error message here
                log("Error creating hsql: " + e.getMessage());
                System.exit(82);
            }
View Full Code Here

Examples of org.hsqldb_voltpatches.HSQLInterface

56
57
58
59
60
61
62
63
64
65
66
67
68
69
            "\"w_zip\" varchar(9) default NULL, " +
            "\"w_tax\" float default NULL, " +
            "PRIMARY KEY  (\"w_id\") " +
            ");";

        HSQLInterface hsql = HSQLInterface.loadHsqldb();

        hsql.runDDLCommand(ddl1);

        VoltXMLElement xml = hsql.getXMLFromCatalog();
        System.out.println(xml);
        assertTrue(xml != null);

    }
View Full Code Here

Examples of org.hsqldb_voltpatches.HSQLInterface

72
73
74
75
76
77
78
79
80
81
82
83
84
        String ddl1 =
            "CREATE TABLE \"warehouse\" ( " +
            "\"w_street_1\" char(32) default NULL, " +
            ");";

        HSQLInterface hsql = HSQLInterface.loadHsqldb();
        try {
            hsql.runDDLCommand(ddl1);
        }
        catch (HSQLParseException e) {
            assertTrue(true);
            return;
        }
View Full Code Here

Examples of org.hsqldb_voltpatches.HSQLInterface

102
103
104
105
106
107
108
109
110
111
112
113
114
115
        while ((line = br.readLine()) != null) {
            ddl1 += line + "\n";
        }

        br.close();
        HSQLInterface hsql = HSQLInterface.loadHsqldb();

        hsql.runDDLCommand(ddl1);

        VoltXMLElement xml = hsql.getXMLFromCatalog();
        System.out.println(xml);
        assertTrue(xml != null);

    }
View Full Code Here

Examples of org.hsqldb_voltpatches.HSQLInterface

122
123
124
125
126
127
128
129
130
131
132
133
134
    //
    // Changes in HSQL's ParserDQL and ParserBase make this more consistent
    //
    public void testENG_912() throws HSQLParseException {
        String schema = "create table tmc (name varchar(32), user varchar(32), primary key (name, user));";
        HSQLInterface hsql = HSQLInterface.loadHsqldb();

        hsql.runDDLCommand(schema);
        VoltXMLElement xml = hsql.getXMLFromCatalog();
        System.out.println(xml);
        assertTrue(xml != null);

    }
View Full Code Here

Examples of org.hsqldb_voltpatches.HSQLInterface

137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
    // Before fixing ENG-2345, the VIEW definition wouldn't compile if it were
    // containing single quote characters.
    //
    public void testENG_2345() throws HSQLParseException {
        String table = "create table tmc (name varchar(32), user varchar(32), primary key (name, user));";
        HSQLInterface hsql = HSQLInterface.loadHsqldb();
        hsql.runDDLCommand(table);

        String view = "create view v (name , user ) as select name , user from tmc where name = 'name';";
        hsql.runDDLCommand(view);

        VoltXMLElement xml = hsql.getXMLFromCatalog();
        System.out.println(xml);
        assertTrue(xml != null);

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