index.js

const TableProxy = require('./proxy')

/**
 * Create new connection to database.
 *
 * By accessing an attribute an existing table will be returned
 * or a new one will be created.
 *
 * See table class about how to do CRUD operations
 *
 * @example
 * // Memory database
 * const dataSet = await connect()
 * const pk = await dataSet.myNewTableName.insert({'myNewColumnName': 'data'})
 *
 * @example
 * // File database
 * const dataSet = await connect('mydb.sqlite')
 * const pk = await dataSet.myNewTableName.insert({'myNewColumnName': 'data'})
 *
 * @param {string} [name=":memory:"]
 * @returns {Object} new Alopex instance.
 */
async function connect(name) {
    const dbName = name || ':memory:'
    const sqlite3Async = await import('sqlite-async');
    return sqlite3Async.Database.open(dbName).then((db) => {
        db.dbName = dbName
        return new Proxy(db, TableProxy)
    })
}

module.exports = connect