Package edu.internet2.middleware.grouper.app.sqlProvisioning

Class SqlProvisionerCommands

java.lang.Object

edu.internet2.middleware.grouper.app.sqlProvisioning.SqlProvisionerCommands

public class SqlProvisionerCommands
extends Object

Constructor Summary

Constructors

Constructor	Description
SqlProvisionerCommands()

Method Summary

Modifier and Type	Method	Description
static void	deleteObjects(List<Object[]> dataToDelete, String dbExternalSystemConfigId, String ownerTableName, List<String> columnNames, String ownerAttributesTableName, String attributesOwnerForeignKeyColumn, String sqlDeletedColumn, boolean deleted, boolean physicallyDelete)	this will delete all attributes for owner and the owner itself
static void	insertObjects(String dbExternalSystemConfigId, String ownerTableName, List<String> columnsToInsertInPrimaryTable, List<Object[]> attributeValuesPrimaryTable)
static List<Object[]>	retrieveObjectsAttributeFilter(String dbExternalSystemConfigId, List<String> columnList, String tableName, String mainTableIdColumnName, String attributeTableName, String attributeForeignKeyColumnName, String attributeTableAttributeNameColumn, String attributeTableAttributeValueColumn, String attributeNameFilter, List<?> attributeValuesFilter, String deletedColumnName, boolean deleted)
static List<Object[]>	retrieveObjectsColumnFilter(String dbExternalSystemConfigId, List<String> columnList, String tableName, List<String> filterColumns0small, List<Object> filterValuesByColumn0small, List<String> filterColumns1large, List<Object> filterValuesByColumn1large, String deletedColumnName, boolean deleted)
static List<Object[]>	retrieveObjectsNoFilter(String dbExternalSystemConfigId, List<String> columnList, String tableName, String sqlDeletedColumn)
static void	updateObjects(String dbExternalSystemConfigId, String tableName, List<String> columnsToUpdate, List<Object[]> valuesToUpdate, List<String> whereClauseColumns, List<Object[]> whereClauseValues)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

SqlProvisionerCommands

public SqlProvisionerCommands()

Method Details

retrieveObjectsAttributeFilter

public static List<Object[]> retrieveObjectsAttributeFilter(String dbExternalSystemConfigId,
 List<String> columnList,
 String tableName,
 String mainTableIdColumnName,
 String attributeTableName,
 String attributeForeignKeyColumnName,
 String attributeTableAttributeNameColumn,
 String attributeTableAttributeValueColumn,
 String attributeNameFilter,
 List<?> attributeValuesFilter,
 String deletedColumnName,
 boolean deleted)

Parameters:

dbExternalSystemConfigId -

columnList -

tableName -

mainTableIdColumnName -

attributeTableName -

attributeForeignKeyColumnName -

attributeTableAttributeNameColumn -

attributeTableAttributeValueColumn -

attributeNameFilter -

attributeValuesFilter -

Returns:

the data

retrieveObjectsColumnFilter

public static List<Object[]> retrieveObjectsColumnFilter(String dbExternalSystemConfigId,
 List<String> columnList,
 String tableName,
 List<String> filterColumns0small,
 List<Object> filterValuesByColumn0small,
 List<String> filterColumns1large,
 List<Object> filterValuesByColumn1large,
 String deletedColumnName,
 boolean deleted)

Parameters:

dbExternalSystemConfigId -

columnList -

tableName -

filterColumns0small - optional filter with number of values less than 100

filterValuesByColumn0small - optional filter with number of values less than 100. If there is more than one column to filter, put each item in an object[]

filterColumns1large - optional filter with values any size

filterValuesByColumn1large - optional filter with values any size. If there is more than one column to filter, put each item in an object[]

Returns:

the data

retrieveObjectsNoFilter

public static List<Object[]> retrieveObjectsNoFilter(String dbExternalSystemConfigId,
 List<String> columnList,
 String tableName,
 String sqlDeletedColumn)

Parameters:

dbExternalSystemConfigId -

columnList -

tableName -

Returns:

the data

deleteObjects

public static void deleteObjects(List<Object[]> dataToDelete,
 String dbExternalSystemConfigId,
 String ownerTableName,
 List<String> columnNames,
 String ownerAttributesTableName,
 String attributesOwnerForeignKeyColumn,
 String sqlDeletedColumn,
 boolean deleted,
 boolean physicallyDelete)

this will delete all attributes for owner and the owner itself

Parameters:

dataToDelete -

dbExternalSystemConfigId -

ownerTableName -

columnNames -

ownerAttributesTableName -

attributesOwnerForeignKeyColumn -

updateObjects

public static void updateObjects(String dbExternalSystemConfigId,
 String tableName,
 List<String> columnsToUpdate,
 List<Object[]> valuesToUpdate,
 List<String> whereClauseColumns,
 List<Object[]> whereClauseValues)

Parameters:

dbExternalSystemConfigId -

tableName -

columnsToUpdate -

valuesToUpdate -

whereClauseColumns -

whereClauseValues -

insertObjects

public static void insertObjects(String dbExternalSystemConfigId,
 String ownerTableName,
 List<String> columnsToInsertInPrimaryTable,
 List<Object[]> attributeValuesPrimaryTable)

Parameters:

dbExternalSystemConfigId -

ownerTableName -

columnsToInsertInPrimaryTable -

attributeValuesPrimaryTable -