Angular, Flask, mysql.connector ProgrammingError: Wrong number of arguments

Question

I'm using Angular, Flask and MySQL.connector to connect to a MySQL database:

This is my python flask code handling post requests inserting a new "movie":

@app.route("/addMovies", methods=['POST'])
def addMovies():
    cnx = mysql.connector.connect(user='root', database='MovieTheatre')
    cursor = cnx.cursor()
    insert_stmt = (
        "INSERT INTO Movie (idMovie, MovieName, MovieYear) "
        "VALUES (%d, %s, %d)"
    )

    post = request.get_json()
    #data = (post['idMovie'], post['MovieName'], post['MovieYear'])
    data = (100, 'Test', 2010) # test data 
    print(insert_stmt,data)
    cursor.execute(insert_stmt,data)
    cnx.commit()
    cnx.close()
    return data

I know its not my Angularjs, because my browser console says Internal Server Error (500) so I started printing out the insert statement handled by flask and mysql.connector:

('INSERT INTO Movie (idMovie, MovieName, MovieYear) VALUES (%d, %s, %d)', (100, 'Test', 2010))

Which seems correct.

However I keep getting

    "Wrong number of arguments during string formatting")
ProgrammingError: Wrong number of arguments during string formatting

===============================================================================

Thanks to the answers, its fixed, for those wondering this is what I switched my code to :

@app.route("/addMovies", methods=['POST'])
def addMovies():
    cnx = mysql.connector.connect(user='root', database='MovieTheatre')
    cursor = cnx.cursor()
    insert_stmt = (
        "INSERT INTO Movie (idMovie, MovieName, MovieYear) "
        "VALUES (%s, %s, %s)"
    )

    post = request.get_json()
    data = (post['idMovie'], post['MovieName'], post['MovieYear'])
    print(insert_stmt,data)
    cursor.execute(insert_stmt,data)
    cnx.commit()
    cnx.close()
    return data

you don't even need to call str() manually since the type conversion is the task of the cursor.execute method — SheepPerplexed
– SheepPerplexed, Commented Dec 3, 2016 at 19:59
however then i get this error: TypeError: 'int' object is not callable — mding5692
– mding5692, Commented Dec 3, 2016 at 20:11

SheepPerplexed · Accepted Answer · 2016-12-03 19:22:19Z

1

Check the docs, it says the cursor.execute() method converts things as necessary to something the database understands. It seems you are supposed to use only %s placeholders in your string and let everything else on the execute method.

edited Dec 3, 2016 at 19:22

answered Dec 3, 2016 at 19:08

SheepPerplexed

1,17210 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Daniel Roseman · Accepted Answer · 2016-12-03 19:06:43Z

1

SQL parameter substitution is not the same as string formatting. You should always use %s, even for integers.

answered Dec 3, 2016 at 19:06

Daniel Roseman

602k68 gold badges911 silver badges924 bronze badges

Collectives™ on Stack Overflow

Angular, Flask, mysql.connector ProgrammingError: Wrong number of arguments

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related