201 lines
7.3 KiB
Python
201 lines
7.3 KiB
Python
"""表结构构建器
|
||
|
||
参考后端源码 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
|