1. python代码:将多行sql合并成一行
#!/usr/bin/python
#encoding:utf-8
import sys
file = open(sys.argv[1])
sql=''
for line in file:
sql += ' ' + line
#print 'sql is ' + sql
result = ' '.join(sql.split())
print 'result is ' + result
2. 配置文件:配置账号和密码
Username=wwh
Password=wwh
IsDeleteFileAfterUpload=1
Sql="select * from user"
#!/bin/bash
#set -e
baseDir=$(readlink -f $(dirname $0))
now=`date '+%Y-%m-%d %H:%M:%S'`
ahourago=`date '+%H:%M:%S' -d '-1 hours'`
filename=`date '+%Y%m%d%H%M%S'`&#