squery
API
Generated with
squery/ba.sake.squery

ba.sake.squery

package ba.sake.squery

Members list

Packages

package ba.sake.squery.read
package ba.sake.squery.write

Type members

Classlikes

class Query(val sqlString: String, val arguments: Seq[SqlArgument[_]])

Attributes

Companion
object
Supertypes
class Object
trait Matchable
class Any
object Query

Attributes

Companion
class
Supertypes
class Object
trait Matchable
class Any
Self type
Query.type
case class SqueryConnection(underlying: Connection)

Attributes

Supertypes
trait Serializable
trait Product
trait Equals
class Object
trait Matchable
class Any
Show all
class SqueryContext(ds: DataSource)

Attributes

Supertypes
class Object
trait Matchable
class Any
class SqueryException(msg: String) extends Exception

Attributes

Supertypes
class Exception
class Throwable
trait Serializable
class Object
trait Matchable
class Any
Show all

Types

type SqlRead[T] = SqlRead[T]
type SqlReadRow[T] = SqlReadRow[T]
type SqlWrite[T] = SqlWrite[T]

Value members

Concrete fields

val SqlRead: SqlRead.type
val SqlWrite: SqlWrite.type

Extensions

Extensions

extension (query: Query)
def execute()(using c: SqueryConnection): Unit
def insert()(using c: SqueryConnection): Int
def insertReturningGenKey[A]()(using c: SqueryConnection, r: SqlRead[A]): A
def insertReturningGenKeyOpt[A]()(using c: SqueryConnection, r: SqlRead[A]): Option[A]
def insertReturningGenKeys[A]()(using c: SqueryConnection, r: SqlRead[A]): Seq[A]

Inserts values and returns generated keys.

Inserts values and returns generated keys.

Value parameters

c

implicit Squery connection

query

SQL query to execute

r

implicit Sql read for the return type (generated key types)

Attributes

Returns

generated keys

def insertReturningRow[A]()(using c: SqueryConnection, r: SqlReadRow[A]): A
def insertReturningRows[A]()(using c: SqueryConnection, r: SqlReadRow[A]): Seq[A]
def readRow[A]()(using c: SqueryConnection, r: SqlReadRow[A]): A
def readRowOpt[A]()(using c: SqueryConnection, r: SqlReadRow[A]): Option[A]
def readRows[A]()(using c: SqueryConnection, r: SqlReadRow[A]): Seq[A]
def readValue[A]()(using c: SqueryConnection, r: SqlRead[A]): A
def readValueOpt[A]()(using c: SqueryConnection, r: SqlRead[A]): Option[A]
def readValues[A]()(using c: SqueryConnection, r: SqlRead[A]): Seq[A]
def update()(using c: SqueryConnection): Int
extension (sc: StringContext)
def sql(args: SqlArgument[_]*): Query

Implementation of sql"" interpolator. For a query sql"SELECT .. WHERE $a > 5 AND b = 'abc' ", there have to be SqlWrite typeclass instances for types of $a and $b.

Implementation of sql"" interpolator. For a query sql"SELECT .. WHERE $a > 5 AND b = 'abc' ", there have to be SqlWrite typeclass instances for types of $a and $b.

Attributes

Generated with