Verified every factual claim in the hand-written prose against the
codebase under ../xly/ and the live xlyweberp_saas_ai schema, and fixed
the drift:
- semantic-fk: clarified — zero FKs on xly tables; the ones that exist
are all on bundled Activiti / Quartz schemas, which the runtime
doesn't join through.
- multi-tenancy / runtime / slice 2: corrected RequestAddParamUtil shape
(16 keys, 56 lines), noted the parallel xlyApi copy.
- slice 1: corrected line ranges for addUpdateDelBusinessData;
clarified that sTableNameList is a cache-invalidation gate, not an
authorisation gate; corrected the gdsroute claim — unregistered paths
are NOT 404'd server-side, the SPA uses gdsroute as a client-side
whitelist (web-verified).
- runtime: fixed controller package paths
(Gdsmodule/Gdsconfigform/Gdsconfigtb live in systemweb/, not
businessweb/); added CheckFlowController.
- sql-templates / proc-dispatch: 8 scaffolds, not 7 (sSqlStr.sql).
- master-slave: removed table names that don't exist (accOrderCostAnalysisMaster,
quoQuotationCalc, mftWorkOrderCalc, mftWorkOrderSlaveMoney);
added the *_tmp family that does.
- permissions: full rewrite. The original page described
gdsjurisdiction as a per-(module, role, button) rule table backed by
empty plat_base_authority_* lookups; reality is gdsjurisdiction is a
per-module catalog of buttons/actions, with sysjurisdiction carrying
the actual role/user grants.
- Removed environment-specific facts (row counts, sizes, timestamps,
per-DB enumerations) so the wiki documents the framework, not one
particular DB snapshot.
Auto-catalog generator (en/scripts/gen_catalog.py):
- Rewritten to query MySQL directly via ~/.my.cnf (replaces the
recon/*.tsv pipeline).
- Stripped ephemeral fields from output (Rows, Data size, Created,
Updated on tables; Created, Last altered on routines; Definer on
views).
- Strips the schema-name prefix from VIEW_DEFINITION so view bodies
are portable across deployments.
- Wipes and rewrites docs/auto-catalog/{tables,views,procedures,functions}/
on each run.
- Auto-catalog regenerated.
New API Reference chapter (5):
- concepts/api-surface.md introduces the three-tier design (xlyEntry
internal, xlyApi external, xlyInterface webhooks).
- api-reference/{index,internal,external,webhooks,messaging}.md cover
each surface, with the data-driven /api/invoke{sApiCode} pattern,
sysapi schema, token flow, and the SpringFox Swagger UI location on
xlyInterface.
- mkdocs nav: chapters renumbered (Auto-Catalog → 6, Glossary → 7,
Contributing → 8); glossary/contributing wrapped as section indexes
to render correctly under navigation.sections.
Other:
- Bilingual top-level README (Chinese + English).
- requirements.txt: pymysql added for the new generator.
Fun_RemoveJsonKey (function)longtext
| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | sJson |
longtext |
| 2 | IN | skey |
varchar(50) |
| 3 | IN | sValue |
varchar(50) |
Body is not pre-cached. To inspect: mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE FUNCTIONFunRemoveJsonKey'._
No human-written narrative yet.