Newbie needing some help
Larry Martell
larry.martell at gmail.com
Fri Aug 8 17:43:55 EDT 2014
On Fri, Aug 8, 2014 at 3:07 PM, Matt Smith <smithmm at tblc.org> wrote:
> I am trying to write a program that will loop through a text file and delete
> rows in a mysql database.
>
> It seemingly runs but I don't see anything getting deleted in the db.
> Is there anything apparent that I am missing?
>
> This is the code:
> #!/usr/bin/python
> import mysql.connector
> #
> f=open('/home/smithm/email-list.txt', 'r')
> for line in f:
> #<do something with line>
> # Open database connection
> db = mysql.connector.connect(user="xx", password="xx",
> host="localhost", database="xx")
>
> # prepare a cursor object using cursor() method
> cursor = db.cursor()
>
> # Prepare SQL query to DELETE required records
> sql = "DELETE FROM tblc_users WHERE user_email=%s, % (line)"
> try:
> # Execute the SQL command
> cursor.execute(sql)
> # Commit your changes in the database
> db.commit()
> except:
> # Rollback in case there is any error
> db.rollback()
>
> # disconnect from server
> db.close()
Run it in the debugger, set a BP after you create the sql, print it
out, and cut and paste it into an interactive sql session and you'll
see what the issues are.
More information about the Python-list
mailing list