changeset 2354:f3417f0d54b5 beta

fixed default sorting on main page with sorting using wrapped lower() call on database level
author Marcin Kuzminski <marcin@python-works.com>
date Mon, 28 May 2012 16:52:13 +0200
parents ef71d7e63806
children 2da7b5984ae5
files rhodecode/model/scm.py
diffstat 1 files changed, 3 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- a/rhodecode/model/scm.py	Mon May 28 16:51:22 2012 +0200
+++ b/rhodecode/model/scm.py	Mon May 28 16:52:13 2012 +0200
@@ -28,6 +28,8 @@
 import logging
 import cStringIO
 
+from sqlalchemy import func
+
 from rhodecode.lib.vcs import get_backend
 from rhodecode.lib.vcs.exceptions import RepositoryError
 from rhodecode.lib.vcs.utils.lazy import LazyProperty
@@ -223,7 +225,7 @@
         if all_repos is None:
             all_repos = self.sa.query(Repository)\
                         .filter(Repository.group_id == None)\
-                        .order_by(Repository.repo_name).all()
+                        .order_by(func.lower(Repository.repo_name)).all()
 
         repo_iter = CachedRepoList(all_repos, repos_path=self.repos_path,
                                    order_by=sort_key)