@Test public void testSystemPropertiesInVDBXML() throws Exception { String vdbName = "test"; String testVDB = "<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"yes\"?>\n" + "<vdb name=\"test\" version=\"1\">\n" + " <property name=\"UseConnectorMetadata\" value=\"${teiid.vdb.UseConnectorMetadata:none}\" />\n" + " <model name=\"loopy\">\n" + " <source name=\"loop\" translator-name=\"loopy\" />\n" + " </model>\n" + "</vdb>"; Collection<?> vdbs = admin.getVDBs(); assertTrue(vdbs.isEmpty()); JavaArchive jar = getLoopyArchive(); admin.deploy("loopy.jar", jar.as(ZipExporter.class).exportAsInputStream()); // normal load admin.deploy("test-vdb.xml", new ByteArrayInputStream(testVDB.getBytes())); AdminUtil.waitForVDBLoad(admin, vdbName, 1, 3); VDB vdb = admin.getVDB(vdbName, 1); String value = vdb.getPropertyValue("UseConnectorMetadata"); // see the arquillian.zml file in resources in the JVM proeprties section for the expected value assertEquals("custom", value); admin.undeploy("loopy.jar"); admin.undeploy("test-vdb.xml"); }
@Test public void testDDLExport() throws Exception { String vdbName = "test"; String testVDB = "<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"yes\"?>\n" + "<vdb name=\"test\" version=\"1\">\n" + " <property name=\"UseConnectorMetadata\" value=\"cached\" />\n" + " <model name=\"loopy\">\n" + " <source name=\"loop\" translator-name=\"loopy\" />\n" + " </model>\n" + "</vdb>"; Collection<?> vdbs = admin.getVDBs(); assertTrue(vdbs.isEmpty()); JavaArchive jar = getLoopyArchive(); admin.deploy("loopy.jar", jar.as(ZipExporter.class).exportAsInputStream()); // normal load admin.deploy("test-vdb.xml", new ByteArrayInputStream(testVDB.getBytes())); AdminUtil.waitForVDBLoad(admin, vdbName, 1, 3); String ddl = admin.getSchema(vdbName, 1, "loopy", null, null); String expected = "CREATE FOREIGN TABLE Matadata (\n" + " execCount integer\n" + ");"; assertEquals(expected, ddl); admin.undeploy("loopy.jar"); }
@Test public void testVDBRestart() throws Exception { String vdbName = "test"; String testVDB = "<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"yes\"?>\n" + "<vdb name=\"test\" version=\"1\">\n" + " <property name=\"UseConnectorMetadata\" value=\"cached\" />\n" + " <model name=\"loopy\">\n" + " <source name=\"loop\" translator-name=\"loopy\" />\n" + " </model>\n" + "</vdb>"; Collection<?> vdbs = admin.getVDBs(); assertTrue(vdbs.isEmpty()); JavaArchive jar = getLoopyArchive(); admin.deploy("loopy.jar", jar.as(ZipExporter.class).exportAsInputStream()); // normal load admin.deploy("test-vdb.xml", new ByteArrayInputStream(testVDB.getBytes())); AdminUtil.waitForVDBLoad(admin, vdbName, 1, 3); int count = assertMetadataLoadCount(false, 1); // 1st restart admin.restartVDB(vdbName, 1); AdminUtil.waitForVDBLoad(admin, vdbName, 1, 3); count = assertMetadataLoadCount(true, count + 1); // 2nd restart admin.restartVDB(vdbName, 1); AdminUtil.waitForVDBLoad(admin, vdbName, 1, 3); count = assertMetadataLoadCount(true, count + 1); admin.undeploy("loopy.jar"); }
@Test public void testGetRequests() throws Exception { JavaArchive jar = getLoopyArchive(); try { admin.deploy("loopy.jar", jar.as(ZipExporter.class).exportAsInputStream()); deployVdb(); Translator t = admin.getTranslator("loopy"); assertNotNull(t); admin.updateSource("bqt", 1, "Source", "loopy", "java:jboss/datasources/ExampleDS"); Connection conn = TeiidDriver.getInstance() .connect("jdbc:teiid:bqt@mm://localhost:31000;user=user;password=user", null); Collection<? extends Session> sessions = admin.getSessions(); assertEquals(1, sessions.size()); Session s = sessions.iterator().next(); Statement stmt = conn.createStatement(); Collection<? extends Request> requests = admin.getRequests(); assertEquals(0, requests.size()); stmt.execute("select * from source.smalla"); requests = admin.getRequests(); assertEquals(1, requests.size()); Request r = requests.iterator().next(); assertEquals("select * from source.smalla", r.getCommand()); assertNotNull(r.getExecutionId()); assertNotNull(r.getSessionId()); stmt.execute("select * from source.smalla"); Collection<? extends Request> requests2 = admin.getRequestsForSession(s.getSessionId()); assertEquals(1, requests2.size()); Request r2 = requests.iterator().next(); assertEquals("select * from source.smalla", r2.getCommand()); assertEquals(s.getSessionId(), r2.getSessionId()); stmt.close(); conn.close(); requests = admin.getRequests(); assertEquals(0, requests.size()); } finally { admin.undeploy("loopy.jar"); } }
@Test public void testChainedDelegates() throws Exception { Properties props = new Properties(); props.setProperty("connection-url", "jdbc:h2:mem:test;DB_CLOSE_DELAY=-1"); props.setProperty("user-name", "sa"); props.setProperty("password", "sa"); AdminUtil.createDataSource(admin, "Oracle11_PushDS", "h2", props); admin.deploy("fake.jar", new FileInputStream(UnitTestUtil.getTestDataFile("fake.jar"))); try { admin.deploy( "chained-vdb.xml", new FileInputStream(UnitTestUtil.getTestDataFile("chained-vdb.xml"))); } finally { admin.undeploy("fake.jar"); } }
@Test public void testTraslators() throws Exception { Collection<? extends Translator> translators = admin.getTranslators(); assertEquals(38, translators.size()); JavaArchive jar = getLoopyArchive(); try { admin.deploy("loopy.jar", jar.as(ZipExporter.class).exportAsInputStream()); VDBTranslatorMetaData t = (VDBTranslatorMetaData) admin.getTranslator("loopy"); assertNotNull(t); assertEquals("ANY", t.getPropertyValue("SupportedJoinCriteria")); assertEquals("true", t.getPropertyValue("supportsSelectDistinct")); } finally { admin.undeploy("loopy.jar"); } VDBTranslatorMetaData t = (VDBTranslatorMetaData) admin.getTranslator("orcl"); assertNull(t); }