Package org.apache.metamodel.schema

Examples of org.apache.metamodel.schema.MutableTable.addColumn()

227
228
229
230
231
232
233
234
235
236
237
        final MutableTable table = new MutableTable("tab", TableType.TABLE, schema);
        final MutableColumn nameColumn = new MutableColumn("name", ColumnType.VARCHAR).setTable(table);
        final MutableColumn ageColumn = new MutableColumn("age", ColumnType.INTEGER).setTable(table);
        schema.addTable(table);
        table.addColumn(nameColumn);
        table.addColumn(ageColumn);

        final Query q = new Query();
        q.select(ageColumn).selectCount();
        q.from(table);
        q.where(ageColumn, OperatorType.GREATER_THAN, 18);
View Full Code Here
318
319
320
321
322
323
324
325
326
327
328
        MutableTable table = new MutableTable("persons", TableType.TABLE, schema);
        schema.addTable(table);
        final Column col1 = new MutableColumn("name", ColumnType.VARCHAR, table, 1, true);
        final Column col2 = new MutableColumn("role", ColumnType.VARCHAR, table, 2, true);
        final Column col3 = new MutableColumn("column_number", ColumnType.INTEGER, table, 3, true);
        table.addColumn(col1);
        table.addColumn(col2);
        table.addColumn(col3);

        Query q = new Query();
        q.select(col3);
View Full Code Here
319
320
321
322
323
324
325
326
327
328
329
        schema.addTable(table);
        final Column col1 = new MutableColumn("name", ColumnType.VARCHAR, table, 1, true);
        final Column col2 = new MutableColumn("role", ColumnType.VARCHAR, table, 2, true);
        final Column col3 = new MutableColumn("column_number", ColumnType.INTEGER, table, 3, true);
        table.addColumn(col1);
        table.addColumn(col2);
        table.addColumn(col3);

        Query q = new Query();
        q.select(col3);
        q.from(col1.getTable());
View Full Code Here
320
321
322
323
324
325
326
327
328
329
330
        final Column col1 = new MutableColumn("name", ColumnType.VARCHAR, table, 1, true);
        final Column col2 = new MutableColumn("role", ColumnType.VARCHAR, table, 2, true);
        final Column col3 = new MutableColumn("column_number", ColumnType.INTEGER, table, 3, true);
        table.addColumn(col1);
        table.addColumn(col2);
        table.addColumn(col3);

        Query q = new Query();
        q.select(col3);
        q.from(col1.getTable());
View Full Code Here
52
53
54
55
56
57
58
59
60
61
62
    @Override
    protected Schema getMainSchema() throws MetaModelException {

        final MutableSchema schema = new MutableSchema(_schemaName);
        final MutableTable primaryTable = new MutableTable(_tableName).setSchema(schema);
        primaryTable.addColumn(new MutableColumn("foo").setColumnNumber(0).setType(ColumnType.VARCHAR)
                .setTable(primaryTable));
        primaryTable.addColumn(new MutableColumn("bar").setColumnNumber(1).setType(ColumnType.VARCHAR)
                .setTable(primaryTable));
        primaryTable.addColumn(new MutableColumn("baz").setColumnNumber(2).setType(ColumnType.VARCHAR)
                .setTable(primaryTable));
View Full Code Here
54
55
56
57
58
59
60
61
62
63
64
        final MutableSchema schema = new MutableSchema(_schemaName);
        final MutableTable primaryTable = new MutableTable(_tableName).setSchema(schema);
        primaryTable.addColumn(new MutableColumn("foo").setColumnNumber(0).setType(ColumnType.VARCHAR)
                .setTable(primaryTable));
        primaryTable.addColumn(new MutableColumn("bar").setColumnNumber(1).setType(ColumnType.VARCHAR)
                .setTable(primaryTable));
        primaryTable.addColumn(new MutableColumn("baz").setColumnNumber(2).setType(ColumnType.VARCHAR)
                .setTable(primaryTable));

        final MutableTable emptyTable = new MutableTable("an_empty_table").setSchema(schema);
View Full Code Here
56
57
58
59
60
61
62
63
64
65
66
        final MutableTable primaryTable = new MutableTable(_tableName).setSchema(schema);
        primaryTable.addColumn(new MutableColumn("foo").setColumnNumber(0).setType(ColumnType.VARCHAR)
                .setTable(primaryTable));
        primaryTable.addColumn(new MutableColumn("bar").setColumnNumber(1).setType(ColumnType.VARCHAR)
                .setTable(primaryTable));
        primaryTable.addColumn(new MutableColumn("baz").setColumnNumber(2).setType(ColumnType.VARCHAR)
                .setTable(primaryTable));

        final MutableTable emptyTable = new MutableTable("an_empty_table").setSchema(schema);
        emptyTable.addColumn(new MutableColumn("foo").setColumnNumber(0).setType(ColumnType.VARCHAR)
                .setTable(emptyTable));
View Full Code Here
60
61
62
63
64
65
66
67
68
69
70
                .setTable(primaryTable));
        primaryTable.addColumn(new MutableColumn("baz").setColumnNumber(2).setType(ColumnType.VARCHAR)
                .setTable(primaryTable));

        final MutableTable emptyTable = new MutableTable("an_empty_table").setSchema(schema);
        emptyTable.addColumn(new MutableColumn("foo").setColumnNumber(0).setType(ColumnType.VARCHAR)
                .setTable(emptyTable));
        emptyTable.addColumn(new MutableColumn("bar").setColumnNumber(1).setType(ColumnType.VARCHAR)
                .setTable(emptyTable));

        schema.addTable(primaryTable);
View Full Code Here
62
63
64
65
66
67
68
69
70
71
72
                .setTable(primaryTable));

        final MutableTable emptyTable = new MutableTable("an_empty_table").setSchema(schema);
        emptyTable.addColumn(new MutableColumn("foo").setColumnNumber(0).setType(ColumnType.VARCHAR)
                .setTable(emptyTable));
        emptyTable.addColumn(new MutableColumn("bar").setColumnNumber(1).setType(ColumnType.VARCHAR)
                .setTable(emptyTable));

        schema.addTable(primaryTable);
        schema.addTable(emptyTable);
View Full Code Here
32
33
34
35
36
37
38
39
40
41
42
public class AbstractInsertBuilderTest extends TestCase {

  public void testInsertValues() throws Exception {
    final MutableRef<Boolean> executed = new MutableRef<Boolean>(false);
    final MutableTable table = new MutableTable("foo");
    table.addColumn(new MutableColumn("foo"));
    table.addColumn(new MutableColumn("bar"));
    table.addColumn(new MutableColumn("baz"));
    RowInsertionBuilder insertBuilder = new AbstractRowInsertionBuilder<UpdateCallback>(
        null, table) {
      @Override
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.