Std.Db.Query.Shape

39 public declarations

• ascendingStr -> Std.Db.Query.Shape.Ordering

  Rows ordered by a column, with the ones holding nothing last.

  fn
• Bound

  How much of a result is wanted. Nothing for either means all of it.

  type
• Condition

  One condition, on a row or on a group.

  type
• crossJoinStr -> Std.Db.Query.Shape.Join

  Every row of one table beside every row of another.

  fn
• descendingStr -> Std.Db.Query.Shape.Ordering

  The same, largest first.

  fn
• everythingStd.Db.Query.Shape.Selected

  Everything, which names nothing and so needs no checking.

  fn
• everythingFromStr -> Std.Db.Query.Shape.Select

  Everything from a table, which is the smallest query there is.

  fn
• firstInt -> Std.Db.Query.Shape.Bound

  At most this many rows.

  fn
• fullJoinStr -> Str -> Str -> Std.Db.Query.Shape.Join

  The same, keeping the rows of both that match nothing.

  fn
• howManyStd.Db.Query.Shape.Selected

  How many rows there are.

  fn
• innerStr -> Str -> Str -> Std.Db.Query.Shape.Join

  A table joined where two columns agree.

  fn
• isStr -> Str -> Str -> Std.Db.Query.Shape.Condition

  A column compared against text, which travels as a parameter.

  fn
• isAmongStr -> &Array[Std.Db.Driver.Value] -> Std.Db.Query.Shape.Condition

  The same, where each value carries its own type.

  fn
• isBoundStr -> Str -> Std.Db.Driver.Value -> Std.Db.Query.Shape.Condition

  A column compared against a value that carries its own type.

  fn
• isMissingStr -> Std.Db.Query.Shape.Condition

  A column holding nothing.

  fn
• isNumberStr -> Str -> Int -> Std.Db.Query.Shape.Condition

  A column compared against a whole number, which crosses as one.

  fn
• isOneOfStr -> &Array[Option[Str]] -> Std.Db.Query.Shape.Condition

  A column that is one of several values, each its own parameter, so a list

  fn
• isPresentStr -> Std.Db.Query.Shape.Condition

  A column holding something.

  fn
• isValueStr -> Str -> Option[Str] -> Std.Db.Query.Shape.Condition

  The same, where the value may be absent.

  fn
• Join

  A table put beside the one a statement reads from.

  type
• Joining

  How two tables are put beside one another.

  type
• joinOnStd.Db.Query.Shape.Joining -> &Std.Db.Schema.Column[K] -> &Std.Db.Schema.Column[K] -> Std.Db.Query.Shape.Join

  A join on two columns whose types must agree, so joining a column of text

  fn
• leftJoinStr -> Str -> Str -> Std.Db.Query.Shape.Join

  The same, keeping rows of the first table that match nothing.

  fn
• Locking

  Whether the rows a statement reads are held for this transaction.

  type
• orderedStr -> Bool -> Bool -> Std.Db.Query.Shape.Ordering

  The same, saying where the rows holding nothing go.

  fn
• Ordering

  One column a result is ordered by, and where the rows holding nothing go.

  type
• overStr -> Str -> Std.Db.Query.Shape.Selected

  An aggregate over a column.

  fn
• pageInt -> Int -> Std.Db.Query.Shape.Bound

  One page of a result.

  fn
• pickStr -> Std.Db.Query.Shape.Selected

  A column a statement answers with.

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

  A name that may carry the table it belongs to.

  fn
• Refining

  A query with one part changed, each answering the query rather than taking

  trait
• rightJoinStr -> Str -> Str -> Std.Db.Query.Shape.Join

  The same, the other way about.

  fn
• select&Std.Db.Query.Shape.Select -> Result[Std.Db.Query.Statement, Std.Db.Query.QueryError]

  A whole query as a statement, or the first thing wrong with it.

  fn
• Select

  A whole query, written as one value.

  type
• Selected

  One thing a statement answers with.

  type
• selectedText&Std.Db.Query.Shape.Selected -> Str

  How one of them is written.

  fn
• Test

  What a condition asks.

  type
• unboundedStd.Db.Query.Shape.Bound

  All of a result.

  fn
• under&Std.Db.Query.Shape.Selected -> Str -> Std.Db.Query.Shape.Selected

  The same thing, answering under a name of its own.

  fn