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 1Siw7X-00056N-VB for garchives@archives.gentoo.org; Sun, 24 Jun 2012 23:21:32 +0000 Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id EDD00E0B18; Sun, 24 Jun 2012 23:21:09 +0000 (UTC) Received: from smtp.gentoo.org (smtp.gentoo.org [140.211.166.183]) by pigeon.gentoo.org (Postfix) with ESMTP id AF8F2E0B18 for ; Sun, 24 Jun 2012 23:21:04 +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 832831B4389 for ; Sun, 24 Jun 2012 23:21:03 +0000 (UTC) Received: from localhost.localdomain (localhost [127.0.0.1]) by hornbill.gentoo.org (Postfix) with ESMTP id 786B8E5431 for ; Sun, 24 Jun 2012 23:21:01 +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: <1340471186.cffe07358db18dcead5bca370b03945ae304349e.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/models.py X-VCS-Directories: gpackages/apps/packages/ X-VCS-Committer: bacher09 X-VCS-Committer-Name: Slava Bacherikov X-VCS-Revision: cffe07358db18dcead5bca370b03945ae304349e X-VCS-Branch: master Date: Sun, 24 Jun 2012 23:21:01 +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: eb68b528-8327-4fe9-ada1-fc5bca62fc02 X-Archives-Hash: d04e48d837e443748a7bb505861e1ff7 commit: cffe07358db18dcead5bca370b03945ae304349e Author: Slava Bacherikov bacher09 org> AuthorDate: Sat Jun 23 17:06:26 2012 +0000 Commit: Slava Bacherikov bacherikov org ua> CommitDate: Sat Jun 23 17:06:26 2012 +0000 URL: http://git.overlays.gentoo.org/gitweb/?p=3Dproj/gentoo-packag= es.git;a=3Dcommit;h=3Dcffe0735 Add indexes --- gpackages/apps/packages/models.py | 32 ++++++++++++++++---------------= - 1 files changed, 16 insertions(+), 16 deletions(-) diff --git a/gpackages/apps/packages/models.py b/gpackages/apps/packages/= models.py index 614faa0..943b370 100644 --- a/gpackages/apps/packages/models.py +++ b/gpackages/apps/packages/models.py @@ -25,7 +25,7 @@ class HomepageModel(models.Model): return self.url =20 class ArchesModel(models.Model): - name =3D models.CharField(unique =3D True, max_length =3D 22) + name =3D models.CharField(unique =3D True, max_length =3D 22, db_ind= ex =3D True) =20 def __unicode__(self): return self.name @@ -43,7 +43,7 @@ class RepositoryModel(AbstractDateTimeModel): if repo is not None: self.init_by_repo(repo) =20 - name =3D models.CharField(unique =3D True, max_length =3D 60) + name =3D models.CharField(unique =3D True, max_length =3D 60, db_ind= ex =3D True) =20 # Additional info description =3D models.TextField(blank =3D True, null =3D True) @@ -114,7 +114,7 @@ class RepositoryModel(AbstractDateTimeModel): return self.name =20 class RepositoryFeedModel(models.Model): - repository =3D models.ForeignKey(RepositoryModel) + repository =3D models.ForeignKey(RepositoryModel, db_index =3D True) feed =3D models.URLField() =20 def __unicode__(self): @@ -129,7 +129,7 @@ class RepositorySourceModel(models.Model): repo_type =3D models.PositiveSmallIntegerField(choices =3D REPO_TYPE= ) url =3D models.CharField(max_length =3D 255) subpath =3D models.CharField(max_length =3D 100, blank =3D True, nul= l =3D True) - repository =3D models.ForeignKey(RepositoryModel) + repository =3D models.ForeignKey(RepositoryModel, db_index =3D True) =20 def __unicode__(self): return self.url @@ -149,7 +149,7 @@ class CategoryModel(models.Model): def check_or_need_update(self, category): return self.metadata_hash =3D=3D category.metadata_sha1 =20 - category =3D models.CharField(unique =3D True, max_length =3D 70) + category =3D models.CharField(unique =3D True, max_length =3D 70, db= _index =3D True) description =3D models.TextField(blank =3D True, null =3D True) metadata_hash =3D models.CharField(max_length =3D 128, null =3D True= ) =20 @@ -165,7 +165,7 @@ class MaintainerModel(AbstractDateTimeModel): self.init_by_maintainer(maintainer) =20 name =3D models.CharField(max_length =3D 255, blank =3D True, null =3D= True) - email =3D models.EmailField(unique =3D True, validators =3D [validat= e_email]) + email =3D models.EmailField(unique =3D True, validators =3D [validat= e_email], db_index =3D True) =20 objects =3D managers.MaintainerManager() =20 @@ -191,7 +191,7 @@ class HerdsModel(AbstractDateTimeModel): if herd is not None: self.init_by_herd(herd) =20 - name =3D models.CharField(unique =3D True, max_length =3D 150) + name =3D models.CharField(unique =3D True, max_length =3D 150, db_in= dex =3D True) email =3D models.EmailField(validators =3D [validate_email]) description =3D models.TextField(blank =3D True, null =3D True) maintainers =3D models.ManyToManyField(MaintainerModel, blank =3D Tr= ue) @@ -218,7 +218,7 @@ class HerdsModel(AbstractDateTimeModel): ordering =3D ('name',) =20 class VirtualPackageModel(models.Model): - name =3D models.CharField(max_length =3D 254) + name =3D models.CharField(max_length =3D 254, db_index =3D True) category =3D models.ForeignKey(CategoryModel) =20 objects =3D managers.VirtualPackageManager() @@ -243,7 +243,7 @@ class PackageModel(AbstractDateTimeModel): self.init_by_package(package_object, category =3D category) =20 =20 - virtual_package =3D models.ForeignKey(VirtualPackageModel) + virtual_package =3D models.ForeignKey(VirtualPackageModel, db_index = =3D True) changelog =3D models.TextField(blank =3D True, null =3D True) changelog_hash =3D models.CharField(max_length =3D 128) manifest_hash =3D models.CharField(max_length =3D 128) @@ -256,7 +256,7 @@ class PackageModel(AbstractDateTimeModel): maintainers =3D models.ManyToManyField(MaintainerModel, blank =3D Tr= ue) =20 description =3D models.TextField(blank =3D True, null =3D True) - repository =3D models.ForeignKey(RepositoryModel) + repository =3D models.ForeignKey(RepositoryModel, db_index =3D True) # Different versions can have different licenses, or homepages. =20 objects =3D managers.PackageManager() @@ -306,14 +306,14 @@ class PackageModel(AbstractDateTimeModel): unique_together =3D ('virtual_package', 'repository') =20 class UseFlagModel(models.Model): - name =3D models.CharField(unique =3D True, max_length =3D 60) + name =3D models.CharField(unique =3D True, max_length =3D 60, db_ind= ex =3D True) description =3D models.TextField(blank =3D True) =20 def __unicode__(self): return self.name =20 class UseFlagDescriptionModel(models.Model): - use_flag =3D models.ForeignKey(UseFlagModel) + use_flag =3D models.ForeignKey(UseFlagModel, db_index =3D True) package =3D models.ForeignKey(VirtualPackageModel) description =3D models.TextField() =20 @@ -327,7 +327,7 @@ class UseFlagDescriptionModel(models.Model): unique_together =3D ('use_flag', 'package') =20 class LicenseModel(models.Model): - name =3D models.CharField(unique =3D True, max_length =3D 60) + name =3D models.CharField(unique =3D True, max_length =3D 60, db_ind= ex =3D True) #description =3D TextField() =20 def __unicode__(self): @@ -335,9 +335,9 @@ class LicenseModel(models.Model): =20 =20 class EbuildModel(AbstractDateTimeModel): - package =3D models.ForeignKey(PackageModel) - version =3D models.CharField(max_length =3D 26) - revision =3D models.CharField(max_length =3D 12) + package =3D models.ForeignKey(PackageModel, db_index =3D True) + version =3D models.CharField(max_length =3D 26, db_index =3D True) + revision =3D models.CharField(max_length =3D 12, db_index =3D True) use_flags =3D models.ManyToManyField(UseFlagModel) licenses =3D models.ManyToManyField(LicenseModel) license =3D models.CharField(max_length =3D 254, blank =3D True )