mirror of
https://github.com/hanzoai/datastore.git
synced 2026-09-26 13:55:07 +00:00
Alexey MilovidovandClaude Opus 4.8
740850efb6
Add generate-table-functions.sql + table_function_generators to the port (same description-as-page-body model as formats/engines). Enrich the file table function's FunctionDocumentation with the full page body and convert its page (validated: badges round-trip, 0 missing vs master, 0 broken links). Co-Authored-By: Claude Opus 4.8 (1M context) <[email protected]>
20 lines
971 B
SQL
20 lines
971 B
SQL
-- Table-function documentation generator.
|
|
-- Usage: one page per table function, driven by the doc page's basename, e.g.:
|
|
-- clickhouse --param_tf='s3' --queries-file generate-table-functions.sql
|
|
--
|
|
-- system.table_functions.description holds the full Markdown body of the table
|
|
-- function's reference page (populated from the FunctionDocumentation attached
|
|
-- at registerFunction 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 function name case- and
|
|
-- separator-insensitively; functions with no description produce no output and
|
|
-- are skipped.
|
|
SELECT description
|
|
FROM system.table_functions
|
|
WHERE lower(replaceRegexpAll(name, '[^0-9a-zA-Z]', ''))
|
|
= lower(replaceRegexpAll({tf:String}, '[^0-9a-zA-Z]', ''))
|
|
AND notEmpty(description)
|
|
ORDER BY name ASC
|
|
LIMIT 1
|
|
INTO OUTFILE 'temp-table-function.md' TRUNCATE FORMAT LineAsString
|