def queryByUserid(parameter):
template = t_query_user_userid
r = db.runQuerySql(template, parameter, 1)
#print r
if r is None:
return r
return User(r[0], r[1], r[2], r[3], r[4], r[5], r[6], r[7], r[8], r[9], r[10])
def insertWorks(parameter):
template = t_insert_works
#r = db.insert_works(u_id, w_name, cont, img, d_post, p_id)
r = db.runInsertSql(template, parameter)
template = t_query_lastworks
r = db.runQuerySql(template, parameter, 1)
return r[0]
def queryActivity(parameter):
template = t_query_activity
r = db.runQuerySql(template, parameter, 2)
if r is None:
return None
a = Activity(r[0], r[1], r[2], r[3])
return a
def query_nActivity(parameter):
template = t_query_nactivity
l = db.runQuerySql(template, parameter, 2)
activityList = []
if l is None:
return activityList
for r in l:
a = Activity(r[0], r[1], r[2], r[3])
activityList.append(a)
return activityList
def get_usersworks(parameter):
template = t_query_usersworks
l = db.runQuerySql(template, parameter, 2)
res = []
if l is None:
return res
for r in l:
w = Works(r[0], r[1], r[2], r[3], r[4], r[5], r[6])
res.append(w.getWorksInfo())
return res
def queryAllUser():
parameter = {}
template = t_query_alluser
l = db.runQuerySql(template, parameter, 2)
userList = []
if l is None:
return userList
for r in l:
u = User(r[0], r[1], r[2], r[3], r[4], r[5], r[6], r[7], r[8], r[9], r[10])
userList.append(u)
return userList
def queryComment(parameter):
template = t_query_comment
r = db.runQuerySql(template, parameter, 2)
commentList = []
if r is None:
return commentList
for item in r:
com = {}
com['c_id'] = item[0]
com['txt'] = item[1]
com['w_id'] = item[2]
com['u_id'] = item[3]
com['d_post'] = item[4]
com['nick'] = item[5]
com['photo'] = item[6]
com['sex'] = item[7]
commentList.append(com)
return commentList
def getFans(parameter):
template = t_query_fans
r = db.runQuerySql(template, parameter, 2)
fanlist = []
if r is None:
return fanlist
for item in r:
parameter = {}
parameter['id'] = item[0]
parameter['nick'] = item[3]
parameter['photo'] = item[4]
parameter['birth'] = item[5]
parameter['reg_date'] = item[6]
parameter['signa'] = item[7]
parameter['fol'] = item[8]
parameter['fan'] = item[9]
parameter['sex'] = item[10]
fanlist.append(parameter)
return fanlist
def queryWorks(parameter):
tamplate = t_query_works
p_name = [u'手绘', u'板绘', u'PS', u'厚涂', u'水彩']
#r = db.query_works(worksid)
r = db.runQuerySql(tamplate, parameter, 1)
workInfo = {}
if r is None:
return None
workInfo['w_id'] = r[0]
workInfo['u_id'] = r[1]
workInfo['w_name'] = r[2]
workInfo['cont'] = r[3]
try:
workInfo['img'] =json.loads(r[4])
except:
workInfo['img'] = r[4]
workInfo['d_post'] = r[5]
print r[6]
workInfo['p_id'] = p_name[r[6] - 1]
return workInfo
def find_user(parameter):
template = t_query_countuser_username
r = db.runQuerySql(template, parameter, 1)
if r[0] == 0:
return False
return True
def queryAdmin(parameter):
template = t_query_admin
r = db.runQuerySql(template, parameter, 1)
if r is None:
return None
return Manager(r[0], r[1], r[2])
def hasSignActivity(parameter):
template = t_query_sign_ac
r = db.runQuerySql(template, parameter)
if r[0] == 1:
return False
return True
def hasFollow(parameter):
template = t_query_relationship
r = db.runQuerySql(template, parameter, 1)
if r is None:
return False
return True