java.lang.Object
org.odpi.openmetadata.adapters.connectors.integration.jdbc.transfer.requests.Omas

public class Omas extends Object
Utility class that delegates requests to designated access service
  • Constructor Details

  • Method Details

    • getSchemas

      public List<DatabaseSchemaElement> getSchemas(String databaseGuid)
      Get schemas of database
      Parameters:
      databaseGuid - database guid
      Returns:
      schemas
    • getTables

      public List<DatabaseTableElement> getTables(String assetGuid)
      Get tables
      Parameters:
      assetGuid - database or schema guid
      Returns:
      tables
    • getViews

      public List<DatabaseViewElement> getViews(String assetGuid)
      Get views
      Parameters:
      assetGuid - database or schema guid
      Returns:
      tables
    • getColumns

      public List<DatabaseColumnElement> getColumns(String tableGuid)
      Get columns of table
      Parameters:
      tableGuid - table guid
      Returns:
      columns
    • createEndpoint

      public Optional<String> createEndpoint(EndpointProperties newEndpointProperties)
      Create endpoint
      Parameters:
      newEndpointProperties - properties
      Returns:
      guid
    • createDatabase

      public Optional<String> createDatabase(DatabaseProperties newDatabaseProperties)
      Create database
      Parameters:
      newDatabaseProperties - properties
      Returns:
      guid
    • createSchema

      public Optional<String> createSchema(String databaseGuid, DatabaseSchemaProperties newSchemaProperties)
      Create schema in database
      Parameters:
      databaseGuid - database guid
      newSchemaProperties - properties
      Returns:
      guid
    • createTable

      public Optional<String> createTable(String schemaGuid, DatabaseTableProperties newTableProperties)
      Create table
      Parameters:
      schemaGuid - schema guid
      newTableProperties - properties
      Returns:
      guid
    • createView

      public Optional<String> createView(String parentGuid, DatabaseViewProperties newViewProperties)
      Create view
      Parameters:
      parentGuid - parent guid
      newViewProperties - properties
      Returns:
      guid
    • createColumn

      public Optional<String> createColumn(String tableGuid, DatabaseColumnProperties newColumnProperties)
      Create column in table
      Parameters:
      tableGuid - table guid
      newColumnProperties - properties
      Returns:
      guid
    • removeSchema

      public void removeSchema(DatabaseSchemaElement schemaElement)
      Remove schema
      Parameters:
      schemaElement - schema
    • removeTable

      public void removeTable(DatabaseTableElement tableElement)
      Remove table
      Parameters:
      tableElement - table
    • removeView

      public void removeView(DatabaseViewElement viewElement)
      Remove view
      Parameters:
      viewElement - view
    • removeColumn

      public void removeColumn(DatabaseColumnElement columnElement)
      Remove column
      Parameters:
      columnElement - column
    • updateDatabase

      public void updateDatabase(String databaseGuid, DatabaseProperties databaseProperties)
      Update database
      Parameters:
      databaseGuid - guid
      databaseProperties - properties
    • updateSchema

      public void updateSchema(String schemaGuid, DatabaseSchemaProperties schemaProperties)
      Update schema
      Parameters:
      schemaGuid - guid
      schemaProperties - properties
    • updateTable

      public void updateTable(String tableGuid, DatabaseTableProperties tableProperties)
      Update table
      Parameters:
      tableGuid - guid
      tableProperties - properties
    • updateView

      public void updateView(String viewGuid, DatabaseViewProperties viewProperties)
      Update view
      Parameters:
      viewGuid - guid
      viewProperties - properties
    • updateColumn

      public void updateColumn(String columnGuid, DatabaseColumnProperties columnProperties)
      Update column
      Parameters:
      columnGuid - guid
      columnProperties - properties
    • setPrimaryKey

      public void setPrimaryKey(String columnGuid, DatabasePrimaryKeyProperties primaryKeyProperties)
      Set primary key
      Parameters:
      columnGuid - guid
      primaryKeyProperties - properties
    • removePrimaryKey

      public void removePrimaryKey(String columnGuid)
      Remove primary key
      Parameters:
      columnGuid - guid
    • setForeignKey

      public void setForeignKey(String primaryKeyColumnGuid, String foreignKeyColumnGuid, DatabaseForeignKeyProperties foreignKeyProperties)
      Set foreign key
      Parameters:
      primaryKeyColumnGuid - guid
      foreignKeyColumnGuid - guid
      foreignKeyProperties - properties
    • removeForeignKey

      public void removeForeignKey(String primaryKeyColumnGuid, String foreignKeyColumnGuid)
      Remove foreign key
      Parameters:
      primaryKeyColumnGuid - guid
      foreignKeyColumnGuid - guid
    • getDatabasesByName

      public List<DatabaseElement> getDatabasesByName(String databaseQualifiedName)
      Get databases
      Parameters:
      databaseQualifiedName - qualified name
      Returns:
      databases
    • getConnectorTypesByName

      public List<ConnectorTypeElement> getConnectorTypesByName(String connectorTypeQualifiedName)
      Get connector types by name
      Parameters:
      connectorTypeQualifiedName - qualified name
      Returns:
      connector types
    • getConnectionsByName

      public List<ConnectionElement> getConnectionsByName(String connectionQualifiedName)
      Get connection by name
      Parameters:
      connectionQualifiedName - qualified name
      Returns:
      connections
    • findEndpoints

      public List<EndpointElement> findEndpoints(String searchBy)
      Find endpoints
      Parameters:
      searchBy - criteria
      Returns:
      endpoints
    • findDatabaseColumns

      public List<DatabaseColumnElement> findDatabaseColumns(String searchBy)
      Find columns
      Parameters:
      searchBy - criteria
      Returns:
      columns