FieldLiteral

class FieldLiteral extends LiteralFieldBase 📜

Define a "field" literal for the underlying database.

Literals are special types in Mythix ORM that are used to define "literal values" for the underlying database.

This literal defines a "field" in the underlying database. It could for example be used in a projection, an ORDER, or a GROUP BY clause.

There are two primary ways to access literals in Mythix ORM. The first is to simply import them. The second way literals can be accessed is via the connection class itself. All Mythix ORM connection classes export all literals on the static Literals attribute of the class. So for example, you could access literals like SQLiteConnection.Literals.FieldLiteral.

All built-in Mythix ORM literals--except Literal and LiteralBase--accept a field as their first argument. This field can be a fully qualified field name, an actual Field instance, or another literal. The second argument to all literal constructors is an options object, that generally contains connection-specific (and operation-specific) options... however, there are common options that can be supplied, such as as: string; which allows you to define an alias for the defined field, and noProjectionAliases: boolean;, which allows you to disable the column alias entirely.

Example:

• const { Literals } = require('mythix-orm');
  const { SQLiteConnection } = require('mythix-orm-sqlite');
  let literal1 = new Literals.FieldLiteral('User:age');
  let literal2 = new SQLiteConnection.Literals.FieldLiteral('User:age');

See also: LiteralFieldBase, LiteralBase

method FieldLiteral::toString(
    connection?: Connection,
    options?: object,
) 📜

Convert this literal to a string to be used in a database query.

This method proxies the conversion of this literal to the connection by calling Connection.literalToString. If no connection is provided when this is called, then the literal will be converted to a string representing it for debugging, i.e. 'FieldLiteral {}'.

Notes:

• Ultimately, for most connections, this will end up calling QueryGenerator._fieldLiteralToString.

Arguments:

• connection?: Connection

  The connection to use to stringify this literal. If none is provided, then a string representing this object will be returned instead.

• options?: object

  A connection and operation specific set of options that can be provided. This might for example be { as: 'name' } to provided a field alias, or { isProjection: true } to define that this is being stringified for use as a field in the query projection. Normally the end-user won't care about any literal options, except as, which is commonly used to give your literal an alias.