conradoqg / embedded-postgresql Goto Github PK

import { checkInstallation, install, uninstall } from 'embedded-postgresql';

async function main() {
    if (!await checkInstallation())
        await install('13.2.0');
}
main();

import { EmbeddedPostgreSQL } from 'embedded-postgresql';

async function main() {
    const embeddedPostgreSQL = new EmbeddedPostgreSQL(testDataPath);

    if (!await embeddedPostgreSQL.isInitialized())
        await embeddedPostgreSQL.initialize();

    await embeddedPostgreSQL.updateConfig({
        wal_level: 'minimal',
        max_worker_processes: 1,
        max_parallel_workers: 1
    });

    await embeddedPostgreSQL.start();

    await embeddedPostgreSQL.stop();
}
main();

import { EmbeddedPostgreSQL } from 'embedded-postgresql';
import pg from 'pg'; // install it with npm install pg

async function main() {
    const password = 'secretpassword';

    await fsExtra.writeFile('./password.txt', password);
    
    if (!await embeddedPostgreSQL.isInitialized())
        await embeddedPostgreSQL.initialize(['-U', 'postgres', '-A', 'md5', '--pwfile', './password.txt']);

    await fsExtra.remove('./password.txt');

    await embeddedPostgreSQL.start();

    const client = new pg.Client({
        host: 'localhost',
        port: 5432,
        user: 'postgres',
        password: password,
        database: 'postgres'
    });

    await client.connect();
    const res = await client.query('SELECT $1::text as message', ['Hello world!']);
    
    await client.end();
}
main();

import { EmbeddedPostgreSQL, logger } from 'embedded-postgresql';

if (process.env.NODE_ENV == 'development') {
    logger.setSettings({
        minLevel: 'debug',
        suppressStdOutput: false
    });
}

async function main() {
    const embeddedPostgreSQL = new EmbeddedPostgreSQL(testDataPath);

    await embeddedPostgreSQL.start();

    await embeddedPostgreSQL.stop();
}
main();