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 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 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 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 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 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 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 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])
