\(\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')