Yes. I think this can be my problem - custom translation of formats. I'm very sorry, that I was too fast with entering this user group. I will study more about it and I will give then message, if the problem is in format definition or really inside web2py. Thanks, Mirek
Dne pondělí, 18. února 2013 16:42:09 UTC+1 Niphlod napsal(a): > > as a general rule of thumb, in web2py date(time(s)) are stored always in > "pseudo-iso" format (YYYY-MM-DD) and transformed to/from according to the > date format specified into languages. Are you using custom translation > files and/or a different date-time widget than the default one included in > web2py ? > > On Monday, February 18, 2013 4:27:08 PM UTC+1, Mirek Zvolský wrote: >> >> Hi, >> maybe this is DAL.py error? Or more as one - strange behavior for dates >> in czech/german format - 'date' fields in tables cannot be used at all (!!) >> >> I have 'date' field in table 'akce' in SQLite database. >> I try a) after removing SQLite database I try run appadmin and browse >> table 'akce' >> b) after removing SQLite database I insert first record and >> immediately I try select records using db().select(db.akce.ALL) >> c) same as b) but after replacing 'date' field in table definition >> with 'datetime' >> >> 2.3.2 stable: >> a) http://localhost:8000/akce/appadmin/select/db?query=db.akce.id%3E0 >> appadmin fails with error message (1)-bellow >> b) select fails with error message (2)-bellow >> c) no error, but no row as select result (instead of proper one) >> >> 2.4.1 trunk (alpha.2 + timestamp.2013.01.10.21.26.18): >> a) appadmin will not fail, however count of rows will not display (there >> is 'rows' instead of '0 rows' - in czech language) >> b) select fails in same way as in 2.3.2 (message (2) !!!!) >> c) select works fine for 'datetime' fields >> >> I think at least in b) case, reason is german/czech date format, which >> SQLite driver get from DAL.py. >> Because >> datetime.date(*map(int, val.split("-"))) >> works well for dates like val='2013-02-19'. >> However sqlite3 driver will receive from DAL.py (func log_execute) the >> date in local german/czech format like val='19.02.2013' and fails. >> >> So field type 'date' in tables cannot be used at all ! >> Could this be repaired? >> >> Thanks, Mirek >> >> >> >> error (1) - I think this is fixed in trunk >> File >> "C:\Python27\Lib\site-packages\web2py\applications\akce\controllers/appadmin.py", >> >> line 213, in select >> nrows = db(query).count() >> File "C:\Python27\Lib\site-packages\web2py\gluon\dal.py", line 8896, in >> count >> return db._adapter.count(self.query,distinct) >> File "C:\Python27\Lib\site-packages\web2py\gluon\dal.py", line 1652, in >> count >> return self.cursor.fetchone()[0] >> TypeError: 'NoneType' object is not subscriptable >> >> error (2) - for 'date' fields, not fixed yet >> File "C:\Python27\Lib\site-packages\web2py\gluon\restricted.py", line >> 212, in restricted >> exec ccode in environment >> File >> "C:/Python27/Lib/site-packages/web2py/applications/akce/controllers/akce.py", >> >> line 47, in <module> >> File "C:\Python27\Lib\site-packages\web2py\gluon\globals.py", line 193, >> in <lambda> >> self._caller = lambda f: f() >> File >> "C:/Python27/Lib/site-packages/web2py/applications/akce/controllers/akce.py", >> >> line 7, in akce >> db.akce.ALL, orderby=db.akce.sraz_kdy) >> File "C:\Python27\Lib\site-packages\web2py\gluon\dal.py", line 9092, in >> select >> return adapter.select(self.query,fields,attributes) >> File "C:\Python27\Lib\site-packages\web2py\gluon\dal.py", line 2178, in >> select >> return super(SQLiteAdapter, self).select(query, fields, attributes) >> File "C:\Python27\Lib\site-packages\web2py\gluon\dal.py", line 1637, in >> select >> return self._select_aux(sql,fields,attributes) >> File "C:\Python27\Lib\site-packages\web2py\gluon\dal.py", line 1602, in >> _select_aux >> self.execute(sql) >> File "C:\Python27\Lib\site-packages\web2py\gluon\dal.py", line 1715, in >> execute >> return self.log_execute(*a, **b) >> File "C:\Python27\Lib\site-packages\web2py\gluon\dal.py", line 1709, in >> log_execute >> ret = self.cursor.execute(*a, **b) >> File "C:\Python27\lib\sqlite3\dbapi2.py", line 63, in convert_date >> return datetime.date(*map(int, val.split("-"))) >> ValueError: invalid literal for int() with base 10: '19.02.2013' >> > -- --- 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]. For more options, visit https://groups.google.com/groups/opt_out.
