async function main()

in setup/nuvolaris/postgres.js [21:66]

• 9 lines of code
• 2 McCabe index (conditional complexity)

async function main(args) {        
    console.log(args.dburi);

    const client = new Client({connectionString:args.dburi});

    const createTableText = `
    CREATE EXTENSION IF NOT EXISTS "pgcrypto";
    CREATE TABLE IF NOT EXISTS nuvolaris_table (
        id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
        message varchar(100)        
    );
    `

    const createSchema = `CREATE SCHEMA IF NOT EXISTS nuvolaris;
    SET search_path TO nuvolaris;
    `;

    // Connect to database server
    await client.connect();

    response = {body: {}}

    try {

        await client.query(createSchema)

        await client.query(createTableText)
        console.log("CREATED TABLE");
        const message = "Nuvolaris Postgres is up and running!"
        await client.query('INSERT INTO nuvolaris_table(message) VALUES($1)', [message])
        console.log("INSERTED RECORD");
        const { rows } = await client.query('SELECT * FROM nuvolaris_table')
        console.log(rows)
        await client.query('DROP table nuvolaris_table');
        console.log("DROPPED TABLE");
        await client.query('DROP SCHEMA nuvolaris CASCADE');
        response.body = rows;
      } catch (e) {
        console.log(e);        
        throw e
      } finally {
        client.end();
      }

    return response;
}