\(\newcommand{\B}[1]{ {\bf #1} }\) \(\newcommand{\R}[1]{ {\rm #1} }\) \(\newcommand{\W}[1]{ \; #1 \; }\)

replace_table.py

View page source

replace_table: Example and Test

def replace_table() :
    import dismod_at
    #
    file_name      = 'example.db'
    connection     = dismod_at.create_connection(
        file_name, new = True, readonly = False
    )
    cursor         = connection.cursor()
    #
    # create my table
    col_name = [ 'int_name', 'real_name', 'text_name'  ]
    col_type = [ 'integer',  'real',       'text'      ]
    row_list = [
        [ 1,          2.0,          'three'     ]
    ]
    tbl_name = 'my'
    dismod_at.create_table(connection, tbl_name, col_name, col_type, row_list)
    #
    # original table
    my_table = dismod_at.get_table_dict(connection, tbl_name)
    #
    # original values
    assert len(my_table)         == 1
    row = my_table[0]
    assert row['int_name']  == 1
    assert row['real_name'] == 2.0
    assert row['text_name'] == 'three'
    #
    # new row in the table
    row = { 'int_name': 2, 'real_name': 3.0, 'text_name': 'four' }
    my_table.append(row)
    dismod_at.replace_table(connection, tbl_name, my_table)
    #
    # check the new table
    new_table = dismod_at.get_table_dict(connection, 'my')
    assert new_table == my_table
    #
    connection.close()
    print('get_name_type: OK')