import sqlite3

s = '''
PRAGMA foreign_keys = ON;
create table artist (id INTEGER PRIMARY KEY);
create table track (
   id INTEGER PRIMARY KEY,
   artist_id INTEGER REFERENCES artist NOT NULL);
create index track_artist ON track(artist_id);
'''
con = sqlite3.connect(':memory:')
con.executescript(s)
con.execute("insert into track (artist_id) values (1)")