Initialize.
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.
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.
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.
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.
Get the SQL that represents the query.
The actual SQL query (FROM, JOINS, and WHERE).
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
Represents the FROM portion of a query, with any JOINs and optionally a WHERE condition. This class is used when selecting, updating, or deleting.