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"))
