Examples of MutableTable

org.apache.metamodel.schema.MutableTable
Represents the metadata about a table. Tables reside within a schema and contains columns and relationships to other tables. @see Schema @see Column @see Relationship

Examples of org.apache.metamodel.schema.MutableTable

            }


            @Override
            protected Schema getMainSchema() throws MetaModelException {
                MutableSchema schema = new MutableSchema(getMainSchemaName());
                MutableTable table = new MutableTable("tabl").setSchema(schema);
                table.addColumn(new MutableColumn("col1").setTable(table).setPrimaryKey(true));
                table.addColumn(new MutableColumn("col2").setTable(table));
                return schema.addTable(table);
            }
        };


        DataSet result = dc.query().from("tabl").select("col2").where("col1").eq("foo").execute();

View Full Code Here

Examples of org.apache.metamodel.schema.MutableTable

    protected Schema getMainSchema() throws MetaModelException {
        if (_schema == null) {
            MutableSchema schema = new MutableSchema(getMainSchemaName());
            for (SimpleTableDef tableDef : _tableDefs) {


                MutableTable table = tableDef.toTable().setSchema(schema);
                Column[] rowIdColumns = table.getColumnsOfType(ColumnType.ROWID);
                for (Column column : rowIdColumns) {
                    if (column instanceof MutableColumn) {
                        ((MutableColumn) column).setPrimaryKey(true);
                    }
                }

View Full Code Here

Examples of org.apache.metamodel.schema.MutableTable

  @Override
  public Table execute() throws MetaModelException {
    final MongoDbDataContext dataContext = getUpdateCallback()
        .getDataContext();
    final Schema schema = dataContext.getDefaultSchema();
    final MutableTable table = getTable();
    if (table.getColumnByName("_id") == null) {
      // all mongo db collections have an _id field as the first field.
      ImmutableColumn idColumn = new ImmutableColumn("_id",
          ColumnType.ROWID, table, table.getColumnCount(), null,
          null, null, null, true, null, true);
      table.addColumn(idColumn);
    }
    table.setSchema(schema);
    getUpdateCallback().createCollection(table.getName());
    dataContext.addTable(table);
    return table;
  }

View Full Code Here

Examples of org.apache.metamodel.schema.MutableTable

            }
        };


        assertFalse(executed.get().booleanValue());


        MutableTable likeTable = new MutableTable("blablablabla");
        likeTable.addColumn(new MutableColumn("foo", ColumnType.VARCHAR, likeTable, 0, 1234, "vch", true, null, false,
                null).setPrimaryKey(true));
        likeTable.addColumn(new MutableColumn("bar"));
        likeTable.addColumn(new MutableColumn("baz"));


        builder.like(likeTable);
        Table table = builder.execute();


        assertTrue(executed.get().booleanValue());

View Full Code Here

Examples of org.apache.metamodel.schema.MutableTable

        }
    }


    public void testEqualsAndHashCode() throws Exception {
        MutableSchema schema = new MutableSchema("schema");
        MutableTable table = new MutableTable("table").setSchema(schema);
        schema.addTable(table);


        Column col1 = new MutableColumn("col1").setTable(table);
        Column col2 = new MutableColumn("col2").setTable(table);
        Column col3 = new MutableColumn("col3").setTable(table);
        table.addColumn(col1);
        table.addColumn(col2);
        table.addColumn(col3);


        Query q1 = new Query().select(col1, col2).from(table).where(col3, OperatorType.EQUALS_TO, "m'jello");


        Query q2 = new InitFromBuilderImpl(null).from(table).select(col1).and(col2).where(col3).eq("m'jello").toQuery();

View Full Code Here

Examples of org.apache.metamodel.schema.MutableTable

        assertEquals("SELECT id AS innerIdColumn GROUP BY id HAVING COUNT(id) = 2", q.toSql());
    }


    public void testToSqlWithFullyQualifiedColumnNames() throws Exception {
        final MutableSchema schema = new MutableSchema("sch");
        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

Examples of org.apache.metamodel.schema.MutableTable

import junit.framework.TestCase;


public class SelectClauseTest extends TestCase {


  public void testDistinctAddition() throws Exception {
    Table table = new MutableTable("foo");
    Column col = new MutableColumn("bar").setTable(table);


    Query q = new Query();
    q.selectDistinct();
    q.from(table);

View Full Code Here

Examples of org.apache.metamodel.schema.MutableTable

    // Ticket #410
    public void testOrFilterItemWithoutSelectingActualItmes() throws Exception {


        // define the schema
        final MutableSchema schema = new MutableSchema("s");
        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);
        q.from(col1.getTable());

View Full Code Here

Examples of org.apache.metamodel.schema.MutableTable


    @Before
    public void setup() {
        query = new Query();


        MutableTable datastoreTable = new MutableTable("datastore", TableType.TABLE);


        MutableColumn dataSourceIdColumn = new MutableColumn("dataSourceIdColumn", ColumnType.VARCHAR);
        MutableColumn dataSourceNameColumn = new MutableColumn("dataSourceNameColumn", ColumnType.VARCHAR);
        MutableColumn versionColumn = new MutableColumn("versionColumn", ColumnType.INTEGER);
        MutableColumn changeSetColumn = new MutableColumn("changeSetColumn", ColumnType.INTEGER);

View Full Code Here

Examples of org.apache.metamodel.schema.MutableTable


    @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));


        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

0 1 2 3 4 5

TOP

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.