Implicits

Provides implicits conversions and extension methods.

class Object

trait Matchable

class Any

Type members

Classlikes

Provides extension methods to java.sql.Connection.

import scala.language.implicitConversions

import little.sql.*
import Implicits.{ *, 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 to javax.sql.DataSource.

Provides extension methods to java.sql.PreparedStatement.

See also: StatementType

Provides extension methods to java.sql.ResultSet.

Provides extension methods to java.sql.Statement.

See also: PreparedStatementType

Givens

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 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 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].