def tweet_from_jso_to_DB_test():
"""TODO
#open json file
#parse json files using json library
#use dictionaries to store Tweet models (Tweet from dictionary already implemented)
"""
twitterAPIfactory = TwitterAPIFactory()
api = twitterAPIfactory.getAPI()
last_tweet_recorded = Tweet.query.first()
print last_tweet_recorded
kw = {}
if last_tweet_recorded:
tweet_id = int(last_tweet_recorded.tweet_id)
kw['since_id'] = tweet_id
results = api.GetHomeTimeline(count=10, **kw)
tweets = results
#tweets[0].id = 9598979 reference in DB
jsonfilename = 'tweet.json'
tweetsJsonContent = [tweet.AsDict() for tweet in tweets]
saveAsJSON(JSONSerializableObject=tweetsJsonContent,
jsonfilename=jsonfilename,
indent=4)
parsedTweets = parseJSON(jsonfilename=jsonfilename)
for parsedTweet in parsedTweets:
my_tweet = Tweet.from_dictionary(parsedTweet)
print "Parsed Tweet: %s" % (my_tweet)
def tweet_from_jso_to_DB_test():
"""TODO
#open json file
#parse json files using json library
#use dictionaries to store Tweet models (Tweet from dictionary already implemented)
"""
twitterAPIfactory = TwitterAPIFactory()
api = twitterAPIfactory.getAPI()
last_tweet_recorded = Tweet.query.first()
print last_tweet_recorded
kw = {}
if last_tweet_recorded:
tweet_id = int(last_tweet_recorded.tweet_id)
kw['since_id'] = tweet_id
results = api.GetHomeTimeline(count=10, **kw)
tweets = results
#tweets[0].id = 9598979 reference in DB
jsonfilename='tweet.json'
tweetsJsonContent = [tweet.AsDict() for tweet in tweets]
saveAsJSON(JSONSerializableObject=tweetsJsonContent,jsonfilename=jsonfilename,indent=4)
parsedTweets = parseJSON(jsonfilename=jsonfilename)
for parsedTweet in parsedTweets:
my_tweet = Tweet.from_dictionary(parsedTweet)
print "Parsed Tweet: %s" %(my_tweet)
def tweet_from_json_to_db(jsonfilename):
parsedTweets = parseJSON(jsonfilename=jsonfilename)
for parsedTweet in parsedTweets:
tweet = Tweet.from_dictionary(parsedTweet)
print "Parsed Tweet: %s" % (tweet)
print "Storing Tweet into DB..."
tweet.submit() # SAVES INTO DATABASE
def tweet_from_json_to_db(jsonfilename):
parsedTweets = parseJSON(jsonfilename=jsonfilename)
for parsedTweet in parsedTweets:
tweet = Tweet.from_dictionary(parsedTweet)
print "Parsed Tweet: %s" %(tweet)
print "Storing Tweet into DB..."
tweet.submit() # SAVES INTO DATABASE
