Yeah, i dont really understand how web2py sends locals() etc back to the view and how that differs from JSON data. I just keep trying random things until it works :)
On Tue, 23 Jun 2020 at 12:15, Pierre <pcg...@gmail.com> wrote: > thanks AG ............ I will look into your suggestion. > Fiddling with the error, found out that it's when reading back from sqlite > that the error arise. It's like something from web2py doesn't like the > format of my date in the field of the table. > But at this time, i do not know how to tell "web2py" that the string > representing the datetime in the field is formated like this '%Y-%m-%d : > %H:%M:%S' > wonder if the datetime format used in my sqlite table field is the > problem. So curius that everything works fine in the controler but not as > a task. > > Le lundi 22 juin 2020 20:54:34 UTC-4, AGRogers a écrit : >> >> Hi >> >> I use this code to solve this problem: >> >> result = json.dumps(result, indent=4, sort_keys=True, default=str) >> >> Don't know what it does but it solves my problem. >> >> I found it here: >> >> https://stackoverflow.com/questions/11875770/how-to-overcome-datetime-datetime-not-json-serializable >> >> >> >> >> On Wed, 17 Jun 2020 at 23:41, Pierre <pcg...@gmail.com> wrote: >> >>> 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 web...@googlegroups.com. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/web2py/ba7a30ef-1e82-430e-8295-8fd4be74c806o%40googlegroups.com >>> <https://groups.google.com/d/msgid/web2py/ba7a30ef-1e82-430e-8295-8fd4be74c806o%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> >> -- > 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 web2py+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/web2py/b9332712-6352-4a98-a051-71149d83f134o%40googlegroups.com > <https://groups.google.com/d/msgid/web2py/b9332712-6352-4a98-a051-71149d83f134o%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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 web2py+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/CACWMBMN4dkyUyy_j6owfS8M-FZxwwtz%3DsTTYzW4YFf_N45M5qQ%40mail.gmail.com.
