Package org.apache.metamodel.schema

Examples of org.apache.metamodel.schema.Column

87
88
89
90
91
92
93
94
95
96
97
98
                q.toString());
    }

    public void testAddOrderBy() throws Exception {
        Table contributorTable = _schema.getTableByName(TABLE_CONTRIBUTOR);
        Column nameColumn = contributorTable.getColumnByName(COLUMN_CONTRIBUTOR_NAME);
        Column countryColumn = contributorTable.getColumnByName(COLUMN_CONTRIBUTOR_COUNTRY);
        FromItem fromContributor = new FromItem(contributorTable);
        fromContributor.setAlias("a");

        Query q = new Query();
        q.select(nameColumn, countryColumn).from(fromContributor).orderBy(nameColumn)
View Full Code Here
107
108
109
110
111
112
113
114
115
116
117
118
119
        Table contributorTable = _schema.getTableByName(TABLE_CONTRIBUTOR);
        Table roleTable = _schema.getTableByName(TABLE_ROLE);
        FromItem fromItem = new FromItem(JoinType.INNER, contributorTable.getRelationships(roleTable)[0]);
        q1.from(fromItem);

        Column nameColumn = contributorTable.getColumnByName(COLUMN_CONTRIBUTOR_NAME);
        Column countryColumn = contributorTable.getColumnByName(COLUMN_CONTRIBUTOR_COUNTRY);
        Column roleNameColumn = roleTable.getColumnByName(COLUMN_ROLE_ROLE_NAME);
        q1.select(nameColumn, countryColumn, roleNameColumn);
        q1.orderBy(roleNameColumn);
        String q1string = q1.toString();
        assertEquals(
                "SELECT contributor.name, contributor.country, role.name FROM MetaModelSchema.contributor INNER JOIN MetaModelSchema.role ON contributor.contributor_id = role.contributor_id ORDER BY role.name ASC",
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
61
62
63
64
65
66
67
68
69
70
71
  public void testSubQueryJoinToString() throws Exception {
    Table projectTable = _schema.getTableByName(TABLE_PROJECT);
    Table roleTable = _schema.getTableByName(TABLE_ROLE);

    Column projectIdColumn = projectTable
        .getColumnByName(COLUMN_PROJECT_PROJECT_ID);

    FromItem leftSide = new FromItem(projectTable);
    leftSide.setAlias("a");
    SelectItem[] leftOn = new SelectItem[] { new SelectItem(projectIdColumn) };
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
98
99
100
101
102
103
104
105
106
107
108
109
110
111
        assertEquals("Col1 = 423426235423.42", c.toString());

        c = new FilterItem(selectItem, OperatorType.EQUALS_TO, true);
        assertEquals("Col1 = 1", c.toString());

        Column timeColumn = new MutableColumn("TimeCol", ColumnType.TIME);
        selectItem = new SelectItem(timeColumn);
        c = new FilterItem(selectItem, OperatorType.GREATER_THAN, "02:30:05.000");
        assertEquals("TimeCol > TIME '02:30:05'", c.toString());

        Column dateColumn = new MutableColumn("DateCol", ColumnType.DATE);
        c = new FilterItem(new SelectItem(dateColumn), OperatorType.GREATER_THAN, "2000-12-31");
        assertEquals("DateCol > DATE '2000-12-31'", c.toString());
    }
View Full Code Here
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
        c = new FilterItem(new SelectItem(dateColumn), OperatorType.GREATER_THAN, "2000-12-31");
        assertEquals("DateCol > DATE '2000-12-31'", c.toString());
    }

    public void testToStringTimeStamp() throws Exception {
        Column timestampColumn = new MutableColumn("TimestampCol", ColumnType.TIMESTAMP);
        FilterItem c = new FilterItem(new SelectItem(timestampColumn), OperatorType.LESS_THAN,
                "2000-12-31 02:30:05.007");
        assertEquals("TimestampCol < TIMESTAMP '2000-12-31 02:30:05'", c.toString());

        c = new FilterItem(new SelectItem(timestampColumn), OperatorType.LESS_THAN, "2000-12-31 02:30:05");
        assertEquals("TimestampCol < TIMESTAMP '2000-12-31 02:30:05'", c.toString());

        Column dateColumn = new MutableColumn("DateCol", ColumnType.DATE);
        c = new FilterItem(new SelectItem(timestampColumn), OperatorType.GREATER_THAN, new SelectItem(dateColumn));
        assertEquals("TimestampCol > DateCol", c.toString());
    }
View Full Code Here
123
124
125
126
127
128
129
130
131
132
133
134
        c = new FilterItem(new SelectItem(timestampColumn), OperatorType.GREATER_THAN, new SelectItem(dateColumn));
        assertEquals("TimestampCol > DateCol", c.toString());
    }

    public void testEvaluateStrings() throws Exception {
        Column col1 = new MutableColumn("Col1", ColumnType.VARCHAR);
        Column col2 = new MutableColumn("Col2", ColumnType.VARCHAR);
        SelectItem s1 = new SelectItem(col1);
        SelectItem s2 = new SelectItem(col2);
        SelectItem[] selectItems = new SelectItem[] { s1, s2 };
        SimpleDataSetHeader header = new SimpleDataSetHeader(selectItems);
        Row row;
View Full Code Here
156
157
158
159
160
161
162
163
164
165
166
167
        row = new DefaultRow(header, new Object[] { "foobbdbafsdfr", "fo%b%r" });
        assertTrue(c.evaluate(row));
    }

    public void testEvaluateNull() throws Exception {
        Column col1 = new MutableColumn("Col1", ColumnType.INTEGER);
        Column col2 = new MutableColumn("Col2", ColumnType.DECIMAL);
        SelectItem s1 = new SelectItem(col1);
        SelectItem s2 = new SelectItem(col2);
        SelectItem[] selectItems = new SelectItem[] { s1, s2 };
        CachingDataSetHeader header = new CachingDataSetHeader(selectItems);
View Full Code Here
TOP

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

  • org.apache.metamodel.AbstractDataContext
  • org.apache.metamodel.AbstractDataContextTest
  • org.apache.metamodel.convert.ConvertedDataSetInterceptor
  • org.apache.metamodel.convert.ConvertedDataSetInterceptorTest
  • org.apache.metamodel.convert.ConvertedRowInsertionInterceptorTest
  • org.apache.metamodel.convert.Converters
  • org.apache.metamodel.couchdb.CouchDbDataContextTest
  • org.apache.metamodel.couchdb.CouchDbInsertionBuilder
  • org.apache.metamodel.couchdb.CouchDbRowUpdationBuilder
  • org.apache.metamodel.create.AbstractTableCreationBuilder
    • 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.