// Ascending (default)
const users = await client.user.findMany({
  orderBy: { name: "asc" },
});

// Descending
const users = await client.user.findMany({
  orderBy: { createdAt: "desc" },
});

// Array syntax
const users = await client.user.findMany({
  orderBy: [
    { lastName: "asc" },
    { firstName: "asc" },
  ],
});

// Sort by role then name
const users = await client.user.findMany({
  orderBy: [
    { role: "asc" },
    { name: "asc" },
  ],
});

// Nulls first
const users = await client.user.findMany({
  orderBy: {
    lastLogin: { sort: "desc", nulls: "first" },
  },
});

// Nulls last
const users = await client.user.findMany({
  orderBy: {
    lastLogin: { sort: "desc", nulls: "last" },
  },
});

// Sort posts by author name
const posts = await client.post.findMany({
  orderBy: {
    author: { name: "asc" },
  },
});

// Sort by nested relation
const comments = await client.comment.findMany({
  orderBy: {
    post: {
      author: { name: "asc" },
    },
  },
});

// Most posts first
const users = await client.user.findMany({
  orderBy: {
    posts: { _count: "desc" },
  },
});

// Most comments first
const posts = await client.post.findMany({
  orderBy: {
    comments: { _count: "desc" },
  },
});

const users = await client.user.findMany({
  include: {
    posts: {
      orderBy: { createdAt: "desc" },
      take: 5,
    },
  },
});

async function getUserList(sortBy: "name" | "createdAt" | "email", order: "asc" | "desc") {
  return client.user.findMany({
    orderBy: { [sortBy]: order },
  });
}

async function getLatestPosts(limit = 10) {
  return client.post.findMany({
    where: { published: true },
    orderBy: { publishedAt: "desc" },
    take: limit,
  });
}

async function getPopularAuthors() {
  return client.user.findMany({
    orderBy: {
      posts: { _count: "desc" },
    },
    include: {
      _count: { select: { posts: true } },
    },
    take: 10,
  });
}

async function getProductsSorted() {
  return client.product.findMany({
    orderBy: [
      { category: { sort: "asc", nulls: "last" } },
      { name: "asc" },
    ],
  });
}

async function getLeaderboard() {
  return client.user.findMany({
    orderBy: [
      { points: "desc" },
      { gamesWon: "desc" },
      { createdAt: "asc" },  // Tiebreaker: oldest first
    ],
    take: 100,
  });
}

// PostgreSQL: Case-sensitive by default
// MySQL: Depends on collation setting
// SQLite: Case-sensitive by default

// Use case-insensitive collation in PostgreSQL
const users = await client.user.findMany({
  orderBy: {
    name: "asc",  // Uses database collation
  },
});