def import_projects(json_file):
with open(json_file) as json_file:
projects = json.loads(json_file.read())
for project in projects:
new_project = Project(
name=project['name'],
short_description=project['short_description'],
description=project['description'],
website=project['website'],
required_informations=project.get('required_informations',
None),
notification_email=project.get('notification_email', None),
cve_vendor=project.get('cve_vendor', ''),
cve_product=project.get('cve_product', ''),
automatic_release_tracking=project.get(
'automatic_release_tracking', ''))
organization = get_or_create(db.session, Organization,
**project['organization'])
new_project.organization_id = organization.id
db.session.add(new_project)
db.session.commit()
