Esempio n. 1
0
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()