def _exists(self, db_query, table, data, ne_id):
"""
Method: _exists
Description: 检查记录是否存在
"""
data = DBSyncUtil.deserialize(data)
i = 1
moid = None
for attr in self.__moc_defs[table]['FIELDS']:
if attr.name == 'moid':
moid = data[i]
break
i = i + 1
sql = 'SELECT * FROM user_sync.%s WHERE "moid"=:1 AND "_SYNC_SOURCE"=:2' % (self.__moc_defs[table]['TABLE_NAME'])
debug.info(sql)
records = db_query.select(sql, [moid, ne_id])
if len(records) > 0:
return True
return False
def _add(self, db_query, table, data, ne_id):
"""
Method: _add
Description: 追加记录
Parameters:
db_query: DB查询对象
table: MOC名
data: 数据
ne_id: 客户端ID
"""
data = DBSyncUtil.deserialize(data)
fields = []
field_indexes = []
i = 1
for attr in self.__moc_defs[table]['FIELDS']:
if attr.name == '_SYNC_SOURCE':
if i <= len(data):
data[i-1] = ne_id
else:
data.append(ne_id)
fields.append('"%s"' % attr.name)
field_indexes.append(':%d' % i)
i = i + 1
sql = 'INSERT INTO user_sync.%s(%s) VALUES(%s)' % (self.__moc_defs[table]['TABLE_NAME']
,','.join(fields)
,','.join(field_indexes))
debug.info(sql)
debug.info(data)
try:
db_query.execute(sql, data)
except DBQueryError, e:
dberror = e.args[0]
if issubclass(dberror.__class__, cx_Oracle.DatabaseError):
error, = dberror.args
# ORA-0001: unique constraint
if error.code == 1:
tracelog.error('add conflict, full-sync will start')
return DBSyncStatus.ERROR_CONFLICT
tracelog.exception('database error')
return DBSyncStatus.ERROR_FAILED
def _edit(self, db_query, table, data, condition, ne_id):
"""
Method: _edit
Description: 更新记录
Parameters:
db_query: DB查询对象
table: MOC名
data: 数据
condition: 更新条件
ne_id: 客户端ID
"""
data = DBSyncUtil.deserialize(data)
fields = []
i = 1
for attr in self.__moc_defs[table]['FIELDS']:
if attr.name == '_SYNC_SOURCE':
if i <= len(data):
data[i-1] = ne_id
else:
data.append(ne_id)
fields.append('"%s"=:%d' % (attr.name, i))
i = i + 1
if condition is None:
sql = 'UPDATE user_sync.%s SET %s' % (self.__moc_defs[table]['TABLE_NAME']
,','.join(fields))
else:
sql = 'UPDATE user_sync.%s SET %s WHERE %s' % (self.__moc_defs[table]['TABLE_NAME']
,','.join(fields)
,condition)
debug.info(sql)
debug.info(data)
cursor = db_query.execute(sql, data)
if cursor is not None and cursor.rowcount == 0:
tracelog.error('update conflict, full-sync will start')
return DBSyncStatus.ERROR_CONFLICT
return DBSyncStatus.ERROR_SUCCESS
