1const chalk = require("chalk");
 2const exec = require("child_process").exec;
 3
 4const execPsqlCommand = async (command = "", psqlConfig) => {
 5  const { host, port, username, password } = psqlConfig;
 6  let shellCmd = `${command} -h ${host} -p ${port} -U ${username}`;
 7
 8  console.log(chalk.grey(shellCmd));
 9
10  if (password) shellCmd = `PGPASSWORD=${password} ${shellCmd}`;
11
12  return new Promise((resolve, reject) => {
13    exec(shellCmd, (error, stdout) => {
14      if (error) reject(error);
15      else resolve(stdout);
16    });
17  });
18};
19
20module.exports = execPsqlCommand;