入门

下面的例子使用H2内存数据库展示了sqala的基本功能，将下面的代码保存为.sc文件，比如demo.sc，通过scala demo.sc命令执行即可看到运行结果：

scala

//> using scala 3.7.0
//> using dep com.h2database:h2:2.3.232
//> using dep com.wz7982::sqala-jdbc:0.5.0

import org.h2.jdbcx.*
import sqala.jdbc.*
import sqala.metadata.*
import sqala.static.dsl.*

object DB:
    given Logger = Logger(content => println(content))
    given JdbcConnection[JdbcDataSource] with
        def init(url: String, username: String, password: String, driverClassName: String): JdbcDataSource =
            val ds = JdbcDataSource()
            ds.setURL(url)
            ds
    val db = JdbcContext(H2Dialect, true, "jdbc:h2:mem:main", "", "", "")

import DB.{db, ds}

ds.getConnection().createStatement().executeUpdate:
    """
    CREATE TABLE `demo` (
        `id` BIGINT PRIMARY KEY AUTO_INCREMENT, 
        `key` TEXT, 
        `value` TEXT
    )
    """

case class Demo(
    @autoInc id: Long,
    key: String,
    value: String
)

db.insert(Demo(0L, "sqala", "Scala's sql lib"))

val result = db.find:
    query:
        from(Demo)
            .filter(_.key == "sqala")
            .map(d => (key = d.key, value = d.value))

println(result)

入门 ​

入门