如何将SQL转换为TypeORM查询生成器

Question

如何将下面的代码转换为TypeORM查询生成器？

SELECT * FROM "user"
ORDER BY (CASE 
WHEN ASCII(SUBSTRING(display_name,1)) BETWEEN 48 AND 57 THEN 3
WHEN ASCII(SUBSTRING(display_name,1)) < 128 THEN 2 ELSE 1 END), display_name;

谢谢。

Answer 1

您可以在项目的typeorm模块中直接运行sql查询

首先导入控制器

import {  getManager } from "typeorm";

const entityManager = getManager();
locationQuery = await entityManager.query(`SELECT * FROM "user"
ORDER BY (CASE 
WHEN ASCII(SUBSTRING(display_name,1)) BETWEEN 48 AND 57 THEN 3
WHEN ASCII(SUBSTRING(display_name,1)) < 128 THEN 2 ELSE 1 END), display_name;`);