Skip to content

reflection unable to handle oracle TIMESTAMP WITH TIME ZONE #651

Closed
@sqlalchemy-bot

Description

@sqlalchemy-bot
Collaborator

Migrated issue, originally created by Anonymous

sqlalchemy 0.3.8

exp_table = Table("foo", metadata, autoload=True)

File "build\bdist.win32\egg\sqlalchemy\schema.py", line 166, in call
File "build\bdist.win32\egg\sqlalchemy\engine\base.py", line 809, in reflecttable
File "build\bdist.win32\egg\sqlalchemy\databases\oracle.py", line 342, in reflecttable
sqlalchemy.exceptions.AssertionError: Can't get coltype for type 'TIMESTAMP WITH TIME ZONE' on colname 'FOO_CREATED_DATE'


Attachments: oratimezones.patch

Activity

sqlalchemy-bot

sqlalchemy-bot commented on Jul 28, 2007

@sqlalchemy-bot
CollaboratorAuthor

Changes by Michael Bayer (@zzzeek):

  • set milestone to "0.4.xx"
sqlalchemy-bot

sqlalchemy-bot commented on Dec 27, 2008

@sqlalchemy-bot
CollaboratorAuthor

Michael Bayer (@zzzeek) wrote:

this just raises a warning in 0.4 and 0.5 so is relatively harmless. Adding the type is targeted for post 0.5.0.

sqlalchemy-bot

sqlalchemy-bot commented on Dec 27, 2008

@sqlalchemy-bot
CollaboratorAuthor

Changes by Michael Bayer (@zzzeek):

  • changed milestone from "0.4.xx" to "0.5.xx"
sqlalchemy-bot

sqlalchemy-bot commented on Feb 25, 2010

@sqlalchemy-bot
CollaboratorAuthor

Catherine Devlin (@catherinedevlin) wrote:

TIMESTAMP WITH TIME ZONE support for Oracle + accompanying unittests

sqlalchemy-bot

sqlalchemy-bot commented on Feb 25, 2010

@sqlalchemy-bot
CollaboratorAuthor

Changes by Catherine Devlin (@catherinedevlin):

  • attached file oratimezones.patch
sqlalchemy-bot

sqlalchemy-bot commented on Feb 25, 2010

@sqlalchemy-bot
CollaboratorAuthor

Changes by Michael Bayer (@zzzeek):

  • changed milestone from "0.5.xx" to "0.6.0"
sqlalchemy-bot

sqlalchemy-bot commented on Mar 19, 2010

@sqlalchemy-bot
CollaboratorAuthor

Michael Bayer (@zzzeek) wrote:

cdda68a

sqlalchemy-bot

sqlalchemy-bot commented on Mar 19, 2010

@sqlalchemy-bot
CollaboratorAuthor

Changes by Michael Bayer (@zzzeek):

  • changed status to closed
added this to the 0.6.0 milestone on Nov 27, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't workingoracle

    Type

    No type

    Projects

    No projects

    Relationships

    None yet

      Development

      No branches or pull requests

        Participants

        @sqlalchemy-bot

        Issue actions

          reflection unable to handle oracle TIMESTAMP WITH TIME ZONE · Issue #651 · sqlalchemy/sqlalchemy