def getAllTweets(dbm):
"""Regresa una lista de objetos Tweet con todos los elementos de la tabla"""
allTweets = []
if dbm is not None:
res = dbm.runQuery(
"SELECT tweetID, from_user_id, tweet, created_at, placeId, source, favorite_count, coordinates, userId, \
geo, lang, filter_level, in_reply_to_status_id_str FROM Tweets")
for row in res:
tweetRes = Tweet()
tweetRes.set(tweetID=row[0],
from_user=User.searchUserById(dbm, row[1]),
tweet=row[2],
created_at=row[3],
place=Place.searchPlaceById(dbm, row[4]),
source=row[5],
favorite_count=row[6],
coordinates=row[7],
geo=row[9],
lang=row[10],
filter_level=row[11],
in_reply_to_status_id_str=row[12])
tweetRes.dbm = dbm
allTweets.append(tweetRes)
return allTweets
else:
raise Exception("No DBM declared")
def searchTweetById(dbm, tweetID):
"""Regresa un objeto Tweet para la id buscada"""
tweetRes = Tweet(dbm)
if dbm is not None:
res = dbm.runQuery(
"SELECT tweetID, from_user_id, tweet, created_at, placeId, source, favorite_count, coordinates, userId, geo, lang, filter_level, in_reply_to_status_id_str FROM Tweets WHERE tweetID={}"
.format(tweetID))
try:
if res is not None:
row = res[0]
tweetRes.set(tweetID=row[0],
from_user=User.searchUserById(dbm, row[1]),
tweet=row[2],
created_at=row[3],
place=Place.searchPlaceById(dbm, row[4]),
source=row[5],
favorite_count=row[6],
coordinates=row[7],
geo=row[9],
lang=row[10],
filter_level=row[11],
in_reply_to_status_id_str=row[12])
except:
pass
return tweetRes
else:
raise Exception("No DBM declared")
def getAllTweets(dbm):
"""Regresa una lista de objetos Tweet con todos los elementos de la tabla"""
allTweets = []
if dbm is not None:
res = dbm.runQuery("SELECT tweetID, from_user_id, tweet, created_at, placeId, source, favorite_count, coordinates, userId, \
geo, lang, filter_level, in_reply_to_status_id_str FROM Tweets")
for row in res:
tweetRes = Tweet()
tweetRes.set(tweetID = row[0], from_user = User.searchUserById(dbm, row[1]), tweet = row[2], created_at = row[3],
place = Place.searchPlaceById(dbm, row[4]), source = row[5], favorite_count = row[6], coordinates = row[7],
geo = row[9], lang = row[10], filter_level = row[11], in_reply_to_status_id_str = row[12])
tweetRes.dbm = dbm
allTweets.append(tweetRes)
return allTweets
else:
raise Exception("No DBM declared")
def searchTweetById(dbm, tweetID):
"""Regresa un objeto Tweet para la id buscada"""
tweetRes = Tweet(dbm)
if dbm is not None:
res = dbm.runQuery("SELECT tweetID, from_user_id, tweet, created_at, placeId, source, favorite_count, coordinates, userId, geo, lang, filter_level, in_reply_to_status_id_str FROM Tweets WHERE tweetID={}".format(tweetID))
try:
if res is not None:
row = res[0]
tweetRes.set(tweetID = row[0], from_user = User.searchUserById(dbm, row[1]), tweet = row[2], created_at = row[3],
place = Place.searchPlaceById(dbm, row[4]), source = row[5], favorite_count = row[6], coordinates = row[7],
geo = row[9], lang = row[10], filter_level = row[11], in_reply_to_status_id_str = row[12])
except:
pass
return tweetRes
else:
raise Exception("No DBM declared")
