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

[Mark Drilling (JIRA)]

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


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