You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
29 lines
646 B
29 lines
646 B
import pg from "pg";
|
|
|
|
console.log(process.argv[2]);
|
|
|
|
if (process.argv[2] === "flush") {
|
|
|
|
flushDatabase();
|
|
|
|
}
|
|
|
|
async function flushDatabase() {
|
|
const client = new pg.Client({
|
|
user: process.env.DB_USER,
|
|
password: process.env.DB_PASSWORD,
|
|
host: process.env.DB_HOST,
|
|
database: process.env.DB_NAME,
|
|
port: 5432
|
|
});
|
|
|
|
try {
|
|
await client.connect();
|
|
await client.query('TRUNCATE TABLE users CASCADE');
|
|
console.log('Database flushed successfully.');
|
|
} catch (err) {
|
|
console.error('Error flushing database:', err);
|
|
} finally {
|
|
await client.end();
|
|
}
|
|
}
|