Node.js Drizzle orderBy 升序、降序、联合排序

orderBy()

使用typeof、$inferSelect提取表结构的类型。

升序

orderBy(columnName)等价于orderBy(asc(columnName))

const postList: Array<Post> = await db.select()
    .from(posts)
    .orderBy(posts.id)
    .limit(10);

降序

orderBy(desc(columnName))

import {desc} from "drizzle-orm";

const postList: Array<Post> = await db.select()
    .from(posts)
    .orderBy(desc(posts.id))
    .limit(10);

联合排序

import {desc, asc} from "drizzle-orm";

const postList: Array<Post> = await db.select()
    .from(posts)
    .orderBy(desc(posts.createTime), asc(posts.id))
    .limit(10);

官方文档

https://orm.drizzle.team/docs/select#order-by