Refine search
@Bean DataSource orderDataSource() { return new EmbeddedDatabaseBuilder().// setType(EmbeddedDatabaseType.HSQL).// setName("orders").// build(); } }
@Test(expected = CannotReadScriptException.class) public void addScriptWithBogusFileName() { new EmbeddedDatabaseBuilder().addScript("bogus.sql").build(); }
@Override public void run() { EmbeddedDatabase db = new EmbeddedDatabaseBuilder()// .addDefaultScripts()// .build(); assertDatabaseCreatedAndShutdown(db); } });
@Override public void run() { EmbeddedDatabase db = builder// .setType(DERBY)// .ignoreFailedDrops(true)// .addScripts("db-schema-derby-with-drop.sql", "db-test-data.sql").build(); assertDatabaseCreatedAndShutdown(db); } });
@Bean(name = "dataSource", destroyMethod = "shutdown") @Profile("test") public DataSource dataSourceForTest() { return new EmbeddedDatabaseBuilder() .generateUniqueName(true) .setType(EmbeddedDatabaseType.H2) .setScriptEncoding("UTF-8") .ignoreFailedDrops(true) .addScript("schema.sql") .addScripts("data.sql") .build(); }
@Bean public DataSource dataSourcePartner() { return new EmbeddedDatabaseBuilder()// .setType(EmbeddedDatabaseType.HSQL)// .ignoreFailedDrops(true)// .addScripts("classpath:org/springframework/batch/core/schema-drop-hsqldb.sql", "classpath:org/springframework/batch/core/schema-hsqldb.sql", "classpath:schema-partner.sql")// .build(); }
@Before public void setUp() throws Exception { db = new EmbeddedDatabaseBuilder().generateUniqueName(true).setType(EmbeddedDatabaseType.DERBY).setName("testdb") .setScriptEncoding("UTF-8").addScript("/org/talend/components/service/rest/schema.sql") .addScript("/org/talend/components/service/rest/data_users.sql").build(); // addresss: Starting embedded database: // url='jdbc:derby:memory:2dc86c66-5d3a-48fd-b903-56aa27d20e3b;create=true', // username='sa' try (Connection connection = db.getConnection()) { dbUrl = connection.getMetaData().getURL(); } RestAssured.port = localServerPort; }
@Before public void setUp() { db = new EmbeddedDatabaseBuilder().setType(getEmbeddedDatabaseType()).build(); jdbcTemplate = new JdbcTemplate(db); }
@Override public void run() { EmbeddedDatabase db = builder// .setType(H2)// .addScripts("db-schema.sql", "db-test-data.sql")// .build(); assertDatabaseCreatedAndShutdown(db); } });
@Test public void createSameSchemaTwiceWithGeneratedUniqueDbNames() throws Exception { EmbeddedDatabase db1 = new EmbeddedDatabaseBuilder(new ClassRelativeResourceLoader(getClass()))// .addScripts("db-schema-without-dropping.sql", "db-test-data.sql")// .generateUniqueName(true)// .build(); JdbcTemplate template1 = new JdbcTemplate(db1); assertNumRowsInTestTable(template1, 1); template1.update("insert into T_TEST (NAME) values ('Sam')"); assertNumRowsInTestTable(template1, 2); EmbeddedDatabase db2 = new EmbeddedDatabaseBuilder(new ClassRelativeResourceLoader(getClass()))// .addScripts("db-schema-without-dropping.sql", "db-test-data.sql")// .generateUniqueName(true)// .build(); assertDatabaseCreated(db2); db1.shutdown(); db2.shutdown(); }
@Test public void createSameSchemaTwiceWithoutUniqueDbNames() throws Exception { EmbeddedDatabase db1 = new EmbeddedDatabaseBuilder(new ClassRelativeResourceLoader(getClass()))// .addScripts("db-schema-without-dropping.sql").build(); try { new EmbeddedDatabaseBuilder(new ClassRelativeResourceLoader(getClass()))// .addScripts("db-schema-without-dropping.sql").build(); fail("Should have thrown a ScriptStatementFailedException"); } catch (ScriptStatementFailedException e) { // expected } finally { db1.shutdown(); } }
@Bean public JdbcTemplate jdbcTemplate() { return new JdbcTemplate(dataSource()); } /** * Spring provided H2 Embedded Database. Read the dbscript and initiates the Database with the name H2-Test-DB. * * @return */ @Bean(name = "dataSource") public DataSource dataSource(){ EmbeddedDatabaseBuilder builder = new EmbeddedDatabaseBuilder(); builder.setName("H2-Test-DB"); EmbeddedDatabase db = builder.setType(EmbeddedDatabaseType.H2) .addScript("classpath:db-script/ddl.sql") .addScript("classpath:db-script/dml.sql").build(); log.info("Initiating the database from dbscript."); return db; }
@Override public void run() { EmbeddedDatabase db = builder// .addScripts("db-schema.sql", "db-test-data.sql")// .build(); assertDatabaseCreatedAndShutdown(db); } });
@Override public void run() { EmbeddedDatabase db = builder// .addScripts("db-schema-block-comments.sql", "db-test-data.sql")// .setBlockCommentStartDelimiter("{*")// .setBlockCommentEndDelimiter("*}")// .build(); assertDatabaseCreatedAndShutdown(db); } });
@Override public void run() { EmbeddedDatabase db = builder// .addScripts("db-schema-custom-comments.sql", "db-test-data.sql")// .setCommentPrefix("~")// .build(); assertDatabaseCreatedAndShutdown(db); } });
@Configuration public class DatabaseTestConfig { @Bean public DataSource dataSource() { return new EmbeddedDatabaseBuilder() .setType(EmbeddedDatabaseType.HSQL) .addScript("classpath:schema.sql") .addScript("classpath:test-data.sql") .build(); } }
/** * Add multiple SQL scripts to execute to initialize or populate the database. * @param scripts the scripts to execute * @return {@code this}, to facilitate method chaining * @since 4.0.3 */ public EmbeddedDatabaseBuilder addScripts(String... scripts) { for (String script : scripts) { addScript(script); } return this; }
@Bean(destroyMethod = "shutdown") public DataSource dataSource() { return new EmbeddedDatabaseBuilder() .generateUniqueName(true) .setType(EmbeddedDatabaseType.H2) .setScriptEncoding("UTF-8") .ignoreFailedDrops(true) .addScript("classpath:me/chanjar/domain/foo-ddl.sql") .build(); }
@Override public void run() { EmbeddedDatabase db = builder// .addScripts("db-schema-comments.sql", "db-test-data.sql")// .build(); assertDatabaseCreatedAndShutdown(db); } });