<!--H2内存数据库，用于测试环境-->
<dependency>
  <groupId>com.h2database</groupId>
  <artifactId>h2</artifactId>
  <version>1.4.196</version>
  <scope>test</scope>
</dependency>


#Database config
dha.driver=org.h2.Driver
dha.url=jdbc:h2:file:target/foobar;MODE=MySQL;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=FALSE;INIT=CREATESCHEMA IF NOT EXISTS "public";LOCK_TIMEOUT=10000;
dha.portNumber=3306
dha.schemaName=dha
dha.userName=sa
dha.dbPassword=
dha.validationQuery=select 1
dha.maxActive=100

<!-- 初始化数据库 -->
<jdbc:initialize-database data-source="dataSource" ignore-failures="NONE">
    <!-- 初始化表结构 -->
    <jdbc:script location="classpath:test-schema.sql"/>
    <!--改用DbSetup在程序中初始化表数据-->
    <!--<jdbc:script location="classpath:test-data.sql"/>-->
</jdbc:initialize-database>

package com.jahentao.springtest.test.dao;

import com.jahentao.springtest.dao.OrganizationDao;
import com.jahentao.springtest.test.BaseTest;
import com.ninja_squad.dbsetup.DbSetup;
import com.ninja_squad.dbsetup.Operations;
import com.ninja_squad.dbsetup.destination.DataSourceDestination;
import com.ninja_squad.dbsetup.operation.Operation;
import org.junit.After;
import org.junit.Before;
import org.junit.Test;
import org.springframework.beans.factory.annotation.Autowired;

import javax.sql.DataSource;
import static org.junit.Assert.assertNotNull;
public class OrganizationDaoTest extends BaseTest {
    @Autowired
    private OrganizationDao dao;
    @Autowired
    private DataSource dataSource;

    @Before
    public void setUp() throws Exception {
        Operation operation = Operations.sequenceOf(
                Operations.deleteAllFrom("sys_organization"),
                Operations.insertInto("sys_organization")
                        .columns("name","priority","parent_id","parent_ids","available")
                        .values("测试组", 10, 0, "0/", Boolean.TRUE)
                        .build()
        );
        DbSetup dbSetup = new DbSetup(new DataSourceDestination(dataSource), operation);
        dbSetupTracker.launchIfNecessary(dbSetup);
    }

    @Test
    public void testFindById() {
        assertNotNull(dao.findById(1L));
    }

    @After
    public void tearDown() throws Exception {
    }
}