Package org.apache.metamodel.schema

Examples of org.apache.metamodel.schema.Column

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
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
        assertNotNull(accountTable);

        String[] columnNames = accountTable.getColumnNames();
        System.out.println("Account table columns: " + Arrays.toString(columnNames));

        Column idColumn = accountTable.getColumnByName("Id");
        Column nameColumn = accountTable.getColumnByName("Name");

        assertNotNull(idColumn);
        assertNotNull(nameColumn);

        assertEquals("Column[name=Id,columnNumber=0,type=VARCHAR,nullable=false,nativeType=id,columnSize=18]",
                idColumn.toString());
        assertEquals("id", idColumn.getNativeType());
        assertTrue(idColumn.isPrimaryKey());

        assertEquals("Column[name=Name,columnNumber=3,type=VARCHAR,nullable=false,nativeType=string,columnSize=255]",
                nameColumn.toString());
        assertEquals("string", nameColumn.getNativeType());
        assertFalse(nameColumn.isPrimaryKey());
    }
View Full Code Here
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
        final SelectItem[] selectItems = ds.getSelectItems();
        while (ds.next()) {
            Row row = ds.getRow();

            for (SelectItem selectItem : selectItems) {
                Column column = selectItem.getColumn();
                Object value = row.getValue(column);
                if (value != null) {
                    ColumnType type = column.getType();
                    Class<?> expected = type.getJavaEquivalentClass();
                    Class<? extends Object> actual = value.getClass();
                    assertEquals("Unexpected type of value: " + value + ". Expected " + expected.getName()
                            + " but found " + actual.getName() + ". Native type was: " + column.getNativeType(),
                            expected, actual);
                }
            }
        }
    }
View Full Code Here
86
87
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
    }
    sb.append(getUpdateCallback().quoteIfNescesary(table.getName()));
    sb.append(" (");
    final Column[] columns = table.getColumns();
    for (int i = 0; i < columns.length; i++) {
      final Column column = columns[i];
      if (i != 0) {
        sb.append(", ");
      }
      sb.append(getUpdateCallback().quoteIfNescesary(column.getName()));
      sb.append(' ');
      final String nativeType = column.getNativeType();
      if (nativeType == null) {
        ColumnType columnType = column.getType();
        if (columnType == null) {
          columnType = ColumnType.VARCHAR;
        }

        final String columnTypeString = queryRewriter.rewriteColumnType(columnType);

        sb.append(columnTypeString);
      } else {
        sb.append(nativeType);
      }
      final Integer columnSize = column.getColumnSize();
      if (columnSize != null) {
        sb.append('(');
        sb.append(columnSize.intValue());
        sb.append(')');
      }
      if (column.isNullable() != null && !column.isNullable().booleanValue()) {
        sb.append(" NOT NULL");
      }
      if (column.isPrimaryKey()) {
        sb.append(" PRIMARY KEY");
      }
    }
    sb.append(")");
    return sb.toString();
View Full Code Here
82
83
84
85
86
87
88
89
90
91
92
                List<FilterItem> whereItems = getWhereItems();
                for (FilterItem whereItem : whereItems) {
                    if (JdbcUtils.isPreparedParameterCandidate(whereItem)) {
                        final Object operand = whereItem.getOperand();
                        final Column column = whereItem.getSelectItem().getColumn();
                       
            JdbcUtils.setStatementValue(st, valueCounter, column, operand);
                       
                        valueCounter++;
                    }
View Full Code Here
79
80
81
82
83
84
85
86
87
88
89
90
        assertEquals("bar", row.getValue(1));

        assertEquals(Style.NO_STYLE, row.getStyle(0));
        assertEquals(Style.NO_STYLE, row.getStyle(1));

        Column column = selectItems[0].getColumn();
        assertNotNull(column);
       
        // the columns used to create the object did not have column types assigned.
        ColumnType type = column.getType();
        assertNull(type);
    }
View Full Code Here
132
133
134
135
136
137
138
139
140
141
142
        assertEquals("SELECT COUNT(*) FROM wiki WHERE wiki.name LIKE 'Trac%'", q.toString());
        assertEquals(1, dc.getFetchSizeCalculator().getFetchSize(q));
        assertEquals(37, dc.executeQuery(q).toObjectArrays().get(0)[0]);

        Table permissionTable = schema.getTableByName("PERMISSION");
        Column typeColumn = permissionTable.getColumnByName("username");
        q = new Query().select(typeColumn).selectCount().from(permissionTable).groupBy(typeColumn).orderBy(typeColumn);
        assertEquals(
                "SELECT permission.username, COUNT(*) FROM permission GROUP BY permission.username ORDER BY permission.username ASC",
                q.toString());

View Full Code Here
149
150
151
152
153
154
155
156
157
158
159
160
    public void testQualifiedLabel() throws Exception {
        DataContext dc = new JdbcDataContext(_connection);
        Schema schema = dc.getDefaultSchema();
        Table wikiTable = schema.getTableByName("WIKI");
        assertEquals("wiki", wikiTable.getQualifiedLabel());
        Column nameColumn = wikiTable.getColumnByName("name");
        assertEquals("wiki.name", nameColumn.getQualifiedLabel());

        assertEquals(
                "Column[name=name,columnNumber=0,type=VARCHAR,nullable=true,nativeType=TEXT,columnSize=2000000000]", dc
                        .getColumnByQualifiedLabel("wiki.name").toString());
        assertEquals("Table[name=wiki,type=TABLE,remarks=null]", dc.getTableByQualifiedLabel("WIKI").toString());
View Full Code Here
162
163
164
165
166
167
168
169
170
171
172
    public void testSingleQuoteInQuery() throws Exception {
        JdbcDataContext dc = new JdbcDataContext(_connection);
        Schema schema = dc.getDefaultSchema();
        Table wikiTable = schema.getTableByName("WIKI");
        Column nameColumn = wikiTable.getColumnByName("name");

        Query q = dc.query().from(wikiTable).select(nameColumn).where(nameColumn).isEquals("m'jello").toQuery();
        assertEquals(16384, dc.getFetchSizeCalculator().getFetchSize(q));

        assertEquals("SELECT wiki.name FROM wiki WHERE wiki.name = 'm'jello'", q.toSql());
View Full Code Here
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
            }
        });

        dc.refreshSchemas();

        Column idColumn = dc.getColumnByQualifiedLabel("test_table.id");
        assertTrue(idColumn.isPrimaryKey());

        Column column = dc.getColumnByQualifiedLabel("test_table.birthdate");
        assertFalse(column.isPrimaryKey());

        // the jdbc driver represents the date as a VARCHAR
        assertEquals("Column[name=birthdate,columnNumber=1,type=VARCHAR,nullable=true,"
                + "nativeType=DATE,columnSize=2000000000]", column.toString());

        DataSet ds = dc.query().from("test_table").select("id").and("birthdate").execute();
        assertTrue(ds.next());
        assertEquals("Row[values=[1, null]]", ds.getRow().toString());
        assertEquals("java.lang.Integer", ds.getRow().getValue(0).getClass().getName());
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.