Package com.redspr.redquerybuilder.core.shared.meta

Examples of com.redspr.redquerybuilder.core.shared.meta.Table

83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
        Type dateType = new Type("DATE");
        dateType.setEditor(new Editor.DateEditor());
        Type[] types = new Type[]{stringType, dateType, refType, singleRefType};
        database.setTypes(types);

        Table person = new Table("PERSON"); // XXX want case sensitivity?
        Column personId = new Column("id", stringType);
        person.add(personId);
        person.add(new Column("sex", singleRefType));
        person.add(new Column("owner", stringType));
        person.add(new Column("category", refType));
        person.add(new Column("category2", refType));
        person.add(new Column("county", suggestType));
        schema.add(person);

        {
            Table log = new Table("Log");
            log.add(new Column("id", stringType));
            log.add(new Column("date", dateType));
            Column pc = new Column("parent", stringType);
            ConstraintReferential fk = new ConstraintReferential("parentfk",
                    log);
            fk.setRefTable(person);
            fk.setColumns(new Column[] {pc });
            fk.setRefColumns(new Column[] {personId });
            log.add(fk);
            log.add(pc);

            schema.add(log);
        }

        {
            Table order = new Table("Order");
            order.add(new Column("date", dateType));
            Column pc = new Column("parent", stringType);
            ConstraintReferential fk = new ConstraintReferential("orderparentfk",
                    order);
            fk.setRefTable(person);
            fk.setColumns(new Column[] {pc });
            fk.setRefColumns(new Column[] {personId });
            order.add(fk);
            order.add(pc);

            schema.add(order);
        }

        if (config == null) {
View Full Code Here
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
    public void testSelectAndThenReverseJoin() throws Exception {
        Session s = getSession();
        s.getDatabase().getMainSchema().addReverseConstraints();
        CommandBuilder cb = new CommandBuilder(s);

        Table log = s.getDatabase().getMainSchema().findTableOrView("Log");
        ConstraintReferential logToPerson = (ConstraintReferential) log
                .getConstraintByName("parentfk");

        Table person = s.getDatabase().getMainSchema().findTableOrView("PERSON");
        ConstraintReferential personToLog = (ConstraintReferential) person
                .getConstraintByName("Rev parentfk");

        cb.getSelect().updateTable(log);
        cb.fireDirty();
View Full Code Here
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
    @Test
    public void testAddThirdDuplicateJoin() throws Exception {
        Session s = getSession();
        CommandBuilder cb = new CommandBuilder(s);

        Table person = s.getDatabase().getMainSchema().findTableOrView("PERSON");

        s.getDatabase().getMainSchema().addReverseConstraints();
        cb.getSelect().updateTable(person);

        JoinHelper.getOrCreateFor(s, (ConstraintReferential) person.getConstraints().get(0));
        TableFilter b = JoinHelper.getOrCreateFor(s, (ConstraintReferential) person.getConstraints().get(1));
        assertTrue(b.getJoin() == null);
        TableFilter c = JoinHelper.getOrCreateFor(s, (ConstraintReferential) person.getConstraints().get(1));
        assertTrue(b == c);
    }
View Full Code Here
430
431
432
433
434
435
436
437
438
439
440
                expr.add(new ExpressionColumn(s, null, alias, "id"));
                cb.getSelect().setExpressions(expr);
            }
        });

        Table person = s.getDatabase().getMainSchema().findTableOrView("PERSON");

        cb.getSelect().updateTable(person);

        assertEquals(
                "SELECT x0.id\nFROM PERSON x0",
View Full Code Here
470
471
472
473
474
475
476
477
478
479
480
    private Prepared parseInsert() throws SQLException {
       return null;
    }

    private TableFilter readTableFilter(boolean fromOuter) throws SQLException {
        Table table;
        String alias = null;
//        if (readIf("(")) {
//            if (isToken("SELECT") || isToken("FROM")) {
//                int start = lastParseIndex;
//                int paramIndex = parameters.size();
View Full Code Here
928
929
930
931
932
933
934
935
936
937
938
        } else {
            parseSelectSimpleSelectPart(command);
            if (!readIf("FROM")) {
                // select without FROM: convert to SELECT ... FROM
                // SYSTEM_RANGE(1,1)
                Table dual = getDualTable();
                TableFilter filter = new TableFilter(session, dual, null, currentSelect);
                command.addTableFilter(filter, true);
            } else {
              //  Window.alert("parseSelectSimple D");
                parseSelectSimpleFromPart(command);
View Full Code Here
2769
2770
2771
2772
2773
2774
2775
2776
2777
2778
2779
    private Table readTableOrView(String tableName) throws SQLException {
//        // same algorithm than readSequence
//        if (schemaName != null) {
//            return getSchema().getTableOrView(session, tableName);
//        }
        Table table = database.getMainSchema(
                //session.getCurrentSchemaName()
                ).findTableOrView(tableName);
        if (table != null) {
            return table;
        }
View Full Code Here
2817
2818
2819
2820
2821
2822
2823
2824
2825
2826
2827
2828
2829
//        }
        throw Message.getSQLException(ErrorCode.SEQUENCE_NOT_FOUND_1, "sequenceName");
    }

    private Prepared parseAlterTable() throws SQLException {
        Table table = readTableOrView();
        if (readIf("ADD")) {
            Prepared command = parseAlterTableAddConstraintIf(table.getName(), table.getSchema());
            if (command != null) {
                return command;
            }
            return parseAlterTableAddColumn(table);
        } else if (readIf("SET")) {
View Full Code Here
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
        database.setTypes(types);

        for (int i = 0; i < meta.getTables().length(); i++) {
            JsTable jst = meta.getTables().get(i);
            Table t = new Table(jst.getName());
            t.setLabel(jst.getLabel());
            for (int j = 0; j < jst.getColumns().length(); j++) {
                JsColumn jsColumn = jst.getColumns().get(j);
                Column c = new Column(jsColumn.getName(), database.getTypeByName(jsColumn
                        .getType()));
                c.setLabel(jsColumn.getLabel());
                if (jsColumn.getEditor() != null) {
                    c.setEditor(Editor.valueOf(jsColumn.getEditor()));
                }
                c.setStyleName(jsColumn.getStyleName());
                t.add(c);
            }
            database.getMainSchema().add(t);
        }

        for (int i = 0; i < meta.getTables().length(); i++) {
            JsTable jst = meta.getTables().get(i);

            Table pkTable = database.getMainSchema().findTableOrView(
                    jst.getName());
            JsArray<JsFk> fks = jst.getFks();
            for (int j = 0; j < fks.length(); j++) {
                JsFk jsfk = fks.get(j);
                Table fkTable = database.getMainSchema().findTableOrView(
                        jsfk.getReferencedTableName());

                ConstraintReferential fk = new ConstraintReferential(
                        jsfk.getName(), pkTable);
                fk.setLabel(jsfk.getLabel());

                fk.setRefTable(fkTable);
                fk.setColumns(createColumns(pkTable, jsfk.getForeignKeyNames()));
                fk.setRefColumns(createColumns(fkTable, jsfk.getReferencedKeyNames()));
                pkTable.add(fk);

                ConstraintReferential fkr = new ConstraintReferential(
                        jsfk.getName() + ".reverse", fkTable);
                fkr.setLabel(jsfk.getReverseLabel());

                fkr.setRefTable(pkTable);
                fkr.setColumns(createColumns(fkTable, jsfk.getReferencedKeyNames())); // XXX
                                                                       // already
                                                                       // done
                                                                       // this
                fkr.setRefColumns(createColumns(pkTable, jsfk.getForeignKeyNames())); // XXX
                                                                          // already
                                                                          // done
                                                                          // this
                fkTable.add(fkr);
            }
        }
    }
View Full Code Here
TOP

Related Classes of com.redspr.redquerybuilder.core.shared.meta.Table

  • com.redspr.redquerybuilder.core.client.AbstractTest
  • com.redspr.redquerybuilder.core.client.command.Parser
  • com.redspr.redquerybuilder.core.client.GwtTestBasics
  • com.redspr.redquerybuilder.js.client.ConfigurationAdapter
    • Copyright © 2018 www.massapicom. 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.