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。

4.5 KB
Raw Blame
import { describe, expect, it } from "vitest";
import {
  buildOceanbaseKillConnectionBlock,
  buildOceanbaseLockDetailsSql,
  buildOceanbaseSessionListSql,
  buildOracleKillSessionBlock,
  buildOracleLockDetailsSql,
  buildOracleSessionListSql,
  mapOceanbaseSessions,
  mapOracleSessions,
  oracleMajorVersion,
  OCEANBASE_OWN_SESSION_SQL,
} from "../oracleSessionManagement";

describe("Oracle session identity and SQL", () => {
  it("parses the reported Oracle major version and rejects unknown formats", () => {
    expect(oracleMajorVersion("19.0.0.0.0")).toBe(19);
    expect(oracleMajorVersion(" 11.2.0.4.0 ")).toBe(11);
    expect(oracleMajorVersion("Oracle Database 19c")).toBeNull();
  });

  it("scopes modern sessions to the current container and keeps legacy SQL separate", () => {
    expect(buildOracleSessionListSql(false)).toContain("s.CON_ID = TO_NUMBER(SYS_CONTEXT('USERENV','CON_ID'))");
    expect(buildOracleSessionListSql(true)).not.toContain("CON_ID");
  });

  it("preserves complete Oracle target identity and permits non-CDB CON_ID zero", () => {
    const [target] = mapOracleSessions({ rows: [["17", "8", "2", "0", "APP", "INACTIVE", "host", "client", null, null, null, null, "99", "2026-10-20 10:00:00"]] });
    expect(buildOracleKillSessionBlock(target!, false)).toContain("CON_ID = 0");
    expect(buildOracleKillSessionBlock(target!, false)).toContain("SID = 17 AND SERIAL# = 8 AND INST_ID = 2 AND CON_ID = 0");
    expect(buildOracleKillSessionBlock(target!, false)).toContain("ALTER SYSTEM KILL SESSION ''17,8,@2'' IMMEDIATE");
    const lockSql = buildOracleLockDetailsSql(target!, false);
    expect(lockSql).toContain("l.CON_ID = 0");
    expect(lockSql).toContain("target.SID = 17 AND target.SERIAL# = 8 AND target.INST_ID = 2 AND target.CON_ID = 0");
    expect(lockSql).toContain("target.AUDSID = 99");
    expect(lockSql).toContain("TO_CHAR(target.LOGON_TIME,'YYYY-MM-DD HH24:MI:SS') = '2026-10-20 10:00:00'");
  });

  it("rejects unsafe Oracle target identities", () => {
    const [target] = mapOracleSessions({ rows: [["9007199254740993", "8", "2", "1", "APP", "INACTIVE", "", "", null, null, null, null, "99", "2026-10-20 10:00:00"]] });
    expect(() => buildOracleKillSessionBlock(target!, false)).toThrow("Invalid SID");
  });
});

describe("OceanBase session identity and SQL", () => {
  const row = {
    id: "9007199254740993",
    user: "APP'X",
    tenant: "tenant_a",
    proxySessionId: null,
    serverIp: "127.0.0.1",
    serverPort: "2882",
  };

  it("maps large IDs losslessly, scopes the list to the active tenant, and reads own identity", () => {
    expect(mapOceanbaseSessions({ rows: [[row.id, row.user, row.tenant, "host", "db", "Query", "2", "active", "SELECT 1", null, row.serverIp, row.serverPort]] })[0]?.id).toBe(row.id);
    expect(buildOceanbaseSessionListSql()).toContain("TENANT = (SELECT TENANT FROM GV$OB_SESSION");
  });

  it("reads the dictionary USER column rather than the login USER function", () => {
    expect(buildOceanbaseSessionListSql()).toContain('"USER" AS SESSION_USER');
    expect(buildOceanbaseSessionListSql()).toContain('AND "USER" = SYS_CONTEXT');
    expect(OCEANBASE_OWN_SESSION_SQL).toContain('SELECT TO_CHAR(ID), "USER", TENANT');
    expect(OCEANBASE_OWN_SESSION_SQL).toContain('AND "USER" = SYS_CONTEXT');
  });

  it("uses one guarded KILL CONNECTION block with exact user, tenant, node and decimal ID", () => {
    const sql = buildOceanbaseKillConnectionBlock(row);
    expect(sql).toContain(`ID = ${row.id} AND "USER" = 'APP''X' AND TENANT = 'tenant_a'`);
    expect(sql).toContain(`IF TO_NUMBER(SYS_CONTEXT('USERENV','SID')) = ${row.id} AND USER = 'APP''X' THEN`);
    expect(sql).toContain("SVR_IP = '127.0.0.1' AND SVR_PORT = 2882");
    expect(sql).toContain(`EXECUTE IMMEDIATE 'KILL CONNECTION ${row.id}'`);
    expect(sql).toContain("Cannot terminate the executing management session");
  });

  it("rejects proxy sessions and includes same-resource lock rows within the target tenant", () => {
    expect(() => buildOceanbaseKillConnectionBlock({ ...row, proxySessionId: "88" })).toThrow("Unsupported");
    const sql = buildOceanbaseLockDetailsSql({ ...row, tenantId: 7 });
    expect(sql).toContain("tl.ID3 = l.ID3");
    expect(sql).toContain('p."USER" AS SESSION_USER');
    expect(sql).toContain(`tp."USER" = 'APP''X'`);
    expect(sql).toContain("tl.SESSION_ID = 9007199254740993 AND tl.SVR_IP = '127.0.0.1' AND tl.SVR_PORT = 2882");
    expect(sql).toContain("p.SVR_IP = l.SVR_IP AND p.SVR_PORT = l.SVR_PORT");
    expect(sql).not.toContain("TENANT_ID FROM GV$OB_SESSION");
  });
});