create_db.py

# WARNING: NOT FOR USE IN PRODUCTION AFTER REAL DATA EXISTS!!!!!!!!!!!!!!!!!!!!!!
'''
This script creates the database tables in the SQLite file. 
Update this file as you update your database.
'''
import os, sys
import importlib

# Don't forget to import your own models!
from app.models import *

conf = load_config('app/config.yaml')

sqlite_dbs  = [ conf['databases']['dev']
                # add more here if multiple DBs
              ]

# Remove DBs
for fname in sqlite_dbs:
  try:
    print ("Removing {0}.".format(fname))
    os.remove(fname)
  except OSError:
    pass

# Creates DBs
for fname in sqlite_dbs:
  if os.path.isfile(fname):
    print ("Database {0} should not exist at this point!".format(fname))
  print ("Creating empty SQLite file: {0}.".format(fname))
  open(fname, 'a').close()
  

def class_from_name (module_name, class_name):
  # load the module, will raise ImportError if module cannot be loaded
  # m = __import__(module_name, globals(), locals(), class_name)
  # get the class, will raise AttributeError if class cannot be found
  c = getattr(module_name, class_name)
  return c
    
"""This file creates the database and fills it with some dummy run it after you have made changes to the models pages."""
def get_classes (db):
  classes = []
  for str in conf['models'][db]:
    print ("\tCreating model for '{0}'".format(str))
    c = class_from_name(sys.modules[__name__], str)
    classes.append(c)
  return classes

  
mainDB.create_tables(get_classes('mainDB'))

# When adding dummy data the varialbes should be in Mixed case and should be the name of the class
###########
#SEMESTERS#
###########
semesters = Semesters(  SEID      = 201612,
                        year      = 2017,
                        term      = "Spring",
                      ).save(force_insert = True)
###########
#DIVISIONS#
###########            
divisions = Divisions(  name      = "Division 1"
                      ).save()

divisions = Divisions(  name      = "Division 2"
                      ).save()
##########
#PROGRAMS#
##########
programs  = Programs(   name      = "Computer Science",
                        DID       = 2
                     ).save()
                     
programs  = Programs(   name      = "Biology",
                        DID       = 1
                    ).save()
#######
#USERS#
#######
users     = Users(      firstName = "Scott",
                        lastName  = "Heggen",
                        username  = "heggens",
                        email     = "heggens@berea.edu",
                        isAdmin     = True
                  ).save(force_insert=True)
            
users     = Users(      firstName  = "Jan",
                        lastName   = "Pearce",
                        username   = "pearcej",
                        email      = "pearcej@berea.edu",
                        DID        = 2
                  ).save(force_insert=True)
                        
users     = Users(      firstName = "Mario",
                        lastName  = "Nakazawa",
                        username  = "nakazawam",
                        PID       = 1,
                        email     = "nakazawam@berea.edu"
                  ).save(force_insert=True)
                  
users     = Users(      firstName = "Matt",
                        lastName  = "Jadud",
                        username  = "jadudm",
                        email     = "jadudm@berea.edu",
                  ).save(force_insert=True)  
#########                  
#COURSES#  
#########             
courses   = Courses(  prefix  = "BIO",
                      number  = "101",
                      section = "A1",
                      PID     = 2,
                      SEID    = 201612
                  ).save()
                  
courses   = Courses(  prefix  = "CSC",
                      number  = "415",
                      section = "SH",
                      PID     = 1,
                      SEID    = 201612
                  ).save()
##############
#USERSCOURSES#
##############
userscourses  = UsersCourses ( username = 'heggens',
                               CID      = 1
                              ).save()
                              
userscourses  = UsersCourses ( username = 'heggens',
                               CID      = 2
                              ).save()