little.sql

Provides extension methods for java.sql.Connection.

import scala.language.implicitConversions

import little.sql.{ *, given }

val connector = Connector("jdbc:h2:~/test", "sa", "s3cr3t", "org.h2.Driver")

connector.withConnection { conn =>
 val statements = Seq(
   "drop table prog_lang if exists",
   "create table prog_lang (id int, name text)",
   "insert into prog_lang (id, name) values (1, 'basic'), (2, 'pascal'), (3, 'c')",
   "select * from prog_lang"
 )

 statements.foreach { sql =>
   // Execute SQL and handle execution result accordingly
   conn.execute(sql) {
     // If update is executed print update count
     case Update(count) ⇒ println(s"Update Count: $count")

     // If query is executed print values of each row in ResultSet
     case Query(resultSet) =>
       while (resultSet.next())
         printf("id: %d, name: %s%n", resultSet.getInt("id"), resultSet.getString("name"))
   }
 }
}

Creates database connections.

Provides extension methods for javax.sql.DataSource.

Represents result of either update or query. If update, result can be obtained via count; otherwise, if query, result can be obtained via resultSet.

Provides factory methods for Execution.

Gets value from ResultSet.

Gets value by index from ResultSet.

Gets value by label from ResultSet.

Defines value for input parameter.

Provides factory methods for InParam.

Provides extension methods for java.sql.PreparedStatement.

Represents result of query.

Provides interface to incrementally build and execute SQL statements.

QueryBuilder is an immutable structure. A new builder is returned with each requested modification, and a new statement and result set are created on each requested execution.

import java.sql.Connection

import scala.language.implicitConversions

import little.sql.{ *, given }

implicit val conn: Connection = ???

QueryBuilder("select * from users where group = ? and enabled = ?")
 .params("staff", true) // Set input parameter values
 .maxRows(10) // Limit result set to 10 rows
 .foreach { rs => printf(s"uid=%d%n", rs.getInt("id")) } // Use implicit connection

// Same as above except use map of parameters
QueryBuilder("select * from users where group = ${group} and enabled = ${enabled}")
 .params("group" -> "staff", "enabled" -> true)
 .maxRows(10)
 .foreach { rs => printf(s"uid=%d%n", rs.getInt("id")) }

Provides QueryBuilder factory.

Provides extension methods for java.sql.ResultSet.

Provides extension methods for java.sql.Statement.

Represents result of update.

Gets BigDecimal from ResultSet.

Gets Boolean from ResultSet.

Gets Byte from ResultSet.

Gets Date from ResultSet.

Gets Double from ResultSet.

Gets Float from ResultSet.

Gets Instant from ResultSet.

Gets Int from ResultSet.

Gets LocalDate from ResultSet.

Gets LocalDateTime from ResultSet.

Gets LocalTime from ResultSet.

Gets Long from ResultSet.

Gets Short from ResultSet.

Gets String from ResultSet.

Gets Time from ResultSet.

Gets Timestamp from ResultSet.

Converts Any to InParam.

Converts BigDecimal to InParam.

Converts Boolean to InParam.

Converts Byte to InParam.

Converts Date to InParam.

Converts Double to InParam.

Converts Float to InParam.

Converts Instant to InParam.

Converts Int to InParam.

Converts LocalDateTime to InParam.

Converts LocalDate to InParam.

Converts LocalTime to InParam.

Converts Long to InParam.

Converts Map[T] to Seq[InParam].

Converts Option[T] to InParam.

Converts Seq[T] to Seq[InParam].

Converts Short to InParam.

Converts String to InParam.

Converts Time to InParam.

Converts Timestamp to InParam.

Converts Map[T] to Seq[InParam].

Provides extension methods for java.sql.Connection.

import scala.language.implicitConversions

import little.sql.{ *, given }

val connector = Connector("jdbc:h2:~/test", "sa", "s3cr3t", "org.h2.Driver")

connector.withConnection { conn =>
 val statements = Seq(
   "drop table prog_lang if exists",
   "create table prog_lang (id int, name text)",
   "insert into prog_lang (id, name) values (1, 'basic'), (2, 'pascal'), (3, 'c')",
   "select * from prog_lang"
 )

 statements.foreach { sql =>
   // Execute SQL and handle execution result accordingly
   conn.execute(sql) {
     // If update is executed print update count
     case Update(count) ⇒ println(s"Update Count: $count")

     // If query is executed print values of each row in ResultSet
     case Query(resultSet) =>
       while (resultSet.next())
         printf("id: %d, name: %s%n", resultSet.getInt("id"), resultSet.getString("name"))
   }
 }
}

Provides extension methods for javax.sql.DataSource.

Provides extension methods for java.sql.PreparedStatement.

Provides extension methods for java.sql.ResultSet.

Provides extension methods for java.sql.Statement.