private void installDDLSilently(final String resourceName) throws IOException { final ClassLoader classLoader = MoreObjects.firstNonNull(Thread.currentThread().getContextClassLoader(), DBTestingHelper.class.getClassLoader()); final Enumeration<URL> resources = classLoader.getResources(resourceName); while (resources.hasMoreElements()) { final URL inputStream = resources.nextElement(); final String ddl; try { ddl = IOUtils.toString(inputStream.openStream()); getInstance().executeScript(ddl); } catch (final Exception ignored) { // The test doesn't have this module ddl in the classpath - that's fine } } }
instance.executeScript("drop table if exists accounts;" + "CREATE TABLE accounts (\n" + " record_id serial unique,\n" + " PRIMARY KEY(record_id)\n" + ");"); instance.executeScript("DROP TABLE IF EXISTS tenants;\n" + "CREATE TABLE tenants (\n" + " record_id serial unique,\n" + instance.executeScript("DROP TABLE IF EXISTS bundles;\n" + "CREATE TABLE bundles (\n" + " record_id serial unique,\n" + " PRIMARY KEY(record_id)\n" + ");"); instance.executeScript("DROP TABLE IF EXISTS subscriptions;\n" + "CREATE TABLE subscriptions (\n" + " record_id serial unique,\n" + instance.executeScript("DROP TABLE IF EXISTS payments;\n" + "CREATE TABLE payments (\n" + " record_id serial unique,\n" +
private void installDDLSilently(final String resourceName) throws IOException { final ClassLoader classLoader = MoreObjects.firstNonNull(Thread.currentThread().getContextClassLoader(), DBTestingHelper.class.getClassLoader()); final Enumeration<URL> resources = classLoader.getResources(resourceName); while (resources.hasMoreElements()) { final URL inputStream = resources.nextElement(); final String ddl; try { ddl = IOUtils.toString(inputStream.openStream()); getInstance().executeScript(ddl); } catch (final Exception ignored) { // The test doesn't have this module ddl in the classpath - that's fine } } }
instance.executeScript("drop table if exists accounts;" + "CREATE TABLE accounts (\n" + " record_id serial unique,\n" + " PRIMARY KEY(record_id)\n" + ");"); instance.executeScript("DROP TABLE IF EXISTS tenants;\n" + "CREATE TABLE tenants (\n" + " record_id serial unique,\n" + instance.executeScript("DROP TABLE IF EXISTS bundles;\n" + "CREATE TABLE bundles (\n" + " record_id serial unique,\n" + " PRIMARY KEY(record_id)\n" + ");"); instance.executeScript("DROP TABLE IF EXISTS subscriptions;\n" + "CREATE TABLE subscriptions (\n" + " record_id serial unique,\n" + instance.executeScript("DROP TABLE IF EXISTS payments;\n" + "CREATE TABLE payments (\n" + " record_id serial unique,\n" +
@BeforeClass(groups = "slow") public void setUpBeforeClass() throws Exception { embeddedDB = PlatformDBTestingHelper.get().getInstance(); embeddedDB.initialize(); embeddedDB.start(); final String ddl = TestUtils.toString(getDdlFileName()); embeddedDB.executeScript(ddl); embeddedDB.refreshTableNames(); }
embeddedDB.executeScript("CREATE DOMAIN datetime AS timestamp without time zone;" + "CREATE OR REPLACE FUNCTION last_insert_id() RETURNS BIGINT AS $$\n" + " DECLARE\n" + embeddedDB.executeScript(ddl);