我正在尝试将表中的数据导出到txt文件。我有如下代码
class Optimization_goolge(object):
def __init__(self):
self.dbname = ""
self.usr_name = ""
self.usr_pass = ""
self.con = ""
self.cur = ""
self.openTime=""
def vT(self, x, y, z, openTime):
try:
con_string="dbname = '%s' user = '%s' password ='%s' host = 'localhost'"%(x,y,z)
con = psycopg2.connect(con_string)
con.set_isolation_level(0)
cur = con.cursor()
cur.execute(("""COPY (select source, target, sum(cost)/1000 as cost from distance_matrix where source != 88888888 and target
!= 88888888 group by source, target order by source) TO '%s\\vrp_distance.txt'""") % (os.getcwd()))
con.commit()
但我犯了个错误
error vT Function could not open file "D:\working_copy\vrp_distance.txt" for writing: No such file or directory
Error optimizeFxn_google arguments did not match any overloaded call:
QMessageBox.warning(QWidget, QString, QString, QMessageBox.StandardButtons buttons=QMessageBox.Ok, QMessageBox.StandardButton defaultButton=QMessageBox.NoButton): argument 1 has unexpected type 'Optimization_goolge'
QMessageBox.warning(QWidget, QString, QString, int, int, int button2=0): argument 1 has unexpected type 'Optimization_goolge'
QMessageBox.warning(QWidget, QString, QString, QString, QString button1Text=QString(), QString button2Text=QString(), int defaultButtonNumber=0, int escapeButtonNumber=-1): argument 1 has unexpected type 'Optimization_goolge'
尝试:
要考虑的旁注(不是原始问题):
OptimizationGoolge
,按惯例vT
改名为有意义的东西你也要检查一下:
同时检查Save PL/pgSQL output from PostgreSQL to a CSV file。如果你没有书面许可,以上都是徒劳的。你知道吗
相关问题 更多 >
编程相关推荐