自己写好代码,还写好了部署文档给老美,可是他嫌各种配置,脚本执行麻烦,于是让我搞个自动化部署,只需傻瓜似的下一步下一步就行了,其中里面有一个执行很多sql脚本文件步骤;
用Python subprocess模块来执行命令,直接上代码
file_path = "/usr/local/web/sql/test.sql"
cmd = ["mysql", "-h", ip, "-u", username, "-p%s" % passwd, dbname]
process = subprocess.Popen(cmd, stdin=subprocess.PIPE, stdout=subprocess.PIPE)
output = process.communicate("source " + file_path)
如果output 返回(”, None)这样的元祖,那就执行成功了