Examples of MutableColumn

Examples of org.apache.metamodel.schema.MutableColumn

380
381
382
383
384
385
386
387
388
389
390
        assertEquals(4, objectArrays.get(1)[0]);
        assertEquals(5, objectArrays.get(2)[0]);
    }

    public void testInOperandSql() throws Exception {
        SelectItem selectItem = new SelectItem(new MutableColumn("foo", ColumnType.VARCHAR, null, 1, null, null, true,
                null, false, null));
        Object operand = new String[] { "foo", "bar" };
        assertEquals("foo IN ('foo' , 'bar')", new FilterItem(selectItem, OperatorType.IN, operand).toSql());

        operand = Arrays.asList("foo", "bar", "baz");
View Full Code Here

Examples of org.apache.metamodel.schema.MutableColumn

396
397
398
399
400
401
402
403
404
405
406
        operand = new ArrayList<Object>();
        assertEquals("foo IN ()", new FilterItem(selectItem, OperatorType.IN, operand).toSql());
    }

    public void testInOperandEvaluate() throws Exception {
        SelectItem selectItem = new SelectItem(new MutableColumn("foo", ColumnType.VARCHAR, null, 1, null, null, true,
                null, false, null));
        Object operand = new String[] { "foo", "bar" };

        FilterItem filterItem = new FilterItem(selectItem, OperatorType.IN, operand);
        SelectItem[] selectItems = new SelectItem[] { selectItem };
View Full Code Here

Examples of org.apache.metamodel.schema.MutableColumn

34
35
36
37
38
39
40
41
42
43
44
45
46
47
    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);

        SelectItem countSelectItem = new SelectItem(FunctionType.COUNT, dataSourceIdColumn);
        SelectItem dsIdSelectItem = new SelectItem(dataSourceIdColumn).setAlias("innerDataSourceRecordId");
        Query leftQuery = new Query();
        leftQuery.select(dsIdSelectItem);
View Full Code Here

Examples of org.apache.metamodel.schema.MutableColumn

90
91
92
93
94
95
96
97
98
    public void testGetSuperQueryAlias() throws Exception {
        SelectItem item = new SelectItem(FunctionType.COUNT, "*", "").setAlias(null);
        assertEquals("COUNT(*)", item.getSameQueryAlias());
        assertEquals("COUNT(*)", item.getSuperQueryAlias());
       
        item = new SelectItem(FunctionType.SUM, new MutableColumn("foo"));
        assertEquals("SUM(foo)", item.getSameQueryAlias());
        assertEquals("SUM(foo)", item.getSuperQueryAlias());
    }
View Full Code Here

Examples of org.apache.metamodel.schema.MutableColumn

52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
    @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

Examples of org.apache.metamodel.schema.MutableColumn

