PostgreSQL backup tool with Point-In-Time-Recovery and restore verification
TypeScript backupbackupsdatabasedatabase-backupdevopsdockergolangkubernetesmariadbmongodbmysqlpgpostgrespostgresqls3self-hostedsystem-administrationtoolsweb-ui
import { App, Modal } from 'antd';
import { useState } from 'react';
import { useTranslation } from 'react-i18next';
import { type Database, DatabaseType, databaseApi } from '../../../../entity/databases';
import { translateApiError } from '../../../../shared/i18n';
import { CreateReadOnlyComponent } from './CreateReadOnlyComponent';
import { EditMariaDbSpecificDataComponent } from './EditMariaDbSpecificDataComponent';
import { EditMongoDbSpecificDataComponent } from './EditMongoDbSpecificDataComponent';
import { EditMySqlSpecificDataComponent } from './EditMySqlSpecificDataComponent';
import { EditPostgreSqlLogicalSpecificDataComponent } from './EditPostgreSqlLogicalSpecificDataComponent';
import { EditPostgreSqlPhysicalSpecificDataComponent } from './EditPostgreSqlPhysicalSpecificDataComponent';
interface Props {
database: Database;
isShowCancelButton?: boolean;
onCancel: () => void;
isShowBackButton: boolean;
onBack: () => void;
saveButtonText?: string;
isSaveToApi: boolean;
onSaved: (database: Database) => void;
isShowDbName?: boolean;
isRestoreMode?: boolean;
onConnectionErrorChange?: (hasConnectionError: boolean) => void;
}
export const EditDatabaseSpecificDataComponent = ({
database,
isShowCancelButton,
onCancel,
isShowBackButton,
onBack,
saveButtonText,
isSaveToApi,
onSaved,
isShowDbName = true,
isRestoreMode = false,
onConnectionErrorChange,
}: Props) => {
const { t } = useTranslation();
const { message } = App.useApp();
const [isShowReadOnlyDialog, setIsShowReadOnlyDialog] = useState(false);
const [editingDatabase, setEditingDatabase] = useState<Database>(database);
const saveDb = async (databaseToSave: Database) => {
setEditingDatabase(databaseToSave);
if (!isSaveToApi) {
onSaved(databaseToSave);
return;
}
try {
const readOnlyUserSuggestion = await databaseApi.shouldSuggestReadOnlyUser(databaseToSave);
if (readOnlyUserSuggestion.shouldSuggestReadOnlyUser) {
setIsShowReadOnlyDialog(true);
} else {
onSaved(databaseToSave);
}
} catch (e) {
message.error(translateApiError(e, t));
}
};
const onReadOnlyUserCreated = (updatedDatabase: Database) => {
setEditingDatabase(updatedDatabase);
setIsShowReadOnlyDialog(false);
};
const skipReadOnlyUser = () => {
setIsShowReadOnlyDialog(false);
onSaved(editingDatabase);
};
if (isShowReadOnlyDialog) {
return (
<Modal
title={t('databases.readOnlyUser.dialogTitle')}
footer={<div />}
open={isShowReadOnlyDialog}
onCancel={() => setIsShowReadOnlyDialog(false)}
maskClosable={false}
width={640}
>
<CreateReadOnlyComponent
database={editingDatabase}
onReadOnlyUserUpdated={(db) => {
console.log('onReadOnlyUserUpdated', db);
onReadOnlyUserCreated(db);
}}
onGoBack={() => {
setIsShowReadOnlyDialog(false);
}}
onSkipped={() => {
skipReadOnlyUser();
}}
onReadOnlyUserNotSuggested={() => {
onSaved(editingDatabase);
}}
/>
</Modal>
);
}
const commonProps = {
database: editingDatabase,
isShowCancelButton,
onCancel,
isShowBackButton,
onBack,
saveButtonText,
isSaveToApi,
onSaved: saveDb,
isShowDbName,
};
switch (editingDatabase.type) {
case DatabaseType.POSTGRES_LOGICAL:
return (
<EditPostgreSqlLogicalSpecificDataComponent
{...commonProps}
isRestoreMode={isRestoreMode}
/>
);
case DatabaseType.POSTGRES_PHYSICAL:
return (
<EditPostgreSqlPhysicalSpecificDataComponent
{...commonProps}
onConnectionErrorChange={onConnectionErrorChange}
/>
);
case DatabaseType.MYSQL:
return <EditMySqlSpecificDataComponent {...commonProps} />;
case DatabaseType.MARIADB:
return <EditMariaDbSpecificDataComponent {...commonProps} />;
case DatabaseType.MONGODB:
return <EditMongoDbSpecificDataComponent {...commonProps} />;
default:
return null;
}
};