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。

3.8 KB
Raw Blame
import { readdir, readFile } from "node:fs/promises";
import { extname, join, relative, sep } from "node:path";
import { fileURLToPath } from "node:url";
import { LANGUAGES } from "./languages.mjs";

const outputDirectory = fileURLToPath(new URL("../out/", import.meta.url));
const scannedExtensions = new Set([".html", ".js", ".txt"]);
const forbiddenEndpoint = "api.github.com";

async function collectFiles(directory) {
  const entries = await readdir(directory, { withFileTypes: true });
  const files = [];

  for (const entry of entries) {
    const path = join(directory, entry.name);
    if (entry.isDirectory()) {
      files.push(...(await collectFiles(path)));
    } else if (scannedExtensions.has(extname(entry.name))) {
      files.push(path);
    }
  }

  return files;
}

const files = await collectFiles(outputDirectory);
const violations = [];

for (const file of files) {
  if ((await readFile(file, "utf8")).includes(forbiddenEndpoint)) {
    violations.push(relative(outputDirectory, file));
  }
}

if (violations.length > 0) {
  throw new Error(`Static export contains browser-visible GitHub API endpoints:\n${violations.join("\n")}`);
}

console.log(`Static export verified: ${files.length} files contain no GitHub API endpoints.`);

// `<html lang>` uses BCP 47, which is not always the route segment.
const HTML_LANG = { en: "en", cn: "zh-CN" };

const requiredContent = [
  ...LANGUAGES.map((language) => ({
    file: `${language}.html`,
    includes: [`<html lang="${HTML_LANG[language] ?? language}"`, '"@type":"SoftwareApplication"'],
  })),
  { file: "llms.txt", includes: ["100+ data systems", "25 MB", "Apache-2.0"] },
];

for (const requirement of requiredContent) {
  const content = await readFile(join(outputDirectory, requirement.file), "utf8");
  for (const expected of requirement.includes) {
    if (!content.includes(expected)) {
      throw new Error(`${requirement.file} is missing required static content: ${expected}`);
    }
  }

  if (content.includes('"potentialAction"')) {
    throw new Error(`${requirement.file} advertises a search action that the static site does not provide.`);
  }
}

console.log("Static export metadata verified for language, software schema, and llms.txt accuracy.");

const localizedHtmlFiles = files.filter((file) => extname(file) === ".html" && LANGUAGES.some((lang) => file === join(outputDirectory, `${lang}.html`) || file.startsWith(`${join(outputDirectory, lang)}${sep}`)));

for (const file of localizedHtmlFiles) {
  const content = await readFile(file, "utf8");
  const relativePath = relative(outputDirectory, file);

  for (const landmark of ["<main", "<h1"]) {
    if (!content.includes(landmark)) {
      throw new Error(`${relativePath} is missing required semantic landmark: ${landmark}>`);
    }
  }
}

console.log(`Static export semantics verified for ${localizedHtmlFiles.length} localized pages.`);

const sitemap = await readFile(join(outputDirectory, "sitemap.xml"), "utf8");
for (const localizedHome of LANGUAGES.map((language) => `https://dbxio.com/${language}`)) {
  if (!sitemap.includes(`<loc>${localizedHome}</loc>`)) {
    throw new Error(`sitemap.xml is missing localized URL: ${localizedHome}`);
  }
}

for (const privateRoute of LANGUAGES.map((language) => `https://dbxio.com/${language}/issue`)) {
  if (sitemap.includes(`<loc>${privateRoute}</loc>`)) {
    throw new Error(`sitemap.xml must not advertise direct-only route: ${privateRoute}`);
  }
}

for (const issuePage of LANGUAGES.map((language) => `${language}/issue.html`)) {
  const content = await readFile(join(outputDirectory, issuePage), "utf8");
  if (!content.includes('<meta name="robots" content="noindex, nofollow, nocache"')) {
    throw new Error(`${issuePage} must remain excluded from search indexing.`);
  }
}

console.log(`Static export sitemap verified with independent URLs for ${LANGUAGES.join(", ")}.`);