Package org.teiid.metadata

Examples of org.teiid.metadata.Column

285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
    private List<Object[]> extractDataFromFields(SObject sObject,
      List<Object> fields, List<Object[]> result) throws TranslatorException {
      Map<String,Integer> fieldToIndexMap = sObjectToResponseField.get(sObject.getType());
      for (int j = 0; j < visitor.getSelectSymbolCount(); j++) {
        Column element = visitor.getSelectSymbolMetadata(j);
        Table table = (Table)element.getParent();
        if(table.getNameInSource().equals(sObject.getType())) {
          Integer index = fieldToIndexMap.get(element.getNameInSource());
          // id gets dropped from the result if it is not the
          // first field in the querystring. Add it back in.
          if (null == index) {
            if (element.getNameInSource().equalsIgnoreCase("id")) { //$NON-NLS-1$
              setValueInColumn(j, sObject.getId(), result);
            } else {
              throw new TranslatorException(SalesForcePlugin.Util.getString("SalesforceQueryExecutionImpl.missing.field")+ element.getNameInSource()); //$NON-NLS-1$
            }
          } else {
            Object cell;
            cell = getCellDatum(element, (Element)fields.get(index));
            setValueInColumn(j, cell, result);
View Full Code Here
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
        Class<?> javaType, int length, NullType nullable, int position, SearchType searchable,
        boolean autoIncrement, boolean caseSensitive, Map<String, String> expectedProps,
        String modeledType, String modeledBaseType, String modeledPrimitiveType)
    throws Exception {
           
        Column element = getElement(fullGroupName, elementShortName, transUtil);          
        assertEquals(nameInSource, element.getNameInSource());
        assertEquals(defaultValue, element.getDefaultValue());
        assertEquals(minValue, element.getMinimumValue());
        assertEquals(maxValue, element.getMaximumValue());
        assertEquals(javaType, element.getJavaType());
        assertEquals(length, element.getLength());
        assertEquals(nullable, element.getNullType());
        assertEquals(position + 1, element.getPosition());
        assertEquals(searchable, element.getSearchType());
        assertEquals(autoIncrement, element.isAutoIncremented());
        assertEquals(caseSensitive, element.isCaseSensitive());     
       
//System.out.println("\n" + element.getModeledType() + "\n" + element.getModeledBaseType() + "\n" + element.getModeledPrimitiveType());       

        assertEquals(modeledType, element.getDatatypeID());
        assertEquals(modeledBaseType, element.getBaseTypeID());
        assertEquals(modeledPrimitiveType, element.getPrimitiveTypeID());
       
              
        Map<String, String> extProps = element.getProperties();
        assertEquals(expectedProps, extProps);
    }
View Full Code Here
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
        checkParams(proc, nameInSource, direction, index, type);
       
        List<Column> rsCols = proc.getResultSet().getColumns();
        // Check first column of result set
        assertEquals(2, rsCols.size());
        Column elemID = rsCols.get(0);
        assertEquals("RSCol1", elemID.getName());         //$NON-NLS-1$
        assertEquals("ConnectorMetadata.TestProc2.RSParam.RSCol1", elemID.getFullName());         //$NON-NLS-1$
        assertEquals("Result set column name in source", elemID.getNameInSource());         //$NON-NLS-1$
        assertEquals(java.sql.Timestamp.class, elemID.getJavaType());
        assertEquals(1, elemID.getPosition());
       
        Column elemID2 = rsCols.get(1);       
        assertEquals("RSCol2", elemID2.getName());         //$NON-NLS-1$
        assertEquals("ConnectorMetadata.TestProc2.RSParam.RSCol2", elemID2.getFullName());         //$NON-NLS-1$
        assertEquals(null, elemID2.getNameInSource());        
        assertEquals(String.class, elemID2.getJavaType());
        assertEquals(2, elemID2.getPosition());
        Properties props = new Properties();
        props.put("ColProp", "defaultvalue"); //$NON-NLS-1$ //$NON-NLS-2$
       
        // failing because default extension properties aren't in the VDB file
        //assertEquals(props, e2.getProperties());
View Full Code Here
92
93
94
95
96
97
98
99
100
101
102
        ColumnReference element = (ColumnReference) symbol.getExpression();
        return element.getMetadataObject();
    }
   
    public void helpTestElementID(String groupName, String elementName, TranslationUtility transUtil) throws Exception {
        Column elementID = getElementID(groupName, elementName, transUtil);    
        assertEquals(groupName + "." + elementName, elementID.getFullName()); //$NON-NLS-1$
        assertEquals(elementName, elementID.getName());
        assertNotNull(elementID.getParent());
        assertEquals(groupName, elementID.getParent().getFullName());       
    }
View Full Code Here
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
        }
        Table table = indexMetadata.getGroupID((String)((Constant)proc.getParameter(1).getExpression()).getValue());
        switch (sysProc) {
        case SETCOLUMNSTATS:
          String columnName = (String)((Constant)proc.getParameter(2).getExpression()).getValue();
          Column c = null;
          for (Column col : table.getColumns()) {
            if (col.getName().equalsIgnoreCase(columnName)) {
              c = col;
              break;
            }
          }
          if (c == null) {
            throw new TeiidProcessingException(columnName + TransformationMetadata.NOT_EXISTS_MESSAGE);
          }
          Integer distinctVals = (Integer)((Constant)proc.getParameter(3).getExpression()).getValue();
          Integer nullVals = (Integer)((Constant)proc.getParameter(4).getExpression()).getValue();
          String max = (String) ((Constant)proc.getParameter(5).getExpression()).getValue();
          String min = (String) ((Constant)proc.getParameter(6).getExpression()).getValue();
          ColumnStats columnStats = new ColumnStats();
          columnStats.setDistinctValues(distinctVals);
          columnStats.setNullValues(nullVals);
          columnStats.setMaximumValue(max);
          columnStats.setMinimumValue(min);
          if (this.metadataRepository != null) {
            this.metadataRepository.setColumnStats(vdbName, vdbVersion, c, columnStats);
          }
          c.setColumnStats(columnStats);
          if (eventDistributor != null) {
            eventDistributor.setColumnStats(vdbName, vdbVersion, table.getParent().getName(), table.getName(), columnName, columnStats);
          }
          break;
        case SETTABLESTATS:
View Full Code Here
582
583
584
585
586
587
588
589
590
591
592
593
     */
  public static List<Column> createElementsWithDefaults(ColumnSet<?> group, String[] names, String[] types, String[] defaults) {
    List<Column> elements = new ArrayList<Column>();
   
    for(int i=0; i<names.length; i++) {
            Column element = createElement(names[i], group, types[i]);
            element.setDefaultValue(defaults[i]);
      elements.add(element);   
    }
   
    return elements;
  } 
View Full Code Here
62
63
64
65
66
67
68
69
70
71
72
73
74
    if (null != Ids && Ids.length > 0) {
      List<JAXBElement> elements = new ArrayList<JAXBElement>();
      for (SetClause clause : ((Update)command).getChanges()) {
        ColumnReference element = clause.getSymbol();
        Column column = element.getMetadataObject();
        String val = ((Literal) clause.getValue()).toString();
        JAXBElement messageElem = new JAXBElement(new QName(column.getNameInSource()), stringClazz, Util.stripQutes(val));
        elements.add(messageElem);
      }

      List<DataPayload> updateDataList = new ArrayList<DataPayload>();
      for (int i = 0; i < Ids.length; i++) {
View Full Code Here
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
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
    TestCase.assertEquals(groupProps, groupMD.getProperties());
   
   
    DerivedColumn symbl = query.getProjectedQuery().getDerivedColumns().get(0);
    ColumnReference element = (ColumnReference)symbl.getExpression();
    Column elementMD = element.getMetadataObject();

    Properties elementProps = new Properties();
    elementProps.setProperty("customPosition", "11");//$NON-NLS-1$ //$NON-NLS-2$
   
    TestCase.assertEquals(0, elementMD.getLength());
    TestCase.assertEquals("Foo", elementMD.getDefaultValue()); //$NON-NLS-1$
    TestCase.assertEquals("TrimNulls", elementMD.getFormat()); //$NON-NLS-1$
    TestCase.assertEquals(String.class, elementMD.getJavaType());
    TestCase.assertEquals(null, elementMD.getMaximumValue());
    TestCase.assertEquals(null, elementMD.getMinimumValue());
    TestCase.assertEquals("http://www.w3.org/2001/XMLSchema#anySimpleType", elementMD.getBaseTypeID()); //$NON-NLS-1$
    TestCase.assertEquals("http://www.w3.org/2001/XMLSchema#string", elementMD.getPrimitiveTypeID()); //$NON-NLS-1$
    TestCase.assertEquals("http://www.w3.org/2001/XMLSchema#string", elementMD.getDatatypeID()); //$NON-NLS-1$
    TestCase.assertEquals("COLUMN1", elementMD.getNameInSource()); //$NON-NLS-1$
    TestCase.assertEquals("STR", elementMD.getNativeType()); //$NON-NLS-1$
    TestCase.assertEquals(NullType.Nullable, elementMD.getNullType());
    TestCase.assertEquals(0, elementMD.getPosition());
    TestCase.assertEquals(0, elementMD.getPrecision());
    TestCase.assertEquals(0, elementMD.getScale());
    TestCase.assertEquals(SearchType.Searchable, elementMD.getSearchType());
    TestCase.assertEquals(false, elementMD.isAutoIncremented());
    TestCase.assertEquals(true, elementMD.isCaseSensitive());
    TestCase.assertEquals(elementProps, elementMD.getProperties());
   
   
    DerivedColumn symbl2 = query.getProjectedQuery().getDerivedColumns().get(1);
    ColumnReference element2 = (ColumnReference)symbl2.getExpression();
    Column elementMD2 = element2.getMetadataObject();

    Properties elementProps2 = new Properties();
    elementProps2.setProperty("customPosition", "12");//$NON-NLS-1$ //$NON-NLS-2$
   
    TestCase.assertEquals(10, elementMD2.getLength());
    TestCase.assertEquals("23", elementMD2.getDefaultValue()); //$NON-NLS-1$
    TestCase.assertEquals("YesFormat", elementMD2.getFormat()); //$NON-NLS-1$
    TestCase.assertEquals(Integer.class, elementMD2.getJavaType());
    TestCase.assertEquals("1", elementMD2.getMaximumValue()); //$NON-NLS-1$
    TestCase.assertEquals("100", elementMD2.getMinimumValue()); //$NON-NLS-1$
    TestCase.assertEquals("http://www.w3.org/2001/XMLSchema#long", elementMD2.getBaseTypeID()); //$NON-NLS-1$
    TestCase.assertEquals("http://www.w3.org/2001/XMLSchema#decimal", elementMD2.getPrimitiveTypeID()); //$NON-NLS-1$
    TestCase.assertEquals("http://www.w3.org/2001/XMLSchema#int", elementMD2.getDatatypeID()); //$NON-NLS-1$
    TestCase.assertEquals("COLUMN2", elementMD2.getNameInSource()); //$NON-NLS-1$
    TestCase.assertEquals("INT", elementMD2.getNativeType()); //$NON-NLS-1$
    TestCase.assertEquals(NullType.No_Nulls, elementMD2.getNullType());
    TestCase.assertEquals(1, elementMD2.getPosition());
    TestCase.assertEquals(0, elementMD2.getPrecision());
    TestCase.assertEquals(10, elementMD2.getScale());
    TestCase.assertEquals(SearchType.Searchable, elementMD2.getSearchType());
    TestCase.assertEquals(true, elementMD2.isAutoIncremented());
    TestCase.assertEquals(false, elementMD2.isCaseSensitive());
   
    TestCase.assertEquals(elementProps2, elementMD2.getProperties());
    ResultSetExecution exec = Mockito.mock(ResultSetExecution.class);
        Mockito.stub(exec.next()).toReturn(null);
        return exec;
  } 
View Full Code Here
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
        table.setSupportsUpdate(true);
        return table;
    }
   
    public static Column createElement(String name, ColumnSet<?> group, String type) {
        Column column = new Column();
        column.setName(name);
        group.addColumn(column);
        column.setRuntimeType(type);
        if(type.equals(DataTypeManager.DefaultDataTypes.STRING)) { 
            column.setSearchType(SearchType.Searchable);       
        } else if (DataTypeManager.isNonComparable(type)){
          column.setSearchType(SearchType.Unsearchable);
        } else {         
          column.setSearchType(SearchType.All_Except_Like);
        }  
        column.setNullType(NullType.Nullable);
        column.setPosition(group.getColumns().size()); //1 based indexing
        column.setUpdatable(true);
        column.setLength(100);
        column.setNameInSource(name);
        return column;
    }
View Full Code Here
TOP

Related Classes of org.teiid.metadata.Column

  • org.teiid.connector.metadata.runtime.MockConnector
  • org.teiid.connector.metadata.runtime.TestElement
  • org.teiid.connector.metadata.runtime.TestMetadataObject
  • org.teiid.connector.metadata.runtime.TestProcedure
  • org.teiid.deployers.PgCatalogMetadataStore
  • org.teiid.dqp.internal.process.DataTierManagerImpl
  • org.teiid.metadata.index.IndexMetadataFactory
  • org.teiid.metadata.index.RecordFactory
  • org.teiid.query.metadata.TransformationMetadata
  • org.teiid.query.optimizer.TestDependentJoins
    • 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.