def article_detail(request,article_id): conn = conn_mysql.connMysql() runStatement = "select blogapp_categoryname.id,category_name,count(category_name) as count from blogapp_categoryname,blogapp_article where category_id = blogapp_categoryname.id group by category_name order by blogapp_categoryname.id;" category = conn.connMysql(runStatement) archives_list = article.objects.values('archives_date').annotate(m_amount =Count('archives_date')) article_obj = article.objects.get(id=article_id) latest_article = article.objects.order_by('-id') category_name = categoryName.objects.order_by('id') return render_to_response("article_detail.html",{'archives_list':archives_list,'article_obj':article_obj,'latest_article':latest_article,'category':category,'category_name':category_name})
def category(request,category_Name): #category archives conn = conn_mysql.connMysql() runStatement = "select blogapp_categoryname.id,category_name,count(category_name) as count from blogapp_categoryname,blogapp_article where category_id = blogapp_categoryname.id group by category_name order by blogapp_categoryname.id;" category = conn.connMysql(runStatement) category_list = article.objects.filter(category = category_Name) archives_list = article.objects.values('archives_date').annotate(m_amount =Count('archives_date')) index_content = article.objects.order_by('-id')[0] latest_article = article.objects.order_by('-id') category_name = categoryName.objects.order_by('id') return render_to_response("category.html",{'archives_list':archives_list,'index_content':index_content,'latest_article':latest_article,'category':category,'category_name':category_name,'category_list':category_list})
def index(request): conn = conn_mysql.connMysql() runStatement = "select blogapp_categoryname.id,category_name,count(category_name) as count from blogapp_categoryname,blogapp_article where category_id = blogapp_categoryname.id group by category_name order by blogapp_categoryname.id;" category = conn.connMysql(runStatement) print category archives_list = article.objects.values('archives_date').annotate(m_amount =Count('archives_date')) #article archives index_content = article.objects.order_by('-id')[0] #latest content latest_article = article.objects.order_by('-id') #recent articles #category = article.objects.values('category').annotate(m_amount =Count('category')) #category archives category_name = categoryName.objects.order_by('id') return render_to_response("index.html",{'archives_list':archives_list,'index_content':index_content,'latest_article':latest_article,'category':category,'category_name':category_name})