Ich erhalte ein <NoneType' object has no attribute 'execute'> und weiß nicht wieso.
Ich habe gegooglet aber half nichts. Hat jemand eine Idee?
Gruß Tron
Code: Alles auswählen
import mysql.connector
import sys
class databaseconnection:
host = username = password = database = connection = cursor = None
def __init__(self, host, username, password, database):
self.host = host
self.username = username
self.password = password
self.database = database
def Connect(self):
config = {
'user': self.username,
'password': self.password,
'host': self.host,
'database': self.database
}
try:
self.connection = mysql.connector.connect(**config)
self.cursor = self.connection.cursor()
print("Verbunden")
except mysql.connector.Error as error:
print("Verbindungs Fehler: {}".format(error))
def QuerySelect(self, sqlstatement):
try:
self.cursor.execute(sqlstatement) # <<< line 31, in QuerySelect - self.cursor.execute(sqlstatement) - AttributeError: 'NoneType' object has no attribute 'execute'
return_value = self.cursor.fetchall()
for row in return_value:
return row
print("Aufruf erfolgreich")
except mysql.connector.Error as error:
print("Aufruf fehlgeschlagen: {}".format(error))
return False
def Disconnect(self):
self.connection.close()
print("Verbindung geschlossen")
v1 = databaseconnection("localhost", "mysql", "****************", "Video_Database")
# v1.QuerySelect("SELECT fi_title, fi_year FROM Video_Database.Movies WHERE `fi_file_id`='1' AND `fi_TMDb_Title` IS NULL")
v1.QuerySelect("SELECT fi_title, fi_year FROM Video_Database.Movies WHERE fi_file_id=1 AND fi_TMDb_Title IS NULL")
