commonMain.com.github.mejiomah17.yasb.sqlite.SqliteTableJoinTest.kt Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of database-sqlite-test-fixtures-jvm Show documentation

An YASB database-sqlite-test-fixtures module

The newest version!

package com.github.mejiomah17.yasb.sqlite

import com.github.mejiomah17.yasb.core.transaction.TransactionAtLeastRepeatableRead
import com.github.mejiomah17.yasb.dsl.TestTable
import com.github.mejiomah17.yasb.dsl.join.TableJoinTest

interface SqliteTableJoinTest<
    TABLE : TestTable,
    DRIVER_DATA_SOURCE,
    DRIVER_STATEMENT,
    DIALECT : SqliteDatabaseDialect,
    TRANSACTION : TransactionAtLeastRepeatableRead
    > :
    TableJoinTest {

    override fun initSqlScripts(): List {
        return listOf(
            "DELETE FROM FIRST",
            "DELETE FROM SECOND",
            "DELETE FROM THIRD",
            "INSERT INTO FIRST (A,B) values ('XXX','B1')",
            "INSERT INTO FIRST (A,B) values ('YYY','C1')",
            "INSERT INTO SECOND (A,B) values ('XXX','B2')",
            "INSERT INTO SECOND (A,B) values ('ZZZ','D1')",
            "INSERT INTO THIRD (A,B) values ('XXX','B3')",
            "INSERT INTO THIRD (A,B) values ('ZZZ','E1')"
        )
    }
}