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。

937 B
Raw Blame
export type XuguSchedulerJobAction = "enable" | "disable" | "run" | "drop";

/**
 * Build the DBMS_SCHEDULER statements supported by the first Xugu job
 * management slice. Scheduler jobs are database-scoped; names are string
 * arguments rather than schema-qualified identifiers.
 */
export function buildXuguSchedulerJobSql(action: XuguSchedulerJobAction, name: string): string | null {
  const jobName = name.trim();
  if (!jobName) return null;
  const literal = quoteXuguString(jobName);
  switch (action) {
    case "enable":
      return `EXEC DBMS_SCHEDULER.ENABLE(${literal});`;
    case "disable":
      return `EXEC DBMS_SCHEDULER.DISABLE(${literal}, FALSE);`;
    case "run":
      return `EXEC DBMS_SCHEDULER.RUN_JOB(${literal}, TRUE);`;
    case "drop":
      return `EXEC DBMS_SCHEDULER.DROP_JOB(${literal}, FALSE);`;
  }
}

function quoteXuguString(value: string): string {
  return `'${value.replaceAll("'", "''")}'`;
}