\(\newcommand{\B}[1]{ {\bf #1} }\) \(\newcommand{\R}[1]{ {\rm #1} }\) \(\newcommand{\W}[1]{ \; #1 \; }\)
get_name_type¶
View page sourceGet Column Names and Types in a Table¶
Syntax¶
( col_name , col_type )
=
dismod_at.get_name_type( connection , tbl_name )
connection¶
is a connection for this database.
table_name¶
is a str that specifies the name of the table.
col_name¶
is a list of strings containing the column names in the same order as they appear in the table.
col_type¶
is a list of strings containing the column types in the same order as
the columns appear in the table.
The possible values for the column types are
integer , real , text , or
integer primary key .
Note that the types in the database are converted to lower case before
being returned in col_type .
Primary Key¶
This routine assumes the primary key is an integer, corresponds
to the first column, and has name tbl_name _ id .
Example¶
The file get_name_type.py is an example use of
get_name_type .