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。
TypeScript aicliclickhousedatabasedatabase-clientdatabase-managementdockerguimcpmongodbmysqlpostgresqlredisrustsql-serversqlitetaurivue
import { describe, expect, it } from "vitest";
import { classifySqlRisk } from "@/lib/sql/sqlRisk";
describe("DynamoDB statement risk", () => {
it("classifies PartiQL reads and mutations without relaxing existing guards", () => {
expect(classifySqlRisk('SELECT * FROM "items" WHERE "status"=\'PENDING\'', { dialect: "dynamodb" }).risk).toBe("read");
expect(classifySqlRisk("-- comment\nSELECT 'UPDATE' FROM \"items\"", { dialect: "dynamodb" }).risk).toBe("read");
for (const sql of ["INSERT INTO \"items\" VALUE {'pk':'x'}", "UPDATE \"items\" SET flag=true WHERE pk='x'", "DELETE FROM \"items\" WHERE pk='x'"]) {
expect(classifySqlRisk(sql, { dialect: "dynamodb" }).risk).toBe("write");
}
expect(classifySqlRisk('SELECT * FROM "items"; DELETE FROM "items" WHERE pk=\'x\'', { dialect: "dynamodb" }).risk).not.toBe("read");
});
it("treats generated scan statements as reads", () => {
expect(classifySqlRisk('DBX DYNAMODB SCAN\ntable: "orders"\nlimit: 1000', { dialect: "dynamodb" }).risk).toBe("read");
expect(classifySqlRisk('DBX DYNAMODB QUERY / SCAN\ntable: "orders"\nfilter:\n{"status":"SHIPPED"}', { dialect: "dynamodb" }).risk).toBe("read");
});
it("treats generated item changes as writes", () => {
for (const operation of ["INSERT ITEM", "PUT ITEM", "DELETE ITEM"]) {
expect(classifySqlRisk(`DBX DYNAMODB ${operation}\ntable: "orders"`, { dialect: "dynamodb" }).risk).toBe("write");
}
});
it("keeps unknown DynamoDB operations unsafe", () => {
expect(classifySqlRisk('DBX DYNAMODB UNKNOWN\ntable: "orders"', { dialect: "dynamodb" }).risk).toBe("unknown");
});
});