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 result set
     case Query(resultSet) =>
       while (resultSet.next())
         printf("id: %d, name: %s%n", resultSet.getInt("id"), resultSet.getString("name"))
   }
 }
}

Provides basic implementation of data source.

Provides extension methods for javax.sql.DataSource.

Represents result of either update or query.

If update, the result is count; otherwise, the execution is a query with resultSet.

Provides factory methods for Execution.

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.

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 query execution.

Provides interface to incrementally build and execute SQL statements.

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 update execution.

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[String, T] to Seq[String, InParam].

Converts None to 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 (String, T) to (String, 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 result set
     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.