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