Example #1
0
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']) 
Example #2
0
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'])
Example #3
0
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'])
Example #4
0
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'])
Example #5
0
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'])
Example #6
0
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'])
Example #7
0
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'
Example #8
0
 def homepage_art_root_url(self):
     if self.homepage_art_url:
         return get_art_root_url(self.homepage_art_url)
     return None
Example #9
0
 def lead_art_root_url(self):
     if self.lead_art_url:
         return get_art_root_url(self.lead_art_url)
     return None
Example #10
0
 def art_root_url(self):
     if self.art_url:
         return get_art_root_url(self.art_url)
     return None