def insert(self,d):
n = MySQL()
n.selectDb('joke')
tbname = 'joke'
n.insert(tbname, d)
n.commit()
def insert(self,d):
n = MySQL()
n.selectDb('images')
tbname = 'similar_images'
n.insert(tbname, d)
n.commit()
def addViewCount(self,id):
n = MySQL()
n.selectDb('joke')
tbname = 'joke'
sql = "update {0} set view_count = view_count+1".format(tbname)
n.query(sql)
# n.update(tbname, { 'view_count': "view_count+1"}, "id='"+id+"'")
n.commit()
def insert_data(data):
n=MySQL()
sql = "select id from urls_crawled where url='"+data['url']+"';"
result = n.query(sql)
if result == 0:
try:
n.insert('urls_crawled',data)
except:
return 200
n.commit()
#!/usr/bin/env python
# -*- coding: utf-8 -*-
import sys
sys.path.insert(0, 'lib')
from mysql import MySQL
import ConfigParser
import logging
config = ConfigParser.ConfigParser()
config.read('config/config.cfg')
db_config = config._sections['db']
db_config.pop('__name__')
a = MySQL(**db_config)
# sql = "show tables"
sql = "insert into url (post_id, url, status) values ('11', 'http://www.baidu.com', '0')"
a.query(sql)
a.commit()
# aa = a.get_all(sql)
# print aa
def updateJoke(self,content,id):
n = MySQL()
n.selectDb('joke')
tbname = 'joke'
n.update(tbname, { 'content': content}, "id='"+id+"'")
n.commit()
favorite_1=row['favorite_count']
print "status:"+status_id_1
print "retweet:"+retweet_1
print "favorite:"+favorite_1
sql_check_1="select * from popularity where status_id='%s'"%(status_id_1)
check_1=myconn.query(sql_check_1)
res_1=myconn.fetchAll()
for i in res_1:
myretweet_1=i['retweet']
myfavorite_1=i['favorite']
if check_1>0:
if int(retweet_1) > int(myretweet_1) or int(myfavorite_1)>int(favorite_1) :
sql_up_1="update popularity set retweet = '%s',favorite ='%s' where status_id ='%s'"%(myretweet_1,myfavorite_1,status_id_1)
try:
myconn.query(sql_up_1)
myconn.commit()
print sql_up_1+"success"
except:
myconn.rollback()
print sql_up_1+"fail"
else:
sql_ins_1="insert into popularity(status_id,retweet,favorite) values('%s','%s','%s')"%(status_id_1,retweet_1,favorite_1)
try:
myconn.query(sql_ins_1)
myconn.commit()
print sql_ins_1+"success"
except:
myconn.rollback()
print sql_ins_1+"fail"
print "set popularity finished"
