hub-postgre-managerdeprecated

# PostgreManager Программа для работы с базой данных postgre

Установка

Для установки программы используйте npm:

npm i postre-manager

Использование postgre-manager.installRouter() c Express js

Подключение модуля

Подключите модуль postgre-manager и в методе use приложения Express укажите на использование installRouter.

   import * as Express from 'express';
   const app = Express();

   import * as Http from 'http';
   const server = new Http.Server(app);
   
   import { InstallRouter, IPostgreConnectionOptions } from 'postgre-manager';

   ...

   app.use('/install/db', InstallRouter(server, "db", <IPostgreConnectionOptions>options, queries));

где,

server: Http.Server,
"db": псевдоним, используется при подключении нескольких InstallRouter,
options: IPostgreConnectionOptions - параметры подключения к базе данных postgre,
queries: Array<namedQuery> - массив запросов создания базы данных.

Параметры подключения к базе данных postgre

    interface IPostgreConnectionOptions {
        host: string,
        user?: string, // default process.env.PGUSER || process.env.USER
        password?: string, //default process.env.PGPASSWORD
        database?: string, // default process.env.PGDATABASE || process.env.USER
        templateDatabase?: string, //template database on which creates new database
        port?: number, // default process.env.PGPORT
        statement_timeout: number, // number of milliseconds before a query will time out default is no timeout

        // number of milliseconds to wait before timing out when connecting a new client
        // by default this is 0 which means no timeout
        connectionTimeoutMillis?: number,
        // number of milliseconds a client must sit idle in the pool and not be checked out
        // before it is disconnected from the backend and discarded
        // default is 10000 (10 seconds) - set to 0 to disable auto-disconnection of idle clients
        idleTimeoutMillis?: number,
        // maximum number of clients the pool should contain
        // by default this is set to 10.
        max?: number,
    }

Пример массива запросов создания базы данных

    const queries: Array<namedQuery> = [
        {
            name: `Создание базы данных "db"`,
            query: `CREATE DATABASE db`
        }
    ]

Пример использования двух InstallRouter()

app.use('/install/products',
    (req: Express.Request, res: Express.Response, next: Express.NextFunction) => {
        if (req.isAuthenticated()) {
            next();    
        } else {
            res.send('Login failed');
        }
    },
    InstallRouter(server, "productsDB", <IPostgreConnectionOptions>productsDBConnectionOptions, installProductsDBQueries)
);

app.use('/install/users',
    (req: Express.Request, res: Express.Response, next: Express.NextFunction) => {
        if (req.isAuthenticated()) {
            next();    
        } else {
            res.send('Login failed');
        }
    },
    InstallRouter(server, "usersDB", <IPostgreConnectionOptions>usersDBConnectionOptions, installusersDBQueries)
);