clear.py

from modreg import db, create_app

app = create_app()

with app.app_context():
    db.engine.execute("""
    DROP TABLE IF EXISTS webuser CASCADE;
    DROP TABLE IF EXISTS webadmins CASCADE;
    DROP TABLE IF EXISTS students CASCADE;
    DROP TABLE IF EXISTS exchanges CASCADE;
    DROP TABLE IF EXISTS modules CASCADE;
    DROP TABLE IF EXISTS faculties CASCADE;
    DROP TABLE IF EXISTS gets CASCADE;
    DROP TABLE IF EXISTS bids CASCADE;
    DROP TABLE IF EXISTS slots CASCADE;
    DROP TABLE IF EXISTS lectures CASCADE;
    DROP TABLE IF EXISTS majors CASCADE;
    DROP TABLE IF EXISTS minors CASCADE;
    DROP TABLE IF EXISTS minoring CASCADE;
    DROP TABLE IF EXISTS majoring CASCADE;
    DROP TABLE IF EXISTS prerequisites CASCADE;
    DROP TABLE IF EXISTS preclusions CASCADE;
    DROP TABLE IF EXISTS completions CASCADE;
    """)