def get_subject_next_article(s_id,id):
sql = "select id,title from article a where (subject like %s or subject like %s) and id<"+str(id)+" ORDER BY id desc limit 0,1"
articles=execute_subject_query(s_id,sql=sql)
if articles:
one={}
one['id']=articles[0][0]
one['title']=articles[0][1]
return one
else:
return None
def get_articles_by_subject(id,start=None,end=None):
data=[]
sql = "select id,user_id,title,content,create_time from article a where subject like %s or subject like %s order by create_time desc limit "+str(start)+","+str(end)+""
articles=execute_subject_query(id,sql=sql)
for a in articles:
a_id,user_id,title,content,create_time=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_questions_by_subject(id,start=None,end=None):
data=[]
sql = "select id,user_id,question,answer_count,create_time,subject,tag,anonymity from question where subject like %s or subject like %s limit "+str(start)+","+str(end)+""
questions=execute_subject_query(id,sql=sql)
for a in questions:
q_id,user_id,question,answer_count,create_time,subject,tag,anonymity=a
q={}
q['id']=q_id
q['user_id']=user_id
q['question']=question
q['answer_count']=answer_count
q['create_time']=create_time
q['anonymity']=anonymity
one = {}
one['q']=q
one['u']=User.objects.get(id=user_id)
one['s']=get_c_subjects(subject)
one['t']=get_c_tags(tag)
data.append(one)
return data
def count_topic_subjects(): subjects= Subject.objects.all() for s in subjects: result = execute_subject_query(s.id,'topic') Subject.objects.filter(id=s.id).update(topic_count=result[0][0])
def count_question_subjects(): subjects= Subject.objects.all() for s in subjects: result = execute_subject_query(s.id,'question') Subject.objects.filter(id=s.id).update(question_count=result[0][0])
def count_article_subjects(): subjects= Subject.objects.all() for s in subjects: result = execute_subject_query(s.id,'article') Subject.objects.filter(id=s.id).update(article_count=result[0][0])
def get_some_subject_question_count(id): return execute_subject_query(id,'question')[0][0]
def get_some_subject_article_count(id): return execute_subject_query(id,'article')[0][0]
