PostgreSQL backup tool with Point-In-Time-Recovery and restore verification
TypeScript backupbackupsdatabasedatabase-backupdevopsdockergolangkubernetesmariadbmongodbmysqlpgpostgrespostgresqls3self-hostedsystem-administrationtoolsweb-ui
import { renderToStaticMarkup } from 'react-dom/server';
import { describe, expect, it, vi } from 'vitest';
import {
type Database,
DatabaseType,
type PostgresqlLogicalDatabase,
PostgresSslMode,
PostgresqlVersion,
} from '../../../../entity/databases';
import { LocaleProvider } from '../../../../shared/i18n';
import { ShowPostgreSqlLogicalSpecificDataComponent } from './ShowPostgreSqlLogicalSpecificDataComponent';
// The entity's public API imports its API client, and the client's config
// module reads window at import time. The tests run in node, so they supply
// window. LocaleProvider then reads localStorage, which here reports no saved
// language.
vi.hoisted(() => {
vi.stubGlobal('window', {});
vi.stubGlobal('localStorage', { getItem: () => null });
vi.stubGlobal('navigator', { language: 'en-US', languages: ['en-US'] });
});
const createPostgresqlDatabase = (change: Partial<PostgresqlLogicalDatabase>): Database => ({
id: 'database-id',
name: 'Orders',
workspaceId: 'workspace-id',
type: DatabaseType.POSTGRES_LOGICAL,
notifiers: [],
postgresqlLogical: {
id: 'postgresql-id',
version: PostgresqlVersion.PostgresqlVersion16,
host: 'db.example.com',
port: 5432,
username: 'backup',
password: '',
database: 'orders',
sslMode: PostgresSslMode.Require,
cpuCount: 1,
...change,
},
});
const renderPostgresqlPage = (database: Database) =>
renderToStaticMarkup(
<LocaleProvider>
<ShowPostgreSqlLogicalSpecificDataComponent database={database} />
</LocaleProvider>,
);
describe('ShowPostgreSqlLogicalSpecificDataComponent', () => {
it('shows each exclusion list under its own label', () => {
const markup = renderPostgresqlPage(
createPostgresqlDatabase({ excludeTables: ['audit_tmp'], excludeTableData: ['logs'] }),
);
const wholeTablesLabelIndex = markup.indexOf('Exclude whole tables');
const tableDataLabelIndex = markup.indexOf('Exclude table data');
expect(wholeTablesLabelIndex).toBeGreaterThan(-1);
expect(markup.indexOf('audit_tmp')).toBeGreaterThan(wholeTablesLabelIndex);
expect(markup.indexOf('audit_tmp')).toBeLessThan(tableDataLabelIndex);
expect(markup.indexOf('logs')).toBeGreaterThan(tableDataLabelIndex);
});
it('hides both exclusion rows when neither list is set', () => {
const markup = renderPostgresqlPage(createPostgresqlDatabase({}));
expect(markup).not.toContain('Exclude whole tables');
expect(markup).not.toContain('Exclude table data');
});
});