Downloading a file form a displayed table

Νίκος Γκρ33κ nikos.gr33k at gmail.com
Tue Mar 5 08:01:19 EST 2013


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] )



More information about the Python-list mailing list