From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from pigeon.gentoo.org ([208.92.234.80] helo=lists.gentoo.org) by finch.gentoo.org with esmtp (Exim 4.60) (envelope-from ) id 1Skf0V-0001dB-I5 for garchives@archives.gentoo.org; Fri, 29 Jun 2012 17:29:23 +0000 Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id 93F96E0281; Fri, 29 Jun 2012 17:29:13 +0000 (UTC) Received: from smtp.gentoo.org (smtp.gentoo.org [140.211.166.183]) by pigeon.gentoo.org (Postfix) with ESMTP id 66251E0281 for ; Fri, 29 Jun 2012 17:29:13 +0000 (UTC) Received: from hornbill.gentoo.org (hornbill.gentoo.org [94.100.119.163]) (using TLSv1 with cipher AECDH-AES256-SHA (256/256 bits)) (No client certificate requested) by smtp.gentoo.org (Postfix) with ESMTPS id 9F04F1B40A8 for ; Fri, 29 Jun 2012 17:29:12 +0000 (UTC) Received: from localhost.localdomain (localhost [127.0.0.1]) by hornbill.gentoo.org (Postfix) with ESMTP id 65E5FE5438 for ; Fri, 29 Jun 2012 17:29:11 +0000 (UTC) From: "Slava Bacherikov" To: gentoo-commits@lists.gentoo.org Content-type: text/plain; charset=UTF-8 Reply-To: gentoo-dev@lists.gentoo.org, "Slava Bacherikov" Message-ID: <1340988971.f6a01a82001fed88cfa5b767d40b824e9abd45b2.bacher09@gentoo> Subject: [gentoo-commits] proj/gentoo-packages:master commit in: gpackages/apps/packages/ X-VCS-Repository: proj/gentoo-packages X-VCS-Files: gpackages/apps/packages/urls.py gpackages/apps/packages/views.py X-VCS-Directories: gpackages/apps/packages/ X-VCS-Committer: bacher09 X-VCS-Committer-Name: Slava Bacherikov X-VCS-Revision: f6a01a82001fed88cfa5b767d40b824e9abd45b2 X-VCS-Branch: master Date: Fri, 29 Jun 2012 17:29:11 +0000 (UTC) Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-commits@lists.gentoo.org Content-Transfer-Encoding: quoted-printable X-Archives-Salt: 19f5fbc5-510d-4996-9103-3db405633084 X-Archives-Hash: 4a4a0329cb21cc1c75e5cfa7f6a3a8c0 commit: f6a01a82001fed88cfa5b767d40b824e9abd45b2 Author: Slava Bacherikov bacher09 org> AuthorDate: Fri Jun 29 16:54:38 2012 +0000 Commit: Slava Bacherikov bacherikov org ua> CommitDate: Fri Jun 29 16:56:11 2012 +0000 URL: http://git.overlays.gentoo.org/gitweb/?p=3Dproj/gentoo-packag= es.git;a=3Dcommit;h=3Df6a01a82 Change urls --- gpackages/apps/packages/urls.py | 3 ++- gpackages/apps/packages/views.py | 8 ++++++++ 2 files changed, 10 insertions(+), 1 deletions(-) diff --git a/gpackages/apps/packages/urls.py b/gpackages/apps/packages/ur= ls.py index 3744802..ffb16ca 100644 --- a/gpackages/apps/packages/urls.py +++ b/gpackages/apps/packages/urls.py @@ -15,5 +15,6 @@ urlpatterns =3D patterns('', # In Future I will write my onw URL Resolver !!! #url(r'^package/(?:(?P\d+)|(?P[^/]+)/(?P[^/]+))/= $', PackageDetailView.as_view(), name =3D 'package'), url(r'^package/(?P\d+)/$', PackageDetailView.as_view(), name =3D= 'package'), - url(r'^package/(?P[^/]+)/(?P[^/:]+)(::(?P[^/]+))?/$', PackageDetailView.as_view(), name =3D 'package'), + url(r'^package/(?P[^/]+)/(?P[^/:]+)/$', PackageDetai= lView.as_view(), name =3D 'package'), + url(r'^package/(?P[^/]+)/(?P[^/:]+)::(?P= [^/]+)/$', PackageDetailView.as_view(), name =3D 'package'), ) diff --git a/gpackages/apps/packages/views.py b/gpackages/apps/packages/v= iews.py index 3b4cd23..2ec2758 100644 --- a/gpackages/apps/packages/views.py +++ b/gpackages/apps/packages/views.py @@ -54,6 +54,14 @@ class PackagesListsView(ContextListView): extra_context =3D {'page_name': 'Packages', 'arches': arches} template_name =3D 'packages.html' context_object_name =3D 'packages' + # Faster query !! + #SELECT t.id, t.virtual_package_id, t.description, t.repository_id, = vp.id + #as virtual_package__name FROM=20 + #(SELECT * FROM packages_packagemodel=20 + #ORDER BY updated_datetime DESC LIMIT 3 ) as t=20 + #INNER JOIN packages_virtualpackagemodel vp=20 + #ON( `vp`.id =3D t.virtual_package_id) INNER JOIN `packages_category= model` cp + #ON (vp.category_id =3D cp.id); queryset =3D PackageModel.objects.all(). \ select_related('virtual_package', 'virtual_package__category'). \