Package org.apache.metamodel.schema

Examples of org.apache.metamodel.schema.MutableColumn

235
236
237
238
239
240
241
242
243
244
245
246
247
248
                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
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
    }

    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
849
850
851
852
853
854
855
856
857
858
859
            @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
887
888
889
890
891
892
893
894
895
896
897
898
            @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
80
81
82
83
84
85
86
87
88
89
90
91
92
93
        };

        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
193
194
195
196
197
198
199
200
201
202
203
204
205
    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
208
209
210
211
212
213
214
215
216
217
218
        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
223
224
225
226
227
228
229
230
231
232
233
234
    }

    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
27
28
29
30
31
32
33
34
35
36
37
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
55
56
57
58
59
60
61
62
63
64
65
            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
TOP

Related Classes of org.apache.metamodel.schema.MutableColumn

  • org.apache.metamodel.AbstractDataContextTest
  • org.apache.metamodel.couchdb.CouchDbTableCreationBuilder
  • org.apache.metamodel.create.AbstractCreateTableBuilderTest
  • org.apache.metamodel.create.AbstractTableCreationBuilder
  • org.apache.metamodel.create.CreateTable
  • org.apache.metamodel.csv.CsvDataContextTest
  • org.apache.metamodel.csv.CsvTable
  • org.apache.metamodel.data.DataSetTableModelTest
  • org.apache.metamodel.data.DefaultRowTest
  • org.apache.metamodel.data.RowPublisherDataSetTest
    • 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.