const { Client } = require('kb')

const client = new Client({
    user: 'SYSTEM',
    host: '192.168.0.102',
    database: 'TEST',
    password: '123456',
    port: 54321,
})

client.connect()

client.query('CREATE TABLE CLIENTTEST (id int, name char(100), address
varchar(200), salary real,' +
             ' date_col DATE, description TEXT)', (err, res) => {
    if (err) {
        return console.error('Error executing query', err.stack)
    }
    console.log(res)

    const now = new Date()
    const text = 'INSERT INTO CLIENTTEST VALUES($1, $2, $3, $4, $5, $6) RETURNING *'
    const values = [1, 'tobby', 'incubation park', '1000', now, 'long TEXT  test']

    client.query(text, values, (err, res) => {
        if (err) {
            return console.error('Error executing query', err.stack)
        }
        console.log(res)

        const query = {
            text: 'UPDATE CLIENTTEST SET name=$1, address=$2 WHERE id=$3  RETURNING *',
            values: ['lewis', 'software park', 1,],
        }

        client.query(query, (err, res) => {
            if (err) {
                return console.error('Error executing query', err.stack)
            }
            console.log(res)

            client.query('SELECT * FROM CLIENTTEST', (err, res) => {
                if (err) {
                    return console.error('Error executing query', err.stack)
                }
                console.log(res)

                client.query('DELETE FROM CLIENTTEST WHERE id=1', (err, res) => {
                    if (err) {
                        return console.error('Error executing query', err.stack)
                    }
                    console.log(res)

                    client.query('DROP TABLE CLIENTTEST', (err, res) => {
                        if (err) {
                            return console.error('Error executing query',
                            err.stack)
                        }
                        console.log(res)

                        client.end()
                    })
                })
            })
        })
    })
})