mirror of
https://github.com/hanzoai/datastore.git
synced 2026-09-26 13:55:07 +00:00
Extend the generator to database engines (generate-database-engines.sql + database_engine_generators in the port, same mechanism as table engines). Convert the pages whose structured docs already match: atomic, backup, replicated (content-neutral / whitespace-only). Co-Authored-By: Claude Opus 4.8 (1M context) <[email protected]>
20 lines
971 B
SQL
20 lines
971 B
SQL
-- Database-engine documentation generator.
|
|
-- Usage: one page per engine, driven by the doc page's basename, e.g.:
|
|
-- clickhouse --param_engine='replicated' --queries-file generate-database-engines.sql
|
|
--
|
|
-- system.database_engines.description holds the full Markdown body of the
|
|
-- engine's reference page (populated from the `Documentation` attached at
|
|
-- registerDatabase time). We emit that body verbatim; the Python port then
|
|
-- applies the same Docusaurus->Mintlify body transforms it runs on migrated
|
|
-- pages. The page basename is matched to the engine name case- and
|
|
-- separator-insensitively, so non-engine pages (e.g. index) produce no output
|
|
-- and are skipped.
|
|
SELECT description
|
|
FROM system.database_engines
|
|
WHERE lower(replaceRegexpAll(name, '[^0-9a-zA-Z]', ''))
|
|
= lower(replaceRegexpAll({engine:String}, '[^0-9a-zA-Z]', ''))
|
|
AND notEmpty(description)
|
|
ORDER BY name ASC
|
|
LIMIT 1
|
|
INTO OUTFILE 'temp-database-engine.md' TRUNCATE FORMAT LineAsString
|