def updateEntity(entityName, entityTable, entityColumnName):
sqlStr = ('INSERT IGNORE INTO ' + mPTConfig.managerPageTableName +
' (' + mPTConfig.managerPageTableColumns['pageTitle'] +
', ' + mPTConfig.managerPageTableColumns['typeColumn'] + ')' +
' (SELECT DISTINCT ' + entityColumnName + ' AS ' + mPTConfig.managerPageTableColumns['pageTitle'] +
', \'' + entityName + '\' AS ' + mPTConfig.managerPageTableColumns['typeColumn'] +
' FROM ' + entityTable + ' WHERE ' + entityColumnName + ' IS NOT NULL )')
print DBClient.executeQuery(sqlStr, numOfResults=1)
