Skip to content

armgit / dbx

Public Imported from GitHub
0

25 MB lightweight cross-platform database client for 100+ databases, including MySQL, PostgreSQL, SQLite, Redis, MongoDB, DuckDB, SQL Server, and Dameng. Built-in AI, MCP Server, CLI, desktop and Docker. | 轻量级跨平台数据库管理工具,支持 MySQL、PostgreSQL、SQLite、Redis、MongoDB、达梦等 100+ 数据库,提供桌面端、Docker、CLI、内置 AI 助手和 MCP。

1.5 KB
Raw Blame
import type { ConnectionConfig } from "@/types/database";

export interface PostgresForeignTableCreateOptions {
  server: string;
  options: Array<{ name: string; value: string }>;
}

export interface PostgresForeignTableDraft extends PostgresForeignTableCreateOptions {
  enabled: boolean;
}

export function supportsPostgresForeignTableCreation(connection?: Pick<ConnectionConfig, "db_type" | "driver_profile">): boolean {
  const profile = connection?.driver_profile?.trim().toLowerCase();
  return connection?.db_type === "postgres" && (!profile || profile === "postgres");
}

export function emptyPostgresForeignTableDraft(): PostgresForeignTableDraft {
  return { enabled: false, server: "", options: [] };
}

export function restorePostgresForeignTableDraft(saved?: PostgresForeignTableDraft): PostgresForeignTableDraft {
  return { ...emptyPostgresForeignTableDraft(), ...saved, options: (saved?.options ?? []).map((option) => ({ ...option })) };
}

export function buildPostgresForeignTableOptions(draft: PostgresForeignTableDraft): PostgresForeignTableCreateOptions {
  return { server: draft.server, options: draft.options.filter((option) => option.name.trim() || option.value).map((option) => ({ name: option.name.trim(), value: option.value })) };
}

export const POSTGRES_FOREIGN_SERVERS_SQL = `SELECT s.srvname AS name, w.fdwname AS wrapper
FROM pg_catalog.pg_foreign_server s
JOIN pg_catalog.pg_foreign_data_wrapper w ON w.oid = s.srvfdw
WHERE pg_catalog.has_server_privilege(s.oid, 'USAGE')
ORDER BY s.srvname`;