PostgreSQL backup tool with Point-In-Time-Recovery and restore verification
TypeScript backupbackupsdatabasedatabase-backupdevopsdockergolangkubernetesmariadbmongodbmysqlpgpostgrespostgresqls3self-hostedsystem-administrationtoolsweb-ui
import { getApplicationServer } from '../../../constants';
import { apiHelper } from '../../../shared/api/apiHelper';
import RequestOptions from '../../../shared/api/RequestOptions';
import type { CreateReadOnlyUserResponse } from '../model/CreateReadOnlyUserResponse';
import type { CreateReplicationOnlyUserResponse } from '../model/CreateReplicationOnlyUserResponse';
import type { Database } from '../model/Database';
import type { ShouldSuggestReadOnlyUserResponse } from '../model/ShouldSuggestReadOnlyUserResponse';
export const databaseApi = {
async createDatabase(database: Database) {
const requestOptions: RequestOptions = new RequestOptions();
requestOptions.setBody(JSON.stringify(database));
return apiHelper.fetchPostJson<Database>(
`${getApplicationServer()}/api/v1/databases/create`,
requestOptions,
);
},
async updateDatabase(database: Database) {
const requestOptions: RequestOptions = new RequestOptions();
requestOptions.setBody(JSON.stringify(database));
return apiHelper.fetchPostJson<Database>(
`${getApplicationServer()}/api/v1/databases/update`,
requestOptions,
);
},
async getDatabase(id: string) {
const requestOptions: RequestOptions = new RequestOptions();
return apiHelper.fetchGetJson<Database>(
`${getApplicationServer()}/api/v1/databases/${id}`,
requestOptions,
true,
);
},
async getDatabases(workspaceId: string) {
const requestOptions: RequestOptions = new RequestOptions();
return apiHelper.fetchGetJson<Database[]>(
`${getApplicationServer()}/api/v1/databases?workspace_id=${workspaceId}`,
requestOptions,
true,
);
},
async deleteDatabase(id: string) {
const requestOptions: RequestOptions = new RequestOptions();
return apiHelper.fetchDeleteRaw(
`${getApplicationServer()}/api/v1/databases/${id}`,
requestOptions,
);
},
async copyDatabase(id: string) {
const requestOptions: RequestOptions = new RequestOptions();
return apiHelper.fetchPostJson<Database>(
`${getApplicationServer()}/api/v1/databases/${id}/copy`,
requestOptions,
);
},
async testDatabaseConnection(id: string) {
const requestOptions: RequestOptions = new RequestOptions();
return apiHelper.fetchPostJson(
`${getApplicationServer()}/api/v1/databases/${id}/test-connection`,
requestOptions,
);
},
async testDatabaseConnectionDirect(database: Database) {
const requestOptions: RequestOptions = new RequestOptions();
requestOptions.setBody(JSON.stringify(database));
return apiHelper.fetchPostJson(
`${getApplicationServer()}/api/v1/databases/test-connection-direct`,
requestOptions,
);
},
async isNotifierUsing(notifierId: string) {
const requestOptions: RequestOptions = new RequestOptions();
return apiHelper
.fetchGetJson<{
isUsing: boolean;
}>(
`${getApplicationServer()}/api/v1/databases/notifier/${notifierId}/is-using`,
requestOptions,
true,
)
.then((res) => res.isUsing);
},
async getDatabasesCountForNotifier(notifierId: string): Promise<number> {
const requestOptions: RequestOptions = new RequestOptions();
return apiHelper
.fetchGetJson<{
count: number;
}>(
`${getApplicationServer()}/api/v1/databases/notifier/${notifierId}/databases-count`,
requestOptions,
true,
)
.then((res) => res.count);
},
async shouldSuggestReadOnlyUser(database: Database) {
const requestOptions: RequestOptions = new RequestOptions();
requestOptions.setBody(JSON.stringify(database));
return apiHelper.fetchPostJson<ShouldSuggestReadOnlyUserResponse>(
`${getApplicationServer()}/api/v1/databases/should-suggest-readonly-user`,
requestOptions,
);
},
async createReadOnlyUser(database: Database) {
const requestOptions: RequestOptions = new RequestOptions();
requestOptions.setBody(JSON.stringify(database));
return apiHelper.fetchPostJson<CreateReadOnlyUserResponse>(
`${getApplicationServer()}/api/v1/databases/create-readonly-user`,
requestOptions,
);
},
async createReplicationOnlyUser(database: Database) {
const requestOptions: RequestOptions = new RequestOptions();
requestOptions.setBody(JSON.stringify(database));
return apiHelper.fetchPostJson<CreateReplicationOnlyUserResponse>(
`${getApplicationServer()}/api/v1/databases/create-replication-only-user`,
requestOptions,
);
},
};