PostgreSQL backup tool with Point-In-Time-Recovery and restore verification
TypeScript backupbackupsdatabasedatabase-backupdevopsdockergolangkubernetesmariadbmongodbmysqlpgpostgrespostgresqls3self-hostedsystem-administrationtoolsweb-ui
import { InfoCircleOutlined } from '@ant-design/icons';
import { useEffect, useState } from 'react';
import { Trans, useTranslation } from 'react-i18next';
import { logicalBackupConfigApi } from '../../../entity/backups/logical';
import { physicalBackupConfigApi } from '../../../entity/backups/physical';
import { type Database, DatabaseType, HEALTH_STATUS_LABEL_KEYS } from '../../../entity/databases';
import { HealthStatus } from '../../../entity/databases/model/HealthStatus';
import type { Storage } from '../../../entity/storages';
import { getStorageLogoFromType } from '../../../entity/storages/models/getStorageLogoFromType';
import { useLocale } from '../../../shared/i18n';
interface Props {
database: Database;
selectedDatabaseId?: string;
setSelectedDatabaseId: (databaseId: string) => void;
}
export const DatabaseCardComponent = ({
database,
selectedDatabaseId,
setSelectedDatabaseId,
}: Props) => {
const { t } = useTranslation();
const { formatRelativeTime } = useLocale();
const [storage, setStorage] = useState<Storage | undefined>();
useEffect(() => {
if (!database.id) return;
const backupConfigRequest =
database.type === DatabaseType.POSTGRES_PHYSICAL
? physicalBackupConfigApi.getPhysicalBackupConfigByDbId(database.id)
: logicalBackupConfigApi.getBackupConfigByDbID(database.id);
backupConfigRequest.then((config) => setStorage(config?.storage));
}, [database.id, database.type]);
return (
<div
className={`mb-3 cursor-pointer rounded p-3 shadow ${selectedDatabaseId === database.id ? 'bg-blue-100 dark:bg-blue-800' : 'bg-white dark:bg-gray-800'}`}
onClick={() => setSelectedDatabaseId(database.id)}
>
<div className="flex">
<div className="mb-1 min-w-0 font-bold break-words">{database.name}</div>
{database.healthStatus && (
<div className="ml-auto shrink-0 pl-1">
<div
className={`rounded px-[6px] py-[2px] text-[10px] text-white ${
database.healthStatus === HealthStatus.AVAILABLE ? 'bg-green-500' : 'bg-red-500'
}`}
>
{t(HEALTH_STATUS_LABEL_KEYS[database.healthStatus])}
</div>
</div>
)}
</div>
{storage && (
<div className="text-sm text-gray-500 dark:text-gray-400">
<Trans
i18nKey="databases.card.storage"
components={{
storageName: (
<span className="inline-flex items-center">
{storage.name}{' '}
{storage.type && (
<img
src={getStorageLogoFromType(storage.type)}
alt=""
className="ml-1 h-4 w-4"
/>
)}
</span>
),
}}
/>
</div>
)}
{database.lastBackupTime && (
<div className="text-gray-500 dark:text-gray-400">
{t('databases.card.lastBackup', {
relativeTime: formatRelativeTime(database.lastBackupTime),
})}
</div>
)}
{database.lastBackupErrorMessage && (
<div className="mt-1 flex items-center text-sm text-red-600 underline dark:text-red-400">
<InfoCircleOutlined className="mr-1" style={{ color: 'red' }} />
{t('databases.card.hasBackupError')}
</div>
)}
</div>
);
};