Examples with Column org.teiid.metadata.Column used on opensource projects

Example 86 with Column

use of org.teiid.metadata.Column in project teiid by teiid.

the class TestCriteriaCapabilityValidatorVisitor method testSubqueryCompareCriteriaSearchableFail.

// element not searchable
@Test
public void testSubqueryCompareCriteriaSearchableFail() throws Exception {
    TransformationMetadata metadata = RealMetadataFactory.example1();
    Schema modelID = metadata.getMetadataStore().getSchema("PM1");
    Column e1 = metadata.getElementID("pm1.g1.e1");
    e1.setSearchType(SearchType.Like_Only);
    FakeCapabilitiesFinder capFinder = new FakeCapabilitiesFinder();
    BasicSourceCapabilities caps = new BasicSourceCapabilities();
    caps.setCapabilitySupport(Capability.CRITERIA_COMPARE_EQ, true);
    // $NON-NLS-1$
    capFinder.addCapabilities("pm1", caps);
    // $NON-NLS-1$
    helpTestVisitorWithCommand("SELECT e1 FROM pm1.g1 WHERE pm1.g1.e1 = ANY (SELECT e1 FROM pm1.g2)", modelID, metadata, capFinder, false, false);
}

Example 87 with Column

use of org.teiid.metadata.Column in project teiid by teiid.

the class TestCreateDrop method testForeignTemp.

@Test
public void testForeignTemp() {
    Create create = new Create();
    // $NON-NLS-1$
    create.setTable(new GroupSymbol("tempTable"));
    create.setOn("source");
    Table t = new Table();
    t.setName("tempTable");
    t.setUUID("tid:0");
    Column c = new Column();
    c.setName("x");
    c.setUUID("tid:0");
    Datatype string = SystemMetadata.getInstance().getRuntimeTypeMap().get("string");
    c.setDatatype(string, true, 0);
    t.addColumn(c);
    c = new Column();
    c.setName("y");
    c.setUUID("tid:0");
    Datatype decimal = SystemMetadata.getInstance().getRuntimeTypeMap().get("decimal");
    c.setDatatype(decimal, true, 0);
    t.addColumn(c);
    t.setCardinality(10000);
    create.setTableMetadata(t);
    // $NON-NLS-1$ //$NON-NLS-2$
    helpTest("create foreign temporary table tempTable (x string, y decimal) options (cardinality 10000) on source", "CREATE FOREIGN TEMPORARY TABLE tempTable (\n	x string,\n	y bigdecimal\n) OPTIONS (CARDINALITY 10000) ON 'source'", create);
}

Example 88 with Column

use of org.teiid.metadata.Column in project teiid by teiid.

the class TestCalculateCostUtil method testEstimateCostOfCriteriaTime2.

/**
 *  Time Criteria - case using invalid max and min time strings
 */
@Test
public void testEstimateCostOfCriteriaTime2() throws Exception {
    TransformationMetadata metadata = RealMetadataFactory.example1();
    // $NON-NLS-1$
    Column e3 = metadata.getElementID("pm3.g1.e3");
    // $NON-NLS-1$
    e3.setMinimumValue("2007-04-03 12:12:12.10");
    // $NON-NLS-1$
    e3.setMaximumValue("2007-06-03 12:12:12.10");
    // $NON-NLS-1$
    String critString = "pm3.g1.e3 <= {t'11:11:11'}";
    helpTestEstimateCost(critString, 100, 33, metadata);
}

Example 89 with Column

use of org.teiid.metadata.Column in project teiid by teiid.

the class TestCalculateCostUtil method testEstimateCostOfCriteriaTimestamp1.

/**
 *  Timestamp Criteria - case using valid max and min timestamp strings
 */
@Test
public void testEstimateCostOfCriteriaTimestamp1() throws Exception {
    TransformationMetadata metadata = RealMetadataFactory.example1();
    // $NON-NLS-1$
    Column e4 = metadata.getElementID("pm3.g1.e4");
    // $NON-NLS-1$
    e4.setMinimumValue("2007-04-03 12:12:12.10");
    // $NON-NLS-1$
    e4.setMaximumValue("2007-04-03 12:12:12.10");
    // $NON-NLS-1$
    String critString = "pm3.g1.e4 <= {ts'2007-04-03 12:12:12.10'}";
    helpTestEstimateCost(critString, 100, 1, metadata);
}

Example 90 with Column

use of org.teiid.metadata.Column in project teiid by teiid.

the class TestSwaggerMetadataProcessor method testReftoResponse.

@Test
public void testReftoResponse() throws TranslatorException {
    SwaggerExecutionFactory translator = new SwaggerExecutionFactory();
    translator.start();
    MetadataFactory mf = petstoreMetadata(translator);
    Procedure p = mf.getSchema().getProcedure("findPetsByTags");
    assertNotNull(p);
    assertEquals("GET", p.getProperty(RestMetadataExtension.METHOD, false).toUpperCase());
    assertEquals("http://petstore.swagger.io/v2/pet/findByTags", p.getProperty(RestMetadataExtension.URI, false));
    assertNotNull(p.getResultSet());
    List<Column> columns = p.getResultSet().getColumns();
    assertEquals(8, columns.size());
    Column pa = p.getResultSet().getColumnByName("id");
    assertNull(pa.getNameInSource());
    pa = p.getResultSet().getColumnByName("category_id");
    assertEquals("category/id", pa.getNameInSource());
    pa = p.getResultSet().getColumnByName("tags_Tag_id");
    assertEquals("tags[]/Tag/id", pa.getNameInSource());
}