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