"use strict";

const utils = require("../utils");

const api = async ({ sql, getConnection }) => {
    const sqlQueries = await utils.loadSqlQueries("events");
    const getSecurity = async SecurityKey => {
        const cnx = await getConnection();
        const request = await cnx.request();
        request.input('SecurityKey', SecurityKey);
        return request.query(sqlQueries.getSecurity);
    };

    return {
        getSecurity
    };
};

module.exports = { api };