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)