peworkshop/actions/auth.js

import { queryOne } from "@/lib/db";
import bcrypt from "bcryptjs";

export async function validateCredentials(username, password) {
  const user = await queryOne("SELECT * FROM users WHERE username = ?", [
    username,
  ]);

  if (user && bcrypt.compareSync(password, user.password)) {
    return {
      id: user.id,
      username: user.username,
      role: user.role,
      teamId: user.team_id,
    };
  }

  return null;
}