Package edu.internet2.middleware.grouperClient.jdbc.tableSync

Class GcTableSyncTableMetadata

java.lang.Object
edu.internet2.middleware.grouperClient.jdbc.tableSync.GcTableSyncTableMetadata
public class GcTableSyncTableMetadata extends Object
metadata for connection name and table name

  • Constructor Details

    • GcTableSyncTableMetadata

      public GcTableSyncTableMetadata()

  • Method Details

    • quoteForColumnsInSql

      public String quoteForColumnsInSql()

    • quoteStrings

      public String quoteStrings(String columns)
      input: a,b,c output: "a","b","c"
      Parameters:
      columns -
      Returns:

    • queryWherePrimaryKey

      public String queryWherePrimaryKey()
      append the primary key where clause
      Parameters:
      sql -

    • queryUpdateNonPrimaryKey

      public String queryUpdateNonPrimaryKey()
      append the nonprimary key update clause
      Parameters:
      sql -

    • getIncrementalProgressColumn

      public GcTableSyncColumnMetadata getIncrementalProgressColumn()
      column in progress table which increments as integer or timestamp
      Returns:
      column

    • setIncrementalProgressColumn

      public void setIncrementalProgressColumn(GcTableSyncColumnMetadata incrementalProgressColumn1)
      column in progress table which increments as integer or timestamp
      Parameters:
      incrementalProgressColumn1 -

    • assignIncrementalProgressColumn

      public void assignIncrementalProgressColumn(String incrementalProgressColumnName)
      Parameters:
      incrementalProgressColumnName -

    • lookupColumns

      public List<GcTableSyncColumnMetadata> lookupColumns(String columnNames)
      find metadata for columns
      Parameters:
      columnNames -
      Returns:
      the list of columns

    • lookupColumn

      public GcTableSyncColumnMetadata lookupColumn(String columnName, boolean exceptionOnNotFound)
      lookup a column by name (case insensitive)
      Parameters:
      columnName -
      exceptionOnNotFound -
      Returns:
      the column metadata

    • retrieveTableMetadataFromCacheOrDatabase

      public static GcTableSyncTableMetadata retrieveTableMetadataFromCacheOrDatabase(String connectionName, String tableName)
      get metadata for table
      Parameters:
      connectionName -
      tableName -
      Returns:
      the metadata for a connection, table, and query

    • retrieveQueryMetadataFromCacheOrDatabase

      public static GcTableSyncTableMetadata retrieveQueryMetadataFromCacheOrDatabase(String connectionName, String query)
      get metadata for table
      Parameters:
      connectionName -
      query -
      Returns:
      the metadata for a connection, table, and query

    • retrieveTableMetadataFromDatabase

      public static GcTableSyncTableMetadata retrieveTableMetadataFromDatabase(String theConnectionName, String tableName)
      get metadata for table
      Parameters:
      theConnectionName -
      tableName -
      Returns:
      the metadata for a connection, table, and query

    • retrieveQueryMetadataFromDatabase

      public static GcTableSyncTableMetadata retrieveQueryMetadataFromDatabase(String theConnectionName, String query)
      get metadata for table
      Parameters:
      theConnectionName -
      tableName -
      Returns:
      the metadata for a connection, table, and query

    • retrieveQueryMetadataFromDatabase

      public static GcTableSyncTableMetadata retrieveQueryMetadataFromDatabase(String theConnectionName, String query, List<Object> bindVars)
      get metadata for table
      Parameters:
      theConnectionName -
      tableName -
      Returns:
      the metadata for a connection, table, and query

    • getMetadataQuery

      public String getMetadataQuery()

    • getConnectionName

      public String getConnectionName()
      Returns:
      the connectionName

    • setConnectionName

      public void setConnectionName(String connectionName)
      Parameters:
      connectionName - the connectionName to set

    • getTableName

      public String getTableName()
      Returns:
      the tableName

    • setTableName

      public void setTableName(String tableName)
      Parameters:
      tableName - the tableName to set

    • getConnectionNameOrReadonly

      public String getConnectionNameOrReadonly()
      database connection name or readonly
      Returns:
      connection name

    • setConnectionNameOrReadonly

      public void setConnectionNameOrReadonly(String connectionNameOrReadonly1)
      database connection name or readonly
      Parameters:
      connectionNameOrReadonly1 -

    • getIncrementalAllCoumnsColumn

      public GcTableSyncColumnMetadata getIncrementalAllCoumnsColumn()
      column in FROM table which has incrementing timestamp or integer
      Returns:
      metadata

    • setIncrementalAllCoumnsColumn

      public void setIncrementalAllCoumnsColumn(GcTableSyncColumnMetadata incrementalAllCoumnsColumn1)
      column in FROM table which has incrementing timestamp or integer
      Parameters:
      incrementalAllCoumnsColumn1 -

    • getChangeFlagColumn

      public GcTableSyncColumnMetadata getChangeFlagColumn()
      if full sync with change flag this is the column
      Returns:
      change flag

    • setChangeFlagColumn

      public void setChangeFlagColumn(GcTableSyncColumnMetadata changeFlagColumn1)
      if full sync with change flag this is the column
      Parameters:
      changeFlagColumn1 -

    • getColumnMetadata

      public List<GcTableSyncColumnMetadata> getColumnMetadata()
      columns in table
      Returns:
      the columnMetadata

    • retrieveColumnMetadataOrdered

      public List<GcTableSyncColumnMetadata> retrieveColumnMetadataOrdered()
      columns in table
      Returns:
      the columnMetadata

    • setColumnMetadata

      public void setColumnMetadata(List<GcTableSyncColumnMetadata> columnMetadata1)
      columns in table
      Parameters:
      columnMetadata1 - the columnMetadata to set

    • assignPrimaryKeyColumns

      public void assignPrimaryKeyColumns(String theColumns)
      Parameters:
      theColumns - could be * or list of columns

    • getColumns

      public List<GcTableSyncColumnMetadata> getColumns()
      mtadata for columns synced
      Returns:
      the columns

    • getNonPrimaryKey

      public List<GcTableSyncColumnMetadata> getNonPrimaryKey()
      non primary key col(s), lazy loaded
      Returns:
      the primary key

    • getPrimaryKey

      public List<GcTableSyncColumnMetadata> getPrimaryKey()
      primary key col(s), lazy loaded
      Returns:
      the primary key

    • assignColumns

      public void assignColumns(String theColumns)
      Parameters:
      theColumns - could be * or list of columns

    • columnListAll

      public String columnListAll()
      get comma separated list of all columns
      Returns:
      the columns

    • columnListAllQuoted

      public String columnListAllQuoted()
      get comma separated list of all columns
      Returns:
      the columns

    • columnListPrimaryKeyAndChangeFlagAndOptionalIncrementalProgress

      public String columnListPrimaryKeyAndChangeFlagAndOptionalIncrementalProgress()
      get comma separated list of primary key and change flag, and optional incremental change column
      Returns:
      the columns

    • columnListInputtedColumnsAndIncrementalProgressColumn

      public String columnListInputtedColumnsAndIncrementalProgressColumn(List<GcTableSyncColumnMetadata> otherTablePrimaryKey)
      get comma separated list of primary key and change flag
      Returns:
      the columns

    • setColumns

      public void setColumns(List<GcTableSyncColumnMetadata> columns1)
      mtadata for columns synced
      Parameters:
      columns1 - the columns to set

    • assignGroupColumn

      public void assignGroupColumn(String groupColumnName)
      Parameters:
      groupColumnName -

    • assignChangeFlagColumn

      public void assignChangeFlagColumn(String changeFlagColumnName)
      Parameters:
      changeFlagColumnName -

    • getGroupColumnMetadata

      public GcTableSyncColumnMetadata getGroupColumnMetadata()
      get group column metadata
      Returns:
      the metadata

    • assignIncrementalAllCoumnsColumn

      public void assignIncrementalAllCoumnsColumn(String incrementalAllColumnsColumnName)
      Parameters:
      incrementalAllColumnsColumnName -