Please help me correct thois code, iam tryign ti for hours and i cant seem to
get it working....it irritates me....
path = "/home/nikos/public_html/data/files/"
for filename in os.walk(path):
try:
#find the needed counter for the page URL
cur.execute('''SELECT ID FROM files WHERE URL = %s''',
(filename,) )
data = cur.fetchone() #URL is unique, so should only be
one
if not data:
#first time for page; primary key is automatic, hit is
defaulted
cur.execute('''INSERT INTO files (URL, lastvisit)
VALUES (%s, %s)''', (filename, date) )
cID = cur.lastrowid #get the primary key value
of the new record
else:
#found the page, save primary key and use it to issue
hit UPDATE
cID = data[0]
cur.execute('''UPDATE files SET hits = hits + 1,
lastvisit = %s WHERE ID = %s''', (date, cID)
except MySQLdb.Error, e:
print ( "Query Error: ", sys.exc_info()[1].excepinfo()[2] )
--
http://mail.python.org/mailman/listinfo/python-list
