How to format a datetime MySQL database field to local using strftime()

vergos.nikolas at gmail.com vergos.nikolas at gmail.com
Tue Feb 26 08:30:45 EST 2019


Τη Τρίτη, 26 Φεβρουαρίου 2019 - 3:26:29 μ.μ. UTC+2, ο χρήστης vergos.... at gmail.com έγραψε:
> Can  you help me rewrite this function, which when iam using 'pymysql' conncector works normally, it does not when iam using 'bottle_pymysql'
> 
> def coalesce( data ):
> 	newdata = []
> 	seen = {}
> 	for host, ref, location, useros, browser, visits, hits, downloads, authuser in data:
> 		# Here i have to decide how to group the rows together
> 		# I want an html row for every unique combination of (host) and that hits should be summed together
> 		key = host
> 		if key not in seen:
> 			newdata.append( [ [host], [ref], location, useros, browser, [visits], hits, [downloads], authuser ] )
> 			seen[key] = len( newdata ) - 1      # Save index (for 'newdata') of this row
> 		else:       # This row is a duplicate row with a different referrer & visit datetime & torrent download
> 			rowindex = seen[key]
> 			newdata[rowindex][0].append( host )
> 			newdata[rowindex][1].append( ref )
> 			newdata[rowindex][5].append( visits )
> 			newdata[rowindex][6] += hits
> 			newdata[rowindex][7].append( downloads )
> 	return newdata



For some reason in 'bottle-pymysql'

pagehit = cur.fetchone()[0] does not work

while reffering by name of the field 

pagehit = cur.fetchone()['hits'] does work.

Please help me write the baove function in a similar way.


More information about the Python-list mailing list