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 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 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 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 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_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 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 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 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
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