On 4/27/06, Jonathan Ellis <[EMAIL PROTECTED]> wrote: > It isn't SA's place to validate data for your database. If you want a > database that's more rigorous about such things, then don't use sqlite. := )
But SA _is_ validating the data. The problem arises because SA is validating it in the DB->Python direction, but not in the Python->DB direction. Thus, SA won't allow me to read the data that I've used SA to write. And I had to dig into the code to find out what format SA _did_ want. See databases/sqlite.py, lines 46-57. It is expecting that the DateTime data found in the database will be a string in a certain format, but it makes no provision for ensuring that the data going in to the database is in this format. This is not in and of itself a very big problem. But it's not documented. When I was writing my app, I looked for documentation on the DateTime type. I didn't find any, so I assumed it was smart enough to handle anything I threw at it. It wasn't. ------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid0709&bid&3057&dat1642 _______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
