我是Python的新手,正在尝试让它工作。我使用的是Python 2.7和PostgreSQL 9.3:
#! F:\Python2.7.6\python
import psycopg2
class Database:
host = "192.168.56.101"
user = "testuser"
passwd = "passwd"
db = "test"
def __init__(self):
self.connection = psycopg2.connect( host = self.host,
user = self.user,
password = self.passwd,
dbname = self.db )
self.cursor = self.connection.cursor
def query(self, q):
cursor = self.cursor
cursor.execute(q)
return cursor.fetchall()
def __del__(self):
self.connection.close()
if __name__ == "__main__":
db = Database()
q = "DELETE FROM testschema.test"
db.query(q)
然而,我遇到了一个错误:“AttributeError: 'builtin_function_or_method' object has no attribute 'execute'”。我想我应该在Database类中放置类似self.execute = something的东西,但我无法弄清楚我需要放置什么。有什么建议吗?