package me.nibblesnow.virgoplex.utils.database;

import lombok.AllArgsConstructor;
import lombok.Getter;
import me.nibblesnow.virgoplex.utils.Settings;

@AllArgsConstructor
public enum QueryType {
    SELECT_FACTIONS("SELECT * FROM `factions_" + Settings.SERVER_NAME + "_factions` LEFT JOIN `factions_" + Settings.SERVER_NAME + "_information` ON `factions_" + Settings.SERVER_NAME + "_factions`.`id`=`factions_" + Settings.SERVER_NAME + "_information`.`faction_id` LEFT JOIN `factions_" + Settings.SERVER_NAME + "_relations` ON `factions_" + Settings.SERVER_NAME + "_factions`.`id`=`factions_" + Settings.SERVER_NAME + "_relations`.`faction_id` LEFT JOIN `factions_" + Settings.SERVER_NAME + "_permissions` ON `factions_" + Settings.SERVER_NAME + "_factions`.`id`=`factions_" + Settings.SERVER_NAME + "_permissions`.`faction_id`;"),
    SELECT_FACTION_CLAIMS("SELECT * FROM `factions_" + Settings.SERVER_NAME + "_claims` LEFT JOIN `factions_" + Settings.SERVER_NAME + "_factions` ON `factions_" + Settings.SERVER_NAME + "_claims`.`faction_id`=`factions_" + Settings.SERVER_NAME + "_factions`.`id`;"),
    SELECT_FACTION_ROLES("SELECT * FROM `factions_" + Settings.SERVER_NAME + "_roles` LEFT JOIN `factions_" + Settings.SERVER_NAME + "_factions` ON `factions_" + Settings.SERVER_NAME + "_roles`.`faction_id`=`factions_" + Settings.SERVER_NAME + "_factions`.`id`;"),
    SELECT_FACTION_LOGS("SELECT * FROM `factions_" + Settings.SERVER_NAME + "_logs` LEFT JOIN `factions_" + Settings.SERVER_NAME + "_factions` ON `factions_" + Settings.SERVER_NAME + "_logs`.`faction_id`=`factions_" + Settings.SERVER_NAME + "_factions`.`id`;"),
    SELECT_FACTION_PERMISSIONS("SELECT * FROM `factions_" + Settings.SERVER_NAME + "_permissions` LEFT JOIN `factions_" + Settings.SERVER_NAME + "_factions` ON `factions_" + Settings.SERVER_NAME + "_permissions`.`faction_id`=`factions_" + Settings.SERVER_NAME + "_factions`.`id` LEFT JOIN `factions_" + Settings.SERVER_NAME + "_claims` ON `factions_" + Settings.SERVER_NAME + "_permissions`.`claim_id`=`factions_" + Settings.SERVER_NAME + "_claims`.`id`;"),
    SELECT_FACTION_PLAYERS("SELECT * FROM `factions_" + Settings.SERVER_NAME + "_players`;"),
    ;

    @Getter
    private String rawQuery;

    public String getQuery(Object... object) {
        return String.format(rawQuery, object);
    }

}