\(\newcommand{\B}[1]{ {\bf #1} }\) \(\newcommand{\R}[1]{ {\rm #1} }\) \(\newcommand{\W}[1]{ \; #1 \; }\)
create_table.py#
View page sourcecreate_table and Unicode: Example and Test#
def create_table() :
import dismod_at
#
file_name = 'example.db'
connection = dismod_at.create_connection(
file_name, new = True, readonly = False
)
cursor = connection.cursor()
#
inverted_exclamation = chr( 10 * 16 + 1 ) # 00a1
cent_sign = chr( 10 * 16 + 2 ) # 00a2
pound_sign = chr( 10 * 16 + 3 ) # 00a3
#
# create table
col_name = [ 'temp_name' ]
col_type = [ 'text' ]
row_list = [
[ inverted_exclamation ],
[ cent_sign ],
[ pound_sign ]
]
tbl_name = 'temp'
dismod_at.create_table(connection, tbl_name, col_name, col_type, row_list)
#
# check values in table
row_list = list()
cmd = 'SELECT temp_id, temp_name FROM temp'
for row in cursor.execute(cmd) :
row_list.append(row)
#
for i in range( len(row_list) ) :
assert row_list[i][0] == i
#
assert row_list[0][1] == inverted_exclamation
assert row_list[1][1] == cent_sign
assert row_list[2][1] == pound_sign
#
connection.close()
print('create_table: OK')