diff options
author | Kseniya Tomskikh <ktomskikh@driver.xyz> | 2018-10-17 17:02:58 +0800 |
---|---|---|
committer | Kseniya Tomskikh <ktomskikh@driver.xyz> | 2018-10-17 17:02:58 +0800 |
commit | 95c3aeecd7e6ad04ce8d216c09e779f5ca38aa6a (patch) | |
tree | dfc94f20d00c84f9dde120f065bfc9298bdff0dc /core-testkit/src/main/scala/xyz/driver/core/testkit/hsql/HsqlTestDatabase.scala | |
parent | f5d0b038457ed9d01687f0949e22e08a6b116066 (diff) | |
parent | a43556851bf986b81351fc9f1ae5ba51bf21dc47 (diff) | |
download | driver-core-kseniya/typized-id.tar.gz driver-core-kseniya/typized-id.tar.bz2 driver-core-kseniya/typized-id.zip |
Merge branch 'master' into kseniya/typized-idkseniya/typized-id
Diffstat (limited to 'core-testkit/src/main/scala/xyz/driver/core/testkit/hsql/HsqlTestDatabase.scala')
-rw-r--r-- | core-testkit/src/main/scala/xyz/driver/core/testkit/hsql/HsqlTestDatabase.scala | 26 |
1 files changed, 26 insertions, 0 deletions
diff --git a/core-testkit/src/main/scala/xyz/driver/core/testkit/hsql/HsqlTestDatabase.scala b/core-testkit/src/main/scala/xyz/driver/core/testkit/hsql/HsqlTestDatabase.scala new file mode 100644 index 0000000..8a4c3e8 --- /dev/null +++ b/core-testkit/src/main/scala/xyz/driver/core/testkit/hsql/HsqlTestDatabase.scala @@ -0,0 +1,26 @@ +package xyz.driver.test.hsql + +import java.nio.file.{Files, Paths} + +import slick.dbio.DBIO + +trait HsqlTestDatabase { + def insertTestData(database: xyz.driver.core.database.Database, filePath: String): DBIO[Int] = { + import database.profile.api._ + + val file = Paths.get(filePath) + val sqlLine = new String(Files.readAllBytes(file), "UTF-8") + + val createProcedure = + sqlu"""CREATE PROCEDURE INSERT_TEST_DATA() + MODIFIES SQL DATA + BEGIN ATOMIC + #$sqlLine + END; + """ + val callProcedure = sqlu"""{call INSERT_TEST_DATA()}""" + val dropProcedure = sqlu"""drop PROCEDURE INSERT_TEST_DATA;""" + + createProcedure >> callProcedure >> dropProcedure + } +} |