Python SimpleSQLite.get_attribute_name_list示例

示例#1

文件： sample_create_table_nested_list.py 项目： kustomzone/SimpleSQLite

#!/usr/bin/env python
# encoding: utf-8


import json
from simplesqlite import SimpleSQLite
import six

table_name = "sample_table"
con = SimpleSQLite("sample.sqlite", "w")

# create table -----
data_matrix = [
    [1, 1.1, "aaa", 1,   1],
    [2, 2.2, "bbb", 2.2, 2.2],
    [3, 3.3, "ccc", 3,   "ccc"],
]
con.create_table_with_data(
    table_name,
    attribute_name_list=["attr_a", "attr_b", "attr_c", "attr_d", "attr_e"],
    data_matrix=data_matrix)

# display values in the table -----
six.print_(con.get_attribute_name_list(table_name))
result = con.select(select="*", table_name=table_name)
for record in result.fetchall():
    six.print_(record)

# display data type for each column in the table -----
six.print_(json.dumps(con.get_attr_type(table_name), indent=4))

示例#2

文件： sample_get_attribute_name_list.py 项目： furikake/SimpleSQLite

#!/usr/bin/env python
# encoding: utf-8


from simplesqlite import SimpleSQLite, TableNotFoundError
import six


table_name = "sample_table"
con = SimpleSQLite("sample.sqlite", "w")
con.create_table_with_data(
    table_name=table_name,
    attribute_name_list=["attr_a", "attr_b"],
    data_matrix=[[1, "a"], [2, "b"]])

six.print_(con.get_attribute_name_list(table_name))

try:
    six.print_(con.get_attribute_name_list("not_existing"))
except TableNotFoundError as e:
    six.print_(e)