def fix_seamus_art_urls(): db = dataset.connect(app_config.POSTGRES_URL) seamus = db['seamus'] for row in seamus.all(): if row['lead_art_url']: update = { 'lead_art_root_url': get_art_root_url(row['lead_art_url']), 'id': row['id'] } print 'updating %s' % update seamus.update(update, ['id'])
def fix_homepage_art_urls(): db = dataset.connect(app_config.POSTGRES_URL) hp = db['homepage'] for row in hp.all(): if row['homepage_art_url']: update = { 'homepage_art_root_url': get_art_root_url(row['homepage_art_url']), 'id': row['id'] } print 'updating %s' % update hp.update(update, ['id'])
def fix_fb_art_urls(): db = dataset.connect(app_config.POSTGRES_URL) fb = db['facebook'] for row in fb.all(): if row['art_url']: update = { 'art_root_url': get_art_root_url(row['art_url']), 'id': row['id'] } print 'updating %s' % update fb.update(update, ['id'])
def save_image(): from flask import request db = dataset.connect(app_config.POSTGRES_URL) table = db['evaluated_images'] data = { 'evaluator': request.form['evaluator'], 'image_url': request.form['image_url'], 'image_root_url': get_art_root_url(request.form['image_url']), } if request.form['quality'] == 'love': data['is_good'] = True else: data['is_good'] = False table.upsert(data, ['evaluator', 'image_url']) return 'success'
def homepage_art_root_url(self): if self.homepage_art_url: return get_art_root_url(self.homepage_art_url) return None
def lead_art_root_url(self): if self.lead_art_url: return get_art_root_url(self.lead_art_url) return None
def art_root_url(self): if self.art_url: return get_art_root_url(self.art_url) return None