index.js

"use strict";
var __awaiter = (this && this.__awaiter) || function (thisArg, _arguments, P, generator) {
    function adopt(value) { return value instanceof P ? value : new P(function (resolve) { resolve(value); }); }
    return new (P || (P = Promise))(function (resolve, reject) {
        function fulfilled(value) { try { step(generator.next(value)); } catch (e) { reject(e); } }
        function rejected(value) { try { step(generator["throw"](value)); } catch (e) { reject(e); } }
        function step(result) { result.done ? resolve(result.value) : adopt(result.value).then(fulfilled, rejected); }
        step((generator = generator.apply(thisArg, _arguments || [])).next());
    });
};
var __generator = (this && this.__generator) || function (thisArg, body) {
    var _ = { label: 0, sent: function() { if (t[0] & 1) throw t[1]; return t[1]; }, trys: [], ops: [] }, f, y, t, g;
    return g = { next: verb(0), "throw": verb(1), "return": verb(2) }, typeof Symbol === "function" && (g[Symbol.iterator] = function() { return this; }), g;
    function verb(n) { return function (v) { return step([n, v]); }; }
    function step(op) {
        if (f) throw new TypeError("Generator is already executing.");
        while (_) try {
            if (f = 1, y && (t = op[0] & 2 ? y["return"] : op[0] ? y["throw"] || ((t = y["return"]) && t.call(y), 0) : y.next) && !(t = t.call(y, op[1])).done) return t;
            if (y = 0, t) op = [op[0] & 2, t.value];
            switch (op[0]) {
                case 0: case 1: t = op; break;
                case 4: _.label++; return { value: op[1], done: false };
                case 5: _.label++; y = op[1]; op = [0]; continue;
                case 7: op = _.ops.pop(); _.trys.pop(); continue;
                default:
                    if (!(t = _.trys, t = t.length > 0 && t[t.length - 1]) && (op[0] === 6 || op[0] === 2)) { _ = 0; continue; }
                    if (op[0] === 3 && (!t || (op[1] > t[0] && op[1] < t[3]))) { _.label = op[1]; break; }
                    if (op[0] === 6 && _.label < t[1]) { _.label = t[1]; t = op; break; }
                    if (t && _.label < t[2]) { _.label = t[2]; _.ops.push(op); break; }
                    if (t[2]) _.ops.pop();
                    _.trys.pop(); continue;
            }
            op = body.call(thisArg, _);
        } catch (e) { op = [6, e]; y = 0; } finally { f = t = 0; }
        if (op[0] & 5) throw op[1]; return { value: op[0] ? op[1] : void 0, done: true };
    }
};
Object.defineProperty(exports, "__esModule", { value: true });
var mysql2_1 = require("mysql2");
var DatabaseMysql = /** @class */ (function () {
    function DatabaseMysql(db) {
        DatabaseMysql.database = db;
    }
    /**
     * Executa uma query no banco de dados
     * @param query
     * @param values
     * @returns Promise
     */
    DatabaseMysql.poolAsync = function (query, values) {
        if (values === void 0) { values = []; }
        var dbConn = mysql2_1.createPool(this.database);
        return new Promise(function (resolve, reject) {
            dbConn.query(query, values, function (error, results, fields) {
                if (error) {
                    reject(error);
                }
                else {
                    resolve(results);
                }
            });
        });
    };
    DatabaseMysql.database = {
        host: '',
        user: '',
        password: '',
        database: ''
    };
    /**
     * Realiza uma operação no banco de dados
     * @param query
     * @param values
     * @returns Promise
     */
    DatabaseMysql.query = function (query, values) {
        if (values === void 0) { values = []; }
        return __awaiter(void 0, void 0, void 0, function () { return __generator(this, function (_a) {
            switch (_a.label) {
                case 0: return [4 /*yield*/, DatabaseMysql.poolAsync(query, values)];
                case 1: return [2 /*return*/, _a.sent()];
            }
        }); });
    };
    /**
     * Realiza um insert no banco de dados
     * @returns Promise
     */
    DatabaseMysql.insert = function (data) { return __awaiter(void 0, void 0, void 0, function () {
        var response;
        return __generator(this, function (_a) {
            switch (_a.label) {
                case 0: return [4 /*yield*/, DatabaseMysql.poolAsync("INSERT INTO " + data.TABLE + " (" + data.columns.join(',') + ") VALUES (" + data.values.join(',') + ")", data.endValues)];
                case 1:
                    response = _a.sent();
                    return [2 /*return*/, response];
            }
        });
    }); };
    /**
     * Realiza um select de colunas em uma tabela, a partir condições no banco de dados
     * @returns Promise
     */
    DatabaseMysql.selectWhere = function (data) { return __awaiter(void 0, void 0, void 0, function () {
        var select, response;
        return __generator(this, function (_a) {
            switch (_a.label) {
                case 0:
                    select = "SELECT " + data.columns.join(',') + " FROM " + data.TABLE + " WHERE " + data.where.join(' ');
                    if (data.order)
                        select += " ORDER " + data.order;
                    if (data.limit)
                        select += " LIMIT " + data.limit;
                    return [4 /*yield*/, DatabaseMysql.poolAsync(select, data.endValues)];
                case 1:
                    response = _a.sent();
                    return [2 /*return*/, response];
            }
        });
    }); };
    /**
     * Realiza um select de colunas em uma tabela no banco de dados
     * @returns Promise
     */
    DatabaseMysql.select = function (data) { return __awaiter(void 0, void 0, void 0, function () {
        var select, response;
        return __generator(this, function (_a) {
            switch (_a.label) {
                case 0:
                    select = "SELECT " + data.columns.join(',') + " FROM " + data.TABLE;
                    if (data.join)
                        select += data.join;
                    if (data.order)
                        select += " ORDER " + data.order;
                    if (data.limit)
                        select += " LIMIT " + data.limit;
                    return [4 /*yield*/, DatabaseMysql.poolAsync(select, [])];
                case 1:
                    response = _a.sent();
                    return [2 /*return*/, response];
            }
        });
    }); };
    /**
     * Realiza um update de colunas em uma tabela no banco de dados a partir de condições
     * @returns Promise
     */
    DatabaseMysql.updateWhere = function (data) { return __awaiter(void 0, void 0, void 0, function () {
        var response;
        return __generator(this, function (_a) {
            switch (_a.label) {
                case 0: return [4 /*yield*/, DatabaseMysql.poolAsync("UPDATE " + data.TABLE + " SET " + data.columns.join(',') + " WHERE " + data.where.join(' '), data.endValues)];
                case 1:
                    response = _a.sent();
                    return [2 /*return*/, response];
            }
        });
    }); };
    /**
     * Realiza um update de colunas em uma tabela no banco de dados
     * @returns Promise
     */
    DatabaseMysql.update = function (data) { return __awaiter(void 0, void 0, void 0, function () {
        var response;
        return __generator(this, function (_a) {
            switch (_a.label) {
                case 0: return [4 /*yield*/, DatabaseMysql.poolAsync("UPDATE " + data.TABLE + " SET " + data.columns.join(','), data.endValues)];
                case 1:
                    response = _a.sent();
                    return [2 /*return*/, response];
            }
        });
    }); };
    /**
     * Realiza um delete em uma tabela, a partir condições no banco de dados
     * @returns Promise
     */
    DatabaseMysql.deleteWhere = function (data) { return __awaiter(void 0, void 0, void 0, function () {
        var response;
        return __generator(this, function (_a) {
            switch (_a.label) {
                case 0: return [4 /*yield*/, DatabaseMysql.poolAsync("DELETE FROM " + data.TABLE + " WHERE " + data.where.join(' '), data.endValues)];
                case 1:
                    response = _a.sent();
                    return [2 /*return*/, response];
            }
        });
    }); };
    /**
     * Realiza um delete em uma tabela no banco de dados
     * @returns Promise
     */
    DatabaseMysql.delete = function (data) { return __awaiter(void 0, void 0, void 0, function () {
        var response;
        return __generator(this, function (_a) {
            switch (_a.label) {
                case 0: return [4 /*yield*/, DatabaseMysql.poolAsync("DELETE FROM " + data.TABLE, [])];
                case 1:
                    response = _a.sent();
                    return [2 /*return*/, response];
            }
        });
    }); };
    return DatabaseMysql;
}());
exports.default = DatabaseMysql;
//# sourceMappingURL=index.js.map