def deleteProject(id):
delete = ProjectModel.deleteByIdRecord(id=id)
if (delete):
flash("Deleted Successfully")
return redirect(url_for('home'))
else:
flash("No record found")
return redirect(url_for('home'))
def put(self,project_name):
data = request.get_json()
project = ProjectModel.query.filter_by(project_name=project_name).first()
if project:
project.project_name = data['project_name']
project.date_posted = data['date_posted']
project.department = data['department']
project.description = data['description']
project.skills = data['skills']
else:
project = ProjectModel(project_name=project_name,**data)
db.session.add(project)
db.session.commit()
return project.json()
def addNewProject():
if request.method == "POST":
title = request.form['title']
description = request.form['description']
startDate = request.form['startDate']
endDate = request.form['endDate']
cost = request.form['cost']
status = request.form['status']
project = ProjectModel(title=title,
description=description,
startDate=startDate,
endDate=endDate,
cost=cost,
status=status)
project.createRecord()
return redirect(url_for('home'))
def home():
print(session)
if session:
# Is logged in
records = ProjectModel.fetchAll()
status = [x.status for x in records]
pie_chart = pygal.Pie()
pie_chart._title = "completed vs pending"
pie_chart.add("pending projects", status.count("pending"))
pie_chart.add("completed projects", status.count("completed"))
graph = pie_chart.render_data_uri()
return render_template('index.html', records=records, graph=graph)
else:
# Is not logged in
return render_template('authentication.html')
def editProject(id):
newTitle = request.form['title']
newDescription = request.form['description']
newStartDate = request.form['startDate']
newEndDate = request.form['endDate']
newCost = request.form['cost']
newStatus = request.form['status']
updated = ProjectModel.updateByIdRecord(id=id,
newTitle=newTitle,
newDescription=newDescription,
newStartDate=newStartDate,
newEndDate=newEndDate,
newCost=newCost,
newStatus=newStatus)
if (updated):
flash("Updated Successfully")
return redirect(url_for('home'))
else:
flash("No record found")
return redirect(url_for('home'))
def mutate(self, info, input):
project = ProjectModel(input)
db_session.add(project)
db_session.commit()
return CreateUser(project=project)
def post(self):
data = request.get_json()
new_project = ProjectModel((data["project_name"],data["date_posted"],data["department"],data["description"],data["skills"]))
db.session.add(new_project)
db.session.commit()
return new_project.json(),201
file17 = FileModel(name='File 17', typename='mp3') file18 = FileModel(name='File 18', typename='text') file19 = FileModel(name='File 19', typename='pdf') file20 = FileModel(name='File 20', typename='text') file21 = FileModel(name='File 21', typename='mp3') file22 = FileModel(name='File 22', typename='text') file23 = FileModel(name='File 23', typename='mp3') file24 = FileModel(name='File 24', typename='pdf') file25 = FileModel(name='File 25', typename='text') file26 = FileModel(name='File 26', typename='text') file27 = FileModel(name='File 27', typename='mp3') file28 = FileModel(name='File 28', typename='pdf') file29 = FileModel(name='File 29', typename='text') file30 = FileModel(name='File 30', typename='mp3') project1 = ProjectModel(name='Project 1', startdate='2020-04-06') project2 = ProjectModel(name='Project 2', startdate='2020-04-06') project3 = ProjectModel(name='Project 3', startdate='2020-04-06') project4 = ProjectModel(name='Project 4', startdate='2020-04-06') project5 = ProjectModel(name='Project 5', startdate='2020-04-06') project6 = ProjectModel(name='Project 6', startdate='2020-04-06') project7 = ProjectModel(name='Project 7', startdate='2020-04-06') project8 = ProjectModel(name='Project 8', startdate='2020-04-06') project9 = ProjectModel(name='Project 9', startdate='2020-04-06') project10 = ProjectModel(name='Project 10', startdate='2020-04-06') project11 = ProjectModel(name='Project 11', startdate='2020-04-06') project12 = ProjectModel(name='Project 12', startdate='2020-04-06') project13 = ProjectModel(name='Project 13', startdate='2020-04-06') project14 = ProjectModel(name='Project 14', startdate='2020-04-06') project15 = ProjectModel(name='Project 15', startdate='2020-04-06')
def get_is(project_id):
project = ProjectDao.query.get_or_404(project_id)
statement = ProjectModel.generate_statement(project)
statement['periodType'] = project.periodType
return statement
def make_is(project):
statement = ProjectModel.generate_statement(project)
statement['periodType'] = project.periodType
return statement