Kettle同步设计思路 - 数据库编程

数据库查询V_DRUG_CLASS_STRUCT_ID调用DB存储过程V_DRUG_CLASS_COUNTY 更新 IWMDS_DRUG_BATCH更新 IWMDS_PRESCRIPTION_DETAILY 表输入增加常量Y 调用DB存储过程V_DRUG_CLASS_COUNT插入 / 更新IWMDS_DRUG_CLASSY 调用DB存储过程V_DRUG_CLASS_ID调用DB存储过程V_DRUG_LINK_IDY 调用DB存储过程V_DRUG_DETAIL_ID值映射Y 调用DB存储过程V_DRUG_LINK_ID调用DB存储过程V_DRUG_DETAIL_IDY 过滤记录数据库查询V_DRUG_CLASS_ID_CY 数据库查询V_DRUG_CLASS_ID_C插入 / 更新IWMDS_DRUG_CLASS_STRUCT_LINK 2Y 插入 / 更新IWMDS_DRUG_CLASS_STRUCT_LINK 2插入 / 更新IWMDS_DRUG_DETAIL 2Y 过滤记录插入 / 更新IWMDS_DRUG_CLASS_STRUCT_LINKY 插入 / 更新IWMDS_DRUG_CLASS_STRUCT_LINK插入 / 更新IWMDS_DRUG_DETAILY 值映射 ValueMapper Y 1 none ENABLE_FLAG Y 0 N 1 135 558 Y 增加常量 Constant Y 1 none V_INFO_SOURCE_TYPE String SOURCE_SYNC 0 0 140 132 Y 插入 / 更新IWMDS_DRUG_CLASS InsertUpdate Y 1 none serverConn 100 N IWMDS_DRUG_CLASS

V_INFO_SOURCE_TYPE INFO_SOURCE_TYPE = DRUG_ID INFO_SOURCE_ID = DRUG_CLASS_ID V_DRUG_CLASS_ID N DRUG_CLASS_CODE DRUG_CODE Y DRUG_CLASS_CN_NAME DRUG_COMMON_CN_NAME Y DRUG_CLASS_EN_NAME DRUG_COMMON_EN_NAME Y REMARKS REMARKS Y INFO_ORDER INFO_ORDER Y IS_DELETE ENABLE_FLAG Y CREATE_TIME CREATE_TIME Y CREATOR CREATOR Y MODIFY_TIME MODIFY_TIME Y MODIFIER MODIFIER Y IS_CONTROLLED IS_CONTROLLED Y INFO_SOURCE_TYPE V_INFO_SOURCE_TYPE Y INFO_SOURCE_ID DRUG_ID N 729 154 Y 插入 / 更新IWMDS_DRUG_CLASS_STRUCT_LINK InsertUpdate Y 1 none serverConn 100 N IWMDS_DRUG_CLASS_STRUCT_LINK

V_DRUG_CLASS_ID DRUG_CLASS_ID = V_DRUG_CLASS_STRUCT_ID DRUG_STRUCT_ID = DCSLINK_ID V_DRUG_LINK_ID N DRUG_STRUCT_ID V_DRUG_CLASS_STRUCT_ID

Y DRUG_CLASS_ID V_DRUG_CLASS_ID Y CREATE_TIME CREATE_TIME Y MODIFIER MODIFIER Y MODIFY_TIME MODIFY_TIME Y INFO_ORDER INFO_ORDER Y REMARKS REMARKS Y IS_DELETE ENABLE_FLAG Y CREATOR CREATOR Y 819 417 Y 插入 / 更新IWMDS_DRUG_CLASS_STRUCT_LINK 2 InsertUpdate Y 1 none serverConn 100 N IWMDS_DRUG_CLASS_STRUCT_LINK

V_DRUG_CLASS_ID_C DRUG_CLASS_ID = V_DRUG_CLASS_STRUCT_ID DRUG_STRUCT_ID = DCSLINK_ID V_DRUG_LINK_ID N DRUG_STRUCT_ID V_DRUG_CLASS_STRUCT_ID Y DRUG_CLASS_ID V_DRUG_CLASS_ID_C Y CREATE_TIME CREATE_TIME Y MODIFIER MODIFIER Y MODIFY_TIME MODIFY_TIME Y INFO_ORDER INFO_ORDER Y REMARKS REMARKS Y IS_DELETE ENABLE_FLAG Y CREATOR CREATOR Y 520 535 Y 插入 / 更新IWMDS_DRUG_DETAIL InsertUpdate Y 1 none serverConn 100 N IWMDS_DRUG_DETAIL

V_DRUG_CLASS_ID DRUG_ID = DRUG_DETAIL_ID V_DRUG_DETAIL_ID N INFO_ORDER INFO_ORDER Y REMARKS REMARKS Y IS_DELETE ENABLE_FLAG Y CREATOR CREATOR Y CREATE_TIME CREATE_TIME Y MODIFIER MODIFIER Y MODIFY_TIME MODIFY_TIME Y DRUG_INGREDIENT DRUG_INGREDIENT Y DRUG_DESCRIPTION DRUG_DESCRIPTION Y DRUG_SPECIFICATIONS DRUG_SPECIFICATIONS Y DRUG_UNIT DRUG_UNIT_CODE Y DRUG_NAME DRUG_COMMON_CN_NAME Y DRUG_ENGLISH_NAME DRUG_COMMON_EN_NAME Y BRAND_NAME DRUG_BRAND_CN_NAME Y BRAND_ENGLISH_NAME DRUG_BRAND_EN_NAME Y IS_CONTROLLED IS_CONTROLLED Y FORM_CODE DRUG_FORM_CODE Y DRUG_ID V_DRUG_CLASS_ID Y BASIC_CODE DRUG_CODE Y DRUG_PINYIN DRUG_PINYIN Y DRUG

Kettle同步设计思路(二)