Repository navigation
@142vip.nest typeorm.类.SelectQueryBuilder
API 参考 / @142vip/nest-typeorm / SelectQueryBuilder
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:22
Allows to build complex sql queries in a fashion way and execute those queries.
-
QueryBuilder<Entity>
Entity extends ObjectLiteral
new SelectQueryBuilder<
Entity>(queryBuilder):SelectQueryBuilder<Entity>
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:54
QueryBuilder can be initialized from given Connection and QueryRunner objects or from given other QueryBuilder.
QueryBuilder<any>
SelectQueryBuilder<Entity>
new SelectQueryBuilder<
Entity>(connection,queryRunner?):SelectQueryBuilder<Entity>
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:58
QueryBuilder can be initialized from given Connection and QueryRunner objects or from given other QueryBuilder.
SelectQueryBuilder<Entity>
readonly@instanceof:symbol
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:23
protectedconditions:string
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:34
readonlyconnection:DataSource
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:30
Connection on which QueryBuilder was created.
readonlyexpressionMap:QueryExpressionMap
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:34
Contains all properties of the QueryBuilder that needs to be build a final query.
protectedfindOptions:FindManyOptions
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:24
protectedjoins:object[]
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:26
alias:
string
parentAlias:
string
relationMetadata:
RelationMetadata
select:
boolean
selection:
FindOptionsSelect<any> |undefined
type:
"inner"|"left"
protectedorderBys:object[]
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:35
alias:
string
direction:
"ASC"|"DESC"
optionalnulls?:"NULLS FIRST"|"NULLS LAST"
protectedparentQueryBuilder:QueryBuilder<any>
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:42
If QueryBuilder was created in a subquery mode then its parent QueryBuilder (who created subquery) will be stored here.
QueryBuilder.parentQueryBuilder
protectedoptionalqueryRunner?:QueryRunner
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:38
Query runner used to execute query builder query.
protectedrelationMetadatas:RelationMetadata[]
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:40
protectedselects:string[]
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:25
get alias():
string
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:67
Gets the main alias string used in this query builder.
string
addCommonTableExpression(
queryBuilder,alias,options?):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:215
Adds CTE to query
string | QueryBuilder<any>
string
QueryBuilderCteOptions
this
QueryBuilder.addCommonTableExpression
addFrom<
T>(entityTarget,aliasName):SelectQueryBuilder<T>
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:112
Specifies FROM which entity's table select/update/delete will be executed. Also sets a main string alias of the selection data.
T extends ObjectLiteral
(qb) => SelectQueryBuilder<any>
string
SelectQueryBuilder<T>
addFrom<
T>(entityTarget,aliasName):SelectQueryBuilder<T>
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:117
Specifies FROM which entity's table select/update/delete will be executed. Also sets a main string alias of the selection data.
T extends ObjectLiteral
EntityTarget<T>
string
SelectQueryBuilder<T>
addGroupBy(
groupBy):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:476
Adds GROUP BY condition in the query builder.
string
this
addOrderBy(
sort,order?,nulls?):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:504
Adds ORDER BY condition in the query builder.
string
"ASC" | "DESC"
"NULLS FIRST" | "NULLS LAST"
this
addSelect(
selection,selectionAliasName?):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:73
Adds new selection to the SELECT query.
(qb) => SelectQueryBuilder<any>
string
this
addSelect(
selection,selectionAliasName?):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:77
Adds new selection to the SELECT query.
string
string
this
addSelect(
selection):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:81
Adds new selection to the SELECT query.
string[]
this
andHaving(
having,parameters?):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:455
Adds new AND HAVING condition in the query builder. Additionally you can add parameters used in where expression.
string
this
andWhere(
where,parameters?):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:399
Adds new AND WHERE condition in the query builder. Additionally you can add parameters used in where expression.
string | ObjectLiteral | ObjectLiteral[] | Brackets | ((qb) => string)
this
WhereExpressionBuilder.andWhere
andWhereExists(
subQuery):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:412
Adds a new AND where EXISTS clause
SelectQueryBuilder<any>
this
andWhereInIds(
ids):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:434
Adds new AND WHERE with conditions for the given ids.
Ids are mixed. It means if you have single primary key you can pass a simple id values, for example [1, 2, 3]. If you have multiple primary keys you need to pass object with property names and values specified, for example [{ firstId: 1, secondId: 2 }, { firstId: 2, secondId: 3 }, ...]
any
this
WhereExpressionBuilder.andWhereInIds
protectedapplyFindOptions():void
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:660
void
protectedbuildEagerRelations(relations,selection,metadata,alias,embedPrefix?):void
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:684
FindOptionsRelations<any>
FindOptionsSelect<any> | undefined
string
string
void
protectedbuildEscapedEntityColumnSelects(aliasName,metadata):SelectQuery[]
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:655
string
SelectQuery[]
protectedbuildOrder(order,metadata,alias,embedPrefix?):void
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:685
FindOptionsOrder<any>
string
string
void
protectedbuildRelations(relations,selection,metadata,alias,embedPrefix?):void
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:683
FindOptionsRelations<any>
FindOptionsSelect<any> | undefined
string
string
void
protectedbuildSelect(select,metadata,alias,embedPrefix?):void
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:682
FindOptionsSelect<any>
string
string
void
protectedbuildWhere(where,metadata,alias,embedPrefix?):string
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:686
FindOptionsWhere<any> | FindOptionsWhere<any>[]
string
string
string
cache(
enabled):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:599
Enables or disables query result caching.
boolean
this
cache(
milliseconds):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:604
Enables query result caching and sets in milliseconds in which cache will expire. If not set then global caching time will be used.
number
this
cache(
id,milliseconds?):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:608
Enables query result caching and sets cache id and milliseconds in which cache will expire.
any
number
this
callListeners(
enabled):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:207
Indicates if listeners and subscribers must be called before and after query execution. Enabled by default.
boolean
this
clone():
this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:184
Clones query builder as it is. Note: it uses new query runner, if you want query builder that uses exactly same query runner, you can create query builder using its constructor, for example new SelectQueryBuilder(queryBuilder) where queryBuilder is cloned QueryBuilder.
this
comment(
comment):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:190
Includes a Query comment in the query builder. This is helpful for debugging purposes, such as finding a specific query in the database server's logs, or for categorization using an APM product.
string
this
concatRelationMetadata(
relationMetadata):void
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:661
RelationMetadata
void
protectedcreateComment():string
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:239
string
protectedcreateCteExpression():string
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:262
string
QueryBuilder.createCteExpression
protectedcreateFromAlias(entityTarget,aliasName?):Alias
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:229
Specifies FROM which entity's table select/update/delete will be executed. Also sets a main string alias of the selection data.
EntityTarget<any> | ((qb) => SelectQueryBuilder<any>)
string
Alias
protectedcreateGroupByExpression():string
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:629
Creates "GROUP BY" part of SQL query.
string
protectedcreateHavingExpression():string
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:654
Creates "HAVING" part of SQL query.
string
protectedcreateJoinExpression():string
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:625
Creates "JOIN" part of SQL query.
string
protectedcreateLimitOffsetExpression():string
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:637
Creates "LIMIT" and "OFFSET" parts of SQL query.
string
protectedcreateLockExpression():string
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:650
string
"LOCK" part of SQL query
protectedcreateOrderByCombinedWithSelectExpression(parentAlias): [string,OrderByCondition]
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:669
string
[string, OrderByCondition]
protectedcreateOrderByExpression():string
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:633
Creates "ORDER BY" part of SQL query.
string
protectedcreateParameter(value):string
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:145
any
string
protectedcreatePropertyPath(metadata,entity,prefix?):string[]
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:272
Creates a property paths for a given ObjectLiteral.
string
string[]
QueryBuilder.createPropertyPath
createQueryBuilder(
queryRunner?):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:177
Creates a completely new query builder. Uses same query runner as current QueryBuilder.
this
QueryBuilder.createQueryBuilder
protectedcreateReturningExpression(returningType):string
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:251
Creates "RETURNING" / "OUTPUT" expression.
ReturningType
string
QueryBuilder.createReturningExpression
protectedcreateSelectDistinctExpression():string
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:621
Creates select | select distinct part of SQL query.
string
protectedcreateSelectExpression():string
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:617
Creates "SELECT FROM" part of SQL query.
string
protectedcreateTimeTravelQuery():string
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:243
Time travel queries for CockroachDB
string
QueryBuilder.createTimeTravelQuery
protectedcreateWhereClausesExpression(clauses):string
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:257
WhereClause[]
string
QueryBuilder.createWhereClausesExpression
protectedcreateWhereConditionExpression(condition,alwaysWrap?):string
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:261
Computes given where argument - transforms to a where string all forms it can take.
WhereClauseCondition
boolean
string
QueryBuilder.createWhereConditionExpression
protectedcreateWhereExpression():string
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:247
Creates "WHERE" expression.
string
QueryBuilder.createWhereExpression
delete():
DeleteQueryBuilder<Entity>
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:106
Creates DELETE query.
DeleteQueryBuilder<Entity>
disableEscaping():
this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:194
Disables escaping.
this
distinct(
distinct?):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:90
Sets whether the selection is DISTINCT.
boolean
this
distinctOn(
distinctOn):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:94
Sets the distinct on clause for Postgres.
string[]
this
escape(
name):string
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:198
Escapes table name, column name or alias name using current database's escaping character.
string
string
execute():
Promise<any>
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:172
Executes sql generated by query builder and returns raw database results.
Promise<any>
protectedexecuteCountQuery(queryRunner):Promise<number>
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:658
Promise<number>
protectedexecuteEntitiesAndRawResults(queryRunner):Promise<{entities:Entity[];raw:any[]; }>
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:665
Executes sql generated by query builder and returns object with raw results and entities created from them.
Promise<{ entities: Entity[]; raw: any[]; }>
protectedexecuteExistsQuery(queryRunner):Promise<boolean>
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:659
Promise<boolean>
protectedfindEntityColumnSelects(aliasName,metadata):SelectQuery[]
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:656
string
SelectQuery[]
from<
T>(entityTarget,aliasName):SelectQueryBuilder<T>
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:101
Specifies FROM which entity's table select/update/delete will be executed. Also sets a main string alias of the selection data. Removes all previously set from-s.
T extends ObjectLiteral
(qb) => SelectQueryBuilder<any>
string
SelectQueryBuilder<T>
from<
T>(entityTarget,aliasName):SelectQueryBuilder<T>
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:107
Specifies FROM which entity's table select/update/delete will be executed. Also sets a main string alias of the selection data. Removes all previously set from-s.
T extends ObjectLiteral
EntityTarget<T>
string
SelectQueryBuilder<T>
fromDummy():
SelectQueryBuilder<any>
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:95
SelectQueryBuilder<any>
getCount():
Promise<number>
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:580
Gets count - number of entities selected by sql generated by this query builder. Count excludes all limitations set by offset, limit, skip, and take.
Promise<number>
getExists():
Promise<boolean>
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:585
Gets exists Returns whether any rows exists matching current query.
Promise<boolean>
protectedgetExistsCondition(subQuery): [string,any[]]
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:267
any
[string, any[]]
QueryBuilder.getExistsCondition
protectedgetMainTableName():string
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:224
Gets name of the table where insert should be performed.
string
getMany():
Promise<Entity[]>
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:575
Gets entities returned by execution of generated query builder sql.
Promise<Entity[]>
getManyAndCount():
Promise<[Entity[],number]>
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:590
Executes built SQL query and returns entities and overall entities count (without limitation). This method is useful to build pagination.
Promise<[Entity[], number]>
getOne():
Promise<Entity|null>
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:567
Gets single entity returned by execution of generated query builder sql.
Promise<Entity | null>
getOneOrFail():
Promise<Entity>
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:571
Gets the first entity returned by execution of generated query builder sql or rejects the returned promise on error.
Promise<Entity>
getParameters():
ObjectLiteral
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:155
Gets all parameters.
protectedgetPredicates(where):Generator<any[],void,unknown>
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:273
Generator<any[], void, unknown>
getQuery():
string
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:44
Gets generated SQL query without parameters being replaced.
string
getQueryAndParameters(): [
string,any[]]
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:168
Gets query to be executed with all parameters used in it.
[string, any[]]
QueryBuilder.getQueryAndParameters
getRawAndEntities<
T>():Promise<{entities:Entity[];raw:T[]; }>
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:560
Executes sql generated by query builder and returns object with raw results and entities created from them.
T = any
Promise<{ entities: Entity[]; raw: T[]; }>
getRawMany<
T>():Promise<T[]>
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:556
Gets all raw results returned by execution of generated query builder sql.
T = any
Promise<T[]>
getRawOne<
T>():Promise<T|undefined>
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:552
Gets first raw result returned by execution of generated query builder sql.
T = any
Promise<T | undefined>
protectedgetReturningColumns():ColumnMetadata[]
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:256
If returning / output cause is set to array of column names, then this method will return all column metadatas of those column names.
ColumnMetadata[]
QueryBuilder.getReturningColumns
getSql():
string
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:164
Gets generated sql that will be executed. Parameters in the query are escaped for the currently used driver.
string
protectedgetTableName(tablePath):string
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:220
Gets escaped table name with schema name if SqlServer driver used with custom schema name, otherwise returns escaped table name.
string
string
protectedgetWhereCondition(where):WhereClauseCondition
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:275
string | ObjectLiteral | ObjectLiteral[] | Brackets | NotBrackets | ((qb) => string)
WhereClauseCondition
QueryBuilder.getWhereCondition
protectedgetWhereInIdsCondition(ids):ObjectLiteral|Brackets
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:266
Creates "WHERE" condition for an in-ids condition.
any
QueryBuilder.getWhereInIdsCondition
protectedgetWherePredicateCondition(aliasPath,parameterValue):WhereClauseCondition
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:274
string
any
WhereClauseCondition
QueryBuilder.getWherePredicateCondition
groupBy():
this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:466
Sets GROUP BY condition in the query builder. If you had previously GROUP BY expression defined, calling this function will override previously set GROUP BY conditions.
this
groupBy(
groupBy):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:472
Sets GROUP BY condition in the query builder. If you had previously GROUP BY expression defined, calling this function will override previously set GROUP BY conditions.
string
this
protectedhasCommonTableExpressions():boolean
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:280
boolean
QueryBuilder.hasCommonTableExpressions
hasParameter(
key):boolean
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:134
Check the existence of a parameter for this query builder.
string
boolean
hasRelation<
T>(target,relation):boolean
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:123
Checks if given relation exists in the entity. Returns true if relation exists, false otherwise.
todo: move this method to manager? or create a shortcut?
T
EntityTarget<T>
string
boolean
hasRelation<
T>(target,relation):boolean
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:130
Checks if given relations exist in the entity. Returns true if relation exists, false otherwise.
todo: move this method to manager? or create a shortcut?
T
EntityTarget<T>
string[]
boolean
having(
having,parameters?):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:450
Sets HAVING condition in the query builder. If you had previously HAVING expression defined, calling this function will override previously set HAVING conditions. Additionally you can add parameters used in where expression.
string
this
innerJoin(
subQueryFactory,alias,condition?,parameters?):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:123
INNER JOINs (without selection) given subquery. You also need to specify an alias of the joined data. Optionally, you can add condition and parameters used in condition.
(qb) => SelectQueryBuilder<any>
string
string
this
innerJoin(
property,alias,condition?,parameters?):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:130
INNER JOINs (without selection) entity's property. Given entity property should be a relation. You also need to specify an alias of the joined data. Optionally, you can add condition and parameters used in condition.
string
string
string
this
innerJoin(
entity,alias,condition?,parameters?):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:136
INNER JOINs (without selection) given entity's table. You also need to specify an alias of the joined data. Optionally, you can add condition and parameters used in condition.
string | Function
string
string
this
innerJoin(
tableName,alias,condition?,parameters?):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:142
INNER JOINs (without selection) given table. You also need to specify an alias of the joined data. Optionally, you can add condition and parameters used in condition.
string
string
string
this
innerJoinAndMapMany(
mapToProperty,subQueryFactory,alias,condition?,parameters?):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:226
INNER JOINs given subquery, SELECTs the data returned by a join and MAPs all that data to some entity's property. This is extremely useful when you want to select some data and map it to some virtual property. It will assume that there are multiple rows of selecting data, and mapped result will be an array. Given entity property should be a relation. You also need to specify an alias of the joined data. Optionally, you can add condition and parameters used in condition.
string
(qb) => SelectQueryBuilder<any>
string
string
this
innerJoinAndMapMany(
mapToProperty,property,alias,condition?,parameters?):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:235
INNER JOINs entity's property, SELECTs the data returned by a join and MAPs all that data to some entity's property. This is extremely useful when you want to select some data and map it to some virtual property. It will assume that there are multiple rows of selecting data, and mapped result will be an array. Given entity property should be a relation. You also need to specify an alias of the joined data. Optionally, you can add condition and parameters used in condition.
string
string
string
string
this
innerJoinAndMapMany(
mapToProperty,entity,alias,condition?,parameters?):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:243
INNER JOINs entity's table, SELECTs the data returned by a join and MAPs all that data to some entity's property. This is extremely useful when you want to select some data and map it to some virtual property. It will assume that there are multiple rows of selecting data, and mapped result will be an array. You also need to specify an alias of the joined data. Optionally, you can add condition and parameters used in condition.
string
string | Function
string
string
this
innerJoinAndMapMany(
mapToProperty,tableName,alias,condition?,parameters?):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:251
INNER JOINs table, SELECTs the data returned by a join and MAPs all that data to some entity's property. This is extremely useful when you want to select some data and map it to some virtual property. It will assume that there are multiple rows of selecting data, and mapped result will be an array. You also need to specify an alias of the joined data. Optionally, you can add condition and parameters used in condition.
string
string
string
string
this
innerJoinAndMapOne(
mapToProperty,subQueryFactory,alias,condition?,parameters?,mapAsEntity?):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:260
INNER JOINs given subquery, SELECTs the data returned by a join and MAPs all that data to some entity's property. This is extremely useful when you want to select some data and map it to some virtual property. It will assume that there is a single row of selecting data, and mapped result will be a single selected value. Given entity property should be a relation. You also need to specify an alias of the joined data. Optionally, you can add condition and parameters used in condition.
string
(qb) => SelectQueryBuilder<any>
string
string
string | Function
this
innerJoinAndMapOne(
mapToProperty,property,alias,condition?,parameters?):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:269
INNER JOINs entity's property, SELECTs the data returned by a join and MAPs all that data to some entity's property. This is extremely useful when you want to select some data and map it to some virtual property. It will assume that there is a single row of selecting data, and mapped result will be a single selected value. Given entity property should be a relation. You also need to specify an alias of the joined data. Optionally, you can add condition and parameters used in condition.
string
string
string
string
this
innerJoinAndMapOne(
mapToProperty,entity,alias,condition?,parameters?):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:277
INNER JOINs entity's table, SELECTs the data returned by a join and MAPs all that data to some entity's property. This is extremely useful when you want to select some data and map it to some virtual property. It will assume that there is a single row of selecting data, and mapped result will be a single selected value. You also need to specify an alias of the joined data. Optionally, you can add condition and parameters used in condition.
string
string | Function
string
string
this
innerJoinAndMapOne(
mapToProperty,tableName,alias,condition?,parameters?):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:285
INNER JOINs table, SELECTs the data returned by a join and MAPs all that data to some entity's property. This is extremely useful when you want to select some data and map it to some virtual property. It will assume that there is a single row of selecting data, and mapped result will be a single selected value. You also need to specify an alias of the joined data. Optionally, you can add condition and parameters used in condition.
string
string
string
string
this
innerJoinAndSelect(
subQueryFactory,alias,condition?,parameters?):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:173
INNER JOINs given subquery and adds all selection properties to SELECT.. You also need to specify an alias of the joined data. Optionally, you can add condition and parameters used in condition.
(qb) => SelectQueryBuilder<any>
string
string
this
innerJoinAndSelect(
property,alias,condition?,parameters?):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:180
INNER JOINs entity's property and adds all selection properties to SELECT. Given entity property should be a relation. You also need to specify an alias of the joined data. Optionally, you can add condition and parameters used in condition.
string
string
string
this
innerJoinAndSelect(
entity,alias,condition?,parameters?):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:186
INNER JOINs entity and adds all selection properties to SELECT. You also need to specify an alias of the joined data. Optionally, you can add condition and parameters used in condition.
string | Function
string
string
this
innerJoinAndSelect(
tableName,alias,condition?,parameters?):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:192
INNER JOINs table and adds all selection properties to SELECT. You also need to specify an alias of the joined data. Optionally, you can add condition and parameters used in condition.
string
string
string
this
insert():
InsertQueryBuilder<Entity>
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:86
Creates INSERT query.
InsertQueryBuilder<Entity>
protectedjoin(direction,entityOrProperty,aliasName,condition?,parameters?,mapToProperty?,isMappingMany?,mapAsEntity?):void
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:613
"INNER" | "LEFT"
string | Function | ((qb) => SelectQueryBuilder<any>)
string
string
string
boolean
string | Function
void
leftJoin(
subQueryFactory,alias,condition?,parameters?):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:148
LEFT JOINs (without selection) given subquery. You also need to specify an alias of the joined data. Optionally, you can add condition and parameters used in condition.
(qb) => SelectQueryBuilder<any>
string
string
this
leftJoin(
property,alias,condition?,parameters?):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:155
LEFT JOINs (without selection) entity's property. Given entity property should be a relation. You also need to specify an alias of the joined data. Optionally, you can add condition and parameters used in condition.
string
string
string
this
leftJoin(
entity,alias,condition?,parameters?):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:161
LEFT JOINs (without selection) entity's table. You also need to specify an alias of the joined data. Optionally, you can add condition and parameters used in condition.
string | Function
string
string
this
leftJoin(
tableName,alias,condition?,parameters?):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:167
LEFT JOINs (without selection) given table. You also need to specify an alias of the joined data. Optionally, you can add condition and parameters used in condition.
string
string
string
this
leftJoinAndMapMany(
mapToProperty,subQueryFactory,alias,condition?,parameters?):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:294
LEFT JOINs given subquery, SELECTs the data returned by a join and MAPs all that data to some entity's property. This is extremely useful when you want to select some data and map it to some virtual property. It will assume that there are multiple rows of selecting data, and mapped result will be an array. Given entity property should be a relation. You also need to specify an alias of the joined data. Optionally, you can add condition and parameters used in condition.
string
(qb) => SelectQueryBuilder<any>
string
string
this
leftJoinAndMapMany(
mapToProperty,property,alias,condition?,parameters?):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:303
LEFT JOINs entity's property, SELECTs the data returned by a join and MAPs all that data to some entity's property. This is extremely useful when you want to select some data and map it to some virtual property. It will assume that there are multiple rows of selecting data, and mapped result will be an array. Given entity property should be a relation. You also need to specify an alias of the joined data. Optionally, you can add condition and parameters used in condition.
string
string
string
string
this
leftJoinAndMapMany(
mapToProperty,entity,alias,condition?,parameters?):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:311
LEFT JOINs entity's table, SELECTs the data returned by a join and MAPs all that data to some entity's property. This is extremely useful when you want to select some data and map it to some virtual property. It will assume that there are multiple rows of selecting data, and mapped result will be an array. You also need to specify an alias of the joined data. Optionally, you can add condition and parameters used in condition.
string
string | Function
string
string
this
leftJoinAndMapMany(
mapToProperty,tableName,alias,condition?,parameters?):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:319
LEFT JOINs table, SELECTs the data returned by a join and MAPs all that data to some entity's property. This is extremely useful when you want to select some data and map it to some virtual property. It will assume that there are multiple rows of selecting data, and mapped result will be an array. You also need to specify an alias of the joined data. Optionally, you can add condition and parameters used in condition.
string
string
string
string
this
leftJoinAndMapOne(
mapToProperty,subQueryFactory,alias,condition?,parameters?,mapAsEntity?):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:328
LEFT JOINs given subquery, SELECTs the data returned by a join and MAPs all that data to some entity's property. This is extremely useful when you want to select some data and map it to some virtual property. It will assume that there is a single row of selecting data, and mapped result will be a single selected value. Given entity property should be a relation. You also need to specify an alias of the joined data. Optionally, you can add condition and parameters used in condition.
string
(qb) => SelectQueryBuilder<any>
string
string
string | Function
this
leftJoinAndMapOne(
mapToProperty,property,alias,condition?,parameters?):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:337
LEFT JOINs entity's property, SELECTs the data returned by a join and MAPs all that data to some entity's property. This is extremely useful when you want to select some data and map it to some virtual property. It will assume that there is a single row of selecting data, and mapped result will be a single selected value. Given entity property should be a relation. You also need to specify an alias of the joined data. Optionally, you can add condition and parameters used in condition.
string
string
string
string
this
leftJoinAndMapOne(
mapToProperty,entity,alias,condition?,parameters?):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:345
LEFT JOINs entity's table, SELECTs the data returned by a join and MAPs all that data to some entity's property. This is extremely useful when you want to select some data and map it to some virtual property. It will assume that there is a single row of selecting data, and mapped result will be a single selected value. You also need to specify an alias of the joined data. Optionally, you can add condition and parameters used in condition.
string
string | Function
string
string
this
leftJoinAndMapOne(
mapToProperty,tableName,alias,condition?,parameters?):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:353
LEFT JOINs table, SELECTs the data returned by a join and MAPs all that data to some entity's property. This is extremely useful when you want to select some data and map it to some virtual property. It will assume that there is a single row of selecting data, and mapped result will be a single selected value. You also need to specify an alias of the joined data. Optionally, you can add condition and parameters used in condition.
string
string
string
string
this
leftJoinAndSelect(
subQueryFactory,alias,condition?,parameters?):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:198
LEFT JOINs given subquery and adds all selection properties to SELECT.. You also need to specify an alias of the joined data. Optionally, you can add condition and parameters used in condition.
(qb) => SelectQueryBuilder<any>
string
string
this
leftJoinAndSelect(
property,alias,condition?,parameters?):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:205
LEFT JOINs entity's property and adds all selection properties to SELECT. Given entity property should be a relation. You also need to specify an alias of the joined data. Optionally, you can add condition and parameters used in condition.
string
string
string
this
leftJoinAndSelect(
entity,alias,condition?,parameters?):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:211
LEFT JOINs entity and adds all selection properties to SELECT. You also need to specify an alias of the joined data. Optionally, you can add condition and parameters used in condition.
string | Function
string
string
this
leftJoinAndSelect(
tableName,alias,condition?,parameters?):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:217
LEFT JOINs table and adds all selection properties to SELECT. You also need to specify an alias of the joined data. Optionally, you can add condition and parameters used in condition.
string
string
string
this
limit(
limit?):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:511
Sets LIMIT - maximum number of rows to be selected. NOTE that it may not work as you expect if you are using joins. If you want to implement pagination, and you are having join in your query, then use the take method instead.
number
this
loadAllRelationIds(
options?):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:384
Loads all relation ids for all relations of the selected entity. All relation ids will be mapped to relation property themself. If array of strings is given then loads only relation ids of the given properties.
boolean
string[]
this
protectedloadRawResults(queryRunner):Promise<any>
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:673
Loads raw results from the database.
Promise<any>
loadRelationCountAndMap(
mapToProperty,relationName,aliasName?,queryBuilderFactory?):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:378
Counts number of entities of entity's relation and maps the value into some entity's property. Optionally, you can add condition and parameters used in condition.
string
string
string
(qb) => SelectQueryBuilder<any>
this
loadRelationIdAndMap(
mapToProperty,relationName,options?):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:366
LEFT JOINs relation id and maps it into some entity's property. Optionally, you can add condition and parameters used in condition.
string
string
boolean
this
loadRelationIdAndMap(
mapToProperty,relationName,alias,queryBuilderFactory):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:373
LEFT JOINs relation id and maps it into some entity's property. Optionally, you can add condition and parameters used in condition.
string
string
string
(qb) => SelectQueryBuilder<any>
this
maxExecutionTime(
milliseconds):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:86
Set max execution time.
number
this
protectedmergeExpressionMap(expressionMap):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:677
Merges into expression map given expression map properties.
Partial<QueryExpressionMap>
this
protectednormalizeNumber(num):any
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:282
any
any
protectedobtainQueryRunner():QueryRunner
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:681
Creates a query builder used to execute sql queries inside this query builder.
QueryBuilder.obtainQueryRunner
offset(
offset?):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:518
Sets OFFSET - selection offset. NOTE that it may not work as you expect if you are using joins. If you want to implement pagination, and you are having join in your query, then use the skip method instead.
number
this
orderBy():
this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:488
Sets ORDER BY condition in the query builder. If you had previously ORDER BY expression defined, calling this function will override previously set ORDER BY conditions.
Calling order by without order set will remove all previously set order bys.
this
orderBy(
sort,order?,nulls?):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:494
Sets ORDER BY condition in the query builder. If you had previously ORDER BY expression defined, calling this function will override previously set ORDER BY conditions.
string
"ASC" | "DESC"
"NULLS FIRST" | "NULLS LAST"
this
orderBy(
order):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:500
Sets ORDER BY condition in the query builder. If you had previously ORDER BY expression defined, calling this function will override previously set ORDER BY conditions.
this
orHaving(
having,parameters?):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:460
Adds new OR HAVING condition in the query builder. Additionally you can add parameters used in where expression.
string
this
orWhere(
where,parameters?):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:404
Adds new OR WHERE condition in the query builder. Additionally you can add parameters used in where expression.
string | ObjectLiteral | ObjectLiteral[] | Brackets | ((qb) => string)
this
WhereExpressionBuilder.orWhere
orWhereExists(
subQuery):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:416
Adds a new OR where EXISTS clause
SelectQueryBuilder<any>
this
orWhereInIds(
ids):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:443
Adds new OR WHERE with conditions for the given ids.
Ids are mixed. It means if you have single primary key you can pass a simple id values, for example [1, 2, 3]. If you have multiple primary keys you need to pass object with property names and values specified, for example [{ firstId: 1, secondId: 2 }, { firstId: 2, secondId: 3 }, ...]
any
this
WhereExpressionBuilder.orWhereInIds
printSql():
this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:159
Prints sql to stdout using console.log.
this
relation(
propertyPath):RelationQueryBuilder<Entity>
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:112
Sets entity's relation with which this query builder gonna work.
string
RelationQueryBuilder<Entity>
relation<
T>(entityTarget,propertyPath):RelationQueryBuilder<T>
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:116
Sets entity's relation with which this query builder gonna work.
T extends ObjectLiteral
EntityTarget<T>
string
protectedreplacePropertyNames(statement):string
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:234
string
string
this way of replace property names is too slow. Instead, we'll replace property names at the end - once query is build.
QueryBuilder.replacePropertyNames
protectedreplacePropertyNamesForTheWholeQuery(statement):string
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:238
Replaces all entity's propertyName to name in the given SQL string.
string
string
QueryBuilder.replacePropertyNamesForTheWholeQuery
restore():
SoftDeleteQueryBuilder<any>
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:108
SoftDeleteQueryBuilder<any>
select():
this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:54
Creates SELECT query. Replaces all previous selections if they exist.
this
select(
selection,selectionAliasName?):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:59
Creates SELECT query. Replaces all previous selections if they exist.
(qb) => SelectQueryBuilder<any>
string
this
select(
selection,selectionAliasName?):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:64
Creates SELECT query and selects given data. Replaces all previous selections if they exist.
string
string
this
select(
selection):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:69
Creates SELECT query and selects given data. Replaces all previous selections if they exist.
string[]
this
QueryBuilder.select
setFindOptions(
findOptions):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:45
FindManyOptions<Entity>
this
setLock(
lockMode,lockVersion):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:536
Sets locking mode.
"optimistic"
number | Date
this
setLock(
lockMode,lockVersion?,lockTables?):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:540
Sets locking mode.
"pessimistic_read" | "pessimistic_write" | "dirty_read" | "pessimistic_partial_write" | "pessimistic_write_or_fail" | "for_no_key_update" | "for_key_share"
undefined
string[]
this
setNativeParameters(
parameters):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:151
Adds native parameters from the given object.
this
Use setParameters instead
QueryBuilder.setNativeParameters
setOnLocked(
onLocked):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:544
Sets lock handling by adding NO WAIT or SKIP LOCKED.
"nowait" | "skip_locked"
this
setOption(
option):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:612
Sets extra options that can be used to configure how query builder works.
SelectQueryBuilderOption
this
setParameter(
key,value):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:140
Sets parameter name and its value.
The key for this parameter may contain numbers, letters, underscores, or periods.
string
any
this
setParameters(
parameters):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:144
Adds all parameters from the given object.
this
setQueryRunner(
queryRunner):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:202
Sets or overrides query builder's QueryRunner.
this
skip(
skip?):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:526
Sets number of entities to skip.
number
this
softDelete():
SoftDeleteQueryBuilder<any>
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:107
SoftDeleteQueryBuilder<any>
stream():
Promise<ReadStream>
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:595
Executes built SQL query and returns raw data stream.
Promise<ReadStream>
subQuery():
SelectQueryBuilder<any>
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:49
Creates a subquery - query that can be used inside other queries.
SelectQueryBuilder<any>
take(
take?):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:522
Sets maximal number of entities to take.
number
this
timeTravelQuery(
timeTravelFn?):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:480
Enables time travelling for the current query (only supported by cockroach currently)
string | boolean
this
update():
UpdateQueryBuilder<Entity>
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:90
Creates UPDATE query and applies given update values.
UpdateQueryBuilder<Entity>
update(
updateSet):UpdateQueryBuilder<Entity>
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:94
Creates UPDATE query and applies given update values.
QueryDeepPartialEntity<Entity>
UpdateQueryBuilder<Entity>
update<
Entity>(entity,updateSet?):UpdateQueryBuilder<Entity>
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:98
Creates UPDATE query for the given entity and applies given update values.
Entity extends ObjectLiteral
EntityTarget<Entity>
_QueryDeepPartialEntity<ObjectLiteral extends Entity ? unknown : Entity>
UpdateQueryBuilder<Entity>
update(
tableName,updateSet?):UpdateQueryBuilder<Entity>
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:102
Creates UPDATE query for the given table name and applies given update values.
string
_QueryDeepPartialEntity<ObjectLiteral extends Entity ? unknown : Entity>
UpdateQueryBuilder<Entity>
useIndex(
index):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:532
Set certain index to be used by the query.
string
Name of index to be used.
this
useTransaction(
enabled):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:211
If set to true the query will be wrapped into a transaction.
boolean
this
protectedvalidateNumericInput(label,num):number|undefined
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:287
Normalizes and validates a numeric query parameter, throwing if the result is NaN.
string
number | undefined
number | undefined
QueryBuilder.validateNumericInput
protectedvalidateOrderByCondition(sort):void
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:281
void
QueryBuilder.validateOrderByCondition
where(
where,parameters?):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:394
Sets WHERE condition in the query builder. If you had previously WHERE expression defined, calling this function will override previously set WHERE conditions. Additionally you can add parameters used in where expression.
string | ObjectLiteral | ObjectLiteral[] | Brackets | ((qb) => string)
this
whereExists(
subQuery):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:408
Sets a new where EXISTS clause
SelectQueryBuilder<any>
this
whereInIds(
ids):this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:425
Adds new AND WHERE with conditions for the given ids.
Ids are mixed. It means if you have single primary key you can pass a simple id values, for example [1, 2, 3]. If you have multiple primary keys you need to pass object with property names and values specified, for example [{ firstId: 1, secondId: 2 }, { firstId: 2, secondId: 3 }, ...]
any
this
WhereExpressionBuilder.whereInIds
withDeleted():
this
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/SelectQueryBuilder.d.ts:548
Disables the global condition of "non-deleted" for the entity with delete date columns.
this
staticregisterQueryBuilderClass(name,factory):void
定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/query-builder/QueryBuilder.d.ts:59
string
any
void
- @142vip/axios
- @142vip/changelog
- @142vip/commit-linter
- @142vip/copyright
- @142vip/data-source
- @142vip/eslint-config
- @142vip/fairy-cli
- @142vip/grpc
- @142vip/nest
- @142vip/nest-redis
- @142vip/nest-typeorm
- @142vip/oauth2.0
- @142vip/open-source
- @142vip/redis
- @142vip/release-version
- @142vip/typeorm
- @142vip/utils