Examples with VDBImportMetadata org.teiid.adminapi.impl.VDBImportMetadata used on opensource projects

Example 11 with VDBImportMetadata

use of org.teiid.adminapi.impl.VDBImportMetadata in project teiid by teiid.

the class TestMatViews method testImportedMatView.

@Test
public void testImportedMatView() throws Exception {
    ModelMetaData mmd2 = new ModelMetaData();
    mmd2.setName("view1");
    mmd2.setModelType(Type.PHYSICAL);
    mmd2.setSchemaSourceType("DDL");
    mmd2.setSchemaText("create foreign table x (col integer); CREATE VIEW v1 ( col1 string ) OPTIONS (MATERIALIZED true) AS select current_database() from x");
    mmd2.addSourceMapping("a", "a", null);
    HardCodedExecutionFactory hcef = new HardCodedExecutionFactory();
    hcef.addData("SELECT x.col FROM x", Arrays.asList(Collections.singletonList(1)));
    server.addTranslator("a", hcef);
    server.deployVDB("base", mmd2);
    VDBMetaData vdbMetaData = new VDBMetaData();
    vdbMetaData.setXmlDeployment(true);
    VDBImportMetadata importVDB = new VDBImportMetadata();
    importVDB.setName("base");
    importVDB.setVersion("1");
    vdbMetaData.getVDBImports().add(importVDB);
    vdbMetaData.setName("importing");
    server.deployVDB(vdbMetaData);
    Connection c = server.getDriver().connect("jdbc:teiid:importing", null);
    Statement s = c.createStatement();
    ResultSet rs = s.executeQuery("select * from v1");
    rs.next();
    assertEquals("base", rs.getString(1));
}