CODEWITHSUNDEEP
pythonsqlsqlitepython-2.xexecute
user3628517
user3628517

Reputation: 93

Python Execute() takes exactly 2 arguments (3 given)

I am trying to insert into the SQLite DataBase values with this code:

con.Execute('''UPDATE tblPlayers SET p_Level = ? WHERE p_Username= ? ''', (PlayerLevel,PlayerUsername))

this is the Execute function:

def Execute(self,SQL):
    self.__connection.execute(SQL)
    self.__connection.comit()

and i am getting this error:

con.Execute('''UPDATE tblPlayers SET p_Level = ? WHERE p_Username= ? ''', (PlayerLevel,PlayerUsername)) TypeError: Execute() takes exactly 2 arguments (3 given)

Upvotes: 0

Views: 3701

Answers (2)

Eithos
Eithos

Reputation: 2491

This line says you are inputting two arguments:

con.Execute('''UPDATE tblPlayers SET p_Level = ? WHERE p_Username= ? ''', (PlayerLevel,PlayerUsername))

Add those 2 arguments to the implicit self argument that's passed automatically with the instance, you now have 3 arguments.

Either keep to 1 argument when calling it or modify the definition of Execute to accomodate 1 more argument.

Upvotes: 0

Martijn Pieters
Martijn Pieters

Reputation: 1122082

Your Execute() method takes only two arguments, self and SQL. The self argument is supplied by Python to bound methods, so there is only room for the SQL argument:

def Execute(self,SQL):

but you called the bound method with an additional argument, not just the one SQL argument:

con.Execute('''UPDATE tblPlayers SET p_Level = ? WHERE p_Username= ? ''',
            (PlayerLevel,PlayerUsername))

The tuple value passed in, together with the auto-inserted self argument and the SQL argument makes three.

If you want to support SQL parameters, you'll need to accept those parameters:

def Execute(self, SQL, params=()):
    self.__connection.execute(SQL, params)
    self.__connection.commit()

Upvotes: 3

Related Questions