将变量传递到python中的路径/命令

Question

我是Python的新手。我想执行一个在python中有参数的脚本。请看下面的例子，了解我最终想要实现的目标。

我有一个带有参数的脚本：

PATH="ABCXYZ"
username = "admin"
password = "pass"
query = "select * from user;"
OUTPUT = /usr/local/<PATH>/dbscript -u username -p password -q query

如何在"/usr/local/<PATH>/dbscript"中传递PATH变量？

我尝试了os.system&subprocess，但我们不能在两者之间使用变量。我想要OUTPUT变量数据，它将打印yes、no或some number

Answer 1

下面必须工作。

import subprocess as sp
PATH="ABCXYZ"
username = "admin"
password = "pass"
query = "select * from user;"
command = "/usr/local/%s/dbscript -u %s -p %s -q %s" % (PATH, username, password, query)
#Next line print '/usr/local/ABCXYZ/dbscript -u admin -p pass -q select * from user;' for me.
print command # 
sp.Popen(command.split(), shell=True)

此外，您应该玩shell参数并阅读它。