Std.Db.Query

49 public declarations

• absentStd.Db.Driver.Value

  A value that is absent.

  fn
• also&Std.Db.Query.Statement -> Str -> Str -> Std.Db.Driver.Value -> Result[Std.Db.Query.Statement, Std.Db.Query.QueryError]

  A further condition that must also hold.

  fn
• andOn&Std.Db.Query.Statement -> &Std.Db.Schema.Column[T] -> Std.Db.Schema.Comparison -> &T -> Std.Db.Query.Statement where T: Bindable

  A further condition that must also hold.

  fn
• countingStr -> Result[Std.Db.Query.Statement, Std.Db.Query.QueryError]

  How many rows a table holds.

  fn
• deleteFromStr -> Result[Std.Db.Query.Statement, Std.Db.Query.QueryError]

  Rows removed from a table.

  fn
• either&Std.Db.Query.Statement -> Str -> Str -> Std.Db.Driver.Value -> Result[Std.Db.Query.Statement, Std.Db.Query.QueryError]

  A further condition where either may hold.

  fn
• emptyStd.Db.Query.Statement

  A statement with nothing in it.

  fn
• except&Std.Db.Query.Statement -> &Std.Db.Query.Statement -> Std.Db.Query.Statement

  The rows in the first and not the second.

  fn
• explain&Std.Db.Query.QueryError -> Str

  What a refusal says.

  fn
• flagBool -> Std.Db.Driver.Value

  A value that is true or false.

  fn
• fromStr -> Result[Std.Db.Query.Statement, Std.Db.Query.QueryError]

  Everything from a table.

  fn
• fromTable&Std.Db.Schema.Column[T] -> Std.Db.Query.Statement

  Everything from the table a column belongs to.

  fn
• insertStr -> &Array[Str] -> &Array[Std.Db.Driver.Value] -> Result[Std.Db.Query.Statement, Std.Db.Query.QueryError]

  A row added to a table, from the columns and the values that fill them.

  fn
• intersect&Std.Db.Query.Statement -> &Std.Db.Query.Statement -> Std.Db.Query.Statement

  The rows in both.

  fn
• limit&Std.Db.Query.Statement -> Int -> Std.Db.Query.Statement

  At most this many rows.

  fn
• matching&Std.Db.Query.Statement -> Str -> Str -> Std.Db.Driver.Value -> Result[Std.Db.Query.Statement, Std.Db.Query.QueryError]

  A condition on a column, with the value travelling beside the statement.

  fn
• matchingMissing&Std.Db.Query.Statement -> Str -> Result[Std.Db.Query.Statement, Std.Db.Query.QueryError]

  A condition that a column holds nothing.

  fn
• matchingOneOf&Std.Db.Query.Statement -> Str -> &Array[Std.Db.Driver.Value] -> Result[Std.Db.Query.Statement, Std.Db.Query.QueryError]

  A condition that a column is one of several values.

  fn
• maybeTextOption[Str] -> Std.Db.Driver.Value

  Text, or its absence.

  fn
• missingOn&Std.Db.Query.Statement -> &Std.Db.Schema.Column[T] -> Std.Db.Query.Statement

  A condition that a column holds nothing.

  fn
• nameStr -> Result[Str, Std.Db.Query.QueryError]

  A name, admitted only when it is one.

  fn
• offset&Std.Db.Query.Statement -> Int -> Std.Db.Query.Statement

  Starting after this many rows.

  fn
• on&Std.Db.Query.Statement -> &Std.Db.Schema.Column[T] -> Std.Db.Schema.Comparison -> &T -> Std.Db.Query.Statement where T: Bindable

  A condition on a column, with the column and the comparison both values.

  fn
• oneOfStr -> &Array[Str] -> Result[Str, Std.Db.Query.QueryError]

  A name chosen from a list the program wrote.

  fn
• operatorStr -> Result[Str, Std.Db.Query.QueryError]

  An operator, admitted only when it is one.

  fn
• orderBy&Std.Db.Query.Statement -> Str -> Bool -> Result[Std.Db.Query.Statement, Std.Db.Query.QueryError]

  The order rows come back in.

  fn
• orderOn&Std.Db.Query.Statement -> &Std.Db.Schema.Column[T] -> Bool -> Std.Db.Query.Statement

  The order rows come back in, by a column the compiler knows.

  fn
• orOn&Std.Db.Query.Statement -> &Std.Db.Schema.Column[T] -> Std.Db.Schema.Comparison -> &T -> Std.Db.Query.Statement where T: Bindable

  A further condition where either may hold.

  fn
• Part

  A statement, and the values that travel beside it.

  type
• qualifiedNameStr -> Result[Str, Std.Db.Query.QueryError]

  A name that may carry the table it belongs to.

  fn
• QueryError

  Why a statement would not be built.

  type
• rawStr -> &Array[Std.Db.Driver.Value] -> Std.Db.Query.Statement

  A statement written out in full, with its values beside it.

  fn
• returning&Std.Db.Query.Statement -> &Array[Str] -> Result[Std.Db.Query.Statement, Std.Db.Query.QueryError]

  A statement that answers with the rows it changed.

  fn
• selecting&Array[Str] -> Str -> Result[Std.Db.Query.Statement, Std.Db.Query.QueryError]

  Named columns from a table.

  fn
• Statement

  The parts are held rather than one text, because a statement is built a

  type
• StatementQuery.QueryError -> Std.Db.Store.StoreError

  The parts are held rather than one text, because a statement is built a

  type
• textStr -> Std.Db.Query.Statement

  A statement from text the program wrote, carrying no values.

  fn
• textIn&Std.Db.Query.Statement -> &Std.Db.Driver.Placeholders -> Str

  The same statement, spelled the way one backend writes a placeholder.

  fn
• textOf&Std.Db.Query.Statement -> Str

  The text a statement holds, which a program may read before running it.

  fn
• textValueStr -> Std.Db.Driver.Value

  A value that is text.

  fn
• textValuesOf&Std.Db.Query.Statement -> Array[Option[Str]]

  The same values as the text a wire carries.

  fn
• then&Std.Db.Query.Statement -> &Std.Db.Query.Statement -> Std.Db.Query.Statement

  Two statements one after the other, with the second's placeholders

  fn
• union&Std.Db.Query.Statement -> &Std.Db.Query.Statement -> Bool -> Std.Db.Query.Statement

  Two results together, with the second's values following the first's.

  fn
• updateStr -> &Array[Str] -> &Array[Std.Db.Driver.Value] -> Result[Std.Db.Query.Statement, Std.Db.Query.QueryError]

  Columns of a table set to new values.

  fn
• valueCount&Std.Db.Query.Statement -> Int

  How many values a statement carries.

  fn
• valuesOf&Std.Db.Query.Statement -> Array[Std.Db.Driver.Value]

  The values that travel beside it.

  fn
• wholeInt -> Std.Db.Driver.Value

  A value that is a whole number, so a numeric comparison is a numeric one.

  fn
• withQueryStr -> &Std.Db.Query.Statement -> &Std.Db.Query.Statement -> Result[Std.Db.Query.Statement, Std.Db.Query.QueryError]

  A named result the rest of a statement reads from.

  fn
• withValue&Std.Db.Query.Statement -> Str -> Std.Db.Driver.Value -> Std.Db.Query.Statement

  A statement with one more piece of text and one more value.

  fn