def trendingChannelsList():
twitv = TwiTv()
rank = twitv.channelRank()
response = ''
i = 0
while i < len(rank):
twits = rank[i][0]
idChannel = rank[i][1]
channelName = rank[i][2]
channelNumber = str(rank[i][3])
channelImage = rank[i][4]
response += '<tr><td>%s</td><td>%s</td><td>%s</td><td><img src="%s" /></td></tr>' % (
idChannel, channelName, channelNumber, channelImage)
i += 1
response = '<table>' + response + '</table>'
return response
def trendingChannelsList():
twitv = TwiTv()
rank = twitv.channelRank()
response = ""
i = 0
while i < len(rank):
twits = rank[i][0]
idChannel = rank[i][1]
channelName = rank[i][2]
channelNumber = str(rank[i][3])
channelImage = rank[i][4]
response += '<tr><td>%s</td><td>%s</td><td>%s</td><td><img src="%s" /></td></tr>' % (
idChannel,
channelName,
channelNumber,
channelImage,
)
i += 1
response = "<table>" + response + "</table>"
return response
def trendingChannels():
twitv = TwiTv()
rank = twitv.channelRank()
response = []
i = 0
while i < len(rank):
twits = rank[i][0]
idChannel = rank[i][1]
channelName = rank[i][2]
channelNumber = str(rank[i][3])
channelImage = rank[i][4]
response.append({
'twits': twits,
'idChannel': idChannel,
'channelName': channelName,
'channelNumber': channelNumber,
'channelImage': channelImage
})
i += 1
return json.dumps({'response': response})
def trendingChannels():
twitv = TwiTv()
rank = twitv.channelRank()
response = []
i = 0
while i < len(rank):
twits = rank[i][0]
idChannel = rank[i][1]
channelName = rank[i][2]
channelNumber = str(rank[i][3])
channelImage = rank[i][4]
response.append(
{
"twits": twits,
"idChannel": idChannel,
"channelName": channelName,
"channelNumber": channelNumber,
"channelImage": channelImage,
}
)
i += 1
return json.dumps({"response": response})
twitHashtagsUsed = ','.join(hashTags[i][4:])
twitText = tweet['text'].replace("'", ' ')
#twitGeoLong = tweet['geo']
idChannel = hashTags[i][1]
#print "Tweet from @%s" % twitOwnerUsername
#print "At: %s %s" % (twitCreatedDate, twitCreatedTime)
#print twitText,"\n"
queryFormat = 'INSERT INTO "tbl_Twit"("idTimeslice", "idChannel", "twitTwitId", "twitOwnerUsername", "twitCreatedDate", "twitCreatedTime", "twitHashtagsUsed", "twitText") VALUES (%d, %d, \'%s\', \'%s\', \'%s\', \'%s\', \'%s\', \'%s\');'
queryValues = (idTimeSlice, idChannel, twitTwitId,
twitOwnerUsername, twitCreatedDate,
twitCreatedTime, twitHashtagsUsed, twitText)
query = queryFormat % queryValues
try:
db.doDB(query)
except Exception, e:
print "Error al guardar twit."
print "ID: %s" % (twitTwitId)
print "@%s" % (twitOwnerUsername)
print "At: %s %s" % (twitCreatedDate, twitCreatedTime)
print "HT: %s" % (twitHashtagsUsed)
print "%s" % (twitText)
print "Unexpected error:", sys.exc_info()[0]
sprint('.')
except Exception, e:
print "Unexpected error:", sys.exc_info()[0]
#print search_results["results"]
sprint(' done!\n')
sleep(5)
i += 1
twitv.channelRank(idTimeSlice)
sleep(20)
twitCreatedDate = twitCreatedDateTime.strftime('%d-%b-%Y')
twitCreatedTime = twitCreatedDateTime.strftime('%H:%M:%S')
twitHashtagsUsed = ','.join(hashTags[i][4:])
twitText = tweet['text'].replace("'", ' ')
#twitGeoLong = tweet['geo']
idChannel = hashTags[i][1]
#print "Tweet from @%s" % twitOwnerUsername
#print "At: %s %s" % (twitCreatedDate, twitCreatedTime)
#print twitText,"\n"
queryFormat = 'INSERT INTO "tbl_Twit"("idTimeslice", "idChannel", "twitTwitId", "twitOwnerUsername", "twitCreatedDate", "twitCreatedTime", "twitHashtagsUsed", "twitText") VALUES (%d, %d, \'%s\', \'%s\', \'%s\', \'%s\', \'%s\', \'%s\');'
queryValues = (idTimeSlice, idChannel, twitTwitId, twitOwnerUsername, twitCreatedDate, twitCreatedTime, twitHashtagsUsed, twitText)
query = queryFormat % queryValues
try:
db.doDB(query)
except Exception, e:
print "Error al guardar twit."
print "ID: %s" % (twitTwitId)
print "@%s" % (twitOwnerUsername)
print "At: %s %s" % (twitCreatedDate, twitCreatedTime)
print "HT: %s" % (twitHashtagsUsed)
print "%s" % (twitText)
print "Unexpected error:", sys.exc_info()[0]
sprint('.')
except Exception, e:
print "Unexpected error:", sys.exc_info()[0]
#print search_results["results"]
sprint(' done!\n')
sleep(5)
i+=1
twitv.channelRank(idTimeSlice)
sleep(20)
