/** * Licensed to JumpMind Inc under one or more contributor * license agreements. See the NOTICE file distributed * with this work for additional information regarding * copyright ownership. JumpMind Inc licenses this file * to you under the GNU General Public License, version 3.0 (GPLv3) * (the "License"); you may not use this file except in compliance * with the License. * * You should have received a copy of the GNU General Public License, * version 3.0 (GPLv3) along with this library; if not, see * <http://www.gnu.org/licenses/>. * * Unless required by applicable law or agreed to in writing, * software distributed under the License is distributed on an * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY * KIND, either express or implied. See the License for the * specific language governing permissions and limitations * under the License. */ package org.jumpmind.symmetric.service.impl; import java.util.Map; import org.jumpmind.db.platform.IDatabasePlatform; public class DataServiceSqlMap extends AbstractSqlMap { public DataServiceSqlMap(IDatabasePlatform platform, Map<String, String> replacementTokens) { super(platform, replacementTokens); putSql("selectTableReloadRequest", "select reload_select, reload_delete_stmt, reload_enabled, reload_time, create_time, last_update_by, last_update_time from $(table_reload_request) where source_node_id=? and target_node_id=? and trigger_id=? and router_id=?"); putSql("insertTableReloadRequest", "insert into $(table_reload_request) (reload_select, reload_delete_stmt, reload_enabled, reload_time, create_time, last_update_by, last_update_time, source_node_id, target_node_id, trigger_id, router_id) values (?,?,?,?,?,?,?,?,?,?,?)"); putSql("updateTableReloadRequest", "update $(table_reload_request) set reload_select=?, reload_delete_stmt=?, reload_enabled=?, reload_time=?, create_time=?, last_update_by=?, last_update_time=? where source_node_id=? and target_node_id=? and trigger_id=? and router_id=?"); putSql("deleteTableReloadRequest", "delete from $(table_reload_request) where source_node_id=? and target_node_id=? and trigger_id=? and router_id=?"); // Note that the order by data_id is done appended in code putSql("selectEventDataToExtractSql", "" + "select d.data_id, d.table_name, d.event_type, d.row_data as row_data, d.pk_data as pk_data, d.old_data as old_data, " + " d.create_time, d.trigger_hist_id, d.channel_id, d.transaction_id, d.source_node_id, d.external_data, d.node_list, e.router_id from $(data) d inner join " + " $(data_event) e on d.data_id = e.data_id inner join $(outgoing_batch) o on o.batch_id=e.batch_id " + " where o.batch_id = ? and o.node_id = ? "); putSql("selectEventDataByBatchIdSql", "" + "select d.data_id, d.table_name, d.event_type, d.row_data as row_data, d.pk_data as pk_data, d.old_data as old_data, " + " d.create_time, d.trigger_hist_id, d.channel_id, d.transaction_id, d.source_node_id, d.external_data, d.node_list, e.router_id from $(data) d inner join " + " $(data_event) e on d.data_id = e.data_id inner join $(outgoing_batch) o on o.batch_id=e.batch_id " + " where o.batch_id = ? "); putSql("selectEventDataIdsSql", "" + "select d.data_id from $(data) d inner join " + " $(data_event) e on d.data_id = e.data_id inner join $(outgoing_batch) o on o.batch_id=e.batch_id " + " where o.batch_id = ? and o.node_id = ? "); putSql("selectMaxDataEventDataIdSql", "" + "select max(data_id) from $(data_event) "); putSql("checkForAndUpdateMissingChannelIdSql", "" + "update $(data) set channel_id=? " + " where " + " data_id >= ? and data_id <= ? and " + " channel_id not in (select channel_id from $(channel)) "); putSql("countDataInRangeSql", "" + "select count(*) from $(data) where data_id > ? and data_id < ? "); putSql("insertIntoDataSql", "" + "insert into $(data) (data_id, table_name, event_type, row_data, pk_data, " + " old_data, trigger_hist_id, channel_id, external_data, node_list, create_time) values(null, ?, ?, ?, ?, ?, ?, ?, ?, ?, current_timestamp) "); putSql("insertIntoDataEventSql", "" + "insert into $(data_event) (data_id, batch_id, router_id, create_time) values(?, ?, ?, current_timestamp) "); putSql("findDataEventCreateTimeSql", "" + "select max(create_time) from $(data_event) where data_id=? "); putSql("findDataCreateTimeSql", "" + "select create_time from $(data) where data_id=? "); putSql("findMinDataSql", "" + "select min(data_id) from $(data) where data_id >= ?"); putSql("findDataGapsByStatusSql", "" + "select start_id, end_id, create_time from $(data_gap) where status=? order by start_id asc "); putSql("insertDataGapSql", "" + "insert into $(data_gap) (status, last_update_hostname, start_id, end_id, last_update_time, create_time) values(?, ?, ?, ?, current_timestamp, current_timestamp) "); putSql("updateDataGapSql", "" + "update $(data_gap) set status=?, last_update_hostname=?, last_update_time=current_timestamp where start_id=? and end_id=? "); putSql("deleteDataGapSql", "delete from $(data_gap) where start_id=? and end_id=? "); putSql("selectMaxDataIdSql", "" + "select max(data_id) from $(data) "); putSql("deleteCapturedConfigChannelDataSql", "delete from $(data) where channel_id='config'"); } }