import {v4 as uuidv4} from "uuid"
import { CORE, ID, ROLE } from "../../utils/globals";
import getDatabaseClient from "../../database/knexClient"
import { Knex } from "knex";

class RoleDAO{
    async createRole(tenantId:string, descriptor:any, descriptorSchemaVersion:string, editable:boolean, isDefault:boolean, descriptorSchemaId:string) {
        const dbClient:Knex = await getDatabaseClient(CORE);
        const [id] = await dbClient
            .insert({
                TenantId: tenantId,
                Descriptor: descriptor,
                DescriptorSchemaVersion: descriptorSchemaVersion,
                Id: uuidv4().toString(),
                Editable: editable,
                IsDefault: isDefault,
                DescriptorSchemaId: descriptorSchemaId
            })
            .into(ROLE)
            .returning(ID);
        return id;
    }

    async getRoles(){
        const dbClient:Knex = await getDatabaseClient(CORE);
        const roles:any[] = await dbClient
            .select()
            .from(ROLE);
        return roles;
    }

}

export default new RoleDAO()