[TOC] ## 查詢 **簡單查詢** ``` const firstUser = await dataSource .getRepository(User) .createQueryBuilder("user") .where("user.id = :id", { id: 1 }) .getOne() ``` **創建和使用QueryBuilder** ``` const user = await dataSource.manager .createQueryBuilder(User, "user") .where("user.id = :id", { id: 1 }) .getOne() ``` ## 插入 批量插入 ``` await dataSource .createQueryBuilder() .insert() .into(User) .values([ { firstName: "Timber", lastName: "Saw" }, { firstName: "Phantom", lastName: "Lancer" }, ]) .execute() ``` 就性能而言，這是將行插入數據庫的最有效方式。您也可以通過這種方式執行批量插入。 支持原生 ``` await dataSource .createQueryBuilder() .insert() .into(User) .values({ firstName: "Timber", lastName: () => "CONCAT('S', 'A', 'W')", }) .execute() ``` ## 更新 ``` await dataSource .createQueryBuilder() .update(User) .set({ firstName: "Timber", lastName: "Saw" }) .where("id = :id", { id: 1 }) .execute() ``` ## 刪除 ``` await dataSource .createQueryBuilder() .delete() .from(User) .where("id = :id", { id: 1 }) .execute() ``` ## where ``` orWhere andWhere where ``` ## ORDER BY ``` createQueryBuilder("user").orderBy("user.id") ``` ## GROUP BY ``` createQueryBuilder("user").groupBy("user.id") ``` ## 分頁 ``` const users = await dataSource .getRepository(User) .createQueryBuilder("user") .leftJoinAndSelect("user.photos", "photo") .skip(5) .take(10) .getMany() ``` ## 打印sql 返回sql ``` const sql = createQueryBuilder("user") .where("user.firstName = :firstName", { firstName: "Timber" }) .orWhere("user.lastName = :lastName", { lastName: "Saw" }) .getSql() ``` 打印控制臺 ``` const users = await createQueryBuilder("user") .where("user.firstName = :firstName", { firstName: "Timber" }) .orWhere("user.lastName = :lastName", { lastName: "Saw" }) .printSql() .getMany() ``` ## 緩存查詢 您可以緩存通過以下方法選擇的結果`QueryBuilder`：`getMany`、`getOne`、`getRawMany`和。`getRawOne``getCount` 您還可以緩存由and的`find*`和`count*`方法選擇的結果。`Repository``EntityManager` 要啟用緩存,現在數據 ``` { type: "mysql", host: "localhost", username: "test", ... cache: true } ``` 緩存 ``` const users = await dataSource .createQueryBuilder(User, "user") .where("user.isAdmin = :isAdmin", { isAdmin: true }) .cache(true) .getMany() ```