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)
def setUpdateSuccess(entityId):
sqlStr = ('UPDATE ' + mPTConfig.managerPageTableName + ' SET ' +
mPTConfig.managerPageTableColumns['needsUpdate'] + ' = 0 WHERE ' +
mPTConfig.managerPageTableColumns['pageTitle'] + ' = %s')
print DBClient.directExeQuery(sqlStr, entityId)
