text: from sqlite_database_interface import SqliteDatabaseInterface
  
  
  db = SqliteDatabaseInterface("test.db")
  
  db.drop_all_tables()
  #db.drop_table("trial")
  
  table_name = "trial"
  record_format = [("id", "integer PRIMARY KEY"), ("name", "text")]
  db.create_table(table_name, record_format)
  record = (1, "JOHN")
  db.insert_record(table_name, record)
  record = (2, "ADAM")
  db.insert_record(table_name, record)
  record = (3, "MIKE")
  db.insert_record(table_name, record)
  print(db.select_values(table_name, [("id", "=", 1)], ["name"]))
  db.update_values(table_name, "ADAM", [("id", "=", 1)], ["name"])
  records = db.select_values(table_name)
  print(db.is_table(table_name, record_format))
  print(db.count_records(table_name))
  