def LKupdateinsertRow(rcrd, query, schema, sc): try: updateres = update_rows(sc, schema, query, [rcrd.to_dict()]) except labkey.exceptions.QueryNotFoundError: print('Update failed for record: ' + rcrd.index) try: insertres = insert_rows(sc, schema, query, [rcrd.to_dict()]) except labkey.exceptions.RequestError: print('ERROR: Could not insert/update ' + query + ' data for subject ' + str(rcrd['SubjectID'])) return
updateResult = update_rows(server_context, schema, table, [originalValue]) print('update_rows: reset value [ ' + updateResult['rows'][0][column3] + ' ]') ################### # Test insert_rows & delete_rows ################### testRow = copy.copy(originalValue) testRow['Key'] = None testRow['Country'] = 'Antarctica' all_rows = select_rows(server_context, schema, table) print('Insert Rows: Initials row count [ ' + str(all_rows['rowCount']) + ' ]') insertResult = insert_rows(server_context, schema, table, [testRow]) print('Insert Rows: New rowId [ ' + str(insertResult['rows'][0]['Key']) + ' ]') all_rows = select_rows(server_context, schema, table) print('Insert Rows: after row count [ ' + str(all_rows['rowCount']) + ' ]') testRow = insertResult['rows'][0] deleteResult = delete_rows(server_context, schema, table, [testRow]) print('Delete Rows: deleted rowId [ ' + str(deleteResult['rows'][0]['Key']) + ' ]') all_rows = select_rows(server_context, schema, table) print('Delete Rows: after row count [ ' + str(all_rows['rowCount']) + ' ]') ################### # Test execute_sql
def LKinsertRow(rcrd, query, schema, sc): try: insertres = insert_rows(sc, schema, query, [rcrd.to_dict()]) except labkey.exceptions.RequestError: print('Insert failed for record: ' + rcrd.index) return