88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
     */
    protected Schema getExampleSchema() {
        MutableSchema schema = new MutableSchema("MetaModelSchema");

        MutableTable table1 = new MutableTable(TABLE_CONTRIBUTOR, TableType.TABLE, schema);
        Column column1 = new MutableColumn(COLUMN_CONTRIBUTOR_CONTRIBUTOR_ID, ColumnType.INTEGER, table1, 0, false)
                .setIndexed(true).setPrimaryKey(true);
        Column column2 = new MutableColumn(COLUMN_CONTRIBUTOR_NAME, ColumnType.VARCHAR, table1, 1, false);
        Column column3 = new MutableColumn(COLUMN_CONTRIBUTOR_COUNTRY, ColumnType.VARCHAR, table1, 2, true);
        table1.setColumns(column1, column2, column3);

        MutableTable table2 = new MutableTable(TABLE_PROJECT, TableType.TABLE, schema);
        Column column4 = new MutableColumn(COLUMN_PROJECT_PROJECT_ID, ColumnType.INTEGER, table2, 0, false)
                .setPrimaryKey(true);
        Column column5 = new MutableColumn(COLUMN_PROJECT_NAME, ColumnType.VARCHAR, table2, 1, false);
        Column column6 = new MutableColumn(COLUMN_PROJECT_LINES_OF_CODE, ColumnType.BIGINT, table2, 2, true);
        Column column7 = new MutableColumn(COLUMN_PROJECT_PARENT_PROJECT_ID, ColumnType.INTEGER, table2, 3, true);
        table2.setColumns(column4, column5, column6, column7);

        MutableTable table3 = new MutableTable(TABLE_ROLE, TableType.TABLE, schema);
        Column column8 = new MutableColumn(COLUMN_ROLE_CONTRIBUTOR_ID, ColumnType.INTEGER, table3, 0, false)
                .setPrimaryKey(true);
        Column column9 = new MutableColumn(COLUMN_ROLE_PROJECT_ID, ColumnType.INTEGER, table3, 1, false)
                .setPrimaryKey(true);
        Column column10 = new MutableColumn(COLUMN_ROLE_ROLE_NAME, ColumnType.VARCHAR, table3, 2, false);
        table3.setColumns(column8, column9, column10);

        MutableTable table4 = new MutableTable(TABLE_PROJECT_CONTRIBUTOR, TableType.VIEW, schema);
        Column column11 = new MutableColumn(COLUMN_PROJECT_CONTRIBUTOR_CONTRIBUTOR, ColumnType.VARCHAR, table4, 0,
                false);
        Column column12 = new MutableColumn(COLUMN_PROJECT_CONTRIBUTOR_PROJECT, ColumnType.VARCHAR, table4, 1, false);
        Column column13 = new MutableColumn(COLUMN_PROJECT_CONTRIBUTOR_ROLE, ColumnType.VARCHAR, table4, 2, false);
        ArrayList<Column> columnList = new ArrayList<Column>();
        columnList.add(column11);
        columnList.add(column12);
        columnList.add(column13);
        table4.setColumns(columnList);
View Full Code Here

Examples of org.apache.metamodel.schema.MutableColumn

101
102
103
104
105
106
107
108
109
110
111
                        final String name = SugarCrmXmlHelper.getChildElementText(node, "name");
                        final String nativeType = SugarCrmXmlHelper.getChildElementText(node, "type");
                        final String remarks = SugarCrmXmlHelper.getChildElementText(node, "label");
                        final ColumnType columnType = convertToColumnType(nativeType);

                        final Column column = new MutableColumn(name, columnType).setNativeType(nativeType)
                                .setRemarks(remarks).setTable(SugarCrmTable.this);
                        result.add(column);
                    }
                }
                return result;
View Full Code Here

Examples of org.apache.metamodel.schema.MutableColumn

355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
        final Date date = DateUtils.get(2013, Month.JANUARY, 23);
        final Timestamp dateTime = new Timestamp(0l);

        final List<FilterItem> children = new ArrayList<FilterItem>();
        children.add(new FilterItem(new SelectItem(new MutableColumn("foo")), OperatorType.EQUALS_TO, "hello\n 'world'"));
        children.add(new FilterItem(new SelectItem(new MutableColumn("bar")), OperatorType.EQUALS_TO, 123));
        children.add(new FilterItem(new SelectItem(new MutableColumn("baz").setType(ColumnType.DATE)),
                OperatorType.EQUALS_TO, date));
        children.add(new FilterItem(new SelectItem(new MutableColumn("saz").setType(ColumnType.TIMESTAMP)),
                OperatorType.EQUALS_TO, dateTime));

        final FilterItem filterItem = new FilterItem(children);

        SalesforceDataContext.rewriteFilterItem(sb, filterItem);
View Full Code Here

Examples of org.apache.metamodel.schema.MutableColumn

55
56
57
58
59
60
61
62
63
64
        _values.add(new Object[] { "1", "hello" });
        _values.add(new Object[] { "2", "there" });
        _values.add(new Object[] { "3", "world" });

        _table = new MutableTable("table");
        _table.addColumn(new MutableColumn("foo", ColumnType.VARCHAR).setTable(_table).setColumnNumber(0));
        _table.addColumn(new MutableColumn("bar", ColumnType.VARCHAR).setTable(_table).setColumnNumber(1));
        _schema = new MutableSchema("schema", _table);
        _table.setSchema(_schema);
    }
View Full Code Here

Examples of org.apache.metamodel.schema.MutableColumn

26
27
28
29
30
31
32
33
34
35
36
37
public class RowPublisherDataSetTest extends TestCase {

  public void testMaxSize() throws Exception {
    SelectItem[] selectItems = new SelectItem[2];
    selectItems[0] = new SelectItem(new MutableColumn("foos"));
    selectItems[1] = new SelectItem(new MutableColumn("bars"));
    DataSet ds = new RowPublisherDataSet(selectItems, 5,
        new Action<RowPublisher>() {
          @Override
          public void run(RowPublisher publisher) throws Exception {
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.