def test_normal(self, con):
     table_name = TEST_TABLE_NAME
     where = SqlQuery.make_where("attr_b", 2)
     con.update(
         table_name=table_name, set_query="attr_a = 100", where=where)
     assert con.get_value(
         select="attr_a", table_name=table_name, where=where) == 100

 def test_normal(self, table, set_query, where, expected):
     assert SqlQuery.make_update(table, set_query, where) == expected

 def test_normal(self, value, operation, expected):
     assert SqlQuery.to_attr_str(value, operation) == expected

 def test_exception(self, value, expected):
     with pytest.raises(expected):
         assert SqlQuery.to_table_str(value)

 def test_abnormal(self, value, expected):
     with pytest.raises(expected):
         SqlQuery.sanitize(value)

 def test_exception(self, key, value, expected):
     with pytest.raises(expected):
         SqlQuery.make_where_not_in(key, value)

from simplesqlite import SimpleSQLite
from simplesqlite.sqlquery import SqlQuery


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

data_matrix = [
    [1, "aaa"],
    [2, "bbb"],
]
con.create_table_from_data_matrix(
    table_name,
    attr_name_list=["key", "value"],
    data_matrix=data_matrix)

print("---- before update ----")
for record in con.select(select="*", table_name=table_name).fetchall():
    print(record)
print()

con.update(
    table_name,
    set_query="value = 'ccc'",
    where=SqlQuery.make_where(key="key", value=1))

print("---- after update ----")
for record in con.select(select="*", table_name=table_name).fetchall():
    print(record)