Examples of MutableColumn

org.apache.metamodel.schema.MutableColumn
Represents a column and it's metadata description. Columns reside within a Table and can be used as keys for relationships between tables. @see MutableTable @see Relationship

Examples of org.apache.metamodel.schema.MutableColumn

                MutableSchema schema = new MutableSchema("sch");
                MutableTable table1 = new MutableTable("tab");
                MutableTable table2 = new MutableTable("tab_le");
                MutableTable table3 = new MutableTable("table");
                MutableTable table4 = new MutableTable("tabl_e");
                schema.addTable(table1.addColumn(new MutableColumn("col").setTable(table1)));
                schema.addTable(table2.addColumn(new MutableColumn("col").setTable(table2)));
                schema.addTable(table3.addColumn(new MutableColumn("col").setTable(table3)));
                schema.addTable(table4.addColumn(new MutableColumn("col").setTable(table4)));
                return schema;
            }


            @Override
            protected String getDefaultSchemaName() {

View Full Code Here

Examples of org.apache.metamodel.schema.MutableColumn

    }


    private Schema createSchema(String name) {
        MutableSchema schema = new MutableSchema(name);
        MutableTable t1 = new MutableTable("table");
        MutableColumn col1 = new MutableColumn("col1");
        MutableColumn col2 = new MutableColumn("col2");
        t1.addColumn(col1).addColumn(col2);
        col1.setTable(t1);
        col2.setTable(t1);
        MutableTable t2 = new MutableTable("tab.le");
        MutableColumn col3 = new MutableColumn("col3");
        MutableColumn col4 = new MutableColumn("col4");
        t2.addColumn(col3).addColumn(col4);
        col3.setTable(t2);
        col4.setTable(t2);
        schema.addTable(t1).addTable(t2);
        t1.setSchema(schema);
        t2.setSchema(schema);
        return schema;
    }

View Full Code Here

Examples of org.apache.metamodel.schema.MutableColumn


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


        DataSet ds = dc.query().from("sch.tabl").selectCount().execute();
        assertTrue(ds.next());

View Full Code Here

Examples of org.apache.metamodel.schema.MutableColumn


            @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.MutableColumn

        };


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

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

View Full Code Here

Examples of org.apache.metamodel.schema.MutableColumn


        assertEquals(q1, q2);
    }


    public void testHavingClauseReferencingFunctionAndOperand() throws Exception {
        MutableColumn idColumn = new MutableColumn("id", ColumnType.VARCHAR);
        SelectItem countSelectItem = new SelectItem(FunctionType.COUNT, idColumn);
        SelectItem idSelectItem = new SelectItem(idColumn).setAlias("innerIdColumn");


        Query q = new Query();
        q.select(idSelectItem);

View Full Code Here

Examples of org.apache.metamodel.schema.MutableColumn

    }


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

View Full Code Here

Examples of org.apache.metamodel.schema.MutableColumn


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);
    q.select(col);

View Full Code Here

Examples of org.apache.metamodel.schema.MutableColumn

            fail("Exception should have been thrown");
        } catch (Exception e) {
            assertEquals("Expression-based filters cannot be manually evaluated", e.getMessage());
        }


        Column col1 = new MutableColumn("Col1", ColumnType.VARCHAR);
        assertEquals("SELECT Col1 WHERE foobar", new Query().select(col1).where(filterItem).toString());


        assertEquals("SELECT Col1 WHERE YEAR(Col1) = 2008", new Query().select(col1).where("YEAR(Col1) = 2008")
                .toString());
    }

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.