GcTableSync (Grouper Client 2.4.0-SNAPSHOT Java API.)

java.lang.Object
- edu.internet2.middleware.grouperClient.jdbc.tableSync.GcTableSync

```
public class GcTableSync
extends Object
```
sync a table

Constructor Summary

Constructors
Constructor and Description

GcTableSync()

Constructors
Constructor and Description
`GcTableSync()`

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`void`	`configureTableSync()`
`GcTableSyncOutput`	`fullSync()`
`String`	`getDatabaseFrom()` database from key
`String`	`getDatabaseTo()` database to key
`GcTableSyncTableData`	`getFromData()` data in the from table
`List<Object>`	`getFromGroupingUniqueValues()` grouping unique vals from source
`int`	`getFullSyncHourEnd()` grouperClient.syncTable.personSource.fullSyncHourEnd = 4
`int`	`getFullSyncHourStart()` grouperClient.syncTable.personSource.fullSyncHourStart = 3
`int`	`getGroupingSize()`
`String`	`getKey()` key in config that points to this instance of table sync
`String`	`getRealTimeSchema()` schema where real time table is.
`String`	`getRealTimeTable()` table where real time primary key and last_updated col is
`String`	`getStatusDatabase()`
`String`	`getStatusSchema()` grouperClient.syncTable.personSource.statusSchema =
`String`	`getStatusTable()` grouperClient.syncTable.personSource.statusTable = grouper_chance_log_consumer
`GcTableSyncTableMetadata`	`getTableMetadata()`
`GcTableSyncTableData`	`getToData()` data in the to table
`Set<Object>`	`getToGroupingUniqueValues()` grouping unique vals to source
`GcTableSyncOutput`	`incrementalSync()`
`void`	`logPeriodically(Map<String,Object> debugMap)` log periodically
`static void`	`main(String[] args)`
`void`	`processDatabaseColumnMetadata()`
`void`	`retrieveDataBatchFromDb(String dbName, List<Object> bindVars, String sql, List<GcTableSyncRowData> dataReturnedHere, GcTableSyncTableData gcTableSyncTableData)`
`void`	`selectStuffTest()`
`void`	`setDatabaseFrom(String databaseFrom1)` database from key
`void`	`setDatabaseTo(String databaseTo1)` database to key
`void`	`setFromData(GcTableSyncTableData fromData1)` data in the from table
`void`	`setFromGroupingUniqueValues(List<Object> fromGroupingUniqueValues1)` grouping unique vals from source
`void`	`setFullSyncHourEnd(int fullSyncHourEnd1)`
`void`	`setFullSyncHourStart(int fullSyncHourStart1)` grouperClient.syncTable.personSource.fullSyncHourStart = 3
`void`	`setGroupingSize(int groupingSize1)`
`void`	`setKey(String key1)` key in config that points to this instance of table sync
`void`	`setRealTimeSchema(String realTimeSchema1)` schema where real time table is.
`void`	`setRealTimeTable(String realTimeTable1)` table where real time primary key and last_updated col is
`void`	`setStatusDatabase(String statusDatabase1)` grouperClient.syncTable.personSource.statusDatabase = awsDev
`void`	`setStatusSchema(String statusSchema1)` grouperClient.syncTable.personSource.statusSchema =
`void`	`setStatusTable(String statusTable1)` grouperClient.syncTable.personSource.statusTable = grouper_chance_log_consumer
`void`	`setTableMetadata(GcTableSyncTableMetadata tableMetadata1)`
`void`	`setToData(GcTableSyncTableData toData1)` data in the to table
`void`	`setToGroupingUniqueValues(Set<Object> toGroupingUniqueValues1)` grouping unique vals to source
`void`	`sqlBatchAdd(Map<String,List<List<Object>>> sqlBatch, String sql, List<Object> args)` sql batch add
`List<Integer>`	`sqlBatchExecute(Map<String,List<List<Object>>> sqlBatch, String sqlPrefix, Map<String,Object> debugMap)` execute a batch, return the count
`void`	`statusAssignLastUpdated(String type, long lastUpdated)`
`boolean`	`statusIsFullRunning(Map<String,Object> debugMap)`
`Long`	`statusRetrieveLastUpdated(String type)` type is

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Constructor Detail
  - GcTableSync
```
public GcTableSync()
```
- Method Detail
  - getKey
```
public String getKey()
```
    key in config that points to this instance of table sync
    
    Returns:
    
    the key
  - setKey
```
public void setKey(String key1)
```
    key in config that points to this instance of table sync
    
    Parameters:
    
    key1 - the key to set
  - getTableMetadata
