使用 Query Builder 插入 - typeorm

Official docs Docs Issue #19

Search…

Contributing to TypeORM

Building and Testing TypeORM

Active Record vs Data Mapper

Caching queries

Connection APIs

Connection Options

Working with Connection

Custom repositories

Decorator reference

Delete using Query Builder

Eager and Lazy Relations

Embedded Entities

Entity Inheritance

EntityManager API

Entity Metadata

Example using TypeORM with Express

Insert using Query Builder

Entity Listeners and Subscribers

Many-to-many relations

Many-to-one / one-to-many relations

Multiple connections, databases, schemas and replication setup

Naming strategy

One-to-one relations

Working with Query Runner

Working with Relations

Repository APIs

Select using Query Builder

Separating Entity Definition

Migration from Sequelize to TypeORM

Supported platforms

Troubleshooting

Update using Query Builder

Using with JavaScript

Using Configuration Sources

Using Validation

What is EntityManager

What is Repository

使用 Query Builder 插入

Powered By GitBook

使用 Query Builder 插入

你可以使用QueryBuilder创建INSERT查询。 例如：
1
import { getConnection } from "typeorm";
2
​
3
await getConnection()
4
  .createQueryBuilder()
5
  .insert()
6
  .into(User)
7
  .values([{ firstName: "Timber", lastName: "Saw" }, { firstName: "Phantom", lastName: "Lancer" }])
8
  .execute();
Copied!
就性能而言，这是向数据库中插入实体的最有效方法。 你也可以通过这种方式执行批量插入。
原始SQL支持
在某些情况下需要执行函数SQL查询时：
1
import {getConnection} from "typeorm";
2
​
3
await getConnection()
4
    .createQueryBuilder()
5
    .insert()
6
    .into(User)
7
    .values({ 
8
        firstName: "Timber", 
9
        lastName: () => "CONCAT('S', 'A', 'W')"
10
    })
11
    .execute();
Copied!
此语法不会对值进行转义，你需要自己处理转义。

Last modified 1mo ago

Copy link

Contents

原始SQL支持