Skip to content

PostgreSQL backup tool with Point-In-Time-Recovery and restore verification

4.5 KB
Raw Blame
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,
    );
  },
};