'use strict';
const mysql = require('mysql');

const Base = require('./base');
const config = require('./config')

module.exports = class MySQLDB extends Base {
    constructor() {
        super();

        this.connection = mysql.createConnection({
            ...config.db.mysql
        });

        this.connection.connect();
    }

    getUserById(id) {
        const sql = `select * from user where id = ${id}`;

        return new Promise((resolve, reject) => {
            this.connection.query(sql, function (err, results, fields) {
                err ? reject(err) : resolve(results);
            });
        });
    }

    getPager(collectionName, json) {
        return this.getUserById(1);
    }
};