自定义查询
query()
如果上面的ORM链式操作均满足不了你，那可以用这个直接写sql语句查询
- @param
sql查询语句，防止注入请用?占位 - @param
values匹配?的值 - @param
isShowSql是否打印最终执行的SQL语句，默认不打印 - (sql: string, values: (number | string)[] = [], isShowSql: boolean = false)
query()
import { Db } from 'think-ts-db'
export default defineEventHandler(async (event) => {
const user = await Db().query('select * from user where id = ?', [1])
return user
})import { Db } from 'think-ts-db'
export default defineEventHandler(async (event) => {
const user = await Db().query('select * from user where id = ?', [1])
return user
})最终的SQL语句为：
SELECT * FROM user WHERE id = 1SELECT * FROM user WHERE id = 1