def main(): con = SimpleSQLite("sample.sqlite", "w") con.create_table_from_data_matrix("hoge", ["attr_a", "attr_b"], [[1, "a"], [2, "b"]]) print(con.has_table("hoge")) print(con.has_table("not_existing"))
def convert_nb(logger, source_info: "SourceInfo", con: SimpleSQLite, result_logger: ResultLogger, nb) -> Set[str]: changed_table_name_set = set() # type: Set[str] changed_table_name_set |= CellConverter(logger, source_info, con, result_logger, nb.cells).convert() changed_table_name_set |= MetaDataConverter(logger, source_info, con, result_logger, nb.metadata).convert() table_name = KEY_VALUE_TABLE need_create_table = not con.has_table(table_name) kv_records = [[source_info.source_id, key, nb.get(key)] for key in ("nbformat", "nbformat_minor")] if len(kv_records) > 0: con.create_table( table_name, [NbAttrDesc.SOURECE_ID, NbAttrDesc.KEY, NbAttrDesc.VALUE]) con.insert_many(table_name, kv_records) result_logger.logging_success( "{}: {}".format(source_info.base_name, table_name), table_name, need_create_table) changed_table_name_set.add(table_name) con.commit() return changed_table_name_set
#!/usr/bin/env python # encoding: utf-8 from __future__ import print_function from simplesqlite import SimpleSQLite con = SimpleSQLite("sample.sqlite", "w") con.create_table_from_data_matrix("hoge", ["attr_a", "attr_b"], [[1, "a"], [2, "b"]]) print(con.has_table("hoge")) print(con.has_table("not_existing"))
#!/usr/bin/env python # encoding: utf-8 from __future__ import print_function from simplesqlite import SimpleSQLite con = SimpleSQLite("sample.sqlite", "w") con.create_table_from_data_matrix( table_name="hoge", attr_name_list=["attr_a", "attr_b"], data_matrix=[[1, "a"], [2, "b"]]) print(con.has_table("hoge")) print(con.has_table("not_existing"))
#!/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.has_table("hoge")) six.print_(con.has_table("not_existing"))