On Tue, Mar 5, 2013 at 8:01 AM, Νίκος Γκρ33κ <nikos.gr...@gmail.com> wrote:
> Please help me correct thois code, iam tryign ti for hours and i cant seem
> to get it working....it irritates me....
>
There is no question here. No indication of what isn't working as you
like. No traceback.
>
> 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
>
--
Joel Goldstick
http://joelgoldstick.com
--
http://mail.python.org/mailman/listinfo/python-list
