sqlite_db.py

# sqlite is a simple local DB
# connecting/creating to/a local sqlite database

import sqlite3

# if DB exists, it connects to it;
# if DB doesn't exist, it will be created
connection = sqlite3.connect('mydbname.db')

cursor = connection.cursor()

# chose the column names and data type for each
cursor.execute('''CREATE TABLE IF NOT EXISTS mytablename
	(col1 type1, col2 type2, col3 type3)''')

connection.commit()
connection.close()

# when you create the table, it would be best to have an autoincrementing primary key id
# use this for col1 type1 : id INTEGER PRIMARY KEY AUTOINCREMENT

-------------------------
## Additional commands (place them between curosr and connection.comit()
## Most commands must be run only once (so cursor + code + commit&close, save file and run)
## e.g. if you run insert multiple times, you'll just get duplicates (to automate you could use an if already exists)

# Insert (manual) values into table (text and data need ' ' )
 cursor.execute("INSERT INTO mytablename VALUES ('Value1', 'Value2', 'Value3')")
  
# Insert (manual) multiple values at once into table
# declare a list of values, create a variable with it, insert it with ??? (for security purposes)
variablename = [('Value11', 'Value12', 'Value13'),
                ('Value21', 'Value22', 'Value23'),
                ('Value31', 'Value32', 'Value33')]
cursor.executemany('Insert INTO mytablename VALUES (?,?,?)', variablename)
  
## Cheking values
# we have multiple ways:
# a) fetch a single row
# b) iterate through every row
# c) fetch all results at once
cursor.execute("SELECT * FROM mytablename")
print(cursor.fetchone())    # fetches a single row
print(cursor.fetchall())    # fetches all rows

records = cursor.execute("SELECT * FROM Movies")
for record in records:
  print(record)