sql-boost:
time-appender: # insert/update时,自动补充创建/更新时间值
enable: true # 是否启用
createTimeColumn: create_time # 创建时间列名(可不填,默认为create_time)
updateTimeColumn: update_time # 更新时间列名(可不填,默认为update_time)
excludeTables: # 跳过该流程的表名
- region
uac: # update时,自动更新关联表中的数据
enable: true # 是否启用
rules:
- sourceTable: user # 源表名
primaryColumn: id # 源表主键列,选填(默认为id)
rootColumn: id # 源表索引列,与目标表assoColumn进行关联
sourceColumn: id # 源表数据列(若update语句中包含该列,则在update后自动用更新后的数据根据association规则去更新目标表的targetColumn列数据)
association:
- targetTable: user_address # 目标表名
assoColumn: user_id # 目标表中关联列(语义上可以理解为与目标表具有外键关联的列,关联指向源表rootColumn)
targetColumn: user_id # 目标表被更新列
- targetTable: user_message
assoColumn: user_id
targetColumn: user_id
- sourceTable: user
rootColumn: id
sourceColumn: name
association:
- targetTable: user_address
assoColumn: user_id
targetColumn: user_name
- targetTable: user_message
assoColumn: user_id
targetColumn: user_name
- sourceTable: region
primaryColumn: id
rootColumn: zip_code
sourceColumn: zip_code
association:
- targetTable: address
assoColumn: zip_code
targetColumn: zip_code
- sourceTable: region
rootColumn: zip_code
sourceColumn: name
association:
- targetTable: address
assoColumn: zip_code
targetColumn: region_name
- sourceTable: address
primaryColumn: id
rootColumn: id
sourceColumn: name
association:
- targetTable: user_address
assoColumn: addr_id
targetColumn: addr_name
- sourceTable: address
rootColumn: id
sourceColumn: region_name
association:
- targetTable: user_address
assoColumn: addr_id
targetColumn: region_name