def _projects_from_json(app, content=''):
if 'projects' in content:
for obj in content['projects']:
user = User.query.filter_by(email=obj['user']).first()
if user is None:
app.logger.error('Project: %s, Unknown user: %s' % (obj['name'], obj['user']))
break
company = Company.query.filter_by(user=user, name=obj['company']).first()
if company is None:
app.logger.error('Project: %s, Unknown company: %s' % (obj['name'], obj['company']))
break
project = Project.query.filter_by(user=user, company=company, name=obj['name']).first()
if project is None:
project = Project()
project.user = user
project.company = company
project.name = obj['name']
project.description = obj['description']
app.logger.debug('adding project: %s' % project)
db.session.add(project)
db.session.commit()
