scalasql.core

Something that supports aggregate operations. Most commonly a Select, but also could be a Aggregatable.Proxy

Things you to do to configure ScalaSql

The contextual information necessary for rendering a ScalaSql query or expression into a SQL string

An interface to the SQL database allowing you to run queries.

A database client. Primarily allows you to access the database within a transaction block or via getAutoCommitClientConnection

A default set of data type mappers that need to be present in any ScalaSql dialect

A single "value" in your SQL query that can be mapped to and from a Scala value of a particular type T

Represents a set of nullable columns that come from a LEFT/RIGHT/OUTER JOIN clause.

Models a set of live Expr expressions which need to be rendered; Expr expressions not in this set can be skipped during rendering to improve the conciseness of the rendered SQL string.

• None is used to indicate this is a top-level context and we want all expressions to be rendered

• Some(set) indicates that only the expressions present in the set need to be rendered, and the rest can be elided.

Typically downstream parts of a SQL query (e.g. the outer SELECT) are rendered before the upstream parts (e.g. FROM (SELECT ...) subqueries), so the LiveExprs from the downstream parts can be used to decide which columns to skip when rendering the upstream parts. The outermost SELECT is rendered using LiveExprs.none since we cannot know what columns end up being used in the application code after the query has finished running, and thus have to preserve all of them

Typeclass to indicate that we are able to evaluate a query of type Q to return a result of type R. Involves two operations: flattening a structured query to a flat list of expressions via walkLabelsAndExprs, and reading a JSON-ish tree-shaped blob back into a return value via valueReader

A SQL query with interpolated ?s expressions and the associated interpolated values, of type Interp. Accumulates SQL snippets, parameters, and referenced expressions in a tree structure to minimize copying overhead, until SqlStr.flatten is called to convert it into a SqlStr.Flattened

A mapping between a Scala type T and a JDBC type, defined by it's jdbcType, castTypeString, and get and put operations.

Defaults are provided for most common Scala primitives, but you can also provide your own by defining an implicit val foo: TypeMapper[T]