Thursday, January 15, 2009
INSERT INTO statement with MySQLdb
One can insert column(s) data into mysql with the following python commands:
import MySQLdb
db=MySQLdb.connect(host="localhost",user = "root",passwd="123",db="mydb")
c=db.cursor()
...............
...............
c.execute("""INSERT INTO StockData (ind,Name,yesterday,pricenow,perch,id) VALUES (%s,"%s","%s","%s","%s","%s")""" %(i, str(comp), str(yesterday),str(pricenow),str(perch),str(id)))
db.commit()
Without using db.commit(), the database will not get updated.
Here ind column is of type integer and rest are strings.
via[Packtpub]
import MySQLdb
db=MySQLdb.connect(host="localhost",user = "root",passwd="123",db="mydb")
c=db.cursor()
...............
...............
c.execute("""INSERT INTO StockData (ind,Name,yesterday,pricenow,perch,id) VALUES (%s,"%s","%s","%s","%s","%s")""" %(i, str(comp), str(yesterday),str(pricenow),str(perch),str(id)))
db.commit()
Without using db.commit(), the database will not get updated.
Here ind column is of type integer and rest are strings.
via[Packtpub]
Saturday, January 10, 2009
How to create a new project in Code::Blocks
I was playing around with the free C++ IDE Code::Blocks.
This is the way to create a new C++ project.
Go through File->New->Project, select "Empty Project", click on "Go" and fill in the Project Name and (browse to) path.
This is the way to create a new C++ project.
Go through File->New->Project, select "Empty Project", click on "Go" and fill in the Project Name and (browse to) path.
Friday, January 9, 2009
Trying to avoid urlfetch errors in Google App Engine
I was having urlfetch download errors in my newsfeed aggregator India Hot News.
Modified code:
try:
result = urlfetch.fetch(url)
except urlfetch.Error():
continue
This seems to work temporarily.
Earlier the code was
try:
result = urlfetch.fetch(url)
except Exception:
continue
This "Exception" was working yesterday.
Gave Server Error today.
Let me see the modified code works fine or not.
This urlfetch errors are real glitches in Google App Engine.