Exemplos de insert_rows em Python

Exemplo n.º 1

Arquivo: NDDdb_py_modules.py Projeto: budsonjelmont/ndddb_examples

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

Exemplo n.º 2

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

Exemplo n.º 3

Arquivo: NDDdb_py_modules.py Projeto: budsonjelmont/ndddb_examples

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

Exemplo n.º 4

Arquivo: query_examples.py Projeto: LabKey/labkey-api-python

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