[teiid-issues] [JBoss JIRA] Commented: (TEIID-851) API improvements for custom connector development

[Steven Hawkins (JIRA)]

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

Steven Hawkins commented on TEIID-851:
--------------------------------------

See TEIID-924, which would directly expose all metadata

> API improvements for custom connector development
> -------------------------------------------------
>
>                 Key: TEIID-851
>                 URL: https://jira.jboss.org/jira/browse/TEIID-851
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Connector API
>    Affects Versions: 6.1.0
>            Reporter: Mark Drilling
>            Assignee: Steven Hawkins
>            Priority: Minor
>             Fix For: 7.0
>
>
> I'm building a custom connector, and I was trying to figure out a way to get information on whether or not a certain column in a Source Model is a Primary or Foreign Key.  
> Here's an example of the code I've been trying:
> MetadataID mdID = group.getMetadataID();  //group is an IGroup
> String tableName = metadata.getObject(mdID).getNameInSource();
> However, there doesn't appear to be a way to determine which column is Primary or Foreign Key.
> One thing I did notice playing around with the API, the MetadataObject contains a TableRecordImpl object that contains all sorts of MetaData info.  That class appears to have tons of great info, along with getters and setters, including one called getForeignKeyIDs.  Don't know if there's maybe a reason it's abstracted such that we can't get to it, but being able to get that and the other info out of that object could be highly beneficial.  Maybe this is something that could be added to the API in the future?

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira