def __init__(self, db_file):
"""
Initializer for the class model. This will want to know which file to look at for the db.
Then it will provide a connection to that database and allow for some ORM opterations, such
as insert and select.
db_file :str
Example Usage:
cm = ClassModel.ClassModel('testing.db')
"""
# init db connection using the datastore
self.conn = Datastore.DB(db_file).ret().conn
def __init__(self, db_file):
"""
Initializer for the road maps toggles model. This will want to know which file to look at for the db.
Then it will provide a connection to that database and allow for some ORM opterations, such
as insert and select.
:param
db_file :str
Example Usage:
tm = TogglesModel.TogglesModel('testing.db')
"""
# init db connection using the datastore
self.conn = Datastore.DB(db_file).ret().conn
"""INSERT INTO "main"."roadmap_toggles"("id","requirements_id","students_id","highlight","created_at",
Samuel Lundquist
Priority credit to:
Ryan Gurnick - 3/4/20 Creation
"""
import os
import ClassParser
import Datastore
DB = 'seed.db'
if not os.path.exists('seed.db'):
# setup datastore
ds = Datastore.DB(DB)
# generate them default tables
ds.generateTables()
# all of the subject codes
subject_codes = ["AAAP", "AAD", "ACTG", "AEIS", "AFR", "AIM", "ANTH", "ANTM", "ARB", "ARCH", "ARH", "ART", "ARTC",
"ARTD", "ARTF", "ARTM", "ARTO", "ARTP", "ARTR", "ARTS", "ASIA", "ASL", "ASTR", "BA", "BI", "BIKC",
"BIOE", "BLST", "CARC", "CAS", "CDS", "CFT", "CH", "CHKC", "CHN", "CHNF", "CINE", "CIS", "CIT", "CLAS",
"COLT", "CPSY", "CRDG", "CRES", "CRWR", "CSCH", "DAN", "DANC", "DANE", "DIST", "DSGN", "EALL", "EC",
"ECE", "EDLD", "EDST", "EDUC", "ENG", "ENVS", "ERTH", "ES", "ESC", "EURO", "FHS", "FIN", "FINN", "FLR",
"FR", "GEOG", "GEOL", "GER", "GRK", "GRST", "GSAE", "GSCL", "GSGE", "GSST", "HBRW", "HC", "HIST",
"HPHY", "HUM", "IARC", "ICH", "INTL", "IST", "ITAL", "J", "JDST", "JGS", "JPN", "KC", "KRN", "LA",
"LAS", "LAT", "LAW", "LEAD", "LERC", "LIB", "LING", "LT", "MATH", "MDVL", "MENA", "MGMT", "MIL",
"MKTG", "MUE", "MUJ", "MUP", "MUS", "NAS", "NORW", "OBA", "OIMB", "OLIS", "PD", "PDX", "PE", "PEAQ",
"PEAS", "PEC", "PEF", "PEI", "PEIA", "PEL", "PEMA", "PEMB", "PEO", "PERS", "PERU", "PETS", "PEW",
"PHIL", "PHKC", "PHYS", "PORT", "PPPM", "PREV", "PS", "PSY", "QST", "REES", "REL", "RL", "RUSS",
