def project_create_update(params, project_id):
if isinstance(project_id, int):
project = Project.query.get(project_id)
else:
project = Project()
print('project_id', project_id)
print('POST: ')
# project = Project()
fields = []
for param in params:
field = request.form.get(param, None)
if not field:
field = None
fields.append(field)
if all(f is None for f in fields):
pass
else:
# https://stackoverflow.com/questions/3253966/python-string-to-attribute
project.project_title = fields[0]
project.year_1 = fields[1]
project.year_2 = fields[2]
project.year_3 = fields[3]
project.year_4 = fields[4]
project.year_5 = fields[5]
project.justification = fields[6]
project.comments = fields[7]
if isinstance(project_id, int):
db.session.commit()
else:
db.session.add(project)
db.session.commit()
