marc
94f1f13302
The Fastify layer over pgmorbac: permission checks, RLS session context, management routes, PostgREST data proxy, and the migration loader for the SQL from @crudy/pgmorbac. The SQL is no longer bundled here.
29 lines
1.3 KiB
TypeScript
29 lines
1.3 KiB
TypeScript
import { extensionSql, upgradeScripts, version } from '@crudy/pgmorbac';
|
|
|
|
export interface MorbacMigration {
|
|
filename: string;
|
|
sql: string;
|
|
}
|
|
|
|
// The pgmorbac install and upgrade scripts (from @crudy/pgmorbac) as plain
|
|
// migrations for a migration runner. Without CREATE EXTENSION the morbac schema is
|
|
// created up front, and the installed version is recorded. The base keeps the
|
|
// historical filename 0001_morbac.sql so schema_migrations rows on existing
|
|
// databases stay valid; its bytes must not change for an unchanged extension
|
|
// version, or boot re-runs it. Upgrades follow as 0001_morbac--<old>--<new>.sql.
|
|
export function morbacMigrations(): MorbacMigration[] {
|
|
const lines = extensionSql().split('\n');
|
|
lines.splice(lines.indexOf('') + 1, 0, 'CREATE SCHEMA IF NOT EXISTS morbac;');
|
|
const sql = lines.join('\n') + `
|
|
-- Record the installed schema version (readable via
|
|
-- morbac.get_config('schema_version'); upgrade scripts bump it).
|
|
INSERT INTO morbac.config (key, value, description)
|
|
VALUES ('schema_version', '${version}', 'Installed pgmorbac schema version')
|
|
ON CONFLICT (key) DO UPDATE SET value = EXCLUDED.value, updated_at = CURRENT_TIMESTAMP;
|
|
`;
|
|
return [
|
|
{ filename: '0001_morbac.sql', sql },
|
|
...upgradeScripts().map(u => ({ filename: `0001_morbac--${u.from}--${u.to}.sql`, sql: u.sql })),
|
|
];
|
|
}
|