Prev Next replace_table.py

@(@\newcommand{\B}[1]{ {\bf #1} } \newcommand{\R}[1]{ {\rm #1} } \newcommand{\W}[1]{ \; #1 \; }@)@ This is dismod_at-20221105 documentation: Here is a link to its current documentation .
replace_table: Example and Test

def replace_table() :
   import dismod_at
   #
   file_name      = 'example.db'
   new            = True
   connection     = dismod_at.create_connection(file_name, new)
   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')
Input File: example/table/replace_table.py