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

get_name_type.py

View page source

get_name_type: Example and Test

#
def get_name_type() :
   import dismod_at
   #
   file_name      = 'example.db'
   connection     = dismod_at.create_connection(
      file_name, new = True, readonly = False
   )
   cursor         = connection.cursor()
   #
   # create temp table
   col_name = [ 'int_name', 'real_name', 'text_name'  ]
   col_type = [ 'integer',  'real',       'text'      ]
   row_list = [
      [ 1,          2.0,          'three'     ]
   ]
   tbl_name = 'temp'
   dismod_at.create_table(connection, tbl_name, col_name, col_type, row_list)
   #
   check_name = [ 'temp_id' ] + col_name
   check_type = [ 'integer primary key'] + col_type
   #
   # get the column names and corresponding types
   (col_name, col_type) = dismod_at.get_name_type(connection, tbl_name)
   #
   assert col_name == check_name
   assert col_type == check_type
   #
   connection.close()
   print('get_name_type: OK')