const { Client } = require('pg')

let datasets = []

const Data = () => {
        return new Promise(resolve => {
            // Connect to PG DB to get MarketPoints
            const client = new Client({
                user: config.database.user,
                host: config.database.host,
                port: config.database.port,
                pass: config.database.password,
                database: config.database.db

            })
            client.connect()

            client.query('SELECT id from schema.table', (err, res) => {
                res.rows.forEach(element => {
                    datasets.push(element)
                });
                resolve(datasets)

                client.end()
            })
 })


const myData = async () => {
  let data = await Data()
  return data
}