def test_normal(self, tmpdir, attr_name_list, data_matrix, index_attr_list, expected_attr): p = tmpdir.join("tmp.db") con = SimpleSQLite(str(p), "w") table_name = TEST_TABLE_NAME con.create_table_from_data_matrix(table_name, attr_name_list, data_matrix, index_attr_list) con.commit() # check data --- result = con.select(select=",".join( SqlQuery.to_attr_str_list(attr_name_list)), table_name=table_name) result_matrix = result.fetchall() assert len(result_matrix) == 3 print("expected: {}".format(expected_attr)) print("actual: {}".format(con.get_attr_type(table_name))) assert con.get_attr_type(table_name) == expected_attr
#!/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 __future__ import print_function import json from simplesqlite import SimpleSQLite 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_from_data_matrix( table_name, attr_name_list=["attr_a", "attr_b", "attr_c", "attr_d", "attr_e"], data_matrix=data_matrix) # display values in the table ----- print(con.get_attr_name_list(table_name)) result = con.select(select="*", table_name=table_name) for record in result.fetchall(): print(record) # display data type for each column in the table ----- print(json.dumps(con.get_attr_type(table_name), indent=4))