任务描述

新增全量同步数据，需执行以下 SQL：


智能刊登数据线上库



INSERT INTO m_mercadolibre_listing_productid (CustomerId, OrderSourceId, ProductId, Status,
                                              FailureLog, Date, Time, CreatorId, Creator,
                                              CreationTime, LastModifierId, LastModifier,
                                              LastModificationTime, SiteStatus, SiteProductId,
                                              GlobalStatus, LastGlobalFinishedTime,
                                              MarketStatus, LastMarketFinishedTime, Remark)
SELECT CustomerId,
       OrderSourceId,
       ProductId,
       0,
       NULL,
       20230203,
       NOW(),
       0,
       '0203全量',
       NOW(),
       0,
       '0203全量',
       NOW(),
       'normal',
       NULL,
       0,
       '1900-01-01 00:00:00',
       0,
       '1900-01-01 00:00:00',
       '0203全量'
FROM m_mercadolibre_listing
where Status = 'active'



历史记录  
  1. 2023-02-06 12:04:05, 由 shilin 创建。
  2. 2023-02-06 12:04:56, 由 shilin 编辑。
    修改了 最初预计，旧值为 "0"，新值为 "1"。
    修改了 预计剩余，旧值为 "0"，新值为 "1"。
    修改了 任务描述，区别为：
    005-
    005+
    006-
    006+
    007- INSERT INTO m_mercadolibre_listing_productid (CustomerId, OrderSourceId, ProductId, Status,
    007+ INSERT INTO m_mercadolibre_listing_productid (CustomerId, OrderSourceId, ProductId, Status,
    008- FailureLog, Date, Time, CreatorId, Creator,
    008+ FailureLog, Date, Time, CreatorId, Creator,
    009- CreationTime, LastModifierId, LastModifier,
    009+ CreationTime, LastModifierId, LastModifier,
    010- LastModificationTime, SiteStatus, SiteProductId,
    010+ LastModificationTime, SiteStatus, SiteProductId,
    011- GlobalStatus, LastGlobalFinishedTime,
    011+ GlobalStatus, LastGlobalFinishedTime,
    012- MarketStatus, LastMarketFinishedTime, Remark)
    012+ MarketStatus, LastMarketFinishedTime, Remark)
    013- SELECT CustomerId,
    013+ SELECT CustomerId,
    014- OrderSourceId,
    014+ OrderSourceId,
    015- ProductId,
    015+ ProductId,
    016- 0,
    016+ 0,
    017- NULL,
    017+ NULL,
    018- 20230203,
    018+ 20230203,
    019- NOW(),
    019+ NOW(),
    020- 0,
    020+ 0,
    021- '0203全量',
    021+ '0203全量',
    022- NOW(),
    022+ NOW(),
    023- 0,
    023+ 0,
    024- '0203全量',
    024+ '0203全量',
    025- NOW(),
    025+ NOW(),
    026- 'normal',
    026+ 'normal',
    027- NULL,
    027+ NULL,
    028- 0,
    028+ 0,
    029- '1900-01-01 00:00:00',
    029+ '1900-01-01 00:00:00',
    030- 0,
    030+ 0,
    031- '1900-01-01 00:00:00',
    031+ '1900-01-01 00:00:00',
    032- '0203全量'
    032+ '0203全量'
    033- FROM m_mercadolibre_listing
    033+ FROM m_mercadolibre_listing
    034- where Status = 'active'
    034+ where Status = 'active'
    035-
    035+
    036-
    036+
    037-
    037+
    038-
    005- <p>
    005+ <p><br /></p>
    006- </p><div style="color:#D4D4D4;background-color:#1E1E1E;font-family:Consolas;">
    006+ <div style="color:#D4D4D4;background-color:#1E1E1E;font-family:Consolas;">
    007- <div><span style="color:#4fc1ff;">INSERT</span> <span style="color:#4fc1ff;">INTO</span> <span style="color:#dcdcaa;">m_mercadolibre_listing_productid</span> (<span style="color:#9cdcfe;">CustomerId</span>, <span style="color:#9cdcfe;">OrderSourceId</span>, <span style="color:#9cdcfe;">ProductId</span>, <span style="color:#9cdcfe;">Status</span>,</div>
    007+ <div><span style="color:#4fc1ff;">INSERT</span> <span style="color:#4fc1ff;">INTO</span> <span style="color:#dcdcaa;">m_mercadolibre_listing_productid</span> (<span style="color:#9cdcfe;">CustomerId</span>, <span style="color:#9cdcfe;">OrderSourceId</span>, <span style="color:#9cdcfe;">ProductId</span>, <span style="color:#9cdcfe;">Status</span>,</div>
    008- <div> <span style="color:#9cdcfe;">FailureLog</span>, <span style="color:#9cdcfe;">Date</span>, <span style="color:#9cdcfe;">Time</span>, <span style="color:#9cdcfe;">CreatorId</span>, <span style="color:#9cdcfe;">Creator</span>,</div>
    008+ <div> <span style="color:#9cdcfe;">FailureLog</span>, <span style="color:#9cdcfe;">Date</span>, <span style="color:#9cdcfe;">Time</span>, <span style="color:#9cdcfe;">CreatorId</span>, <span style="color:#9cdcfe;">Creator</span>,</div>
    009- <div> <span style="color:#9cdcfe;">CreationTime</span>, <span style="color:#9cdcfe;">LastModifierId</span>, <span style="color:#9cdcfe;">LastModifier</span>,</div>
    009+ <div> <span style="color:#9cdcfe;">CreationTime</span>, <span style="color:#9cdcfe;">LastModifierId</span>, <span style="color:#9cdcfe;">LastModifier</span>,</div>
    010- <div> <span style="color:#9cdcfe;">LastModificationTime</span>, <span style="color:#9cdcfe;">SiteStatus</span>, <span style="color:#9cdcfe;">SiteProductId</span>,</div>
    010+ <div> <span style="color:#9cdcfe;">LastModificationTime</span>, <span style="color:#9cdcfe;">SiteStatus</span>, <span style="color:#9cdcfe;">SiteProductId</span>,</div>
    011- <div> <span style="color:#9cdcfe;">GlobalStatus</span>, <span style="color:#9cdcfe;">LastGlobalFinishedTime</span>,</div>
    011+ <div> <span style="color:#9cdcfe;">GlobalStatus</span>, <span style="color:#9cdcfe;">LastGlobalFinishedTime</span>,</div>
    012- <div> <span style="color:#9cdcfe;">MarketStatus</span>, <span style="color:#9cdcfe;">LastMarketFinishedTime</span>, <span style="color:#9cdcfe;">Remark</span>)</div>
    012+ <div> <span style="color:#9cdcfe;">MarketStatus</span>, <span style="color:#9cdcfe;">LastMarketFinishedTime</span>, <span style="color:#9cdcfe;">Remark</span>)</div>
    013- <div><span style="color:#4fc1ff;">SELECT</span> <span style="color:#9cdcfe;">CustomerId</span>,</div>
    013+ <div><span style="color:#4fc1ff;">SELECT</span> <span style="color:#9cdcfe;">CustomerId</span>,</div>
    014- <div> <span style="color:#9cdcfe;">OrderSourceId</span>,</div>
    014+ <div> <span style="color:#9cdcfe;">OrderSourceId</span>,</div>
    015- <div> <span style="color:#9cdcfe;">ProductId</span>,</div>
    015+ <div> <span style="color:#9cdcfe;">ProductId</span>,</div>
    016- <div> <span style="color:#b5cea8;">0</span>,</div>
    016+ <div> <span style="color:#b5cea8;">0</span>,</div>
    017- <div> <span style="color:#4fc1ff;">NULL</span>,</div>
    017+ <div> <span style="color:#4fc1ff;">NULL</span>,</div>
    018- <div> <span style="color:#b5cea8;">20230203</span>,</div>
    018+ <div> <span style="color:#b5cea8;">20230203</span>,</div>
    019- <div> <span style="color:#dcdcaa;">NOW</span>(),</div>
    019+ <div> <span style="color:#dcdcaa;">NOW</span>(),</div>
    020- <div> <span style="color:#b5cea8;">0</span>,</div>
    020+ <div> <span style="color:#b5cea8;">0</span>,</div>
    021- <div> <span style="color:#ce9178;">'0203全量'</span>,</div>
    021+ <div> <span style="color:#ce9178;">'0203全量'</span>,</div>
    022- <div> <span style="color:#dcdcaa;">NOW</span>(),</div>
    022+ <div> <span style="color:#dcdcaa;">NOW</span>(),</div>
    023- <div> <span style="color:#b5cea8;">0</span>,</div>
    023+ <div> <span style="color:#b5cea8;">0</span>,</div>
    024- <div> <span style="color:#ce9178;">'0203全量'</span>,</div>
    024+ <div> <span style="color:#ce9178;">'0203全量'</span>,</div>
    025- <div> <span style="color:#dcdcaa;">NOW</span>(),</div>
    025+ <div> <span style="color:#dcdcaa;">NOW</span>(),</div>
    026- <div> <span style="color:#ce9178;">'normal'</span>,</div>
    026+ <div> <span style="color:#ce9178;">'normal'</span>,</div>
    027- <div> <span style="color:#4fc1ff;">NULL</span>,</div>
    027+ <div> <span style="color:#4fc1ff;">NULL</span>,</div>
    028- <div> <span style="color:#b5cea8;">0</span>,</div>
    028+ <div> <span style="color:#b5cea8;">0</span>,</div>
    029- <div> <span style="color:#ce9178;">'1900-01-01 00:00:00'</span>,</div>
    029+ <div> <span style="color:#ce9178;">'1900-01-01 00:00:00'</span>,</div>
    030- <div> <span style="color:#b5cea8;">0</span>,</div>
    030+ <div> <span style="color:#b5cea8;">0</span>,</div>
    031- <div> <span style="color:#ce9178;">'1900-01-01 00:00:00'</span>,</div>
    031+ <div> <span style="color:#ce9178;">'1900-01-01 00:00:00'</span>,</div>
    032- <div> <span style="color:#ce9178;">'0203全量'</span></div>
    032+ <div> <span style="color:#ce9178;">'0203全量'</span></div>
    033- <div><span style="color:#4fc1ff;">FROM</span> <span style="color:#9cdcfe;">m_mercadolibre_listing</span></div>
    033+ <div><span style="color:#4fc1ff;">FROM</span> <span style="color:#9cdcfe;">m_mercadolibre_listing</span></div>
    034- <div><span style="color:#9cdcfe;">where</span> <span style="color:#9cdcfe;">Status</span> = <span style="color:#ce9178;">'active'</span></div>
    034+ <div><span style="color:#9cdcfe;">where</span> <span style="color:#9cdcfe;">Status</span> = <span style="color:#ce9178;">'active'</span></div>
    035- </div>
    035+ </div>
    036- <p><br /></p>
    036+ <p><br /></p>
    037-
    037+ <p><br /></p>
    038- <p><br /></p>
  3. 2023-10-31 14:25:58, 由 周杰 关闭。
    修改了 任务状态，旧值为 "wait"，新值为 "closed"。
    修改了 指派给 ，旧值为 ""，新值为 "closed"。
    修改了 由谁关闭，旧值为 ""，新值为 "zhoujie"。
    修改了 关闭时间，旧值为 "0000-00-00 00:00:00"，新值为 "2023-10-31 14:25:58"。
返回
所属迭代 技术研发中心 2月运维事项（2023年）
所属模块 /
相关需求 暂无
指派给 Closed 于 2023-10-31 14:25:58
任务类型 运维
任务标签 初始
开发组 财务开发组
任务状态 已关闭
进度 0%
优先级 P2
关键词
抄送给
由谁创建 shilin 于 2023-02-06 12:04:05
由谁完成 暂无
由谁取消 暂无
由谁关闭 周杰 于 2023-10-31 14:25:58
关闭原因 暂无
最后编辑 周杰 于 2023-10-31 14:25:58
团队 最初预计 总计消耗 预计剩余
工时信息
最初预计 1工时
总计消耗 0工时
预计剩余 1工时
预计开始 0000-00-00
实际开始 0000-00-00
截止日期 0000-00-00