Examples CSV Connection

The CSV file driver connects to a local CSV file. It does not support transactions.

Connection URL

csv:///file_path

Usage

var Connection = require('database-js2').Connection;

(async () => {
    let connection, statement, rows;
    connection = new Database('csv:///test.csv?headers=true&overwriteOnExecute=true');
    
    try {
        statement = await connection.prepareStatement("SELECT * WHERE user_name = ?");
        rows = await statement.query('not_so_secret_user');
        console.log(rows);
    } catch (error) {
        console.log(error);
    } finally {
        await connection.close();
    }
})();