dbmodel

import { load, deploy, build } from 'dbmodel'; import { initializeApiEnvironment } from 'dbgate-api'; import { registerPlugins } from 'dbgate-api'; import dbgatePluginPostgres from 'dbgate-plugin-postgres'; async function main() { // It's crucial to initialize the API environment and register plugins for programmatic use initializeApiEnvironment(); registerPlugins(dbgatePluginPostgres); const connectionOptions = { server: process.env.DB_SERVER ?? 'localhost', user: process.env.DB_USER ?? 'postgres', password: process.env.DB_PASSWORD ?? '', database: process.env.DB_DATABASE ?? 'mydatabase', engine: 'postgres@dbgate-plugin-postgres' // Ensure the plugin is installed and registered }; const projectFolder = './my-db-model'; const outputSqlFile = './my-schema.sql'; console.log('Loading database schema...'); await load({ connection: connectionOptions, folder: projectFolder }); console.log(`Schema loaded into ${projectFolder}`); // Make some changes to the YAML files in projectFolder if needed console.log('Deploying schema changes...'); await deploy({ connection: connectionOptions, folder: projectFolder }); console.log('Schema deployed.'); console.log('Building SQL script...'); await build({ engine: 'postgres@dbgate-plugin-postgres', folder: projectFolder, file: outputSqlFile }); console.log(`SQL script built to ${outputSqlFile}`); } main().catch(console.error);