```
public GcTableSyncTableMetadata getTableMetadata()
```
    Returns:
    
    the tableMetadata
  - setTableMetadata
```
public void setTableMetadata(GcTableSyncTableMetadata tableMetadata1)
```
    Parameters:
    
    tableMetadata1 - the tableMetadata to set
  - getFromData
```
public GcTableSyncTableData getFromData()
```
    data in the from table
    
    Returns:
    
    the fromData
  - setFromData
```
public void setFromData(GcTableSyncTableData fromData1)
```
    data in the from table
    
    Parameters:
    
    fromData1 - the fromData to set
  - getToData
```
public GcTableSyncTableData getToData()
```
    data in the to table
    
    Returns:
    
    the toData
  - setToData
```
public void setToData(GcTableSyncTableData toData1)
```
    data in the to table
    
    Parameters:
    
    toData1 - the toData to set
  - statusIsFullRunning
```
public boolean statusIsFullRunning(Map<String,Object> debugMap)
```
    Parameters:
    
    debugMap -
    
    Returns:
    
    true if running, false if not
  - incrementalSync
```
public GcTableSyncOutput incrementalSync()
```
    Returns:
    
    the output
  - statusRetrieveLastUpdated
```
public Long statusRetrieveLastUpdated(String type)
```
    type is
    
    Parameters:
    
    type - full or incremental
    
    Returns:
    
    the last updated for a status
  - statusAssignLastUpdated
```
public void statusAssignLastUpdated(String type,
                                    long lastUpdated)
```
    Parameters:
    
    type -
    
    lastUpdated -
  - fullSync
```
public GcTableSyncOutput fullSync()
```
    Returns:
    
    the output
  - logPeriodically
```
public void logPeriodically(Map<String,Object> debugMap)
```
    log periodically
    
    Parameters:
    
    debugMap -
  - retrieveDataBatchFromDb
```
public void retrieveDataBatchFromDb(String dbName,
                                    List<Object> bindVars,
                                    String sql,
                                    List<GcTableSyncRowData> dataReturnedHere,
                                    GcTableSyncTableData gcTableSyncTableData)
```
    Parameters:
    
    dbName -
    
    bindVars -
    
    sql -
    
    dataReturnedHere -
    
    gcTableSyncTableData -
  - configureTableSync
```
public void configureTableSync()
```
  - getRealTimeSchema
```
public String getRealTimeSchema()
```
    schema where real time table is. blank for the FROM schema grouperClient.syncTable.personSource.realTimeSchema =
    
    Returns:
    
    the realTimeSchema
  - setRealTimeSchema
```
public void setRealTimeSchema(String realTimeSchema1)
```
    schema where real time table is. blank for the FROM schema grouperClient.syncTable.personSource.realTimeSchema =
    
    Parameters:
    
    realTimeSchema1 - the realTimeSchema to set
  - getRealTimeTable
```
public String getRealTimeTable()
```
    table where real time primary key and last_updated col is
    
    Returns:
    
    the realTimeTable
  - setRealTimeTable
```
public void setRealTimeTable(String realTimeTable1)
```
    table where real time primary key and last_updated col is
    
    Parameters:
    
    realTimeTable1 - the realTimeTable to set
  - getStatusDatabase
```
public String getStatusDatabase()
```
    Returns:
    
    the statusDatabase
  - setStatusDatabase
```
public void setStatusDatabase(String statusDatabase1)
```
    grouperClient.syncTable.personSource.statusDatabase = awsDev
    
    Parameters:
    
    statusDatabase1 - the statusDatabase to set
  - getStatusSchema
```
public String getStatusSchema()
```
    grouperClient.syncTable.personSource.statusSchema =
    
    Returns:
    
    the statusSchema
  - setStatusSchema
```
public void setStatusSchema(String statusSchema1)
```
    grouperClient.syncTable.personSource.statusSchema =
    
    Parameters:
    
    statusSchema1 - the statusSchema to set
  - getStatusTable
```
public String getStatusTable()
```
    grouperClient.syncTable.personSource.statusTable = grouper_chance_log_consumer
    
    Returns:
    
    the statusTable
  - setStatusTable
```
public void setStatusTable(String statusTable1)
```
    grouperClient.syncTable.personSource.statusTable = grouper_chance_log_consumer
    
    Parameters:
    
    statusTable1 - the statusTable to set
  - getFullSyncHourStart
```
public int getFullSyncHourStart()
```
    grouperClient.syncTable.personSource.fullSyncHourStart = 3
    
    Returns:
    
    the fullSyncHourStart
  - setFullSyncHourStart
