"""表结构构建器 参考后端源码 TableFeildsEnum.java / TableFieldsNameConst.java。 生成包含系统字段和用户字段的完整表结构 JSON。 支持主表 + 子表(table 控件)结构。 """ from typing import Any, Dict, List, Optional # 主表系统字段 - FlowFormDataUtil.generalInsert 会自动写入 _MAIN_SYSTEM_FIELDS = [ {"field": "F_Id", "fieldName": "主键", "dataType": "varchar", "dataLength": "50", "primaryKey": 1, "allowNull": 0, "identity": 0}, {"field": "f_flow_task_id", "fieldName": "流程任务id", "dataType": "varchar", "dataLength": "50", "primaryKey": 0, "allowNull": 1, "identity": 0}, {"field": "f_flow_id", "fieldName": "流程id", "dataType": "varchar", "dataLength": "50", "primaryKey": 0, "allowNull": 1, "identity": 0}, {"field": "f_flow_state", "fieldName": "流程任务状态", "dataType": "int", "dataLength": "9", "primaryKey": 0, "allowNull": 1, "identity": 0}, {"field": "f_tenant_id", "fieldName": "租户id", "dataType": "varchar", "dataLength": "50", "primaryKey": 0, "allowNull": 0, "identity": 0}, {"field": "F_Sort_Code", "fieldName": "排序码", "dataType": "varchar", "dataLength": "50", "primaryKey": 0, "allowNull": 1, "identity": 0}, {"field": "F_Create_User", "fieldName": "创建者", "dataType": "varchar", "dataLength": "50", "primaryKey": 0, "allowNull": 1, "identity": 0}, {"field": "F_Create_Time", "fieldName": "创建时间", "dataType": "varchar", "dataLength": "50", "primaryKey": 0, "allowNull": 1, "identity": 0}, {"field": "F_Modify_User", "fieldName": "修改者", "dataType": "varchar", "dataLength": "50", "primaryKey": 0, "allowNull": 1, "identity": 0}, {"field": "F_Modify_Time", "fieldName": "修改时间", "dataType": "varchar", "dataLength": "50", "primaryKey": 0, "allowNull": 1, "identity": 0}, ] # 子表系统字段 _CHILD_SYSTEM_FIELDS = [ {"field": "F_Id", "fieldName": "主键", "dataType": "varchar", "dataLength": "50", "primaryKey": 1, "allowNull": 0, "identity": 0}, {"field": "f_tenant_id", "fieldName": "租户id", "dataType": "varchar", "dataLength": "50", "primaryKey": 0, "allowNull": 0, "identity": 0}, ] def _build_user_fields(fields: List[Dict[str, Any]]) -> List[Dict[str, Any]]: """从字段定义列表构建表字段列表 兼容两种字段名格式: - field_model 返回格式:__vModel__ 存储字段名 - 直接传入格式:field 存储字段名 """ user_fields = [] for f in fields: # 优先使用 field,否则使用 __vModel__(兼容 field_model 构建器) field_name = f.get("field") or f.get("__vModel__") or f.get("id", "") field_def = { "field": field_name, "fieldName": f.get("fieldName") or f.get("fullName") or f.get("__config__", {}).get("label", field_name), "dataType": f.get("dataType", "varchar"), "primaryKey": 0, "allowNull": 0 if f.get("required", False) else 1, "autoIncrement": 0, "identity": 0, "columnName": None, } data_length = f.get("dataLength", "200") if data_length: # 跳过空值(datetime 等类型不需要长度) field_def["dataLength"] = data_length user_fields.append(field_def) return user_fields def build_tables( table_name: str, table_label: str, fields: List[Dict[str, Any]], relation_table: str = "", ) -> List[Dict[str, Any]]: """构建表结构 JSON(仅主表,向后兼容) Args: table_name: 数据库表名,如 "base_sales_vendor" table_label: 表中文名,如 "文具销售商表" fields: 用户自定义字段列表,每个元素含 field/fieldName/dataType/dataLength/required relation_table: 关联表名(默认无关联) Returns: tables 列表(需 JSON 序列化后传入 API) """ return [build_main_table_entry(table_name, table_label, fields, relation_table)] def build_main_table_entry( table_name: str, table_label: str, fields: List[Dict[str, Any]], relation_table: str = "", ) -> Dict[str, Any]: """构建主表表结构条目 Args: table_name: 数据库表名 table_label: 表中文名 fields: 用户自定义字段列表 relation_table: 关联表名 Returns: 主表结构字典 """ return { "table": table_name, "tableName": table_label, "relationTable": relation_table, "tableField": "", "fields": _MAIN_SYSTEM_FIELDS + _build_user_fields(fields), "relationField": "", "typeId": "1", } def build_child_table_entry( child_table_name: str, child_table_label: str, main_table_name: str, child_fields: List[Dict[str, Any]], relation_field: str = "F_Id", foreign_key_field: str = "F_ParentId", ) -> Dict[str, Any]: """构建子表表结构条目 子表通过外键关联主表:child_table.foreign_key_field → main_table.relation_field Args: child_table_name: 子表数据库表名,如 "base_order_item" child_table_label: 子表中文名,如 "订单明细表" main_table_name: 主表数据库表名,如 "base_order" child_fields: 子表用户字段列表(不含外键,外键自动添加) relation_field: 主表关联字段(默认 F_Id,即主表主键) foreign_key_field: 子表外键字段名(默认 F_ParentId) Returns: 子表结构字典 """ # 外键字段定义 fk_field = { "field": foreign_key_field, "fieldName": "主表主键", "dataType": "varchar", "dataLength": "50", "primaryKey": 0, "allowNull": 1, "autoIncrement": 0, "identity": 0, "columnName": None, } return { "table": child_table_name, "tableName": child_table_label, "relationTable": main_table_name, "tableField": foreign_key_field, "typeId": "0", "fields": _CHILD_SYSTEM_FIELDS + [fk_field] + _build_user_fields(child_fields), "relationField": relation_field, } def build_tables_with_child( table_name: str, table_label: str, fields: List[Dict[str, Any]], child_tables: List[Dict[str, Any]], ) -> List[Dict[str, Any]]: """构建包含子表的完整 tables 结构 Args: table_name: 主表数据库表名 table_label: 主表中文名 fields: 主表用户字段列表 child_tables: 子表定义列表,每个子表包含: - table_name: 子表名 - table_label: 子表中文名 - fields: 子表字段列表 - foreign_key_field: 外键字段名(默认 "F_ParentId") - relation_field: 主表关联字段(默认 "F_Id") Returns: tables 列表:[主表, 子表1, 子表2, ...] """ tables = [build_main_table_entry(table_name, table_label, fields)] for ct in child_tables: tables.append(build_child_table_entry( child_table_name=ct["table_name"], child_table_label=ct["table_label"], main_table_name=table_name, child_fields=ct["fields"], relation_field=ct.get("relation_field", "F_Id"), foreign_key_field=ct.get("foreign_key_field", "F_ParentId"), )) return tables