run.py

import sqlite3

conn = sqlite3.connect('app.db')
c = conn.cursor()
c.execute('ALTER TABLE analyses ADD COLUMN study_uid VARCHAR DEFAULT \
\')
c.execute('ALTER TABLE analyses ADD COLUMN gradcam_path VARCHAR DEFAULT \
\')
c.execute('ALTER TABLE analyses ADD COLUMN router_probability DOUBLE PRECISION DEFAULT 0')
conn.commit()
print('Added columns to analyses')
c.execute('ALTER TABLE xrays ADD COLUMN study_uid VARCHAR DEFAULT \
\')
c.execute('ALTER TABLE xrays ADD COLUMN gradcam_path VARCHAR DEFAULT \
\')
c.execute('ALTER TABLE xrays ADD COLUMN fracture BOOLEAN DEFAULT FALSE')
c.execute('ALTER TABLE xrays ADD COLUMN confidence DOUBLE PRECISION DEFAULT 0')
c.execute('ALTER TABLE xrays ADD COLUMN model_used VARCHAR DEFAULT \
specialist\')
c.execute('ALTER TABLE xrays ADD COLUMN attention_score DOUBLE PRECISION DEFAULT 0')
conn.commit()
print('Added columns to xrays')
conn.close()