书接上回，该章节主要是数据同步，脚本如下：
<?xml version="1.0" encoding="UTF-8"?>
<transformation>
<info>
<name>sync_sp-dev</name>
<description />
<extended_description />
<trans_version />
<trans_type>Normal</trans_type>
<directory>/</directory>
<parameters>
</parameters>
<log>
<trans-log-table>
<connection />
<schema />
<table />
<size_limit_lines />
<interval />
<timeout_days />
<field>
<id>ID_BATCH</id>
<enabled>Y</enabled>
<name>ID_BATCH</name>
</field>
<field>
<id>CHANNEL_ID</id>
<enabled>Y</enabled>
<name>CHANNEL_ID</name>
</field>
<field>
<id>TRANSNAME</id>
<enabled>Y</enabled>
<name>TRANSNAME</name>
</field>
<field>
<id>STATUS</id>
<enabled>Y</enabled>
<name>STATUS</name>
</field>
<field>
<id>LINES_READ</id>
<enabled>Y</enabled>
<name>LINES_READ</name>
<subject />
</field>
<field>
<id>LINES_WRITTEN</id>
<enabled>Y</enabled>
<name>LINES_WRITTEN</name>
<subject />
</field>
<field>
<id>LINES_UPDATED</id>
<enabled>Y</enabled>
<name>LINES_UPDATED</name>
<subject />
</field>
<field>
<id>LINES_INPUT</id>
<enabled>Y</enabled>
<name>LINES_INPUT</name>
<subject />
</field>
<field>
<id>LINES_OUTPUT</id>
<enabled>Y</enabled>
<name>LINES_OUTPUT</name>
<subject />
</field>
<field>
<id>LINES_REJECTED</id>
<enabled>Y</enabled>
<name>LINES_REJECTED</name>
<subject />
</field>
<field>
<id>ERRORS</id>
<enabled>Y</enabled>
<name>ERRORS</name>
</field>
<field>
<id>STARTDATE</id>
<enabled>Y</enabled>
<name>STARTDATE</name>
</field>
<field>
<id>ENDDATE</id>
<enabled>Y</enabled>
<name>ENDDATE</name>
</field>
<field>
<id>LOGDATE</id>
<enabled>Y</enabled>
<name>LOGDATE</name>
</field>
<field>
<id>DEPDATE</id>
<enabled>Y</enabled>
<name>DEPDATE</name>
</field>
<field>
<id>REPLAYDATE</id>
<enabled>Y</enabled>
<name>REPLAYDATE</name>
</field>
<field>
<id>LOG_FIELD</id>
<enabled>Y</enabled>
<name>LOG_FIELD</name>
</field>
<field>
<id>EXECUTING_SERVER</id>
<enabled>N</enabled>
<name>EXECUTING_SERVER</name>
</field>
<field>
<id>EXECUTING_USER</id>
<enabled>N</enabled>
<name>EXECUTING_USER</name>
</field>
<field>
<id>CLIENT</id>
<enabled>N</enabled>
<name>CLIENT</name>
</field>
</trans-log-table>
<perf-log-table>
<connection />
<schema />
<table />
<interval />
<timeout_days />
<field>
<id>ID_BATCH</id>
<enabled>Y</enabled>
<name>ID_BATCH</name>
</field>
<field>
<id>SEQ_NR</id>
<enabled>Y</enabled>
<name>SEQ_NR</name>
</field>
<field>
<id>LOGDATE</id>
<enabled>Y</enabled>
<name>LOGDATE</name>
</field>
<field>
<id>TRANSNAME</id>
<enabled>Y</enabled>
<name>TRANSNAME</name>
</field>
<field>
<id>STEPNAME</id>
<enabled>Y</enabled>
<name>STEPNAME</name>
</field>
<field>
<id>STEP_COPY</id>
<enabled>Y</enabled>
<name>STEP_COPY</name>
</field>
<field>
<id>LINES_READ</id>
<enabled>Y</enabled>
<name>LINES_READ</name>
</field>
<field>
<id>LINES_WRITTEN</id>
<enabled>Y</enabled>
<name>LINES_WRITTEN</name>
</field>
<field>
<id>LINES_UPDATED</id>
<enabled>Y</enabled>
<name>LINES_UPDATED</name>
</field>
<field>
<id>LINES_INPUT</id>
<enabled>Y</enabled>
<name>LINES_INPUT</name>
</field>
<field>
<id>LINES_OUTPUT</id>
<enabled>Y</enabled>
<name>LINES_OUTPUT</name>
</field>
<field>
<id>LINES_REJECTED</id>
<enabled>Y</enabled>
<name>LINES_REJECTED</name>
</field>
<field>
<id>ERRORS</id>
<enabled>Y</enabled>
<name>ERRORS</name>
</field>
<field>
<id>INPUT_BUFFER_ROWS</id>
<enabled>Y</enabled>
<name>INPUT_BUFFER_ROWS</name>
</field>
<field>
<id>OUTPUT_BUFFER_ROWS</id>
<enabled>Y</enabled>
<name>OUTPUT_BUFFER_ROWS</name>
</field>
</perf-log-table>
<channel-log-table>
<connection />
<schema />
<table />
<timeout_days />
<field>
<id>ID_BATCH</id>
<enabled>Y</enabled>
<name>ID_BATCH</name>
</field>
<field>
<id>CHANNEL_ID</id>
<enabled>Y</enabled>
<name>CHANNEL_ID</name>
</field>
<field>
<id>LOG_DATE</id>
<enabled>Y</enabled>
<name>LOG_DATE</name>
</field>
<field>
<id>LOGGING_OBJECT_TYPE</id>
<enabled>Y</enabled>
<name>LOGGING_OBJECT_TYPE</name>
</field>
<field>
<id>OBJECT_NAME</id>
<enabled>Y</enabled>
<name>OBJECT_NAME</name>
</field>
<field>
<id>OBJECT_COPY</id>
<enabled>Y</enabled>
<name>OBJECT_COPY</name>
</field>
<field>
<id>REPOSITORY_DIRECTORY</id>
<enabled>Y</enabled>
<name>REPOSITORY_DIRECTORY</name>
</field>
<field>
<id>FILENAME</id>
<enabled>Y</enabled>
<name>FILENAME</name>
</field>
<field>
<id>OBJECT_ID</id>
<enabled>Y</enabled>
<name>OBJECT_ID</name>
</field>
<field>
<id>OBJECT_REVISION</id>
<enabled>Y</enabled>
<name>OBJECT_REVISION</name>
</field>
<field>
<id>PARENT_CHANNEL_ID</id>
<enabled>Y</enabled>
<name>PARENT_CHANNEL_ID</name>
</field>
<field>
<id>ROOT_CHANNEL_ID</id>
<enabled>Y</enabled>
<name>ROOT_CHANNEL_ID</name>
</field>
</channel-log-table>
<step-log-table>
<connection />
<schema />
<table />
<timeout_days />
<field>
<id>ID_BATCH</id>
<enabled>Y</enabled>
<name>ID_BATCH</name>
</field>
<field>
<id>CHANNEL_ID</id>
<enabled>Y</enabled>
<name>CHANNEL_ID</name>
</field>
<field>
<id>LOG_DATE</id>
<enabled>Y</enabled>
<name>LOG_DATE</name>
</field>
<field>
<id>TRANSNAME</id>
<enabled>Y</enabled>
<name>TRANSNAME</name>
</field>
<field>
<id>STEPNAME</id>
<enabled>Y</enabled>
<name>STEPNAME</name>
</field>
<field>
<id>STEP_COPY</id>
<enabled>Y</enabled>
<name>STEP_COPY</name>
</field>
<field>
<id>LINES_READ</id>
<enabled>Y</enabled>
<name>LINES_READ</name>
</field>
<field>
<id>LINES_WRITTEN</id>
<enabled>Y</enabled>
<name>LINES_WRITTEN</name>
</field>
<field>
<id>LINES_UPDATED</id>
<enabled>Y</enabled>
<name>LINES_UPDATED</name>
</field>
<field>
<id>LINES_INPUT</id>
<enabled>Y</enabled>
<name>LINES_INPUT</name>
</field>
<field>
<id>LINES_OUTPUT</id>
<enabled>Y</enabled>
<name>LINES_OUTPUT</name>
</field>
<field>
<id>LINES_REJECTED</id>
<enabled>Y</enabled>
<name>LINES_REJECTED</name>
</field>
<field>
<id>ERRORS</id>
<enabled>Y</enabled>
<name>ERRORS</name>
</field>
<field>
<id>LOG_FIELD</id>
<enabled>N</enabled>
<name>LOG_FIELD</name>
</field>
</step-log-table>
<metrics-log-table>
<connection />
<schema />
<table />
<timeout_days />
<field>
<id>ID_BATCH</id>
<enabled>Y</enabled>
<name>ID_BATCH</name>
</field>
<field>
<id>CHANNEL_ID</id>
<enabled>Y</enabled>
<name>CHANNEL_ID</name>
</field>
<field>
<id>LOG_DATE</id>
<enabled>Y</enabled>
<name>LOG_DATE</name>
</field>
<field>
<id>METRICS_DATE</id>
<enabled>Y</enabled>
<name>METRICS_DATE</name>
</field>
<field>
<id>METRICS_CODE</id>
<enabled>Y</enabled>
<name>METRICS_CODE</name>
</field>
<field>
<id>METRICS_DESCRIPTION</id>
<enabled>Y</enabled>
<name>METRICS_DESCRIPTION</name>
</field>
<field>
<id>METRICS_SUBJECT</id>
<enabled>Y</enabled>
<name>METRICS_SUBJECT</name>
</field>
<field>
<id>METRICS_TYPE</id>
<enabled>Y</enabled>
<name>METRICS_TYPE</name>
</field>
<field>
<id>METRICS_VALUE</id>
<enabled>Y</enabled>
<name>METRICS_VALUE</name>
</field>
</metrics-log-table>
</log>
<maxdate>
<connection />
<table />
<field />
<offset>0.0</offset>
<maxdiff>0.0</maxdiff>
</maxdate>
<size_rowset>10000</size_rowset>
<sleep_time_empty>50</sleep_time_empty>
<sleep_time_full>50</sleep_time_full>
<unique_connections>N</unique_connections>
<feedback_shown>Y</feedback_shown>
<feedback_size>50000</feedback_size>
<using_thread_priorities>Y</using_thread_priorities>
<shared_objects_file />
<capture_step_performance>N</capture_step_performance>
<step_performance_capturing_delay>1000</step_performance_capturing_delay>
<step_performance_capturing_size_limit>100</step_performance_capturing_size_limit>
<dependencies>
</dependencies>
<partitionschemas>
</partitionschemas>
<slaveservers>
</slaveservers>
<clusterschemas>
</clusterschemas>
<created_user>-</created_user>
<created_date>2024/06/04 19:26:53.938</created_date>
<modified_user>-</modified_user>
<modified_date>2024/06/04 19:26:53.938</modified_date>
<key_for_session_key />
<is_key_private>N</is_key_private>
</info>
<notepads>
</notepads>
<connection>
<name>local_sp-dev</name>
<server>${local_ip}</server>
<type>MYSQL</type>
<access>Native</access>
<database>${schemeName_sp-dev}</database>
<port>3306</port>
<username>${local_user}</username>
<password>${password}</password>
<servername />
<data_tablespace />
<index_tablespace />
<attributes>
<attribute>
<code>FORCE_IDENTIFIERS_TO_LOWERCASE</code>
<attribute>N</attribute>
</attribute>
<attribute>
<code>FORCE_IDENTIFIERS_TO_UPPERCASE</code>
<attribute>N</attribute>
</attribute>
<attribute>
<code>IS_CLUSTERED</code>
<attribute>N</attribute>
</attribute>
<attribute>
<code>PORT_NUMBER</code>
<attribute>3306</attribute>
</attribute>
<attribute>
<code>PRESERVE_RESERVED_WORD_CASE</code>
<attribute>Y</attribute>
</attribute>
<attribute>
<code>QUOTE_ALL_FIELDS</code>
<attribute>N</attribute>
</attribute>
<attribute>
<code>STREAM_RESULTS</code>
<attribute>Y</attribute>
</attribute>
<attribute>
<code>SUPPORTS_BOOLEAN_DATA_TYPE</code>
<attribute>Y</attribute>
</attribute>
<attribute>
<code>SUPPORTS_TIMESTAMP_DATA_TYPE</code>
<attribute>Y</attribute>
</attribute>
<attribute>
<code>USE_POOLING</code>
<attribute>N</attribute>
</attribute>
</attributes>
</connection>
<connection>
<name>local_sp-dev1</name>
<server>${local_ip}</server>
<type>MYSQL</type>
<access>Native</access>
<database>${schemeName_sp-dev1}</database>
<port>3306</port>
<username>${local_user}</username>
<password>${password}</password>
<servername />
<data_tablespace />
<index_tablespace />
<attributes>
<attribute>
<code>FORCE_IDENTIFIERS_TO_LOWERCASE</code>
<attribute>N</attribute>
</attribute>
<attribute>
<code>FORCE_IDENTIFIERS_TO_UPPERCASE</code>
<attribute>N</attribute>
</attribute>
<attribute>
<code>IS_CLUSTERED</code>
<attribute>N</attribute>
</attribute>
<attribute>
<code>PORT_NUMBER</code>
<attribute>3306</attribute>
</attribute>
<attribute>
<code>PRESERVE_RESERVED_WORD_CASE</code>
<attribute>Y</attribute>
</attribute>
<attribute>
<code>QUOTE_ALL_FIELDS</code>
<attribute>N</attribute>
</attribute>
<attribute>
<code>STREAM_RESULTS</code>
<attribute>Y</attribute>
</attribute>
<attribute>
<code>SUPPORTS_BOOLEAN_DATA_TYPE</code>
<attribute>Y</attribute>
</attribute>
<attribute>
<code>SUPPORTS_TIMESTAMP_DATA_TYPE</code>
<attribute>Y</attribute>
</attribute>
<attribute>
<code>USE_POOLING</code>
<attribute>N</attribute>
</attribute>
</attributes>
</connection>
<order>
<hop>
<from>删除所有sp-dev表数据</from>
<to>查询category 2</to>
<enabled>Y</enabled>
</hop>
<hop>
<from>删除所有sp-dev表数据</from>
<to>查询lottery 2</to>
<enabled>Y</enabled>
</hop>
<hop>
<from>删除所有sp-dev表数据</from>
<to>查询password 2</to>
<enabled>Y</enabled>
</hop>
<hop>
<from>删除所有sp-dev表数据</from>
<to>查询ser_article</to>
<enabled>Y</enabled>
</hop>
<hop>
<from>删除所有sp-dev表数据</from>
<to>查询ser_goods</to>
<enabled>Y</enabled>
</hop>
<hop>
<from>删除所有sp-dev表数据</from>
<to>查询sp_admin</to>
<enabled>Y</enabled>
</hop>
<hop>
<from>删除所有sp-dev表数据</from>
<to>查询sp_admin_login</to>
<enabled>Y</enabled>
</hop>
<hop>
<from>删除所有sp-dev表数据</from>
<to>查询sp_apilog</to>
<enabled>Y</enabled>
</hop>
<hop>
<from>删除所有sp-dev表数据</from>
<to>查询sp_cfg 2</to>
<enabled>Y</enabled>
</hop>
<hop>
<from>删除所有sp-dev表数据</from>
<to>查询sp_role</to>
<enabled>Y</enabled>
</hop>
<hop>
<from>删除所有sp-dev表数据</from>
<to>查询sp_role_permission</to>
<enabled>Y</enabled>
</hop>
<hop>
<from>删除所有sp-dev表数据</from>
<to>查询sys_dept</to>
<enabled>Y</enabled>
</hop>
<hop>
<from>删除所有sp-dev表数据</from>
<to>查询sys_notice</to>
<enabled>Y</enabled>
</hop>
<hop>
<from>查询category 2</from>
<to>插入 / 更新 category 2</to>
<enabled>Y</enabled>
</hop>
<hop>
<from>查询lottery 2</from>
<to>插入 / 更新 lottery 2</to>
<enabled>Y</enabled>
</hop>
<hop>
<from>查询password 2</from>
<to>插入 / 更新 password 2</to>
<enabled>Y</enabled>
</hop>
<hop>
<from>查询ser_article</from>
<to>插入 / 更新 ser_article</to>
<enabled>Y</enabled>
</hop>
<hop>
<from>查询ser_goods</from>
<to>插入 / 更新ser_goods</to>
<enabled>Y</enabled>
</hop>
<hop>
<from>查询sp_admin</from>
<to>插入 / 更新sp_admin</to>
<enabled>Y</enabled>
</hop>
<hop>
<from>查询sp_admin_login</from>
<to>插入 / 更新sp_admin_login</to>
<enabled>Y</enabled>
</hop>
<hop>
<from>查询sp_apilog</from>
<to>插入 / 更新sp_apilog</to>
<enabled>Y</enabled>
</hop>
<hop>
<from>查询sp_cfg 2</from>
<to>插入 / 更新 sp_cfg 2</to>
<enabled>Y</enabled>
</hop>
<hop>
<from>查询sp_role</from>
<to>插入 / 更新 sp_role</to>
<enabled>Y</enabled>
</hop>
<hop>
<from>查询sp_role_permission</from>
<to>插入 / 更新sp_role_permission</to>
<enabled>Y</enabled>
</hop>
<hop>
<from>查询sys_dept</from>
<to>插入 / 更新sys_dept</to>
<enabled>Y</enabled>
</hop>
<hop>
<from>查询sys_notice</from>
<to>插入 / 更新sys_notice</to>
<enabled>Y</enabled>
</hop>
<hop>
<from>查询sys_type</from>
<to>插入 / 更新sys_type</to>
<enabled>Y</enabled>
</hop>
<hop>
<from>查询user 2</from>
<to>插入 / 更新 user 2</to>
<enabled>Y</enabled>
</hop>
<hop>
<from>删除所有sp-dev表数据</from>
<to>查询sys_type</to>
<enabled>Y</enabled>
</hop>
<hop>
<from>删除所有sp-dev表数据</from>
<to>查询user 2</to>
<enabled>Y</enabled>
</hop>
</order>
<step>
<name>删除所有sp-dev表数据</name>
<type>ExecSQL</type>
<description />
<distribute>Y</distribute>
<custom_distribution />
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name />
</partitioning>
<connection>local_sp-dev1</connection>
<execute_each_row>Y</execute_each_row>
<single_statement>N</single_statement>
<replace_variables>N</replace_variables>
<quoteString>N</quoteString>
<sql>DELETE FROM category;
DELETE FROM lottery;
DELETE FROM password;
DELETE FROM ser_article;
DELETE FROM ser_goods;
DELETE FROM sp_admin;
DELETE FROM sp_admin_login;
DELETE FROM sp_apilog;
DELETE FROM sp_cfg;
DELETE FROM sp_role;
DELETE FROM sp_role_permission;
DELETE FROM sys_dept;
DELETE FROM sys_notice;
DELETE FROM sys_type;
DELETE FROM `user`;
</sql>
<set_params>N</set_params>
<insert_field />
<update_field />
<delete_field />
<read_field />
<arguments>
</arguments>
<cluster_schema />
<remotesteps>
<input>
</input>
<output>
</output>
</remotesteps>
<GUI>
<xloc>176</xloc>
<yloc>544</yloc>
<draw>Y</draw>
</GUI>
</step>
<step>
<name>查询category 2</name>
<type>TableInput</type>
<description />
<distribute>Y</distribute>
<custom_distribution />
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name />
</partitioning>
<connection>local_sp-dev</connection>
<sql>SELECT * FROM category;</sql>
<limit>0</limit>
<lookup />
<execute_each_row>N</execute_each_row>
<variables_active>N</variables_active>
<lazy_conversion_active>N</lazy_conversion_active>
<cluster_schema />
<remotesteps>
<input>
</input>
<output>
</output>
</remotesteps>
<GUI>
<xloc>560</xloc>
<yloc>32</yloc>
<draw>Y</draw>
</GUI>
</step>
<step>
<name>查询lottery 2</name>
<type>TableInput</type>
<description />
<distribute>Y</distribute>
<custom_distribution />
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name />
</partitioning>
<connection>local_sp-dev</connection>
<sql>SELECT * FROM lottery;</sql>
<limit>0</limit>
<lookup />
<execute_each_row>N</execute_each_row>
<variables_active>N</variables_active>
<lazy_conversion_active>N</lazy_conversion_active>
<cluster_schema />
<remotesteps>
<input>
</input>
<output>
</output>
</remotesteps>
<GUI>
<xloc>560</xloc>
<yloc>112</yloc>
<draw>Y</draw>
</GUI>
</step>
<step>
<name>查询password 2</name>
<type>TableInput</type>
<description />
<distribute>Y</distribute>
<custom_distribution />
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name />
</partitioning>
<connection>local_sp-dev</connection>
<sql>SELECT * FROM password;</sql>
<limit>0</limit>
<lookup />
<execute_each_row>N</execute_each_row>
<variables_active>N</variables_active>
<lazy_conversion_active>N</lazy_conversion_active>
<cluster_schema />
<remotesteps>
<input>
</input>
<output>
</output>
</remotesteps>
<GUI>
<xloc>560</xloc>
<yloc>192</yloc>
<draw>Y</draw>
</GUI>
</step>
<step>
<name>查询ser_article</name>
<type>TableInput</type>
<description />
<distribute>Y</distribute>
<custom_distribution />
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name />
</partitioning>
<connection>local_sp-dev</connection>
<sql>SELECT * FROM ser_article;</sql>
<limit>0</limit>
<lookup />
<execute_each_row>N</execute_each_row>
<variables_active>N</variables_active>
<lazy_conversion_active>N</lazy_conversion_active>
<cluster_schema />
<remotesteps>
<input>
</input>
<output>
</output>
</remotesteps>
<GUI>
<xloc>560</xloc>
<yloc>272</yloc>
<draw>Y</draw>
</GUI>
</step>
<step>
<name>插入 / 更新 category 2</name>
<type>InsertUpdate</type>
<description />
<distribute>Y</distribute>
<custom_distribution />
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name />
</partitioning>
<connection>local_sp-dev1</connection>
<commit>100</commit>
<update_bypassed>Y</update_bypassed>
<lookup>
<schema />
<table>category</table>
<key>
<name>id</name>
<field>id</field>
<condition>=</condition>
<name2 />
</key>
<value>
<name>id</name>
<rename>id</rename>
<update>Y</update>
</value>
<value>
<name>user_id</name>
<rename>user_id</rename>
<update>Y</update>
</value>
<value>
<name>name</name>
<rename>name</rename>
<update>Y</update>
</value>
<value>
<name>create_by</name>
<rename>create_by</rename>
<update>Y</update>
</value>
<value>
<name>create_time</name>
<rename>create_time</rename>
<update>Y</update>
</value>
<value>
<name>update_by</name>
<rename>update_by</rename>
<update>Y</update>
</value>
<value>
<name>update_time</name>
<rename>update_time</rename>
<update>Y</update>
</value>
</lookup>
<cluster_schema />
<remotesteps>
<input>
</input>
<output>
</output>
</remotesteps>
<GUI>
<xloc>832</xloc>
<yloc>32</yloc>
<draw>Y</draw>
</GUI>
</step>
<step>
<name>插入 / 更新 lottery 2</name>
<type>InsertUpdate</type>
<description />
<distribute>Y</distribute>
<custom_distribution />
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name />
</partitioning>
<connection>local_sp-dev1</connection>
<commit>100</commit>
<update_bypassed>N</update_bypassed>
<lookup>
<schema />
<table>lottery</table>
<key>
<name>id</name>
<field>id</field>
<condition>=</condition>
<name2 />
</key>
<value>
<name>code</name>
<rename>code</rename>
<update>Y</update>
</value>
<value>
<name>date</name>
<rename>date</rename>
<update>Y</update>
</value>
<value>
<name>red</name>
<rename>red</rename>
<update>Y</update>
</value>
<value>
<name>blue</name>
<rename>blue</rename>
<update>Y</update>
</value>
<value>
<name>sales</name>
<rename>sales</rename>
<update>Y</update>
</value>
<value>
<name>one_type_num</name>
<rename>one_type_num</rename>
<update>Y</update>
</value>
<value>
<name>one_type_money</name>
<rename>one_type_money</rename>
<update>Y</update>
</value>
<value>
<name>two_type_num</name>
<rename>two_type_num</rename>
<update>Y</update>
</value>
<value>
<name>two_type_money</name>
<rename>two_type_money</rename>
<update>Y</update>
</value>
<value>
<name>three_type_num</name>
<rename>three_type_num</rename>
<update>Y</update>
</value>
<value>
<name>three_type_money</name>
<rename>three_type_money</rename>
<update>Y</update>
</value>
<value>
<name>poolmoney</name>
<rename>poolmoney</rename>
<update>Y</update>
</value>
</lookup>
<cluster_schema />
<remotesteps>
<input>
</input>
<output>
</output>
</remotesteps>
<GUI>
<xloc>832</xloc>
<yloc>112</yloc>
<draw>Y</draw>
</GUI>
</step>
<step>
<name>插入 / 更新 password 2</name>
<type>InsertUpdate</type>
<description />
<distribute>Y</distribute>
<custom_distribution />
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name />
</partitioning>
<connection>local_sp-dev1</connection>
<commit>100</commit>
<update_bypassed>N</update_bypassed>
<lookup>
<schema />
<table>password</table>
<key>
<name>id</name>
<field>id</field>
<condition>=</condition>
<name2 />
</key>
<value>
<name>id</name>
<rename>id</rename>
<update>Y</update>
</value>
<value>
<name>user_id</name>
<rename>user_id</rename>
<update>Y</update>
</value>
<value>
<name>category_id</name>
<rename>category_id</rename>
<update>Y</update>
</value>
<value>
<name>title</name>
<rename>title</rename>
<update>Y</update>
</value>
<value>
<name>account</name>
<rename>account</rename>
<update>Y</update>
</value>
<value>
<name>password</name>
<rename>password</rename>
<update>Y</update>
</value>
<value>
<name>url</name>
<rename>url</rename>
<update>Y</update>
</value>
<value>
<name>notes</name>
<rename>notes</rename>
<update>Y</update>
</value>
<value>
<name>create_by</name>
<rename>create_by</rename>
<update>Y</update>
</value>
<value>
<name>create_time</name>
<rename>create_time</rename>
<update>Y</update>
</value>
<value>
<name>update_by</name>
<rename>update_by</rename>
<update>Y</update>
</value>
<value>
<name>update_time</name>
<rename>update_time</rename>
<update>Y</update>
</value>
</lookup>
<cluster_schema />
<remotesteps>
<input>
</input>
<output>
</output>
</remotesteps>
<GUI>
<xloc>832</xloc>
<yloc>192</yloc>
<draw>Y</draw>
</GUI>
</step>
<step>
<name>插入 / 更新 ser_article</name>
<type>InsertUpdate</type>
<description />
<distribute>Y</distribute>
<custom_distribution />
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name />
</partitioning>
<connection>local_sp-dev1</connection>
<commit>100</commit>
<update_bypassed>N</update_bypassed>
<lookup>
<schema />
<table>ser_article</table>
<key>
<name>id</name>
<field>id</field>
<condition>=</condition>
<name2 />
</key>
<value>
<name>id</name>
<rename>id</rename>
<update>Y</update>
</value>
<value>
<name>title</name>
<rename>title</rename>
<update>Y</update>
</value>
<value>
<name>content</name>
<rename>content</rename>
<update>Y</update>
</value>
<value>
<name>type_id</name>
<rename>type_id</rename>
<update>Y</update>
</value>
<value>
<name>goods_id</name>
<rename>goods_id</rename>
<update>Y</update>
</value>
<value>
<name>eff_time</name>
<rename>eff_time</rename>
<update>Y</update>
</value>
<value>
<name>create_time</name>
<rename>create_time</rename>
<update>Y</update>
</value>
<value>
<name>status</name>
<rename>status</rename>
<update>Y</update>
</value>
<value>
<name>is_eff</name>
<rename>is_eff</rename>
<update>Y</update>
</value>
</lookup>
<cluster_schema />
<remotesteps>
<input>
</input>
<output>
</output>
</remotesteps>
<GUI>
<xloc>832</xloc>
<yloc>272</yloc>
<draw>Y</draw>
</GUI>
</step>
<step>
<name>查询ser_goods</name>
<type>TableInput</type>
<description />
<distribute>Y</distribute>
<custom_distribution />
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name />
</partitioning>
<connection>local_sp-dev</connection>
<sql>SELECT * FROM ser_goods;</sql>
<limit>0</limit>
<lookup />
<execute_each_row>N</execute_each_row>
<variables_active>N</variables_active>
<lazy_conversion_active>N</lazy_conversion_active>
<cluster_schema />
<remotesteps>
<input>
</input>
<output>
</output>
</remotesteps>
<GUI>
<xloc>560</xloc>
<yloc>336</yloc>
<draw>Y</draw>
</GUI>
</step>
<step>
<name>插入 / 更新ser_goods</name>
<type>InsertUpdate</type>
<description />
<distribute>Y</distribute>
<custom_distribution />
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name />
</partitioning>
<connection>local_sp-dev1</connection>
<commit>100</commit>
<update_bypassed>N</update_bypassed>
<lookup>
<schema />
<table>ser_goods</table>
<key>
<name>id</name>
<field>id</field>
<condition>=</condition>
<name2 />
</key>
<value>
<name>id</name>
<rename>id</rename>
<update>Y</update>
</value>
<value>
<name>name</name>
<rename>name</rename>
<update>Y</update>
</value>
<value>
<name>avatar</name>
<rename>avatar</rename>
<update>Y</update>
</value>
<value>
<name>image_list</name>
<rename>image_list</rename>
<update>Y</update>
</value>
<value>
<name>content</name>
<rename>content</rename>
<update>Y</update>
</value>
<value>
<name>money</name>
<rename>money</rename>
<update>Y</update>
</value>
<value>
<name>type_id</name>
<rename>type_id</rename>
<update>Y</update>
</value>
<value>
<name>stock_count</name>
<rename>stock_count</rename>
<update>Y</update>
</value>
<value>
<name>status</name>
<rename>status</rename>
<update>Y</update>
</value>
<value>
<name>create_time</name>
<rename>create_time</rename>
<update>Y</update>
</value>
<value>
<name>update_time</name>
<rename>update_time</rename>
<update>Y</update>
</value>
</lookup>
<cluster_schema />
<remotesteps>
<input>
</input>
<output>
</output>
</remotesteps>
<GUI>
<xloc>832</xloc>
<yloc>336</yloc>
<draw>Y</draw>
</GUI>
</step>
<step>
<name>查询sp_admin</name>
<type>TableInput</type>
<description />
<distribute>Y</distribute>
<custom_distribution />
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name />
</partitioning>
<connection>local_sp-dev</connection>
<sql>SELECT * FROM sp_admin;</sql>
<limit>0</limit>
<lookup />
<execute_each_row>N</execute_each_row>
<variables_active>N</variables_active>
<lazy_conversion_active>N</lazy_conversion_active>
<cluster_schema />
<remotesteps>
<input>
</input>
<output>
</output>
</remotesteps>
<GUI>
<xloc>560</xloc>
<yloc>400</yloc>
<draw>Y</draw>
</GUI>
</step>
<step>
<name>插入 / 更新sp_admin</name>
<type>InsertUpdate</type>
<description />
<distribute>Y</distribute>
<custom_distribution />
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name />
</partitioning>
<connection>local_sp-dev1</connection>
<commit>100</commit>
<update_bypassed>N</update_bypassed>
<lookup>
<schema />
<table>sp_admin</table>
<key>
<name>id</name>
<field>id</field>
<condition>=</condition>
<name2 />
</key>
<value>
<name>id</name>
<rename>id</rename>
<update>Y</update>
</value>
<value>
<name>name</name>
<rename>name</rename>
<update>Y</update>
</value>
<value>
<name>avatar</name>
<rename>avatar</rename>
<update>Y</update>
</value>
<value>
<name>password</name>
<rename>password</rename>
<update>Y</update>
</value>
<value>
<name>pw</name>
<rename>pw</rename>
<update>Y</update>
</value>
<value>
<name>phone</name>
<rename>phone</rename>
<update>Y</update>
</value>
<value>
<name>role_id</name>
<rename>role_id</rename>
<update>Y</update>
</value>
<value>
<name>status</name>
<rename>status</rename>
<update>Y</update>
</value>
<value>
<name>create_by_aid</name>
<rename>create_by_aid</rename>
<update>Y</update>
</value>
<value>
<name>create_time</name>
<rename>create_time</rename>
<update>Y</update>
</value>
<value>
<name>login_time</name>
<rename>login_time</rename>
<update>Y</update>
</value>
<value>
<name>login_ip</name>
<rename>login_ip</rename>
<update>Y</update>
</value>
<value>
<name>login_count</name>
<rename>login_count</rename>
<update>Y</update>
</value>
</lookup>
<cluster_schema />
<remotesteps>
<input>
</input>
<output>
</output>
</remotesteps>
<GUI>
<xloc>832</xloc>
<yloc>400</yloc>
<draw>Y</draw>
</GUI>
</step>
<step>
<name>查询sp_admin_login</name>
<type>TableInput</type>
<description />
<distribute>Y</distribute>
<custom_distribution />
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name />
</partitioning>
<connection>local_sp-dev</connection>
<sql>SELECT * FROM sp_admin_login;</sql>
<limit>0</limit>
<lookup />
<execute_each_row>N</execute_each_row>
<variables_active>N</variables_active>
<lazy_conversion_active>N</lazy_conversion_active>
<cluster_schema />
<remotesteps>
<input>
</input>
<output>
</output>
</remotesteps>
<GUI>
<xloc>560</xloc>
<yloc>480</yloc>
<draw>Y</draw>
</GUI>
</step>
<step>
<name>插入 / 更新sp_admin_login</name>
<type>InsertUpdate</type>
<description />
<distribute>Y</distribute>
<custom_distribution />
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name />
</partitioning>
<connection>local_sp-dev1</connection>
<commit>100</commit>
<update_bypassed>N</update_bypassed>
<lookup>
<schema />
<table>sp_admin_login</table>
<key>
<name>id</name>
<field>id</field>
<condition>=</condition>
<name2 />
</key>
<value>
<name>id</name>
<rename>id</rename>
<update>Y</update>
</value>
<value>
<name>acc_id</name>
<rename>acc_id</rename>
<update>Y</update>
</value>
<value>
<name>acc_token</name>
<rename>acc_token</rename>
<update>Y</update>
</value>
<value>
<name>login_ip</name>
<rename>login_ip</rename>
<update>Y</update>
</value>
<value>
<name>address</name>
<rename>address</rename>
<update>Y</update>
</value>
<value>
<name>device</name>
<rename>device</rename>
<update>Y</update>
</value>
<value>
<name>`system`</name>
<rename>system</rename>
<update>Y</update>
</value>
<value>
<name>create_time</name>
<rename>create_time</rename>
<update>Y</update>
</value>
</lookup>
<cluster_schema />
<remotesteps>
<input>
</input>
<output>
</output>
</remotesteps>
<GUI>
<xloc>832</xloc>
<yloc>480</yloc>
<draw>Y</draw>
</GUI>
</step>
<step>
<name>查询sp_apilog</name>
<type>TableInput</type>
<description />
<distribute>Y</distribute>
<custom_distribution />
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name />
</partitioning>
<connection>local_sp-dev</connection>
<sql>SELECT * FROM sp_apilog;</sql>
<limit>0</limit>
<lookup />
<execute_each_row>N</execute_each_row>
<variables_active>N</variables_active>
<lazy_conversion_active>N</lazy_conversion_active>
<cluster_schema />
<remotesteps>
<input>
</input>
<output>
</output>
</remotesteps>
<GUI>
<xloc>560</xloc>
<yloc>544</yloc>
<draw>Y</draw>
</GUI>
</step>
<step>
<name>插入 / 更新sp_apilog</name>
<type>InsertUpdate</type>
<description />
<distribute>Y</distribute>
<custom_distribution />
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name />
</partitioning>
<connection>local_sp-dev1</connection>
<commit>100</commit>
<update_bypassed>N</update_bypassed>
<lookup>
<schema />
<table>sp_apilog</table>
<key>
<name>id</name>
<field>id</field>
<condition>=</condition>
<name2 />
</key>
<value>
<name>id</name>
<rename>id</rename>
<update>Y</update>
</value>
<value>
<name>req_ip</name>
<rename>req_ip</rename>
<update>Y</update>
</value>
<value>
<name>req_api</name>
<rename>req_api</rename>
<update>Y</update>
</value>
<value>
<name>req_parame</name>
<rename>req_parame</rename>
<update>Y</update>
</value>
<value>
<name>req_type</name>
<rename>req_type</rename>
<update>Y</update>
</value>
<value>
<name>req_token</name>
<rename>req_token</rename>
<update>Y</update>
</value>
<value>
<name>req_header</name>
<rename>req_header</rename>
<update>Y</update>
</value>
<value>
<name>res_code</name>
<rename>res_code</rename>
<update>Y</update>
</value>
<value>
<name>res_msg</name>
<rename>res_msg</rename>
<update>Y</update>
</value>
<value>
<name>res_string</name>
<rename>res_string</rename>
<update>Y</update>
</value>
<value>
<name>user_id</name>
<rename>user_id</rename>
<update>Y</update>
</value>
<value>
<name>admin_id</name>
<rename>admin_id</rename>
<update>Y</update>
</value>
<value>
<name>start_time</name>
<rename>start_time</rename>
<update>Y</update>
</value>
<value>
<name>end_time</name>
<rename>end_time</rename>
<update>Y</update>
</value>
<value>
<name>cost_time</name>
<rename>cost_time</rename>
<update>Y</update>
</value>
</lookup>
<cluster_schema />
<remotesteps>
<input>
</input>
<output>
</output>
</remotesteps>
<GUI>
<xloc>832</xloc>
<yloc>544</yloc>
<draw>Y</draw>
</GUI>
</step>
<step>
<name>查询sp_cfg 2</name>
<type>TableInput</type>
<description />
<distribute>Y</distribute>
<custom_distribution />
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name />
</partitioning>
<connection>local_sp-dev</connection>
<sql>SELECT * FROM sp_cfg;</sql>
<limit>0</limit>
<lookup />
<execute_each_row>N</execute_each_row>
<variables_active>N</variables_active>
<lazy_conversion_active>N</lazy_conversion_active>
<cluster_schema />
<remotesteps>
<input>
</input>
<output>
</output>
</remotesteps>
<GUI>
<xloc>560</xloc>
<yloc>608</yloc>
<draw>Y</draw>
</GUI>
</step>
<step>
<name>插入 / 更新 sp_cfg 2</name>
<type>InsertUpdate</type>
<description />
<distribute>Y</distribute>
<custom_distribution />
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name />
</partitioning>
<connection>local_sp-dev1</connection>
<commit>100</commit>
<update_bypassed>N</update_bypassed>
<lookup>
<schema />
<table>sp_cfg</table>
<key>
<name>id</name>
<field>id</field>
<condition>=</condition>
<name2 />
</key>
<value>
<name>id</name>
<rename>id</rename>
<update>Y</update>
</value>
<value>
<name>cfg_name</name>
<rename>cfg_name</rename>
<update>Y</update>
</value>
<value>
<name>cfg_value</name>
<rename>cfg_value</rename>
<update>Y</update>
</value>
<value>
<name>remarks</name>
<rename>remarks</rename>
<update>Y</update>
</value>
</lookup>
<cluster_schema />
<remotesteps>
<input>
</input>
<output>
</output>
</remotesteps>
<GUI>
<xloc>832</xloc>
<yloc>608</yloc>
<draw>Y</draw>
</GUI>
</step>
<step>
<name>查询sp_role</name>
<type>TableInput</type>
<description />
<distribute>Y</distribute>
<custom_distribution />
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name />
</partitioning>
<connection>local_sp-dev</connection>
<sql>SELECT * FROM sp_role;</sql>
<limit>0</limit>
<lookup />
<execute_each_row>N</execute_each_row>
<variables_active>N</variables_active>
<lazy_conversion_active>N</lazy_conversion_active>
<cluster_schema />
<remotesteps>
<input>
</input>
<output>
</output>
</remotesteps>
<GUI>
<xloc>560</xloc>
<yloc>688</yloc>
<draw>Y</draw>
</GUI>
</step>
<step>
<name>插入 / 更新 sp_role</name>
<type>InsertUpdate</type>
<description />
<distribute>Y</distribute>
<custom_distribution />
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name />
</partitioning>
<connection>local_sp-dev1</connection>
<commit>100</commit>
<update_bypassed>N</update_bypassed>
<lookup>
<schema />
<table>sp_role</table>
<key>
<name>id</name>
<field>id</field>
<condition>=</condition>
<name2 />
</key>
<value>
<name>id</name>
<rename>id</rename>
<update>Y</update>
</value>
<value>
<name>name</name>
<rename>name</rename>
<update>Y</update>
</value>
<value>
<name>info</name>
<rename>info</rename>
<update>Y</update>
</value>
<value>
<name>is_lock</name>
<rename>is_lock</rename>
<update>Y</update>
</value>
<value>
<name>create_time</name>
<rename>create_time</rename>
<update>Y</update>
</value>
</lookup>
<cluster_schema />
<remotesteps>
<input>
</input>
<output>
</output>
</remotesteps>
<GUI>
<xloc>832</xloc>
<yloc>688</yloc>
<draw>Y</draw>
</GUI>
</step>
<step>
<name>查询sp_role_permission</name>
<type>TableInput</type>
<description />
<distribute>Y</distribute>
<custom_distribution />
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name />
</partitioning>
<connection>local_sp-dev</connection>
<sql>SELECT * FROM sp_role_permission;</sql>
<limit>0</limit>
<lookup />
<execute_each_row>N</execute_each_row>
<variables_active>N</variables_active>
<lazy_conversion_active>N</lazy_conversion_active>
<cluster_schema />
<remotesteps>
<input>
</input>
<output>
</output>
</remotesteps>
<GUI>
<xloc>560</xloc>
<yloc>752</yloc>
<draw>Y</draw>
</GUI>
</step>
<step>
<name>插入 / 更新sp_role_permission</name>
<type>InsertUpdate</type>
<description />
<distribute>Y</distribute>
<custom_distribution />
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name />
</partitioning>
<connection>local_sp-dev1</connection>
<commit>100</commit>
<update_bypassed>N</update_bypassed>
<lookup>
<schema />
<table>sp_role_permission</table>
<key>
<name>id</name>
<field>id</field>
<condition>=</condition>
<name2 />
</key>
<value>
<name>id</name>
<rename>id</rename>
<update>Y</update>
</value>
<value>
<name>role_id</name>
<rename>role_id</rename>
<update>Y</update>
</value>
<value>
<name>permission_code</name>
<rename>permission_code</rename>
<update>Y</update>
</value>
<value>
<name>create_time</name>
<rename>create_time</rename>
<update>Y</update>
</value>
</lookup>
<cluster_schema />
<remotesteps>
<input>
</input>
<output>
</output>
</remotesteps>
<GUI>
<xloc>832</xloc>
<yloc>752</yloc>
<draw>Y</draw>
</GUI>
</step>
<step>
<name>查询sys_dept</name>
<type>TableInput</type>
<description />
<distribute>Y</distribute>
<custom_distribution />
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name />
</partitioning>
<connection>local_sp-dev</connection>
<sql>SELECT * FROM sys_dept;</sql>
<limit>0</limit>
<lookup />
<execute_each_row>N</execute_each_row>
<variables_active>N</variables_active>
<lazy_conversion_active>N</lazy_conversion_active>
<cluster_schema />
<remotesteps>
<input>
</input>
<output>
</output>
</remotesteps>
<GUI>
<xloc>560</xloc>
<yloc>816</yloc>
<draw>Y</draw>
</GUI>
</step>
<step>
<name>插入 / 更新sys_dept</name>
<type>InsertUpdate</type>
<description />
<distribute>Y</distribute>
<custom_distribution />
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name />
</partitioning>
<connection>local_sp-dev1</connection>
<commit>100</commit>
<update_bypassed>N</update_bypassed>
<lookup>
<schema />
<table>sys_dept</table>
<key>
<name>id</name>
<field>id</field>
<condition>=</condition>
<name2 />
</key>
<value>
<name>id</name>
<rename>id</rename>
<update>Y</update>
</value>
<value>
<name>name</name>
<rename>name</rename>
<update>Y</update>
</value>
<value>
<name>intro</name>
<rename>intro</rename>
<update>Y</update>
</value>
<value>
<name>parent_id</name>
<rename>parent_id</rename>
<update>Y</update>
</value>
<value>
<name>create_time</name>
<rename>create_time</rename>
<update>Y</update>
</value>
</lookup>
<cluster_schema />
<remotesteps>
<input>
</input>
<output>
</output>
</remotesteps>
<GUI>
<xloc>832</xloc>
<yloc>816</yloc>
<draw>Y</draw>
</GUI>
</step>
<step>
<name>查询sys_notice</name>
<type>TableInput</type>
<description />
<distribute>Y</distribute>
<custom_distribution />
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name />
</partitioning>
<connection>local_sp-dev</connection>
<sql>SELECT * FROM sys_notice;</sql>
<limit>0</limit>
<lookup />
<execute_each_row>N</execute_each_row>
<variables_active>N</variables_active>
<lazy_conversion_active>N</lazy_conversion_active>
<cluster_schema />
<remotesteps>
<input>
</input>
<output>
</output>
</remotesteps>
<GUI>
<xloc>560</xloc>
<yloc>896</yloc>
<draw>Y</draw>
</GUI>
</step>
<step>
<name>插入 / 更新sys_notice</name>
<type>InsertUpdate</type>
<description />
<distribute>Y</distribute>
<custom_distribution />
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name />
</partitioning>
<connection>local_sp-dev1</connection>
<commit>100</commit>
<update_bypassed>N</update_bypassed>
<lookup>
<schema />
<table>sys_notice</table>
<key>
<name>id</name>
<field>id</field>
<condition>=</condition>
<name2 />
</key>
<value>
<name>id</name>
<rename>id</rename>
<update>Y</update>
</value>
<value>
<name>title</name>
<rename>title</rename>
<update>Y</update>
</value>
<value>
<name>content</name>
<rename>content</rename>
<update>Y</update>
</value>
<value>
<name>img</name>
<rename>img</rename>
<update>Y</update>
</value>
<value>
<name>audio</name>
<rename>audio</rename>
<update>Y</update>
</value>
<value>
<name>video</name>
<rename>video</rename>
<update>Y</update>
</value>
<value>
<name>img_list</name>
<rename>img_list</rename>
<update>Y</update>
</value>
<value>
<name>audio_list</name>
<rename>audio_list</rename>
<update>Y</update>
</value>
<value>
<name>video_list</name>
<rename>video_list</rename>
<update>Y</update>
</value>
<value>
<name>img_video_list</name>
<rename>img_video_list</rename>
<update>Y</update>
</value>
<value>
<name>is_show</name>
<rename>is_show</rename>
<update>Y</update>
</value>
<value>
<name>is_lock</name>
<rename>is_lock</rename>
<update>Y</update>
</value>
<value>
<name>see_count</name>
<rename>see_count</rename>
<update>Y</update>
</value>
<value>
<name>sort</name>
<rename>sort</rename>
<update>Y</update>
</value>
<value>
<name>create_time</name>
<rename>create_time</rename>
<update>Y</update>
</value>
<value>
<name>update_time</name>
<rename>update_time</rename>
<update>Y</update>
</value>
</lookup>
<cluster_schema />
<remotesteps>
<input>
</input>
<output>
</output>
</remotesteps>
<GUI>
<xloc>832</xloc>
<yloc>896</yloc>
<draw>Y</draw>
</GUI>
</step>
<step>
<name>查询sys_type</name>
<type>TableInput</type>
<description />
<distribute>Y</distribute>
<custom_distribution />
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name />
</partitioning>
<connection>local_sp-dev</connection>
<sql>SELECT * FROM sys_type;</sql>
<limit>0</limit>
<lookup />
<execute_each_row>N</execute_each_row>
<variables_active>N</variables_active>
<lazy_conversion_active>N</lazy_conversion_active>
<cluster_schema />
<remotesteps>
<input>
</input>
<output>
</output>
</remotesteps>
<GUI>
<xloc>560</xloc>
<yloc>976</yloc>
<draw>Y</draw>
</GUI>
</step>
<step>
<name>插入 / 更新sys_type</name>
<type>InsertUpdate</type>
<description />
<distribute>Y</distribute>
<custom_distribution />
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name />
</partitioning>
<connection>local_sp-dev1</connection>
<commit>100</commit>
<update_bypassed>N</update_bypassed>
<lookup>
<schema />
<table>sys_type</table>
<key>
<name>id</name>
<field>id</field>
<condition>=</condition>
<name2 />
</key>
<value>
<name>id</name>
<rename>id</rename>
<update>Y</update>
</value>
<value>
<name>name</name>
<rename>name</rename>
<update>Y</update>
</value>
<value>
<name>icon</name>
<rename>icon</rename>
<update>Y</update>
</value>
<value>
<name>sort</name>
<rename>sort</rename>
<update>Y</update>
</value>
<value>
<name>create_time</name>
<rename>create_time</rename>
<update>Y</update>
</value>
</lookup>
<cluster_schema />
<remotesteps>
<input>
</input>
<output>
</output>
</remotesteps>
<GUI>
<xloc>832</xloc>
<yloc>976</yloc>
<draw>Y</draw>
</GUI>
</step>
<step>
<name>查询user 2</name>
<type>TableInput</type>
<description />
<distribute>Y</distribute>
<custom_distribution />
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name />
</partitioning>
<connection>local_sp-dev</connection>
<sql>SELECT * FROM `user`;</sql>
<limit>0</limit>
<lookup />
<execute_each_row>N</execute_each_row>
<variables_active>N</variables_active>
<lazy_conversion_active>N</lazy_conversion_active>
<cluster_schema />
<remotesteps>
<input>
</input>
<output>
</output>
</remotesteps>
<GUI>
<xloc>560</xloc>
<yloc>1040</yloc>
<draw>Y</draw>
</GUI>
</step>
<step>
<name>插入 / 更新 user 2</name>
<type>InsertUpdate</type>
<description />
<distribute>Y</distribute>
<custom_distribution />
<copies>1</copies>
<partitioning>
<method>none</method>
<schema_name />
</partitioning>
<connection>local_sp-dev1</connection>
<commit>100</commit>
<update_bypassed>N</update_bypassed>
<lookup>
<schema />
<table>user</table>
<key>
<name>id</name>
<field>id</field>
<condition>=</condition>
<name2 />
</key>
<value>
<name>id</name>
<rename>id</rename>
<update>Y</update>
</value>
<value>
<name>username</name>
<rename>username</rename>
<update>Y</update>
</value>
<value>
<name>password</name>
<rename>password</rename>
<update>Y</update>
</value>
<value>
<name>create_by</name>
<rename>create_by</rename>
<update>Y</update>
</value>
<value>
<name>create_time</name>
<rename>create_time</rename>
<update>Y</update>
</value>
<value>
<name>update_by</name>
<rename>update_by</rename>
<update>Y</update>
</value>
<value>
<name>update_time</name>
<rename>update_time</rename>
<update>Y</update>
</value>
</lookup>
<cluster_schema />
<remotesteps>
<input>
</input>
<output>
</output>
</remotesteps>
<GUI>
<xloc>832</xloc>
<yloc>1040</yloc>
<draw>Y</draw>
</GUI>
</step>
<step_error_handling>
</step_error_handling>
<slave-step-copy-partition-distribution>
</slave-step-copy-partition-distribution>
<slave_transformation>N</slave_transformation>
</transformation>