from urllib2 import urlopen, quote as urlquote import json import os import re import collections import datetime import hashlib import gzip from cStringIO import StringIO from app.main import Session from app.blog import BlogPost, BlogComment from app.social import RedditLink session = Session() raw_data = json.loads(urlopen('http://www.reddit.com/user/mikeboers/submitted.json').read()) for child in raw_data['data']['children']: data = child['data'] url = 'http://reddit.com' + data['permalink'] obj = RedditLink(url) print obj.id, obj.created_at post = BlogPost( title='', subtitle='', created_at=obj.created_at, preview='${remote_content(%r)}' % url, body='', source=url,
from app.main import Session from app.blog import BlogPost session = Session() for post in session.query(BlogPost).filter(BlogPost.source != None): post.preview = '${remote_content("%s")}' % post.source print post.preview session.commit()