I got my runtime down to 3m25s from 4m2s by using these functions instead.
def this_line_is_useless(line):
useless_es = [
'BEGIN TRANSACTION',
'COMMIT',
'sqlite_sequence',
'CREATE UNIQUE INDEX',
'PRAGMA foreign_keys=OFF'
]
for useless in useless_es:
if useless in line:
return True
def has_primary_key(line):
return 'PRIMARY KEY' in line