#!/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))
#!/usr/bin/env python # encoding: utf-8 from simplesqlite import SimpleSQLite import six con = SimpleSQLite("sample.sqlite", "w") con.create_table_with_data( table_name="hoge", attribute_name_list=["attr_a", "attr_b"], data_matrix=[[1, "a"], [2, "b"]]) six.print_(con.get_table_name_list())
#!/usr/bin/env python # encoding: utf-8 from simplesqlite import SimpleSQLite import six con = SimpleSQLite("sample.sqlite", "w", profile=True) 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="sample_table", attribute_name_list=["a", "b", "c", "d", "e"], data_matrix=data_matrix, index_attribute_list=["a"]) for profile in con.get_profile(): six.print_(profile)
#!/usr/bin/env python # encoding: utf-8 from collections import namedtuple from simplesqlite import SimpleSQLite import six table_name = "sample_table" con = SimpleSQLite("sample.sqlite", "w") con.create_table_with_data( table_name, attribute_name_list=["attr_a", "attr_b", "attr_c", "attr_d", "attr_e"], data_matrix=[[1, 1.1, "aaa", 1, 1]]) SampleTuple = namedtuple( "SampleTuple", "attr_a attr_b attr_c attr_d attr_e") con.insert(table_name, insert_record=[7, 7.7, "fff", 7.77, "bar"]) con.insert_many( table_name, insert_record_list=[ (8, 8.8, "ggg", 8.88, "foobar"), SampleTuple(9, 9.9, "ggg", 9.99, "hogehoge"), ] ) result = con.select(select="*", table_name=table_name) for record in result.fetchall(): six.print_(record)
from simplesqlite import SimpleSQLite from simplesqlite.sqlquery import SqlQuery import six table_name = "sample_table" con = SimpleSQLite("sample.sqlite", "w") data_matrix = [ [1, "aaa"], [2, "bbb"], ] con.create_table_with_data( table_name, attribute_name_list=["key", "value"], data_matrix=data_matrix) six.print_("---- before update ----") for record in con.select(select="*", table_name=table_name).fetchall(): six.print_(record) six.print_() con.update( table_name, set_query="value = 'ccc'", where=SqlQuery.make_where(key="key", value=1)) six.print_("---- after update ----") for record in con.select(select="*", table_name=table_name).fetchall(): six.print_(record)