import {resolve} from 'path'; import {parse, startChain, param} from 'parameter-reducers'; import isInteractive = require('is-interactive'); import * as interrogator from 'interrogator'; import chalk = require('chalk'); import getSchema, {connect} from '@databases/pg-schema-introspect'; import {readPgConfigSync, getPgConfigSync} from '@databases/pg-config'; import {writeSchema} from '@databases/pg-schema-print-types'; const parameterParser = startChain() .addParam(param.string(['-c', '--database'], 'database')) .addParam(param.string(['-d', '--directory'], 'directory')) .addParam(param.string(['--config'], 'configFilename')) .addParam(param.string(['-s', '--schemaName'], 'schemaName')); export default async function run( cwd: string, args: string[], ): Promise { const params = parse(parameterParser, args).extract(); const { connectionStringEnvironmentVariable, types: {directory, ...types}, } = params.configFilename ? readPgConfigSync(resolve(cwd, params.configFilename)) : getPgConfigSync(cwd); let database = params.database ?? process.env[connectionStringEnvironmentVariable]; if (!database) { console.error( 'You must supply a connection string for the database. You can supply it as either:', ); console.error(''); console.error( ` - The environment variable ${chalk.cyan( connectionStringEnvironmentVariable, )}`, ); console.error( ` - The ${chalk.cyan('--database')} parameter when calling pg-migrations`, ); console.error(''); if (isInteractive()) { database = await interrogator.input('Please enter a connection string:'); } } if (!database) { return 1; } const connection = connect({connectionString: database, poolSize: 1}); let schema; try { schema = await getSchema(connection, {schemaName: params.schemaName}); } finally { await connection.dispose().catch(() => { // ignore the error if it's just disposing the database connection }); } await writeSchema(schema, resolve(cwd, params.directory ?? directory), types); return 0; }