How do I insert this data into postgresql with python?

Question

In the following codes,I want insert authors by locating link.

self.cur.execute("""
    UPDATE articles 
    SET authors = %s 
    WHERE link = %s returning id;
""" % (authors, link))
ret_id = self.cur.fetchone()

And two problems are encountered:

Some names are not regular like this:

LINE 1: UPDATE articles SET authors = Francesco D'Angelo,  Roberto T...

When author names are no problem:

"""UPDATE articles SET authors = %s WHERE link = %s returning id;""" % (authors, link))
psycopg2.ProgrammingError: syntax error at or near ":"
LINE 1: ...DATE articles SET authors = test WHERE link = http://www.wor...

Francisco · Accepted Answer · 2016-11-10 03:06:03Z

1

Don't format your strings with % when you are using SQL, let the driver do the proper escaping:

self.cur.execute(
    """UPDATE articles SET authors = %s WHERE link = %s returning id;""", (authors, link))

Notice I passed the data as the second argument, execute will take care of escaping the data properly.

answered Nov 10, 2016 at 3:06

Francisco

11.6k6 gold badges37 silver badges47 bronze badges

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

Collectives™ on Stack Overflow

How do I insert this data into postgresql with python?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related