import sqlite3 as base

# create or connect a data base
data_base = base.connect("database.db")

# create a cursor
cursor = data_base.cursor()

cursor.execute("CREATE TABLE IF NOT EXISTS users (first_name text, last_name text, age integer)")
cursor.execute("INSERT INTO users VALUES (:first_name, :last_name, :age)",
               {
                   'first_name': "lee",
                   'last_name': "john",
                   'age':22
               }

               )

cursor.execute("SELECT *, oid FROM users")


#cursor.execute("DELETE from users WHERE oid='0'")
print(cursor.fetchall())


# commit all the changes
data_base.commit()

# close the database
data_base.close()