Prev
Next
Index->
contents
reference
index
search
external
Up->
dismod_at
database
input
nslist_pair_table
nslist_pair_table.py
nslist_pair_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
.
nslist_pair_table: Example and Test
def nslist_pair_table () :
import dismod_at
import copy
import collections
#
file_name = 'example.db'
new = True
connection = dismod_at. create_connection ( file_name, new)
cursor = connection. cursor ()
#
# create nslist_pair table column names and types
col_name2type = collections. OrderedDict ( [
( 'nslist_id' , 'integer' ),
( 'node_id' , 'integer' ),
( 'smooth_id' , 'integer' )
] )
col_name = list ( col_name2type. keys ())
col_type = list ( col_name2type. values ())
# two lists with different smoothing for each node
row_list = [
# nslist_id, node_id, smooth_id
[ 0 , 0 , 0 ],
[ 0 , 1 , 1 ],
[ 0 , 2 , 2 ],
[ 1 , 0 , 3 ],
[ 1 , 1 , 4 ],
[ 1 , 2 , 5 ]
]
tbl_name = 'nslist_pair'
dismod_at. create_table ( connection, tbl_name, col_name, col_type, row_list)
# ----------------------------------------------------------------------
# include primary key in test
check_name = [ tbl_name + '_id' ] + col_name
check_list = list ()
for i in range ( len ( row_list) ) :
check_list. append ( [ i] + row_list[ i] )
#
row_list = dismod_at. get_row_list ( connection, tbl_name, check_name)
assert row_list == check_list
# ----------------------------------------------------------------------
connection. close ()
print ( 'nslist_pair_table: OK' )
Input File: example/table/nslist_pair_table.py