Python scraper how to add mysql insert

Question

What is wrong in my code ? I want to add %s to my mysql db.

 titlux = tree.xpath('//*[@id="offer-title"]/h1/text()')
 pretx = tree.xpath('//*[@id="offer-price-stock"]/div[3]/span/@content')

 print "%s," % titlux 
 print "%s," % pretx
 print "\n"
 conn = ..............

 x = conn.cursor()

 try:
    x.execute ("""INSERT INTO produse (titlu, pret) VALUES (%s, %s)""")
    conn.commit()
 except:
    conn.rollback()

 conn.close()

Please: tell us more! And Don't put bold everywhere! Thanks in advance. — Clodion
– Clodion, Commented Jul 28, 2015 at 18:16

Alastair McCormack · Accepted Answer · 2015-07-28 18:25:48Z

1

You're missing the replacement variables and some quotes in your SQL insert. Change it to:

x.execute ("""INSERT INTO produse (titlu, pret) VALUES ("%s", "%s")""" % (titlux[0], pretx[0]))

edited Jul 28, 2015 at 18:25

answered Jul 28, 2015 at 18:15

Alastair McCormack

28k8 gold badges81 silver badges106 bronze badges

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

4 Comments

Isuf Alex Over a year ago

Thancks, is worcking but give me the resulst like ['1199.99'], cant i remove [' ']?

FirebladeDan Over a year ago

That is just Python's output. Your database should show 1199.99. Does it?

Isuf Alex Over a year ago

No, is give me the result like: "titlu = [u'Laptop Asus X553MA-SX455B cu procesor Intelxae Celeronxae Dual-Core N2840, 2.16GHz, 4GB, 500GB, Intelxae HD Graphics, Microsoft Windows 8.1, Bing, Black']"

Alastair McCormack Over a year ago

Your xpath results obviously return lists. I've updated my answer to select the first item in the list. Don't forget to accept my answer :)

FirebladeDan · Accepted Answer · 2015-07-28 18:20:23Z

0

@Alastair has the right answer but if you want to see the query you're using

print "INSERT INTO produse (titlu, pret) VALUES (%s, %s)" % (titlux, pretx)
x.execute ("""INSERT INTO produse (titlu, pret) VALUES (%s, %s)""" % (titlux, pretx))

answered Jul 28, 2015 at 18:20

FirebladeDan

1,0696 silver badges14 bronze badges

Collectives™ on Stack Overflow

Python scraper how to add mysql insert

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related