Def name_condition(name): c = sqlite3.connect(videolist)

Question

Def name_condition(name): c = sqlite3.connect(videolist)

myCursor = c.cursor()
myCursor.executescript('''CREATE TABLE IF NOT EXISTS Media (name);''')
myCursor.execute('SELECT COUNT(name) FROM Media WHERE name=?;', [(name)])
a = myCursor.fetchone()
aa = a[0]

if aa < 1:
myCursor.execute("INSERT OR REPLACE INTO Media (name) VALUES (?)", [(name)])
c.commit()
c.close()
result = ("new")
else:
result = ("old")
c.commit()
c.close()
return result