def get_i_college_topic_count(user_id): us = UserSchool.objects.get(id=user_id) if us.college: sql=" select count(*) from user_school as us,topic as a where us.college = "+str(us.college)+" and a.user_id = us.id" result = custom_raw_sql(sql) if result: return result[0][0] else: return 0
def get_user_next_article(user_id,id):
sql = "select id,title from article where user_id=%d and id < %d ORDER BY id desc limit 0,1"%(user_id,id)
articles=custom_raw_sql(sql)
if articles:
one={}
one['id']=articles[0][0]
one['title']=articles[0][1]
return one
else:
return None
def get_prev_article(id):
sql = "select id,title from article where id > %d ORDER BY id asc limit 0,1"%(id)
articles = custom_raw_sql(sql)
if articles:
one={}
one['id']=articles[0][0]
one['title']=articles[0][1]
return one
else:
return None
def get_articles_by_i_college(user_id,start,end):
us = UserSchool.objects.get(id=user_id)
data=[]
if us.college:
sql = "select a.id,a.user_id,a.title,a.create_time,a.content from user_school us,article a where us.college="+str(us.college)+" and us.id = a.user_id order by create_time desc limit "+str(start)+","+str(end)+""
articles=custom_raw_sql(sql)
for a in articles:
a_id,user_id,title,create_time,content=a
article={}
article['id']=a_id
article['user_id']=user_id
article['title']=title
article['content']=content
article['create_time']=create_time
one = {}
one['article']=article
one['author']=User.objects.get(id=user_id)
data.append(one)
return data
def get_i_college_limit_topics(user_id,start,end):
us = UserSchool.objects.get(id=user_id)
data=[]
if us.college:
sql = "select a.id,a.user_id,a.topic,a.create_time,a.comment_count,a.tag,a.subject from user_school us,topic a where us.college="+str(us.college)+" and us.id = a.user_id order by create_time desc,comment_count desc limit "+str(start)+","+str(end)+""
topics=custom_raw_sql(sql)
for a in topics:
id,user_id,t,create_time,comment_count,tag,subject=a
topic={}
topic['id']=id
topic['user_id']=user_id
topic['topic']=t
topic['comment_count']=comment_count
topic['create_time']=create_time
one={}
one['s']=get_c_subjects(subject)
one['t']=get_c_tags(tag)
one['p']=topic
one['user']=User.objects.get(id=user_id)
data.append(one)
return data