import sqlite3

#create connection with sqlite 
conn = sqlite3.connect("programme.db", check_same_thread= False)

#create cursor to establish connection 
cursor = conn.cursor()

#create the table 
prog_table_info = """
CREATE TABLE programme(ProgrammeTitle nvarchar(500), ProgrammeStatus nvarchar(30), ProgrammeType nvarchar(30), Genre nvarchar(40), 
SubGenre nvarchar(50), Language nvarchar(30), Duration nvarchar(30))
"""
cursor.execute(prog_table_info)

print("Access the table programme")
data = cursor.execute('''SELECT * from programme''')
for row in data:
    print(row)

eps_table_info = """
CREATE TABLE episode(EpisodeTitle nvarchar(500), EpisodeNumber int, Duration nvarchar(30))
"""
cursor.execute(eps_table_info)

print("Access the table episode")
data = cursor.execute('''SELECT * from episode''')
for row in data:
    print(row)

conn.commit()
conn.close()