Repository navigation
@142vip.nest typeorm.类.InsertQueryBuilder
API 参考 / @142vip/nest-typeorm / InsertQueryBuilder
定义于: 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/InsertQueryBuilder.d.ts:11
Allows to build complex sql queries in a fashion way and execute those queries.
-
QueryBuilder<Entity>
Entity extends ObjectLiteral
new InsertQueryBuilder<
Entity>(queryBuilder):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:54
QueryBuilder can be initialized from given Connection and QueryRunner objects or from given other QueryBuilder.
QueryBuilder<any>
InsertQueryBuilder<Entity>
new InsertQueryBuilder<
Entity>(connection,queryRunner?):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:58
QueryBuilder can be initialized from given Connection and QueryRunner objects or from given other QueryBuilder.
InsertQueryBuilder<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/InsertQueryBuilder.d.ts:12
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.
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.
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
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
protectedcreateColumnNamesExpression():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/InsertQueryBuilder.d.ts:102
Creates a columns string where values must be inserted to for INSERT INTO expression.
string
protectedcreateColumnValueExpression(valueSets,valueSetIndex,column):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/InsertQueryBuilder.d.ts:133
number
ColumnMetadata
string
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
protectedcreateInsertExpression():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/InsertQueryBuilder.d.ts:94
Creates INSERT express used to perform insert query.
string
protectedcreateMergeExpression():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/InsertQueryBuilder.d.ts:120
Creates MERGE express used to perform insert query.
string
protectedcreateMergeIntoInsertValuesExpression(mergeSourceAlias):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/InsertQueryBuilder.d.ts:128
Creates list of values needs to be inserted in the VALUES expression.
string
string
protectedcreateMergeIntoSourceExpression(mergeSourceAlias):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/InsertQueryBuilder.d.ts:124
Creates list of values needs to be inserted in the VALUES expression.
string
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
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
protectedcreateUpsertConditionExpression():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/InsertQueryBuilder.d.ts:132
Create upsert search condition expression.
string
protectedcreateValuesExpression():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/InsertQueryBuilder.d.ts:106
Creates list of values needs to be inserted in the VALUES expression.
string
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
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<InsertResult>
定义于: 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/InsertQueryBuilder.d.ts:20
Executes sql generated by query builder and returns raw database results.
Promise<InsertResult>
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
protectedgetInsertedColumns():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/InsertQueryBuilder.d.ts:98
Gets list of columns where values must be inserted to.
ColumnMetadata[]
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
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/InsertQueryBuilder.d.ts:16
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
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
protectedgetValueSets():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/InsertQueryBuilder.d.ts:110
Gets array of values need to be inserted into the target table.
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
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
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>
into<
T>(entityTarget,columns?):InsertQueryBuilder<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/InsertQueryBuilder.d.ts:24
Specifies INTO which entity's table insertion will be executed.
T extends ObjectLiteral
EntityTarget<T>
string[]
InsertQueryBuilder<T>
protectedisOverridingAutoIncrementBehavior(column):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/InsertQueryBuilder.d.ts:116
Checks if column is an auto-generated primary key, but the current insertion specifies a value for it.
ColumnMetadata
boolean
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/QueryBuilder.d.ts:279
Creates a query builder used to execute sql queries inside this query builder.
QueryBuilder.obtainQueryRunner
onConflict(
statement):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/InsertQueryBuilder.d.ts:68
Adds additional ON CONFLICT statement supported in postgres and cockroach.
string
this
Use orIgnore or orUpdate
orIgnore(
statement?):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/InsertQueryBuilder.d.ts:72
Adds additional ignore statement supported in databases.
string | boolean
this
orUpdate(
statement?):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/InsertQueryBuilder.d.ts:85
string[]
string | string[]
string[]
this
.orUpdate({ columns: [ "is_updated" ] }).setParameter("is_updated", value)
is now .orUpdate(["is_updated"])
.orUpdate({ conflict_target: ['date'], overwrite: ['title'] })
is now .orUpdate(['title'], ['date'])
orUpdate(
overwrite,conflictTarget?,orUpdateOptions?):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/InsertQueryBuilder.d.ts:90
string[]
string | string[]
InsertOrUpdateOptions
this
.orUpdate({ columns: [ "is_updated" ] }).setParameter("is_updated", value)
is now .orUpdate(["is_updated"])
.orUpdate({ conflict_target: ['date'], overwrite: ['title'] })
is now .orUpdate(['title'], ['date'])
output(
columns):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/InsertQueryBuilder.d.ts:33
Optional returning/output clause. This will return given column values.
string[]
this
output(
output):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/InsertQueryBuilder.d.ts:38
Optional returning/output clause. Returning is a SQL string containing returning statement.
string
this
output(
output):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/InsertQueryBuilder.d.ts:42
Optional returning/output clause.
string | string[]
this
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>
returning(
columns):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/InsertQueryBuilder.d.ts:47
Optional returning/output clause. This will return given column values.
string[]
this
returning(
returning):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/InsertQueryBuilder.d.ts:52
Optional returning/output clause. Returning is a SQL string containing returning statement.
string
this
returning(
returning):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/InsertQueryBuilder.d.ts:56
Optional returning/output clause.
string | string[]
this
select():
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:72
Creates SELECT query. Replaces all previous selections if they exist.
SelectQueryBuilder<Entity>
select(
selection,selectionAliasName?):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:77
Creates SELECT query and selects given data. Replaces all previous selections if they exist.
string
string
SelectQueryBuilder<Entity>
select(
selection):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:82
Creates SELECT query and selects given data. Replaces all previous selections if they exist.
string[]
SelectQueryBuilder<Entity>
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
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
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>
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>
updateEntity(
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/InsertQueryBuilder.d.ts:62
Indicates if entity must be updated after insertion operations. This may produce extra query or use RETURNING / OUTPUT statement (depend on database). Enabled by default.
boolean
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
values(
values):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/InsertQueryBuilder.d.ts:28
Values needs to be inserted into table.
_QueryDeepPartialEntity<ObjectLiteral extends Entity ? unknown : Entity> | _QueryDeepPartialEntity<ObjectLiteral extends Entity ? unknown : Entity>[]
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