Function getUsers

server/users.ts:19–57

(
  input: GetUsersInput
)

}

export async function getUsers(
  input: GetUsersInput
): Promise<GetUsersResponse> {
  try {
    const offset = (input.page - 1) * input.totalItems;
    const limit = input.totalItems;

    const [totalCount] = await db
      .select({ count: count() })
      .from(users)
      .where(
        or(
          input.search ? ilike(users.email, `%${input.search}%`) : undefined,
          input.search ? ilike(users.username, `%${input.search}%`) : undefined
        )
      );

    const totalPages = Math.ceil(totalCount.count / limit);

    const items = await db
      .select()
      .from(users)
      .where(
        or(
          input.search ? ilike(users.email, `%${input.search}%`) : undefined,
          input.search ? ilike(users.username, `%${input.search}%`) : undefined
        )
      )
      .offset(offset)
      .limit(limit);

    return {
      items,
      totalPages,
    };
  } catch (e) {
    throw e;
  }
}

interface CreateUserInput {
  username: string;