mirror of
https://github.com/meienberger/runtipi.git
synced 2024-10-04 07:38:21 +03:00
84ea5dcb7f
* chore: bump version to 3.5.2 * fix(container): use env variables instead of parsing before ready * chore: run biome safe autofix * fix(db): use env for username and db instead of hardcoded value
18 lines
504 B
TypeScript
18 lines
504 B
TypeScript
import * as schema from '@runtipi/db';
|
|
import { drizzle } from 'drizzle-orm/node-postgres';
|
|
import { Pool } from 'pg';
|
|
|
|
const connectionString = `postgresql://tipi:${process.env.POSTGRES_PASSWORD}@${process.env.SERVER_IP}:5432/tipi?connect_timeout=300`;
|
|
|
|
const pool = new Pool({
|
|
connectionString,
|
|
});
|
|
|
|
export const db = drizzle(pool, { schema });
|
|
|
|
export const clearDatabase = async () => {
|
|
// delete all data in table user
|
|
await db.delete(schema.userTable);
|
|
await db.delete(schema.appTable);
|
|
};
|