def initinform(): """初始化举报表""" try: conn = initconn.getConn() cur = conn.cursor() type = ["话题", "活动", "圈子"] viewurl = ["admin/topic/view", "admin/activity/view", "admin/circle/view"] reason = ["色情", "欺诈", "诋毁侮辱", "广告骚扰", "政治", "非交大校友", "其他"] for i in range(1,101): typeIndex = random.randint(0, 2) refId = random.randint(1, 100) value = [ refId, "title" + str(i), time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()), "otherinfo" + str(i), reason[random.randint(0, 5)], random.randint(0, 1), type[typeIndex], viewurl[typeIndex] + "id=" + str(refId), random.randint(1, 100) ] cur.execute( 'insert into inform(asso_id,asso_name,c_time,otherinfo,reason,state,type,viewurl,create_userid) values(%s,%s,%s,%s,%s,%s,%s,%s,%s)', value) conn.commit() cur.close() conn.close() except MySQLdb.Error, e: print "Mysql Error %d: %s" % (e.args[0], e.args[1])
def resetPicPath(table): """重置图片路径""" picpath = [ "uploadfiles/20150811/20150811111719207/pic1.jpg", "uploadfiles/20150811/20150811111719207/pic2.jpg", "uploadfiles/20150811/20150811111719207/pic3.jpg" ] conn = initconn.getConn() cur = conn.cursor() totalCount = 100 if table == "focus": totalCount = 11 for i in range(totalCount): value = [ picpath[random.randint(0, 2)], i ] if table == "alumnus": cur.execute('update ' + table + ' set headpic_path=%s where id=%s', value) else: cur.execute('update ' + table + ' set picpath=%s where id=%s', value) if table == "circle": cur.execute('update ' + table + ' set iconpath=%s where id=%s', value) conn.commit() cur.close() conn.close()
def initinform(): """初始化举报表""" try: conn = initconn.getConn() cur = conn.cursor() type = ["资讯", "活动", "圈子"] viewurl = [ "pc/admin/news/view", "pc/admin/activity/view", "pc/admin/circle/view" ] reason = ["色情", "欺诈", "诋毁侮辱", "广告骚扰", "政治", "非交大校友", "其他"] for i in range(100): typeIndex = random.randint(0, 2) refId = random.randint(0, 99) value = [ i, refId, "title" + str(i), time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()), "otherinfo" + str(i), reason[random.randint(0, 5)], random.randint(0, 1), type[typeIndex], viewurl[typeIndex] + "id=" + str(refId), random.randint(0, 99) ] cur.execute( 'insert into inform values(%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)', value) conn.commit() cur.close() conn.close() except MySQLdb.Error, e: print "Mysql Error %d: %s" % (e.args[0], e.args[1])
def initAdmin(): """初始化管理员信息表""" try: conn = initconn.getConn() cur = conn.cursor() # 添加超级管理员 value = [ 0, time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()), 0, "123456", "111111" + str(0), "超级管理员", "superadmin" ] cur.execute('insert into admin values(%s,%s,%s,%s,%s,%s,%s)', value) for i in range(1, 110): value = [ str(i), time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()), str(1), "pass" + str(i), "111111" + str(i), "realname" + str(i), "username" + str(i) ] cur.execute('insert into admin values(%s,%s,%s,%s,%s,%s,%s)', value) conn.commit() cur.close() conn.close() except MySQLdb.Error, e: print "Mysql Error %d: %s" % (e.args[0], e.args[1])
def initActivity(): """活动信息表""" conn = initconn.getConn() cur = conn.cursor() for i in range(1,101): value = [ "activitydesc" + str(i), "address" + str(i), "city" + str(i), "contactemail" + str(i) + "@qq.com", "contactman" + str(i), "contactphone" + str(i), time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()), time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()), "joinfee" + str(i), "picpath" + str(i), random.randint(1, 100), time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()), str(1), "title" + str(i), str(i), time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()), "otherinfo" + str(i), random.randint(1, 100), "topic" + str(i) ] cur.execute('insert into activity(activitydesc,address,city,contactemail,' 'contactman,contactphone,c_time,e_time,joinfee,' 'picpath,pv,s_time,state,title,create_userid,close_time,otherinfo,personlimit,topic) ' 'values(%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)', value) conn.commit() cur.close() conn.close()
def initmessage(): """初始化消息表""" try: conn = initconn.getConn() cur = conn.cursor() for i in range(1, 101): sender_id = str(random.randint(1, 100)) receiver_id = str(random.randint(1, 100)) # 插入消息表 value = [ "content" + str(i), time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()), random.randint(0, 1), sender_id, receiver_id, ] cur.execute( "insert into message(content,c_time,state,receive_userid,sender_userid) values(%s,%s,%s,%s,%s)", value ) conn.commit() cur.close() conn.close() except MySQLdb.Error, e: print "Mysql Error %d: %s" % (e.args[0], e.args[1])
def inittopictype(): """话题分类""" try: conn = initconn.getConn() cur = conn.cursor() value = [1, "商机信息", "商机"] cur.execute('insert into topictype(id,typedesc,typename) values(%s,%s,%s)', value) value = [2, "招聘信息", "招聘"] cur.execute('insert into topictype(id,typedesc,typename) values(%s,%s,%s)', value) value = [3, "校企信息", "校企"] cur.execute('insert into topictype(id,typedesc,typename) values(%s,%s,%s)', value) value = [4, "杂谈信息", "杂谈"] cur.execute('insert into topictype(id,typedesc,typename) values(%s,%s,%s)', value) value = [5, "资讯信息", "资讯"] cur.execute('insert into topictype(id,typedesc,typename) values(%s,%s,%s)', value) conn.commit() cur.close() conn.close() except MySQLdb.Error, e: print "Mysql Error %d: %s" % (e.args[0], e.args[1])
def inituser(): """初始化用户表""" try: conn = initconn.getConn() cur = conn.cursor() for i in range(1, 101): value = [ str(i), time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()), jdbmd5.md5("pass" + str(i)), str(1), "111111" + str(i) ] cur.execute('insert into user(id,c_time,password,state,username) values(%s,%s,%s,%s,%s)', value) value = [ "102", time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()), jdbmd5.md5("123456"), str(1), "13691513507" ] cur.execute('insert into user(id,c_time,password,state,username) values(%s,%s,%s,%s,%s)', value) conn.commit() cur.close() conn.close() except MySQLdb.Error, e: print "Mysql Error %d: %s" % (e.args[0], e.args[1])
def initActivity(): """活动信息表""" conn = initconn.getConn() cur = conn.cursor() for i in range(100): value = [ str(i), "activitydesc" + str(i), "address" + str(i), "city" + str(i), time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()), "contactemail" + str(i) + "@qq.com", "contactman" + str(i), "contactphone" + str(i), time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()), time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()), "joinfee" + str(i), "otherinfo" + str(i), random.randint(0, 99), "picpath" + str(i), random.randint(1, 100), time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()), str(1), "title" + str(i), "topic" + str(i), str(i) ] cur.execute('insert into activity values(%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)', value) conn.commit() cur.close() conn.close()
def initAdmin(): """初始化管理员信息表""" try: conn = initconn.getConn() cur = conn.cursor() # 添加超级管理员 value = [ time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()), 0, "123456", "111111" + str(0), "超级管理员", "superadmin" ] cur.execute('insert into admin(c_time,level,password,phone,realname,username) values(%s,%s,%s,%s,%s,%s)', value) for i in range(1,101): value = [ time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()), str(1), "pass" + str(i), "111111" + str(i), "realname" + str(i), "username" + str(i) ] cur.execute('insert into admin(c_time,level,password,phone,realname,username) values(%s,%s,%s,%s,%s,%s)', value) conn.commit() cur.close() conn.close() except MySQLdb.Error, e: print "Mysql Error %d: %s" % (e.args[0], e.args[1])
def initAlumnus(): """用户详细信息表""" conn = initconn.getConn() cur = conn.cursor() for i in range(100): value = [ str(i), "company" + str(i), "department" + str(i), "email" + str(i) + "@qq.com", "enrealname" + str(i), "grade" + str(i), "headpicpath" + str(i), str(round(random.random() * 360, 2)), str(round(random.random() * 360, 2)), "111111" + str(i), "realname" + str(i), "school" + str(i), random.randint(0, 1), "title" + str(i), "weixin" + str(i), str(i) ] cur.execute('insert into alumnus values(%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)', value) conn.commit() cur.close() conn.close()
def test(): conn = initconn.getConn() cur = conn.cursor() for i in range(20): value = [ str(i+200), time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()), time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()), random.randint(0, 1000), random.randint(0, 1), 96, str(i) ] cur.execute('insert into friend values(%s,%s,%s,%s,%s,%s,%s)', value) for i in range(20): value = [ str(i+300), time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()), time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()), random.randint(0, 1000), random.randint(0, 1), str(20 + i), 96 ] cur.execute('insert into friend values(%s,%s,%s,%s,%s,%s,%s)', value) conn.commit() cur.close() conn.close()
def resetType(): conn = initconn.getConn() cur = conn.cursor() type = ["投融资", "思源创业", "合作商机", "互帮互助", "校友企业", "求职招聘", "新闻动态", "在水一方"] for i in range(100): value = [type[random.randint(0, 7)], str(i)] cur.execute('update news set type=%s where id=%s', value) conn.commit() cur.close() conn.close()
def initAlumnus(): """用户详细信息表""" conn = initconn.getConn() cur = conn.cursor() for i in range(1,101): value = [ "company" + str(i), "department" + str(i), "email" + str(i) + "@qq.com", "enrealname" + str(i), "grade" + str(i), "headpicpath" + str(i), str(round(random.random() * 360, 2)), str(round(random.random() * 360, 2)), "111111" + str(i), "realname" + str(i), "school" + str(i), random.randint(0, 1), "title" + str(i), "weixin" + str(i), "remark" + str(i), str(i) ] cur.execute('insert into alumnus(company,department,email,enrealname,grade,' 'headpic_path,lat,lng,phone,realname,school,sex,title,weixin,remark,user_id) ' 'values(%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)', value) value = [ "company102", "department102", "*****@*****.**", "enrealname102", "grade102", "headpicpath102", str(round(random.random() * 360, 2)), str(round(random.random() * 360, 2)), "13691513507", "realname102", "school102", random.randint(0, 1), "title102", "weixin102", "remark102", "102" ] cur.execute('insert into alumnus(company,department,email,enrealname,grade,headpic_path,' 'lat,lng,phone,realname,school,sex,title,weixin,remark,user_id) ' 'values(%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)', value) conn.commit() cur.close() conn.close()
def initfocus(): """焦点推荐""" try: conn = initconn.getConn() cur = conn.cursor() id = random.randint(0,99) value = [1, "","", 1, id, "", "资讯", "pc/admin/news/view?id=" + str(id)] cur.execute('insert into focus values(%s,%s,%s,%s,%s,%s,%s,%s)', value) id = random.randint(0,99); value = [2, "","", 2, id, "", "资讯", "pc/admin/news/view?id=" + str(id)] cur.execute('insert into focus values(%s,%s,%s,%s,%s,%s,%s,%s)', value) id = random.randint(0,99); value = [3, "","", 3, id, "", "活动", "pc/admin/activity/view?id=" + str(id)] cur.execute('insert into focus values(%s,%s,%s,%s,%s,%s,%s,%s)', value) id = random.randint(0,99); value = [4, "","", 4, id, "", "活动", "pc/admin/activity/view?id=" + str(id)] cur.execute('insert into focus values(%s,%s,%s,%s,%s,%s,%s,%s)', value) id = random.randint(0,99); value = [5, "","", 5, id, "", "资讯", "pc/admin/news/view?id=" + str(id)] cur.execute('insert into focus values(%s,%s,%s,%s,%s,%s,%s,%s)', value) id = random.randint(0,99); value = [6, "","", 6, id, "", "资讯", "pc/admin/news/view?id=" + str(id)] cur.execute('insert into focus values(%s,%s,%s,%s,%s,%s,%s,%s)', value) id = random.randint(0,99); value = [7, "","", 7, id, "", "圈子", "pc/admin/circle/view?id=" + str(id)] cur.execute('insert into focus values(%s,%s,%s,%s,%s,%s,%s,%s)', value) id = random.randint(0,99); value = [8, "","", 8, id, "", "圈子", "pc/admin/circle/view?id=" + str(id)] cur.execute('insert into focus values(%s,%s,%s,%s,%s,%s,%s,%s)', value) id = random.randint(0,99); value = [9, "","", 9, id, "", "圈子", "pc/admin/circle/view?id=" + str(id)] cur.execute('insert into focus values(%s,%s,%s,%s,%s,%s,%s,%s)', value) id = random.randint(0,99); value = [10, "","", 10, id, "", "圈子", "pc/admin/circle/view?id=" + str(id)] cur.execute('insert into focus values(%s,%s,%s,%s,%s,%s,%s,%s)', value) conn.commit() cur.close() conn.close() except MySQLdb.Error, e: print "Mysql Error %d: %s" % (e.args[0], e.args[1])
def resetReason(): try: conn = initconn.getConn() cur = conn.cursor() reason = ["色情", "欺诈", "诋毁侮辱", "广告骚扰", "政治", "非交大校友", "其他"] for i in range(100): value = [reason[random.randint(0, 6)], str(i)] cur.execute('update inform set reason=%s where id=%s', value) conn.commit() cur.close() conn.close() except MySQLdb.Error, e: print "Mysql Error %d: %s" % (e.args[0], e.args[1])
def resetInformUser(): """重置被举报人id""" reload(sys) sys.setdefaultencoding('utf8') try: conn = initconn.getConn() cur = conn.cursor() sql = "select * from inform" cur.execute(sql) results = cur.fetchall() for row in results: id = row[0] asso_id = row[1] type = row[7] if unicode(type) == unicode("话题"): sql1 = "select create_userid from topic where id=%s" cur.execute(sql1, asso_id) create_userid = cur.fetchone()[0] sql1 = "update inform set inform_userid=%s where id=%s" value = [create_userid, id] cur.execute(sql1, value) if unicode(type) == unicode("活动"): sql1 = "select create_userid from activity where id=%s" cur.execute(sql1, asso_id) create_userid = cur.fetchone()[0] sql1 = "update inform set inform_userid=%s where id=%s" value = [create_userid, id] cur.execute(sql1, value) if unicode(type) == unicode("圈子"): sql1 = "select create_userid from circle where id=%s" cur.execute(sql1, asso_id) create_userid = cur.fetchone()[0] sql1 = "update inform set inform_userid=%s where id=%s" value = [create_userid, id] cur.execute(sql1, value) conn.commit() conn.close() except MySQLdb.Error, e: print "Mysql Error %d: %s" % (e.args[0], e.args[1])
def initFriends(): """好友信息表""" conn = initconn.getConn() cur = conn.cursor() for i in range(1,101): value = [ time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()), time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()), random.randint(0, 1000), random.randint(0, 1), random.randint(1, 100), random.randint(1, 100) ] cur.execute('insert into friend(a_time,c_time,distance,state,friend_id,user_id) values(%s,%s,%s,%s,%s,%s)', value) conn.commit() cur.close() conn.close()
def initCircle(): """初始化圈子表""" conn = initconn.getConn() cur = conn.cursor() for i in range(100): value = [ str(i), time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()), "iconpath" + str(i), "introduce" + str(i), "picpath" + str(i), str(1), "title" + str(i), random.randint(0, 99) ] cur.execute('insert into circle values(%s,%s,%s,%s,%s,%s,%s,%s)', value) conn.commit() cur.close() conn.close()
def initCircle(): """初始化圈子表""" conn = initconn.getConn() cur = conn.cursor() for i in range(1,101): value = [ time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()), "iconpath" + str(i), "introduce" + str(i), "picpath" + str(i), str(1), "title" + str(i), random.randint(1, 100) ] cur.execute('insert into circle(c_time,iconpath,introduce,picpath,state,title,create_userid) values(%s,%s,%s,%s,%s,%s,%s)', value) conn.commit() cur.close() conn.close()
def initCmt(table): conn = initconn.getConn() cur = conn.cursor() circleIds = [0] * 10 # 定义长度为10的数组 # 先插入10条一级评论 for i in range(10): circleIds[i] = random.randint(0, 99) value = [ str(i), "content" + str(i), time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()), random.randint(0, 99), random.randint(0, 99), random.randint(0, 99) ] if table == "newscmt": value[5] = circleIds[i] if table == "circmt" or table == "atvcmt": value[4] = circleIds[i] cur.execute('insert into ' + table + ' values(%s,%s,%s,%s,%s,%s,null)', value) conn.commit() # 插入90条 子评论 for i in range(11, 100, 1): parentCmtId = random.randint(0, 9) value = [ str(i), "content" + str(i), time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()), random.randint(0, 99), random.randint(0, 99), random.randint(0, 99), parentCmtId ] if table == "newscmt": value[5] = circleIds[parentCmtId] if table == "circmt" or table == "atvcmt": value[4] = circleIds[parentCmtId] cur.execute('insert into ' + table + ' values(%s,%s,%s,%s,%s,%s,%s)', value) conn.commit() cur.close() conn.close()
def resetReason(): try: conn = initconn.getConn() cur = conn.cursor() reason = ["色情", "欺诈", "诋毁侮辱", "广告骚扰", "政治", "非交大校友", "其他"] for i in range(1,101): value = [ reason[random.randint(0, 6)], str(i) ] cur.execute('update inform set reason=%s where id=%s', value) conn.commit() cur.close() conn.close() except MySQLdb.Error, e: print "Mysql Error %d: %s" % (e.args[0], e.args[1])
def initFriends(): """好友信息表""" conn = initconn.getConn() cur = conn.cursor() for i in range(100): value = [ str(i), time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()), time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()), random.randint(0, 1000), random.randint(0, 1), random.randint(0, 99), random.randint(0, 99) ] cur.execute('insert into friend values(%s,%s,%s,%s,%s,%s,%s)', value) conn.commit() cur.close() conn.close()
def initNews(): """初始化资讯表""" conn = initconn.getConn() cur = conn.cursor() type = ["投融资", "思源创业", "合作商机", "互帮互助", "校友企业", "求职招聘", "新闻动态", "在水一方"] for i in range(100): value = [ str(i), "content" + str(i), time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()), "path" + str(i), str(1), str(1), "title" + str(i), type[random.randint(0, 7)], str(i) ] cur.execute('insert into news values(%s,%s,%s,%s,%s,%s,%s,%s,%s)', value) conn.commit() cur.close() conn.close()
def inituser(): """初始化用户表""" try: conn = initconn.getConn() cur = conn.cursor() for i in range(100): value = [ i, time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()), "pass" + str(i), str(1), "111111" + str(i) ] cur.execute('insert into user values(%s,%s,%s,%s,%s)', value) conn.commit() cur.close() conn.close() except MySQLdb.Error, e: print "Mysql Error %d: %s" % (e.args[0], e.args[1])
def initVerifyCode(): """初始化验证码""" try: conn = initconn.getConn() cur = conn.cursor() for i in range(1, 101): value = [ str(i), time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()), "111111" + str(i), "123456" ] cur.execute('insert into verifycode(id,c_time,phone,verifycode) values(%s,%s,%s,%s)', value) conn.commit() cur.close() conn.close() except MySQLdb.Error, e: print "Mysql Error %d: %s" % (e.args[0], e.args[1])
def initInvitatecode(): """初始化邀请码""" try: conn = initconn.getConn() cur = conn.cursor() for i in range(1, 101): value = [ str(i), "123456", time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()), random.randint(1,100) ] cur.execute('insert into invitatecode(id,code,c_time,create_userid) values(%s,%s,%s,%s)', value) conn.commit() cur.close() conn.close() except MySQLdb.Error, e: print "Mysql Error %d: %s" % (e.args[0], e.args[1])
def initAlumnus(): """用户详细信息表""" conn = initconn.getConn() cur = conn.cursor() for i in range(100): value = [ str(i), "company" + str(i), "department" + str(i), "email" + str(i) + "@qq.com", "enrealname" + str(i), "grade" + str(i), "headpicpath" + str(i), str(round(random.random() * 360, 2)), str(round(random.random() * 360, 2)), "111111" + str(i), "realname" + str(i), "school" + str(i), random.randint(0, 1), "title" + str(i), "weixin" + str(i), str(i) ] cur.execute( 'insert into alumnus values(%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)', value) conn.commit() cur.close() conn.close()
def initspecolumn(): """专栏""" try: conn = initconn.getConn() cur = conn.cursor() value = [1, "150周年校庆", "这是150周年校庆专栏"] cur.execute("insert into specolumn(id,columnname,columndesc) values(%s,%s,%s)", value) value = [2, "专栏2", "专栏2描述"] cur.execute("insert into specolumn(id,columnname,columndesc) values(%s,%s,%s)", value) value = [3, "专栏3", "专栏3描述"] cur.execute("insert into specolumn(id,columnname,columndesc) values(%s,%s,%s)", value) value = [4, "专栏4", "专栏4描述"] cur.execute("insert into specolumn(id,columnname,columndesc) values(%s,%s,%s)", value) conn.commit() cur.close() conn.close() except MySQLdb.Error, e: print "Mysql Error %d: %s" % (e.args[0], e.args[1])
def initmessage(): """初始化消息表""" try: conn = initconn.getConn() cur = conn.cursor() for i in range(100): value = [ i, "attachpath" + str(i), "content" + str(i), time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()), random.randint(0, 1), "title" + str(i), str(random.randint(0, 99)), str(random.randint(0, 99)) ] cur.execute('insert into message values(%s,%s,%s,%s,%s,%s,%s,%s)', value) conn.commit() cur.close() conn.close() except MySQLdb.Error, e: print "Mysql Error %d: %s" % (e.args[0], e.args[1])
def initTopic(): """初始化话题表""" conn = initconn.getConn() cur = conn.cursor() for i in range(1, 101): value = [ "content" + str(i), time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()), "path" + str(i), str(1), str(1), str(1), str(1), random.randint(1, 5), str(i) ] cur.execute( 'insert into topic(content,c_time,picpath,pv,lv,sv,state,type_id,create_userid)' ' values(%s,%s,%s,%s,%s,%s,%s,%s,%s)', value) conn.commit() cur.close() conn.close()
def initfocus(): """焦点推荐""" try: conn = initconn.getConn() cur = conn.cursor() id = random.randint(0, 99) value = [ 1, "", "", 1, id, "", "资讯", "pc/admin/news/view?id=" + str(id) ] cur.execute('insert into focus values(%s,%s,%s,%s,%s,%s,%s,%s)', value) id = random.randint(0, 99) value = [ 2, "", "", 2, id, "", "资讯", "pc/admin/news/view?id=" + str(id) ] cur.execute('insert into focus values(%s,%s,%s,%s,%s,%s,%s,%s)', value) id = random.randint(0, 99) value = [ 3, "", "", 3, id, "", "活动", "pc/admin/activity/view?id=" + str(id) ] cur.execute('insert into focus values(%s,%s,%s,%s,%s,%s,%s,%s)', value) id = random.randint(0, 99) value = [ 4, "", "", 4, id, "", "活动", "pc/admin/activity/view?id=" + str(id) ] cur.execute('insert into focus values(%s,%s,%s,%s,%s,%s,%s,%s)', value) id = random.randint(0, 99) value = [ 5, "", "", 5, id, "", "资讯", "pc/admin/news/view?id=" + str(id) ] cur.execute('insert into focus values(%s,%s,%s,%s,%s,%s,%s,%s)', value) id = random.randint(0, 99) value = [ 6, "", "", 6, id, "", "资讯", "pc/admin/news/view?id=" + str(id) ] cur.execute('insert into focus values(%s,%s,%s,%s,%s,%s,%s,%s)', value) id = random.randint(0, 99) value = [ 7, "", "", 7, id, "", "圈子", "pc/admin/circle/view?id=" + str(id) ] cur.execute('insert into focus values(%s,%s,%s,%s,%s,%s,%s,%s)', value) id = random.randint(0, 99) value = [ 8, "", "", 8, id, "", "圈子", "pc/admin/circle/view?id=" + str(id) ] cur.execute('insert into focus values(%s,%s,%s,%s,%s,%s,%s,%s)', value) id = random.randint(0, 99) value = [ 9, "", "", 9, id, "", "圈子", "pc/admin/circle/view?id=" + str(id) ] cur.execute('insert into focus values(%s,%s,%s,%s,%s,%s,%s,%s)', value) id = random.randint(0, 99) value = [ 10, "", "", 10, id, "", "圈子", "pc/admin/circle/view?id=" + str(id) ] cur.execute('insert into focus values(%s,%s,%s,%s,%s,%s,%s,%s)', value) conn.commit() cur.close() conn.close() except MySQLdb.Error, e: print "Mysql Error %d: %s" % (e.args[0], e.args[1])