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]