SQLAlchemy's PGDateTime object does nothing, so its likely the issue
you're having is a psycopg2 issue. You should ask on their list
(using psycopg2-only code).
On Sep 26, 2008, at 5:28 AM, mraer wrote:
>
> This simple test fails with error:
> DataError: (DataError) unable to parse time None None
>
>
> def testDate1919(self):
> class DateHolder(object):
> def __init__(self, date):
> self.date = date
>
> metadata = MetaData()
> dateTable = Table(
> "date",
> metadata,
> Column("id", Integer, primary_key = True),
> Column("date", DateTime(timezone = True))
> )
>
> dateMapper = Mapper(DateHolder, dateTable)
> postgresSQLEngine = sqlalchemy.create_engine("postgres://
> postgres:[EMAIL PROTECTED]:5432/postgres")
> metadata.drop_all(bind = postgresSQLEngine)
> metadata.create_all(bind = postgresSQLEngine)
>
> oldDate = datetime.date(1919, month = 1, day = 1)
> time = datetime.datetime.now().time()
> oldDate = datetime.datetime.combine(oldDate, time)
> OldDate = DateHolder(oldDate)
>
> Session = sessionmaker(bind = postgresSQLEngine)
> session = Session()
> session.add(OldDate)
> session.commit()
>
> session = Session()
> dates = [date for date in session.query(DateHolder)]
> session.commit()
> >
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
