def getStudentProject(self, StudentID): return [ Project(tuple) for tuple in self._db.execute("""select * from Project where ProjectID = (select ProjectID from Student where StudentID = {id});""". format(id=StudentID)).fetchall() ][0]
def getActiveProjects() -> list: """Get active projects """ cursor = connection.cursor() cursor.execute(SQLQueries.ACTIVE_PROJECT_GET) queryResult = cursor.fetchall() if (len(queryResult) == 0): return None projectList = [] for project in queryResult: projectData = Project() projectData.projectId = project[0] projectData.projectName = project[1] projectList.append(projectData) return projectList
def create_project(): userInfo = session.get('userProfile') name = request.form.get('name', '') desc = request.form.get('desc', '') start_date = DATE new_id = db.session.query(func.max(Project.p_id)).one() print(new_id) if new_id[0] == None: new_id[0] = 0 project = Project(new_id[0] + 1, name, desc, start_date, 'N/A') try: project.insert() except: print(sys.exc_info()) abort(500) return redirect(url_for('get_all_projects'))
def getDefaultProjects() -> list: """Creates default projects as defined in the configuration with default task "-". Returns: list -- List of Projects """ projectList = [] for projectName in DEFAULT_PROJECT: project = Project() project.projectName = projectName taskList = [] task = Task() task.taskName = "-" taskList.append(task) project.taskList = taskList projectList.append(project) return projectList
from application import db from models.User import User from models.Subject import Subject from models.Project import Project from models.Document import Document Subject.query.delete() Project.query.delete() # CREATE DOMAIN OBJECTS Engineering = Subject("Engineering") DataScience = Subject("Data Science") DigitalAudioEqualizer = Project(title="Digital Audio Equalizer", academic=True, subject=Engineering) FuzzyLogicClusteringAlgorithm = Project(title="Fuzzy Logic Clustering Algorithm", academic=False, subject=DataScience) # ADD AND COMMIT db.session.add_all([Engineering, DataScience, DigitalAudioEqualizer, FuzzyLogicClusteringAlgorithm]) db.session.commit() # PRINT print(Subject.query.all()) # CREATE RELATIONSHIPS
def getProjects(self): return [ Project(tuple) for tuple in self._db.execute("select * from Project").fetchall() ]
def getProject(self, ProjectID): return [ Project(tuple) for tuple in self._db.execute(""" select * from Project where ProjectID={id}""".format( id=ProjectID)).fetchall() ][0]
def getProjectsForTeacher(self, TeacherID): return [ Project(tuple) for tuple in self._db.execute(""" select * from Project where TeacherID={id};""".format( id=TeacherID)).fetchall() ]