[teiid-issues] [JBoss JIRA] (TEIID-4578) Create SqlAlchemy Dialect for Teiid

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-4578?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13379064#comment-13379064 ] 

Steven Hawkins commented on TEIID-4578:
---------------------------------------

The sqlalchemy wrapper is just adjusting the version detection.  If we move past that issue for now, then there are issues depending upon what functionality of sqlalchemy is accessed.  Here's a list of methods with missing server side functionality:

has_table
-pg_table_is_visible

has_type
-pg_type_is_visible

get_foreign_keys
-pg_get_constraintdef

_load_domains
-format_type

With that, most of the usage that I can see would then be error free - but of course sequences and other concepts that we don't directly support won't work.

> Create SqlAlchemy Dialect for Teiid
> -----------------------------------
>
>                 Key: TEIID-4578
>                 URL: https://issues.jboss.org/browse/TEIID-4578
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Misc. Connectors, Tooling
>    Affects Versions: 9.1.1
>            Reporter: Salvatore Incandela
>            Assignee: Steven Hawkins
>             Fix For: Open To Community, 9.3
>
>
> Create SqlAlchemy Dialect for Teiid
> http://www.sqlalchemy.org/
> http://docs.sqlalchemy.org/en/latest/dialects/



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)