public class GcTableSyncTableMetadata extends Object
Constructor and Description |
---|
GcTableSyncTableMetadata() |
Modifier and Type | Method and Description |
---|---|
void |
assignChangeFlagColumn(String changeFlagColumnName) |
void |
assignColumns(String theColumns) |
void |
assignGroupColumn(String groupColumnName) |
void |
assignIncrementalAllCoumnsColumn(String incrementalAllColumnsColumnName) |
void |
assignIncrementalProgressColumn(String incrementalProgressColumnName) |
void |
assignPrimaryKeyColumns(String theColumns) |
String |
columnListAll()
get comma separated list of all columns
|
String |
columnListInputtedColumnsAndIncrementalProgressColumn(List<GcTableSyncColumnMetadata> otherTablePrimaryKey)
get comma separated list of primary key and change flag
|
String |
columnListPrimaryKeyAndChangeFlagAndOptionalIncrementalProgress()
get comma separated list of primary key and change flag, and optional incremental change column
|
GcTableSyncColumnMetadata |
getChangeFlagColumn()
if full sync with change flag this is the column
|
List<GcTableSyncColumnMetadata> |
getColumnMetadata()
columns in table
|
List<GcTableSyncColumnMetadata> |
getColumns()
mtadata for columns synced
|
String |
getConnectionName() |
String |
getConnectionNameOrReadonly()
database connection name or readonly
|
GcTableSyncColumnMetadata |
getGroupColumnMetadata()
get group column metadata
|
GcTableSyncColumnMetadata |
getIncrementalAllCoumnsColumn()
column in FROM table which has incrementing timestamp or integer
|
GcTableSyncColumnMetadata |
getIncrementalProgressColumn()
column in progress table which increments as integer or timestamp
|
String |
getMetadataQuery() |
List<GcTableSyncColumnMetadata> |
getNonPrimaryKey()
non primary key col(s), lazy loaded
|
List<GcTableSyncColumnMetadata> |
getPrimaryKey()
primary key col(s), lazy loaded
|
String |
getTableName() |
GcTableSyncColumnMetadata |
lookupColumn(String columnName,
boolean exceptionOnNotFound)
lookup a column by name (case insensitive)
|
List<GcTableSyncColumnMetadata> |
lookupColumns(String columnNames)
find metadata for columns
|
String |
queryUpdateNonPrimaryKey()
append the nonprimary key update clause
|
String |
queryWherePrimaryKey()
append the primary key where clause
|
static GcTableSyncTableMetadata |
retrieveQueryMetadataFromDatabase(String theConnectionName,
String query)
get metadata for table
|
static GcTableSyncTableMetadata |
retrieveQueryMetadataFromDatabase(String theConnectionName,
String query,
List<Object> bindVars)
get metadata for table
|
static GcTableSyncTableMetadata |
retrieveTableMetadataFromCacheOrDatabase(String connectionName,
String tableName)
get metadata for table
|
static GcTableSyncTableMetadata |
retrieveTableMetadataFromDatabase(String theConnectionName,
String tableName)
get metadata for table
|
void |
setChangeFlagColumn(GcTableSyncColumnMetadata changeFlagColumn1)
if full sync with change flag this is the column
|
void |
setColumnMetadata(List<GcTableSyncColumnMetadata> columnMetadata1)
columns in table
|
void |
setColumns(List<GcTableSyncColumnMetadata> columns1)
mtadata for columns synced
|
void |
setConnectionName(String connectionName) |
void |
setConnectionNameOrReadonly(String connectionNameOrReadonly1)
database connection name or readonly
|
void |
setIncrementalAllCoumnsColumn(GcTableSyncColumnMetadata incrementalAllCoumnsColumn1)
column in FROM table which has incrementing timestamp or integer
|
void |
setIncrementalProgressColumn(GcTableSyncColumnMetadata incrementalProgressColumn1)
column in progress table which increments as integer or timestamp
|
void |
setTableName(String tableName) |
public String queryWherePrimaryKey()
sql
- public String queryUpdateNonPrimaryKey()
sql
- public GcTableSyncColumnMetadata getIncrementalProgressColumn()
public void setIncrementalProgressColumn(GcTableSyncColumnMetadata incrementalProgressColumn1)
incrementalProgressColumn1
- public void assignIncrementalProgressColumn(String incrementalProgressColumnName)
incrementalProgressColumnName
- public List<GcTableSyncColumnMetadata> lookupColumns(String columnNames)
columnNames
- public GcTableSyncColumnMetadata lookupColumn(String columnName, boolean exceptionOnNotFound)
columnName
- exceptionOnNotFound
- public static GcTableSyncTableMetadata retrieveTableMetadataFromCacheOrDatabase(String connectionName, String tableName)
connectionName
- tableName
- public static GcTableSyncTableMetadata retrieveTableMetadataFromDatabase(String theConnectionName, String tableName)
theConnectionName
- tableName
- public static GcTableSyncTableMetadata retrieveQueryMetadataFromDatabase(String theConnectionName, String query)
theConnectionName
- tableName
- public static GcTableSyncTableMetadata retrieveQueryMetadataFromDatabase(String theConnectionName, String query, List<Object> bindVars)
theConnectionName
- tableName
- public String getMetadataQuery()
public String getConnectionName()
public void setConnectionName(String connectionName)
connectionName
- the connectionName to setpublic String getTableName()
public void setTableName(String tableName)
tableName
- the tableName to setpublic String getConnectionNameOrReadonly()
public void setConnectionNameOrReadonly(String connectionNameOrReadonly1)
connectionNameOrReadonly1
- public GcTableSyncColumnMetadata getIncrementalAllCoumnsColumn()
public void setIncrementalAllCoumnsColumn(GcTableSyncColumnMetadata incrementalAllCoumnsColumn1)
incrementalAllCoumnsColumn1
- public GcTableSyncColumnMetadata getChangeFlagColumn()
public void setChangeFlagColumn(GcTableSyncColumnMetadata changeFlagColumn1)
changeFlagColumn1
- public List<GcTableSyncColumnMetadata> getColumnMetadata()
public void setColumnMetadata(List<GcTableSyncColumnMetadata> columnMetadata1)
columnMetadata1
- the columnMetadata to setpublic void assignPrimaryKeyColumns(String theColumns)
theColumns
- could be * or list of columnspublic List<GcTableSyncColumnMetadata> getColumns()
public List<GcTableSyncColumnMetadata> getNonPrimaryKey()
public List<GcTableSyncColumnMetadata> getPrimaryKey()
public void assignColumns(String theColumns)
theColumns
- could be * or list of columnspublic String columnListAll()
public String columnListPrimaryKeyAndChangeFlagAndOptionalIncrementalProgress()
public String columnListInputtedColumnsAndIncrementalProgressColumn(List<GcTableSyncColumnMetadata> otherTablePrimaryKey)
public void setColumns(List<GcTableSyncColumnMetadata> columns1)
columns1
- the columns to setpublic void assignGroupColumn(String groupColumnName)
groupColumnName
- public void assignChangeFlagColumn(String changeFlagColumnName)
changeFlagColumnName
- public GcTableSyncColumnMetadata getGroupColumnMetadata()
public void assignIncrementalAllCoumnsColumn(String incrementalAllColumnsColumnName)
incrementalAllColumnsColumnName
- Copyright © 2016 Internet2. All rights reserved.