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})
