def insert_event(list):
conn = getconn()
cur = conn.cursor()
sql = "insert into event_attention (name,eventID,label,attentionTime) values(%s,%s,%s,%s)"
result = cur.execute(sql, (list))
closeAll(conn, cur)
return result
def insert_group(list):
conn = getconn()
cur = conn.cursor()
sql = "insert into `group` (name,groupName,people,peopleCount,createTime,modifyTime) values(%s,%s,%s,%s,%s,%s)"
result = cur.execute(sql, list)
closeAll(conn, cur)
return result
def login(name, password):
password = md5(password)
conn = getconn()
cur = conn.cursor()
sql = "select * from user where name=%s and password=%s"
result = cur.execute(sql, (name, password))
return result
def insert_people_history(list):
conn = getconn()
cur = conn.cursor()
sql = "insert into people_history (name,peopleID,modifyRecord,modifyTime) values(%s,%s,%s,%s)"
result = cur.execute(sql, list)
closeAll(conn, cur)
return result
def select_user():
conn = getconn()
cur = conn.cursor()
sql = "select * from user"
count = cur.execute(sql)
result = cur.fetchmany(count)
return result
def delete_item(username):
conn = getconn()
cur = conn.cursor()
sql = "delete from user where name='%s'" % (username)
result = cur.execute(sql)
closeAll(conn, cur)
return result
def delete_group(name, groupName):
conn = getconn()
cur = conn.cursor()
sql = "delete from `group` where name=%s and groupName=%s"
result = cur.execute(sql, (name, groupName))
closeAll(conn, cur)
return result
def update_topic():
conn = getconn()
cur = conn.messages
sql = ""
result = cur.extend(sql, ())
closeAll(conn, cur)
return result
def delete_topic(name, topicName):
conn = getconn()
cur = conn.cursor()
sql = "delete from topic where name=%s and topicName=%s"
result = cur.execute(sql, (name, topicName))
closeAll(conn, cur)
return result
def delete_event(name, eventID):
conn = getconn()
cur = conn.cursor()
sql = "delete from event_attention where name=%s and eventID=%s"
result = cur.execute(sql, (name, eventID))
closeAll(conn, cur)
return result
def insert_people(list):
conn = getconn()
cur = conn.cursor()
sql = "insert into people_attention (name,peopleID,label,attentionTime) values (%s,%s,%s,%s)"
result = cur.execute(sql, list)
closeAll(conn, cur)
return result
def delete_people(name, peopleID):
conn = getconn()
cur = conn.cursor()
sql = "delete from people_attention where name=%s and peopleID=%s"
result = cur.execute(sql, (name, peopleID))
closeAll(conn, cur)
return result
def insert_topic(list):
conn = getconn()
cur = conn.cursor()
sql = "insert into topic (name,topicName,event,eventCount,createTime,modifyTime) values (%s,%s,%s,%s,%s,%s)"
print sql
result = cur.execute(sql, list)
closeAll(conn, cur)
return result
def select_topic(name):
conn = getconn()
cur = conn.cursor()
sql = "select * from topic where name=%s"
count = cur.execute(sql, (name, ))
result = cur.fetchmany(count)
closeAll(conn, cur)
return result
def select_people_history():
conn = getconn()
cur = conn.cursor()
sql = "select * from people_history"
count = cur.execute(sql)
result = cur.fetchmany(count)
closeAll(conn, cur)
return result
def insert_item(username, password):
password = md5(password)
conn = getconn()
cur = conn.cursor()
sql = "insert into user (name,password) values (%s,%s)"
result = cur.execute(sql, (username, password))
closeAll(conn, cur)
return result
def select_people(name):
conn = getconn()
cur = conn.cursor()
sql = "select * from people_attention where name=%s"
count = cur.execute(sql, (name, ))
result = cur.fetchmany(count)
closeAll(conn, cur)
return result
def update_itme(username, password):
conn = getconn()
cur = conn.cursor()
password = md5(password)
sql = "update user set password='******' where name = '%s'" % (password,
username)
print sql
result = cur.execute(sql)
closeAll(conn, cur)
return result
def select_group(name):
conn = getconn()
cur = conn.cursor()
sql = "select * from `group` where name=%s"
print sql
count = cur.execute(sql, (name, ))
result = cur.fetchmany(count)
print result
closeAll(conn, cur)
return result
