QueryBuilderForTable

usql.dao.QueryBuilderForTable

A Query builder which somehow still presents a table. Supports delete call

Attributes

Graph
Supertypes
trait QueryBuilder[T]
trait Query[T]
class Object
trait Matchable
class Any
Show all

Members list

Value members

Abstract methods

def delete()(using cp: ConnectionProvider): Int

Delete selected elements.

Delete selected elements.

Attributes

override def filter(f: ColumnBasePath[T] => Rep[Boolean]): QueryBuilderForTable[T]

Filter step.

Filter step.

Attributes

Definition Classes

Inherited methods

def all()(using cp: ConnectionProvider): Vector[T]

Run a query for all rows.

Run a query for all rows.

Attributes

Inherited from:
Query
def one()(using cp: ConnectionProvider): Option[T]

Run a query for one row.

Run a query for one row.

Attributes

Inherited from:
Query
override def rowDecoder: RowDecoder[T]

The row decoder

The row decoder

Attributes

Definition Classes
Inherited from:
QueryBuilder
final def sql: Sql

Convert this query to SQL.

Convert this query to SQL.

Attributes

Inherited from:
QueryBuilder

Inherited and Abstract methods

def count()(using cp: ConnectionProvider): Int

Count elements.

Count elements.

Attributes

Inherited from:
QueryBuilder

Tabular representation of the result.

Tabular representation of the result.

Attributes

Inherited from:
QueryBuilder
def join[R](right: QueryBuilder[R])(on: (ColumnBasePath[T], ColumnBasePath[R]) => Rep[Boolean]): QueryBuilder[(T, R)]

Join two queries.

Join two queries.

Attributes

Inherited from:
QueryBuilder
def leftJoin[R](right: QueryBuilder[R])(on: (ColumnBasePath[T], ColumnBasePath[R]) => Rep[Boolean]): QueryBuilder[(T, Option[R])]

Left Join two Queries

Left Join two Queries

Attributes

Inherited from:
QueryBuilder
override def map[R0](f: ColumnPath[T, T] => ColumnPath[T, R0]): QueryBuilderForProjectedTable[R0]

Map one element.

Map one element.

Attributes

Definition Classes
Inherited from:
QueryBuilderForProjectedTable
override def project[P](p: ColumnPath[T, P]): QueryBuilderForProjectedTable[P]

Project values.

Project values.

Attributes

Definition Classes
Inherited from:
QueryBuilderForProjectedTable
def update(in: T)(using cp: ConnectionProvider): Int

Update elements.

Update elements.

Attributes

Inherited from:
QueryBuilderForProjectedTable