Example usage for org.springframework.jdbc.datasource.embedded EmbeddedDatabaseBuilder addScript

Introduction

In this page you can find the example usage for org.springframework.jdbc.datasource.embedded EmbeddedDatabaseBuilder addScript.

Prototype

public EmbeddedDatabaseBuilder addScript(String script) 

Source Link

Document

Add an SQL script to execute to initialize or populate the database.

Usage

From source file:org.cloudfoundry.identity.uaa.password.PasswordChangeEndpointTests.java

@BeforeClass
public static void init() {
    EmbeddedDatabaseBuilder builder = new EmbeddedDatabaseBuilder();
    builder.addScript("classpath:/org/cloudfoundry/identity/uaa/schema-hsqldb.sql");
    builder.addScript("classpath:/org/cloudfoundry/identity/uaa/scim/schema-hsqldb.sql");
    database = builder.build();//from  w w  w  .  j av a 2  s  . co m
}

---

From source file:org.cloudfoundry.identity.uaa.scim.ScimUserEndpointsTests.java

@BeforeClass
public static void setUp() {
    EmbeddedDatabaseBuilder builder = new EmbeddedDatabaseBuilder();
    builder.addScript("classpath:/org/cloudfoundry/identity/uaa/schema-hsqldb.sql");
    database = builder.build();//from   www.  j  a  v  a2  s.  c  om
    JdbcTemplate jdbcTemplate = new JdbcTemplate(database);
    dao = new JdbcScimUserProvisioning(jdbcTemplate);
    dao.setPasswordEncoder(NoOpPasswordEncoder.getInstance());
    dao.setPasswordValidator(new NullPasswordValidator());
    ScimSearchQueryConverter filterConverter = new ScimSearchQueryConverter();
    Map<String, String> replaceWith = new HashMap<String, String>();
    replaceWith.put("emails\\.value", "email");
    replaceWith.put("groups\\.display", "authorities");
    replaceWith.put("phoneNumbers\\.value", "phoneNumber");
    filterConverter.setAttributeNameMapper(new SimpleAttributeNameMapper(replaceWith));
    dao.setQueryConverter(filterConverter);
    endpoints = new ScimUserEndpoints();
    endpoints.setScimUserProvisioning(dao);
    mm = new JdbcScimGroupMembershipManager(jdbcTemplate);
    mm.setScimUserProvisioning(dao);
    JdbcScimGroupProvisioning gdao = new JdbcScimGroupProvisioning(jdbcTemplate);
    mm.setScimGroupProvisioning(gdao);
    endpoints.setScimGroupMembershipManager(mm);
    groupEndpoints = new ScimGroupEndpoints(gdao, mm);
    joel = new ScimUser(null, "jdsa", "Joel", "D'sa");
    joel.addEmail("jdsa@vmware.com");
    dale = new ScimUser(null, "olds", "Dale", "Olds");
    dale.addEmail("olds@vmware.com");
    joel = dao.createUser(joel, "password");
    dale = dao.createUser(dale, "password");
}

---

From source file:no.magott.training.BusinessSchemaDbIntegrationTest.java

@Test
public void createAndInsertIntoSpursMatch() {
    EmbeddedDatabaseBuilder builder = new EmbeddedDatabaseBuilder();
    EmbeddedDatabase db = builder.addScript("classpath:business-schema.sql").build();
    String sql = "INSERT INTO SPURS_MATCH(MATCH_DATE, COMPETITION, OPPOSITION, VENUE, HALF_TIME_SCORE, GOALS_FOR, GOALS_AGAINST) VALUES(:date, :competition, :opposition, :venue, :halfTimeScore, :spursGoals, :oppositionGoals)";
    NamedParameterJdbcTemplate jdbcTemplate = new NamedParameterJdbcTemplate(db);
    Map<String, Object> params = new HashMap<String, Object>();
    params.put("date", new Date());
    params.put("opposition", "Ar5ena1");
    params.put("halfTimeScore", "(2-0)");
    params.put("venue", "WHL");
    params.put("spursGoals", 5);
    params.put("oppositionGoals", 1);
    params.put("competition", "FACUP");
    jdbcTemplate.update(sql, params);/*w ww  .  j  a va  2  s  .co m*/
    db.shutdown();
}

---

From source file:net.eusashead.hateoas.springhalbuilder.config.JpaConfig.java

@Bean
public DataSource dataSource() {
    EmbeddedDatabaseBuilder builder = new EmbeddedDatabaseBuilder();
    builder.addScript("schema.sql");
    builder.addScript("data.sql");
    return builder.setType(EmbeddedDatabaseType.H2).build();
}

---

From source file:org.cloudfoundry.identity.uaa.scim.ScimUserBootstrapTests.java

