Function searchCreaturesByUsername

server/creatures.ts:120–139

(query: string)

}

export async function searchCreaturesByUsername(query: string) {
  if (!query || query.length < 1) return [];

  try {
    const results = await db.query.creatures.findMany({
      where: ilike(creatures.githubProfileUrl, `%github.com/${query}%`),
      limit: 5,
      orderBy: (creatures, { desc }) => desc(creatures.contributions),
    });

    return results.map((c) => ({
      username: c.githubProfileUrl.split("/").pop() ?? "",
      name: c.name,
      image: c.image,
    }));
  } catch (error) {
    console.error(error);
    return [];
  }
}