list.js

const sqlite = require('sqlite-async')


module.exports = class List {

	constructor(dbName = ':memory:') {
		return (async() => {
			this.db = await sqlite.open(dbName)
			//we need this table to store the user track
			const sql = 'CREATE TABLE IF NOT EXISTS uploadTrack\
				(id INTEGER PRIMARY KEY AUTOINCREMENT, singer_name TEXT, singer_details TEXT, description TEXT,image_url TEXT, Track_name TEXT;'
			await this.db.run(sql)
			return this
            console.log("Track open")
		})()
	}

	/**
	 * checks to see if a set of login credentials are valid
	 * @param {String} username the username to check
	 * @param {String} password the password to check
	 * @returns {Boolean} returns true if credentials are valid
	 */
	async getAll() {


	}

	async tearDown() {
		await this.db.close()
	}
}