On Apr 27, 2006, at 4:28 PM, Jon Rosebaugh wrote:
On 4/27/06, William K. Volkman <[EMAIL PROTECTED]> wrote:
I believe it's in the SQLite documentation that the database
doesn't really concern itself with the data types that you
specify. Basically it considers everything to be a string
object for storage purposes. It's when you try to fetch the
data that conversion happens to your requested type.
Could be. But there was no indication, either in the SQLite
documentation or SQLAlchemy documentation, of what the expected format
was.
there *is no date or time type* in SQLite: http://www.sqlite.org/
datatype3.html . so there is no expected format.
if you use the Date/Time/DateTime type in SQLAlchemy, it will do
reaonsable conversions between dates and strings, using a hardcoded
format. it *will not* work with some other arbitrary format you may
have stuck in your sqlite database.
This is less of a code bug as a documentation bug, but even so it
might be a good idea to not be so liberal about what we accept.
if youd like to add some notes to SQLite, there is a page on the wiki:
http://www.sqlalchemy.org/trac/wiki/DatabaseNotes
-------------------------------------------------------
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
-------------------------------------------------------
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
