Initialize the From instance.
Used for accessing columns in tables.
Used for accessing tables in the database.
Used for accessing relationships between tables.
Used for pulling table property maps (used in conjunction with the relStore to get remote columns).
An Escaper matching the database type (e.g. MySQLEscaper or MSSQLEscaper). Used when escaping column names in compiled conditions.
An Executer instance that matches the database type (e.g. MySQLExecuter).
Constructor of the FROM table.
Alias for the FROM table, used in conditions, joins, and column selection. Optional: defaults to the name of the table.
Used for accessing columns in tables.
An Escaper matching the database type (e.g. MySQLEscaper or MSSQLEscaper). Used when escaping column names in compiled conditions.
An Executer instance that matches the database type (e.g. MySQLExecuter).
Used for pulling table property maps (used in conjunction with the relStore to get remote columns).
Used for accessing relationships between tables.
Used for accessing tables in the database.
Get the record count from a table.
An optional column to count on. If not provided, then COUNT(*) is used.
Helper method to get the meta data of the FROM table, which is the first table in FromMeta.
A meta object describing the table.
Get the metadata (tables, columns, and parameters).
Get the FROM portion of the query as a string.
The FROM portion of the query (FROM <table> AS <alias>), escaped.
Helper method to get the meta data of the JOIN'd in tables.
An array of meta objects describing each table. The meta objects are in insertion order (e.g. in the order the tables were joined in).
Get the JOIN parts of the query string.
The JOIN parts of the query, escaped.
Get the list of parameters for the From.
Get the WHERE portion of the query string.
The WHERE part of the query, or a blank string if there is no where clause.
Inner join in a table. See From.join.
Join in a table.
How to join the two tables (INNER JOIN, LEFT OUTER JOIN).
The Table-decorated Entity to join in.
Alias of the joined-in table.
The fully-qualified property name on the parent Entity to which this Entity will be mapped.
A ParameterizedCondition instance. See ConditionBuilder.
Join in a table.
How to join the two tables (INNER JOIN, LEFT OUTER JOIN).
The Table-decorated Entity to join in.
Alias of the joined-in table.
The fully-qualified property name on the parent Entity to which this Entity will be mapped.
An optional condition that describes how to join the two tables. If not supplied then the join condition will be derived.
An optional set of parameters that will be used to replace values in joinCond.
Left outer join in a table. See From.join.
Select from the table. See Select.select.
An optional set of columns to select.
An executable Select instance.
Get the SQL that represents the query.
The actual SQL query (FROM, JOINS, and WHERE).
Update a table. See Update.
The model describing what to update.
An Update instance matching the database type (e.g. MySQLUpdate).
Add a WHERE condition to the query. This method can only be called one time (if called a second time an exception is raised).
The where condition object.
Any parameter replacements in the condition object.
Add a WHERE condition to the query. This method can only be called one time (if called a second time an exception is raised).
A ParameterizedCondition instance. See ConditionBuilder.
Generated using TypeDoc
Adapter for the From class that exposes a nice user interface for Select, Delete, and Update, all of which depend on a From instance.