@Before
public void setUp() {
    EmbeddedDatabaseBuilder builder = new EmbeddedDatabaseBuilder();
    builder.addScript("classpath:/org/cloudfoundry/identity/uaa/schema-hsqldb.sql");
    database = builder.build();/*from w  ww  .j a v  a 2s .  co  m*/
    JdbcTemplate jdbcTemplate = new JdbcTemplate(database);
    db = new JdbcScimUserProvisioning(jdbcTemplate);
    db.setPasswordValidator(new NullPasswordValidator());
    gdb = new JdbcScimGroupProvisioning(jdbcTemplate);
    mdb = new JdbcScimGroupMembershipManager(jdbcTemplate);
    mdb.setScimUserProvisioning(db);
    mdb.setScimGroupProvisioning(gdb);
    userEndpoints = new ScimUserEndpoints();
    userEndpoints.setScimGroupMembershipManager(mdb);
    userEndpoints.setScimUserProvisioning(db);
}

---

From source file:com.github.mjeanroy.dbunit.tests.db.EmbeddedDatabaseRule.java

@Override
protected void before() {
    EmbeddedDatabaseBuilder builder = new EmbeddedDatabaseBuilder().setType(EmbeddedDatabaseType.HSQL)
            .generateUniqueName(false).setName("testdb");

    if (loadScript) {
        builder.addScript("classpath:/sql/init.sql");
    }/*from  w  ww. j a va 2 s.c o m*/

    db = builder.build();
}

---

From source file:org.cloudfoundry.identity.uaa.scim.bootstrap.ScimUserBootstrapTests.java

@Before
public void setUp() {
    EmbeddedDatabaseBuilder builder = new EmbeddedDatabaseBuilder();
    builder.addScript("classpath:/org/cloudfoundry/identity/uaa/schema-hsqldb.sql");
    builder.addScript("classpath:/org/cloudfoundry/identity/uaa/scim/schema-hsqldb.sql");
    database = builder.build();/* w  ww.  ja  v a2s .  co  m*/
    JdbcTemplate jdbcTemplate = new JdbcTemplate(database);
    JdbcPagingListFactory pagingListFactory = new JdbcPagingListFactory(jdbcTemplate,
            new DefaultLimitSqlAdapter());
    db = new JdbcScimUserProvisioning(jdbcTemplate, pagingListFactory);
    db.setPasswordValidator(new NullPasswordValidator());
    gdb = new JdbcScimGroupProvisioning(jdbcTemplate, pagingListFactory);
    mdb = new JdbcScimGroupMembershipManager(jdbcTemplate);
    mdb.setScimUserProvisioning(db);
    mdb.setScimGroupProvisioning(gdb);
    userEndpoints = new ScimUserEndpoints();
    userEndpoints.setScimGroupMembershipManager(mdb);
    userEndpoints.setScimUserProvisioning(db);
}

---

From source file:uk.ac.ebi.ep.data.testConfig.SpringDataMockConfig.java

@Bean
public DataSource dataSource() {
    EmbeddedDatabaseBuilder builder = new EmbeddedDatabaseBuilder();
    builder.setType(EmbeddedDatabaseType.H2);
    //return builder.build();
    //return builder.addDefaultScripts().build();
    return builder.addScript("classpath:schema.sql").addScript("classpath:data.sql").build();

}

---

From source file:rzd.vivc.documentexamination.repository.SpringDateConfig.java

@Bean
//? ? //  w  ww .  j av  a 2  s. co  m
public DataSource dataSource() {
    //??  H2
    EmbeddedDatabaseBuilder edb = new EmbeddedDatabaseBuilder();
    edb.setType(EmbeddedDatabaseType.H2);
    //? ? ? ??    ?
    edb.addScript("rzd/vivc/documentexamination/testdb/schema.sql");
    edb.addScript("rzd/vivc/documentexamination/testdb/test-data.sql");
    //? 
    EmbeddedDatabase embeddedDatabase = edb.build();
    return embeddedDatabase;
}

---

From source file:com.acmemotors.batch.LoaderJobConfiguration.java

/**
 * Configures the embedded data source used by this Spring Batch job.
 *
 * @return the {@link javax.sql.DataSource} to be used by Spring Batch for the job
 *       repository/*from www  .ja v  a 2 s.c  o m*/
 */
@Bean
public DataSource dataSource() {
    EmbeddedDatabaseBuilder embeddedDatabaseBuilder = new EmbeddedDatabaseBuilder();
    return embeddedDatabaseBuilder.addScript("classpath:org/springframework/batch/core/schema-drop-hsqldb.sql")
            .addScript("classpath:org/springframework/batch/core/schema-hsqldb.sql")
            .setType(EmbeddedDatabaseType.HSQL).build();
}

---

• «
• 1
• 2
• »