def soldier_restrain_import(db):
data = request.files.data
error = ''
if data and data.file:
tmp_root = './tmp/'
if not isdir(tmp_root):
os.mkdir(tmp_root)
tmp_filename = os.path.join(
tmp_root, current_time('tmpsoldierrestrain_%Y%m%d%H%M.xls'))
tmp_file = open(tmp_filename, 'w')
rows = data.file.readlines()
if not rows:
error = '数据个数错误[2]'
return template('error', error=error)
for row in rows:
tmp_file.write(row)
tmp_file.close()
# 导入数据前先备份当前数据库中数据
export_sqls = SOLDIER_RESTRAIN_EXPORT_SQLS
try:
if os.path.exists(
os.path.join(tmp_root, SOLDIER_RESTRAIN_BACK_FILE)):
os.remove(os.path.join(tmp_root, SOLDIER_RESTRAIN_BACK_FILE))
excel_export(export_sqls, tmp_root, SOLDIER_RESTRAIN_BACK_FILE, db)
except Exception, e:
print 'soldier restrain 数据备份错误:%s' % e
all_sqls = SOLDIER_RESTRAIN_IMPORT_SQLS
error = excel_import(all_sqls, tmp_filename, db)
os.remove(tmp_filename)
def soldier_restrain_import(db):
data = request.files.data
error = ''
if data and data.file:
tmp_root = './tmp/'
if not isdir(tmp_root):
os.mkdir(tmp_root)
tmp_filename = os.path.join(tmp_root, current_time('tmpsoldierrestrain_%Y%m%d%H%M.xls'))
tmp_file = open(tmp_filename, 'w')
rows = data.file.readlines()
if not rows:
error = '数据个数错误[2]'
return template('error', error=error)
for row in rows:
tmp_file.write(row)
tmp_file.close()
# 导入数据前先备份当前数据库中数据
export_sqls = SOLDIER_RESTRAIN_EXPORT_SQLS
try:
if os.path.exists(os.path.join(tmp_root, SOLDIER_RESTRAIN_BACK_FILE)):
os.remove(os.path.join(tmp_root, SOLDIER_RESTRAIN_BACK_FILE))
excel_export(export_sqls, tmp_root, SOLDIER_RESTRAIN_BACK_FILE, db)
except Exception, e:
print 'soldier restrain 数据备份错误:%s' %e
all_sqls = SOLDIER_RESTRAIN_IMPORT_SQLS
error = excel_import(all_sqls, tmp_filename, db)
os.remove(tmp_filename)
def error_import(db):
data = request.files.data
error = ''
if data and data.file:
tmp_root = './tmp/'
if not isdir(tmp_root):
os.mkdir(tmp_root)
tmp_filename = os.path.join(tmp_root, current_time('tmperror_%Y%m%d%H%M.xls'))
tmp_file = open(tmp_filename, 'w') # 新建一个xls后缀的文件，然后将读取的excel文件的内容写入该文件
rows = data.file.readlines()
if not rows: # 文件空
error = '数据个数错误[2]'
return template('error', error=error)
for row in rows:
tmp_file.write(row)
tmp_file.close()
# 导入数据前，先对数据库数据进行备份
export_sqls = ERROR_EXPORT_SQLS
try:
# 若备份文件存在，删除重新写入
if os.path.exists(os.path.join(tmp_root, ERROR_BACK_FILE)):
os.remove(os.path.join(tmp_root, ERROR_BACK_FILE))
excel_export(export_sqls, tmp_root, ERROR_BACK_FILE, db)
except Exception, e:
print 'error 数据备份错误: %s' %e
all_sqls = ERROR_IMPORT_SQLS
error = excel_import(all_sqls, tmp_filename, db)
os.remove(tmp_filename) # 删除临时文件
def monthly_card_import(db):
data = request.files.data
error = ''
all_sqls = IMPORT_SQLS
if data and data.file:
tmp_root = './tmp/'
if not isdir(tmp_root): # 若目录tmp_root不存在，则创建
os.mkdir(tmp_root)
tmp_filename = os.path.join(tmp_root, current_time('tmp_monthly_card%Y%m%d%H%M%S.xls'))
tmp_file = open(tmp_filename, 'w') # 新建一个xls后缀的文件，然后将读取的excel文件的内容写入该文件中
rows = data.file.readlines()
if not rows: # 文件空
error = '数据格式错误[2]'
return template('error', error=error)
for row in rows:
tmp_file.write(row)
tmp_file.close()
# 在导入新的数据前，先将数据库原有数据导出到tmp目录，作为备份，数据导入失败时可以恢复数据
export_sqls = EXPORT_SQLS
try:
# 若备份文件已存在，则删除重新写入
if os.path.exists(os.path.join(tmp_root, BACK_FILE)):
os.remove(os.path.join(tmp_root, BACK_FILE))
excel_export(export_sqls, tmp_root, BACK_FILE, db)
except Exception, e:
print '数据备份错误: %s' %e
error = excel_import(all_sqls, tmp_filename, db)
os.remove(tmp_filename) # 删除上传的临时文件
def soldier_restrain_recover(db):
tmp_root = './tmp/'
filename = os.path.join(tmp_root, SOLDIER_RESTRAIN_BACK_FILE)
error = ''
if not isfile(filename):
error = '没有soldier restrain 备份文件'
return template('error', error=error)
all_sqls = SOLDIER_RESTRAIN_IMPORT_SQLS
error = excel_import(all_sqls, filename, db)
if error:
return template('error', error='数据恢复失败，原因：' + error)
else:
redirect("/soldier/restrain")
def skill_ball_recover(db):
tmp_root = './tmp/'
filename = os.path.join(tmp_root, SKILL_BALL_BACK_FILE)
error = ''
if not isfile(filename):
error = '没有备份文件'
return template('error', error=error)
all_sqls = SKILL_BALL_IMPORT_SQLS
error = excel_import(all_sqls, filename, db)
if error:
return template('error', error= '数据恢复失败，原因：' + error)
else:
redirect('/skill_ball')
def monthly_card_recover(db):
tmp_root = './tmp/'
filename = os.path.join(tmp_root, BACK_FILE)
error = ''
if not isfile(filename):
error = '没有备份文件'
return template('error', error=error)
all_sqls = IMPORT_SQLS
error = excel_import(all_sqls, filename, db)
if error:
return template('error', error= '数据恢复失败，原因：' + error)
else:
redirect('/monthly_card')
def attribute_recover(db):
tmp_root = './tmp/'
filename = os.path.join(tmp_root, ATTRIBUTE_BACK_FILE)
error = ''
if not isfile(filename):
error = '没有备份文件'
return template('error', error=error)
all_sqls = ATTRIBUTE_IMPORT_SQLS
error = excel_import(all_sqls, filename, db)
if error:
return template('error', error= '数据恢复失败，原因：' + error)
else:
redirect('/attribute')
def soldier_restrain_recover(db):
tmp_root = './tmp/'
filename = os.path.join(tmp_root, SOLDIER_RESTRAIN_BACK_FILE)
error = ''
if not isfile(filename):
error = '没有soldier restrain 备份文件'
return template('error', error=error)
all_sqls = SOLDIER_RESTRAIN_IMPORT_SQLS
error = excel_import(all_sqls, filename, db)
if error:
return template('error', error='数据恢复失败，原因：' + error)
else:
redirect("/soldier/restrain")
def error_recover(db):
tmp_root = './tmp/'
filename = os.path.join(tmp_root, ERROR_BACK_FILE)
error =''
if not isfile(filename):
error = '没有error备份文件'
return template('error', error=error)
all_sqls = ERROR_IMPORT_SQLS
error = excel_import(all_sqls, filename, db)
if error:
return template('error', error = '数据恢复失败，原因：' + error)
else:
redirect('/errorCode')
def keyword_import(db):
data = request.files.data
error = ''
lang_id = int(request.forms.lang)
_table = 'tb_keyword_%s' % lang_id if lang_id and lang_id != '0' else table_name
all_sqls = {'Message': [insert_sql.format(_table), _table]}
export_sqls = {
_table: [sql_base_tpl.format(_table), field_base, 'Message']
}
if data and data.file:
tmp_root = './tmp/'
if not isdir(tmp_root): # 若目录tmp_root不存在，则创建
os.mkdir(tmp_root)
tmp_filename = os.path.join(
tmp_root, current_time('tmpkeyword_%Y%m%d%H%M%S.xls'))
tmp_file = open(tmp_filename,
'w') # 新建一个xls后缀的文件，然后将读取的excel文件的内容写入该文件中
rows = data.file.readlines()
if not rows: # 文件空
error = '数据格式错误[2]'
return template('error', error=error)
for row in rows:
tmp_file.write(row)
tmp_file.close()
# 在导入新的数据前，先将数据库原有数据导出到tmp目录，作为备份，数据导入失败时可以恢复数据
try:
# 若备份文件已存在，则删除重新写入
if os.path.exists(os.path.join(tmp_root, BACK_FILE)):
os.remove(os.path.join(tmp_root, BACK_FILE))
excel_export(export_sqls, tmp_root, BACK_FILE, db)
except Exception, e:
print '数据备份错误: %s' % e
error = excel_import(all_sqls, tmp_filename, db)
os.remove(tmp_filename) # 删除上传的临时文件
def keyword_import(db):
data = request.files.data
error = ''
lang_id = int(request.forms.lang)
_table = 'tb_keyword_%s' % lang_id if lang_id and lang_id != '0' else table_name
all_sqls = { 'Message' : [insert_sql.format( _table ), _table] }
export_sqls = { _table : [sql_base_tpl.format( _table ), field_base, 'Message'] }
if data and data.file:
tmp_root = './tmp/'
if not isdir(tmp_root): # 若目录tmp_root不存在，则创建
os.mkdir(tmp_root)
tmp_filename = os.path.join(tmp_root, current_time('tmpkeyword_%Y%m%d%H%M%S.xls'))
tmp_file = open(tmp_filename, 'w') # 新建一个xls后缀的文件，然后将读取的excel文件的内容写入该文件中
rows = data.file.readlines()
if not rows: # 文件空
error = '数据格式错误[2]'
return template('error', error=error)
for row in rows:
tmp_file.write(row)
tmp_file.close()
# 在导入新的数据前，先将数据库原有数据导出到tmp目录，作为备份，数据导入失败时可以恢复数据
try:
# 若备份文件已存在，则删除重新写入
if os.path.exists(os.path.join(tmp_root, BACK_FILE)):
os.remove(os.path.join(tmp_root, BACK_FILE))
excel_export(export_sqls, tmp_root, BACK_FILE, db)
except Exception, e:
print '数据备份错误: %s' %e
error = excel_import(all_sqls, tmp_filename, db)
os.remove(tmp_filename) # 删除上传的临时文件
# 若备份文件已存在，则删除重新写入
if os.path.exists(os.path.join(tmp_root, MONSTER_DROP_BACK_FILE)):
os.remove(os.path.join(tmp_root, MONSTER_DROP_BACK_FILE))
excel_export(export_sqls, tmp_root, MONSTER_DROP_BACK_FILE, db)
except Exception, e:
print '数据备份错误: %s' % e
error = excel_import(all_sqls, tmp_filename, db)
os.remove(tmp_filename) # 删除上传的临时文件
else: # 没有文件
error = '数据格式错误[1]'
if error:
# 导入数据错误，进行数据恢复
try:
excel_import(all_sqls,
os.path.join(tmp_root, MONSTER_DROP_BACK_FILE), db)
print '数据恢复成功'
except Exception, e:
print '数据恢复错误: %s' % e
return template('error', error=error + ' 数据已恢复')
else:
redirect("/monster_drop")
@route("/monster_drop/export")
def monster_drop_export(db):
tmp_root = './tmp/'
filename = current_time("monster_drop_%Y%m%d%H%M.xls") # 文件名
error = ''
if not isfile(tmp_root + filename):
# 若备份文件已存在，则删除重新写入
if os.path.exists(os.path.join(tmp_root, BACK_FILE)):
os.remove(os.path.join(tmp_root, BACK_FILE))
excel_export(export_sqls, tmp_root, BACK_FILE, db)
except Exception, e:
print '数据备份错误: %s' %e
error = excel_import(all_sqls, tmp_filename, db)
os.remove(tmp_filename) # 删除上传的临时文件
else: # 没有文件
error = '数据格式错误[1]'
if error:
# 导入数据错误，进行数据恢复
try:
excel_import(all_sqls, os.path.join(tmp_root, BACK_FILE), db)
print '数据恢复成功'
except Exception, e:
print '数据恢复错误: %s' %e
return template('error', error=error + ' 数据已恢复')
else:
redirect("/monthly_card")
@route("/monthly_card/export")
def monthly_card_export(db):
tmp_root = './tmp/'
filename = current_time(excel_export_filename) # 文件名
error = ''
if not isfile(tmp_root + filename):
all_sqls = EXPORT_SQLS
os.remove(os.path.join(tmp_root, SOLDIER_BACK_FILE))
excel_export(export_sqls, tmp_root, SOLDIER_BACK_FILE, db)
except Exception, e:
print 'soldier 数据备份错误: %s' % e
all_sqls = SOLDIER_IMPORT_SQLS
error = excel_import(all_sqls, tmp_filename, db)
os.remove(tmp_filename) # 删除上传的临时文件
else: # 没有文件
error = '数据格式错误[1]'
if error:
# 导入数据错误，进行数据恢复
try:
excel_import(all_sqls, os.path.join(tmp_root, SOLDIER_BACK_FILE),
db)
print 'soldier 数据恢复成功'
except Exception, e:
print 'soldier 数据恢复错误: %s' % e
return template('error', error=error + ' 数据已恢复')
else:
redirect("/soldier")
def old_soldier_import(db):
data = request.files.data
error = ''
if data and data.file:
content = data.file.readlines()
content = [[col.strip() for col in row.split(',')]
os.remove(os.path.join(tmp_root, SOLDIER_BACK_FILE))
excel_export(export_sqls, tmp_root, SOLDIER_BACK_FILE, db)
except Exception, e:
print 'soldier 数据备份错误: %s' %e
all_sqls = SOLDIER_IMPORT_SQLS
error = excel_import(all_sqls, tmp_filename, db)
os.remove(tmp_filename) # 删除上传的临时文件
else: # 没有文件
error = '数据格式错误[1]'
if error:
# 导入数据错误，进行数据恢复
try:
excel_import(all_sqls, os.path.join(tmp_root, SOLDIER_BACK_FILE), db)
print 'soldier 数据恢复成功'
except Exception, e:
print 'soldier 数据恢复错误: %s' %e
return template('error', error=error + ' 数据已恢复')
else:
redirect("/soldier")
def old_soldier_import(db):
data = request.files.data
error = ''
if data and data.file:
content = data.file.readlines()
content = [[col.strip() for col in row.split(',')] for row in content[1:]]
# 若备份文件已存在，则删除重新写入
if os.path.exists(os.path.join(tmp_root, MONSTER_DROP_BACK_FILE)):
os.remove(os.path.join(tmp_root, MONSTER_DROP_BACK_FILE))
excel_export(export_sqls, tmp_root, MONSTER_DROP_BACK_FILE, db)
except Exception, e:
print '数据备份错误: %s' %e
error = excel_import(all_sqls, tmp_filename, db)
os.remove(tmp_filename) # 删除上传的临时文件
else: # 没有文件
error = '数据格式错误[1]'
if error:
# 导入数据错误，进行数据恢复
try:
excel_import(all_sqls, os.path.join(tmp_root, MONSTER_DROP_BACK_FILE), db)
print '数据恢复成功'
except Exception, e:
print '数据恢复错误: %s' %e
return template('error', error=error + ' 数据已恢复')
else:
redirect("/monster_drop")
@route("/monster_drop/export")
def monster_drop_export(db):
tmp_root = './tmp/'
filename = current_time("monster_drop_%Y%m%d%H%M.xls") # 文件名
error = ''
if not isfile(tmp_root + filename):
all_sqls = MONSTER_DROP_EXPORT_SQLS
