psycopg2 doesn't save data in to postgres database

Question

So I am web scraping from a news site for certain articles. And I am using psycopg2 to connect to postgres database and save data from this article.

with conn.cursor() as cur:
    query = """INSERT INTO
    articles (title, article_body, author, author_title, source_date, "createdAt", "updatedAt")
    VALUES (%s, %s, %s, %s, %s, %s, %s);"""
    cur.execute(query, (articleTitle, parsedText, articleAuthor, articleAuthorTitle, articlePostDate, now, now))
    cur.execute('SELECT author FROM articles')
    rows = cur.fetchall()
    print ('')
    print (rows)
    print ('')

The thing is that when second query is executed, it returns the data from the articles table, but when I make a query through terminal psql it shows that articles table is empty.

You should commit after you execute the insert query. Add this line conn.commit() after the line cur.execute(query, (articleTitle,... — Arihant
– Arihant, Commented Oct 7, 2018 at 9:27
Thanks, that was the problem. Completely forgot about commiting — SnakesCantWearBoots
– SnakesCantWearBoots, Commented Oct 7, 2018 at 9:33

Arihant · Accepted Answer · 2018-10-07 09:36:24Z

4

Try this. Hope it helps.

with conn.cursor() as cur:
    query = """INSERT INTO
    articles (title, article_body, author, author_title, source_date, "createdAt", "updatedAt")
    VALUES (%s, %s, %s, %s, %s, %s, %s);"""
    cur.execute(query, (articleTitle, parsedText, articleAuthor, articleAuthorTitle, articlePostDate, now, now))
    conn.commit()
    cur.execute('SELECT author FROM articles')
    rows = cur.fetchall()
    print ('')
    print (rows)
    print ('')

answered Oct 7, 2018 at 9:36

Arihant

7455 silver badges14 bronze badges

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

Collectives™ on Stack Overflow

psycopg2 doesn't save data in to postgres database

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