import type { Knex } from "knex";

export async function seed(knex: Knex): Promise<void> {
  // Deletes ALL existing entries
  await knex("roles").del();

  // Insert admin user
  await knex("roles").insert([
    {
      role_name: "Admin",
      role_code: "admin",
      role_description: "Have All the Access",
      created_at: new Date(),
      updated_at: new Date(),
      deleted_at: null,
    },
    {
      role_name: "Developer",
      role_code: "developer",
      role_description: "Have All the Access",
      created_at: new Date(),
      updated_at: new Date(),
      deleted_at: null,
    },
    {
      role_name: "Project Manager",
      role_code: "project_manager",
      role_description:
        "have to add the content pages and the content of the pages",
      created_at: new Date(),
      updated_at: new Date(),
      deleted_at: null,
    },
    {
      role_name: "Content Writer",
      role_code: "content_writer",
      role_description: "Have to add prompts and the content",
      created_at: new Date(),
      updated_at: new Date(),
      deleted_at: null,
    },
    {
      role_name: "Web User",
      role_code: "web_user",
      role_description: "Frontend website user with minimal access",
      created_at: new Date(),
      updated_at: new Date(),
      deleted_at: null,
    },
  ]);
}