Class SQLDatabaseQuery<T>

Type Parameters

T extends OrmEntity

Hierarchy

Query<T>
- SQLDatabaseQuery

Index

Constructors

Properties

databaseSession model resolver

Methods

sqlSelect where

Constructors

constructor

new SQLDatabaseQuery<T>(classSchema: ReflectionClass<T>, databaseSession: DatabaseSession<DatabaseAdapter>, resolver: SQLQueryResolver<T>): SQLDatabaseQuery<T>
Type Parameters
- T extends OrmEntity
Parameters
- classSchema: ReflectionClass<T>
- databaseSession: DatabaseSession<DatabaseAdapter>
- resolver: SQLQueryResolver<T>
Returns SQLDatabaseQuery<T>
Overrides Query<T>.constructor
- Defined in packages/sql/src/sql-adapter.ts:384

Properties

`Protected` databaseSession

databaseSession: DatabaseSession<DatabaseAdapter>

model

model: SQLQueryModel<T> = ...

`Protected` resolver

resolver: SQLQueryResolver<T>

Methods

sqlSelect

sqlSelect(sql: SqlQuery): Replace<SQLDatabaseQuery<T>, Pick<T, any>>
Adds additional selects to the query. Automatically converts the query to a partial (no class instances).
Parameters
- sql: SqlQuery
Returns Replace<SQLDatabaseQuery<T>, Pick<T, any>>
- Defined in packages/sql/src/sql-adapter.ts:413

where

where(sql: SqlQuery): SQLDatabaseQuery<T>
Adds raw SQL to the where clause of the query. If there is a filter() set as well, the where is added after the filter using AND.
```
database.query(User).where(`id > ${id}`).find();
```
Use ${identifier('name')} = ${'Peter'} for column names that need to be quoted.
Parameters
- sql: SqlQuery
Returns SQLDatabaseQuery<T>
- Defined in packages/sql/src/sql-adapter.ts:403

Generated using TypeDoc