```
public void setFullSyncHourStart(int fullSyncHourStart1)
```
    grouperClient.syncTable.personSource.fullSyncHourStart = 3
    
    Parameters:
    
    fullSyncHourStart1 - the fullSyncHourStart to set
  - getFullSyncHourEnd
```
public int getFullSyncHourEnd()
```
    grouperClient.syncTable.personSource.fullSyncHourEnd = 4
    
    Returns:
    
    the fullSyncHourEnd
  - setFullSyncHourEnd
```
public void setFullSyncHourEnd(int fullSyncHourEnd1)
```
    Parameters:
    
    fullSyncHourEnd1 - the fullSyncHourEnd to set
  - getFromGroupingUniqueValues
```
public List<Object> getFromGroupingUniqueValues()
```
    grouping unique vals from source
    
    Returns:
    
    the fromGroupingUniqueValues
  - setFromGroupingUniqueValues
```
public void setFromGroupingUniqueValues(List<Object> fromGroupingUniqueValues1)
```
    grouping unique vals from source
    
    Parameters:
    
    fromGroupingUniqueValues1 - the fromGroupingUniqueValues to set
  - getToGroupingUniqueValues
```
public Set<Object> getToGroupingUniqueValues()
```
    grouping unique vals to source
    
    Returns:
    
    the toGroupingUniqueValues
  - setToGroupingUniqueValues
```
public void setToGroupingUniqueValues(Set<Object> toGroupingUniqueValues1)
```
    grouping unique vals to source
    
    Parameters:
    
    toGroupingUniqueValues1 - the toGroupingUniqueValues to set
  - processDatabaseColumnMetadata
```
public void processDatabaseColumnMetadata()
```
  - sqlBatchAdd
```
public void sqlBatchAdd(Map<String,List<List<Object>>> sqlBatch,
                        String sql,
                        List<Object> args)
```
    sql batch add
    
    Parameters:
    
    sqlBatch -
    
    sql -
    
    args -
  - sqlBatchExecute
```
public List<Integer> sqlBatchExecute(Map<String,List<List<Object>>> sqlBatch,
                                     String sqlPrefix,
                                     Map<String,Object> debugMap)
```
    execute a batch, return the count
    
    Parameters:
    
    sqlBatch -
    
    sqlPrefix - if we only want to run a certain prefix
    
    debugMap -
    
    Returns:
    
    the count
  - getDatabaseTo
```
public String getDatabaseTo()
```
    database to key
    
    Returns:
    
    the databaseTo
  - setDatabaseTo
```
public void setDatabaseTo(String databaseTo1)
```
    database to key
    
    Parameters:
    
    databaseTo1 - the databaseTo to set
  - getDatabaseFrom
```
public String getDatabaseFrom()
```
    database from key
    
    Returns:
    
    the databaseFrom
  - setDatabaseFrom
```
public void setDatabaseFrom(String databaseFrom1)
```
    database from key
    
    Parameters:
    
    databaseFrom1 - the databaseFrom to set
  - getGroupingSize
```
public int getGroupingSize()
```
    Returns:
    
    the groupingSize
  - setGroupingSize
```
public void setGroupingSize(int groupingSize1)
```
    Parameters:
    
    groupingSize1 - the groupingSize to set
  - main
```
public static void main(String[] args)
```
    Parameters:
    
    args -
  - selectStuffTest
```
public void selectStuffTest()
```

Class GcTableSync

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Constructor Detail

GcTableSync

Method Detail

getKey

setKey

getTableMetadata

setTableMetadata

getFromData

setFromData

getToData

setToData

statusIsFullRunning

incrementalSync

statusRetrieveLastUpdated

statusAssignLastUpdated

fullSync

logPeriodically

retrieveDataBatchFromDb

configureTableSync

getRealTimeSchema

setRealTimeSchema

getRealTimeTable

setRealTimeTable

getStatusDatabase

setStatusDatabase

getStatusSchema

setStatusSchema

getStatusTable

setStatusTable

getFullSyncHourStart

setFullSyncHourStart

getFullSyncHourEnd

setFullSyncHourEnd

getFromGroupingUniqueValues

setFromGroupingUniqueValues

getToGroupingUniqueValues

setToGroupingUniqueValues

processDatabaseColumnMetadata

sqlBatchAdd

sqlBatchExecute

getDatabaseTo

setDatabaseTo

getDatabaseFrom

setDatabaseFrom

getGroupingSize

setGroupingSize

main

selectStuffTest