'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();
    }

    async getUserById(id) {
        const sql = 'SELECT * FROM user WHERE id = ?';
        try {
            const results = await this.connection.query(sql, [id]);
            return results;
        } catch (err) {
            throw err;
        }
    }


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