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()
]
