Unable to update SQL database using python Pymysql

Question

I'm trying to create a class to automatically generate customer objects which would automatically get updated in the customer table in Mysql.

While i'm able to successfully generate customers, i'm not seeing the updated results in localhost/phpmyadmin.

from itertools import count
import pymysql

db = pymysql.connect('localhost','root','',db = 'customers')

cursor = db.cursor()

class customer():
    _ids = count(0)

    def __init__(self,User,Password,Wallet):
        self.ID = next(self._ids)
        self.User = User
        self.Password = Password
        self.wallet = Wallet

        insert = '''INSERT INTO customer(ID,Username,Password,Wallet) values ('%s','%s','%s','%s');'''%(self.ID,self.User,self.Password,self.wallet)

        conn = pymysql.connect('localhost','root','',db = 'customers')
        inscursor = conn.cursor()
        conn.commit()

Python doesnt seem to raise any error or exceptions as well.

KJ

I don't see your insert statement being executed anywhere, could be the problem? — Kev
– Kev, Commented Jun 15, 2015 at 8:01

Robert Moon · Accepted Answer · 2015-06-15 08:04:40Z

1

You have to execute before commit.

with connection.cursor() as cursor:
    # Create a new record
    sql = "INSERT INTO `users` (`email`, `password`) VALUES (%s, %s)"
    cursor.execute(sql, ('[email protected]', 'very-secret'))

# connection is not autocommit by default. So you must commit to save
# your changes.
connection.commit()

https://github.com/PyMySQL/PyMySQL#example

answered Jun 15, 2015 at 8:04

Robert Moon

1,05510 silver badges17 bronze badges

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

Comments

Tata · Accepted Answer · 2015-06-15 08:08:57Z

0

The answer is very simple. You are not running the query you are building.

You should add the row

inscursor.execute(insert)

before conn.commit()

answered Jun 15, 2015 at 8:08

Tata

8099 silver badges20 bronze badges

Collectives™ on Stack Overflow

Unable to update SQL database using python Pymysql

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