const { Client } = require('pg')
const connectionString = 'postgresql://postgres:@127.0.0.1:5432/oz'
const insertCount = 1000;

const client = new Client({
    connectionString: connectionString,
})

client.connect()

function insertToDatabase() {
    return new Promise((resolve, reject) => {
        for (let i = 0; i < insertCount; i++) {
            client.query(`insert into documents(name, type, created_at, department, contracted_amount) values (${i}, ${i}, \'2019-11-22\', ${i}, ${i})`, (err, res) => {
                if(i === insertCount-1){
                    resolve(true)
                }
            })
        }
    })
}

let date1 = Date.now()
insertToDatabase().then(x => {
    let date2 = Date.now();
    console.log("Inserts per second:", insertCount/((date2-date1)/1000))
    client.end()
})