Re: [sqlalchemy] PostGIS/SQLite DateTime

2013-07-19 Thread Basil Veerman
sqlalchemy import create_engine engine = create_engine('sqlite:///test.db', echo=True) Session = sessionmaker(bind=engine) session = Session() for ob in session.query(Obs.time): print ob On Jul 12, 2013, at 8:56 PM, Basil Veerman basilv...@gmail.com wrote: Here is a short example

Re: [sqlalchemy] PostGIS/SQLite DateTime

2013-07-17 Thread Basil Veerman
('sqlite:///test.db', echo=True) Session = sessionmaker(bind=engine) session = Session() for ob in session.query(Obs.time): print ob On Jul 12, 2013, at 8:56 PM, Basil Veerman basilv...@gmail.comjavascript: wrote: Here is a short example that illustrates the original error: *Create

[sqlalchemy] PostGIS/SQLite DateTime

2013-07-12 Thread Basil Veerman
Hi, I've been struggling for a while trying to create a mapping that works with both PostGIS and SQLite databases when dealing with DateTime. Background: Production PostGIS database has been reduced and converted to a spatialite database with the same schema for offline testing purposes.

Re: [sqlalchemy] PostGIS/SQLite DateTime

2013-07-12 Thread Basil Veerman
/query.py, line 3157, in proc return row[column] ValueError: Couldn't parse datetime string: u'2004-05-18T00:00:00' On Fri, Jul 12, 2013 at 4:50 PM, Michael Bayer mike...@zzzcomputing.comwrote: On Jul 12, 2013, at 5:53 PM, Basil Veerman bveer...@uvic.ca wrote: Hi, I've been struggling