module.exports = (db) => {
    return {
        getUsers: (res, callback) => {
            db.all('SELECT * FROM Users', (err, rows) => {
                callback(rows, res);
                return;
            });
        },
        getTasks: (res, callback) => {
            db.all('SELECT * FROM Tasks', (err, rows) => {
                callback(rows, res);
                return;
            });
        },
        getUser: (id) => {
            return db.get('SELECT * FROM User WHERE id = ?', id, (err, row) => {
                callback(row, res);
                return;
            });
        },
        getTask: (res, id, callback) => {
            db.get('SELECT * FROM Tasks WHERE id = ?', id, (err, row) => {
                callback(row, res);
                return;
            });
        },
        updateUser: (id, name, password) => {
            db.run('UPDATE Users SET name = ?, password = ? WHERE id = ?', name, password, id);
        },
        updateTask: (id, title, description) => {
            db.run('UPDATE Tasks SET title = ?, description = ? WHERE id = ?', title, description, id);
        },
        deleteUser: (id) => {
            db.run('DELETE FROM Users WHERE id = ?', id);
        },
        deleteTask: (id) => {
            db.run('DELETE FROM Tasks WHERE id = ?', id);
        },
        insertUser: (name, password) => {
            db.run('INSERT INTO Users VALUES (?,?)', name, password);
        },
        insertTasks: (title, description) => {
            db.run('INSERT INTO Tasks VALUES (?,?)', title, password);
        }
    }
}