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, ) session.add(post) session.commit()