def load_gremium(engine, data): gremium = Gremium.query.filter_by(key=data.get('key')).first() if gremium is None: gremium = Gremium() gremium.key = data.get('key') gremium.source_url = data.get('source_url') gremium.name = data.get('name') gremium.typ = data.get('type') gremium.url = data.get('url') gremium.aufgabe = data.get('aufgabe') gremium.rss_url = data.get('rss_url') gremium.image_url = data.get('image_url') gremium.image_copyright = data.get('image_copyright') db.session.add(gremium) db.session.commit() return gremium
def load_gremien(engine): log.info("Loading gremien into production DB...") _GremiumSource = sl.get_table(engine, 'gremium') for data in sl.all(engine, _GremiumSource): gremium = Gremium.query.filter_by(key=data.get('key')).first() if gremium is None: gremium = Gremium() gremium.key = data.get('key') gremium.source_url = data.get('source_url') gremium.name = data.get('name') gremium.typ = data.get('type') gremium.url = data.get('url') gremium.aufgabe = data.get('aufgabe') gremium.rss_url = data.get('rss_url') gremium.image_url = data.get('image_url') gremium.image_copyright = data.get('image_copyright') db.session.add(gremium) db.session.commit()