Gooday,
In the controler the function works correctly. But as a task, it gives an
error about Json not beeing able to deal with datetime.
any suggestion would be appreciated :)
here is the error : TypeError: datetime.datetime(2020, 6, 16, 5, 17, 49)
is not JSON serializable
here is the code:
#reload(sys)
#sys.setdefaultencoding('utf-8')
import sys
import os
import time
import datetime
import sqlite3
#
#------------------------------------------------------------------------------
def pump_most_recent():
state = 'unknown'
try:
conn=sqlite3.connect('z:/alarm.sqlite')
except sqlite3.Error as err:
state = err # ='connexion impossible'
else:
state = 'connection ok'
# last entry in the local storage is kept in the acue table, have to
get this in order to query the prod databases
k = db(db.acue).select(db.acue.dstd2) # get the row
l = k[0].dstd2 # get the date of interest
curs=conn.cursor()
rows = curs.execute("select * from log_txt where date > ?",
(l,)).fetchall()
curs.close()
conn.close()
#
for row in rows:
a = datetime.datetime.strptime(row[1],'%Y-%m-%d : %H:%M:%S') #
date avec le temps
b = row[2]
c = row[3]
d = row[4]
e = row[5]
f = row[6]
g = row[7]
h = row[8]
i = row[9]
j = row[10]
#
db.alogs.insert(quand=a,etat=b,zone1=c,zone2=d,zone3=e,zone4=f,zone5=g,zone6=h,zone7=i,note=j)
finally:
return locals()
#
#-------------------------------------------------------------------------------
#
def acue_src_dst_update():
#
z = acue_src_dst_show()
a = z.get('a')
b = z.get('b')
c = z.get('c')
d = z.get('d')
#
db.acue.truncate()
db.acue.insert(srcd1=a,srcd2=b,dstd1=c, dstd2=d)
acue_after_update = db(db.acue).select()
#
return locals()
#------------------------------------------------------------------------------------------------------
from gluon.scheduler import Scheduler
Scheduler(db,dict(sync_data=pump_most_recent,sync_dates=acue_src_dst_update))
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/ba7a30ef-1e82-430e-8295-8fd4be74c806o%40googlegroups.com.
