migration: detach permissions defaults migration from current models.

This was causing that latest code was used results in potential problems
during migration. Now we use the bound migraiton code that always will
perform the same exact migrations independent of the current code changes.

rhodecode/lib/dbmigrate/utils.py

@@ -0,0 +1,56 b''
+# -*- coding: utf-8 -*-
+
+# Copyright (C) 2010-2017 RhodeCode GmbH
+#
+# This program is free software: you can redistribute it and/or modify
+# it under the terms of the GNU Affero General Public License, version 3
+# (only), as published by the Free Software Foundation.
+#
+# This program is distributed in the hope that it will be useful,
+# but WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+# GNU General Public License for more details.
+#
+# You should have received a copy of the GNU Affero General Public License
+# along with this program.  If not, see <http://www.gnu.org/licenses/>.
+#
+# This program is dual-licensed. If you wish to learn more about the
+# RhodeCode Enterprise Edition, including its added features, Support services,
+# and proprietary license terms, please see https://rhodecode.com/licenses/
+
+import logging
+
+log = logging.getLogger(__name__)
+
+
+def create_default_permissions(_SESSION, db):
+    for p in db.Permission.PERMS:
+        if not db.Permission.get_by_key(p[0]):
+            new_perm = db.Permission()
+            new_perm.permission_name = p[0]
+            new_perm.permission_longname = p[0]  # translation err with p[1]
+            _SESSION().add(new_perm)
+
+
+def create_default_object_permission(_SESSION, db):
+
+    obj = db.User.get_by_username(db.User.DEFAULT_USER)
+    obj_perms = db.UserToPerm.query().filter(db.UserToPerm.user == obj).all()
+
+    def _get_group(perm_name):
+        return '.'.join(perm_name.split('.')[:1])
+
+    defined_perms_groups = map(
+        _get_group, (x.permission.permission_name for x in obj_perms))
+    log.debug('GOT ALREADY DEFINED:%s', obj_perms)
+
+    # for every default permission that needs to be created, we check if
+    # it's group is already defined, if it's not we create default perm
+    for perm_name in db.Permission.DEFAULT_USER_PERMISSIONS:
+        gr = _get_group(perm_name)
+        if gr not in defined_perms_groups:
+            log.debug('GR:%s not found, creating permission %s', gr, perm_name)
+            new_perm = db.UserToPerm()
+            new_perm.user = obj
+            new_perm.permission = db.Permission.get_by_key(perm_name)
+            _SESSION().add(new_perm)

rhodecode/lib/dbmigrate/versions/040_version_3_0_0.py

@@ -1,47 +1,39 b''
 import logging
-import datetime
 
 from sqlalchemy import *
-from sqlalchemy.exc import DatabaseError
-from sqlalchemy.orm import relation, backref, class_mapper, joinedload
-from sqlalchemy.orm.session import Session
-from sqlalchemy.ext.declarative import declarative_base
 
-from rhodecode.lib.dbmigrate.migrate import *
-from rhodecode.lib.dbmigrate.migrate.changeset import *
-from rhodecode.lib.utils2 import str2bool
-
-from rhodecode.model.meta import Base
 from rhodecode.model import meta
 from rhodecode.lib.dbmigrate.versions import _reset_base, notify
-
+from rhodecode.lib.dbmigrate.utils import (
+    create_default_object_permission, create_default_permissions)
 log = logging.getLogger(__name__)
 
 
 def upgrade(migrate_engine):
     """
     Upgrade operations go here.
     Don't create your own engine; bind migrate_engine to your metadata
     """
     _reset_base(migrate_engine)
     from rhodecode.lib.dbmigrate.schema import db_3_0_0_0
 
     # issue fixups
     fixups(db_3_0_0_0, meta.Session)
 
 
 def downgrade(migrate_engine):
     meta = MetaData()
     meta.bind = migrate_engine
 
 
 def fixups(models, _SESSION):
-    # ** create default permissions ** #
-    from rhodecode.model.permission import PermissionModel
-    PermissionModel(_SESSION()).create_permissions()
+    # create default permissions
+    create_default_permissions(_SESSION, models)
+    log.info('created default global permissions definitions')
     _SESSION().commit()
 
-    res = PermissionModel(_SESSION()).create_default_user_permissions(
-        models.User.DEFAULT_USER)
-    log.info('created default permission %s', res)
+    # fix default object permissions
+    create_default_object_permission(_SESSION, models)
+
+    log.info('created default permission')
     _SESSION().commit()

rhodecode/lib/dbmigrate/versions/061_version_4_5_0.py

@@ -1,42 +1,37 b''
 import logging
-import datetime
 
 from sqlalchemy import *
-from sqlalchemy.exc import DatabaseError
-from sqlalchemy.orm import relation, backref, class_mapper, joinedload
-from sqlalchemy.orm.session import Session
-from sqlalchemy.ext.declarative import declarative_base
-
-from rhodecode.lib.dbmigrate.migrate import *
-from rhodecode.lib.dbmigrate.migrate.changeset import *
-from rhodecode.lib.utils2 import str2bool
-
-from rhodecode.model.meta import Base
 from rhodecode.model import meta
 from rhodecode.lib.dbmigrate.versions import _reset_base, notify
-
+from rhodecode.lib.dbmigrate.utils import (
+    create_default_object_permission, create_default_permissions)
 log = logging.getLogger(__name__)
 
 
 def upgrade(migrate_engine):
     """
     Upgrade operations go here.
     Don't create your own engine; bind migrate_engine to your metadata
     """
     _reset_base(migrate_engine)
     from rhodecode.lib.dbmigrate.schema import db_4_5_0_0
 
     fixups(db_4_5_0_0, meta.Session)
 
+
 def downgrade(migrate_engine):
     meta = MetaData()
     meta.bind = migrate_engine
 
+
 def fixups(models, _SESSION):
-    # ** create default permissions ** #
-    from rhodecode.model.permission import PermissionModel
-    PermissionModel(_SESSION()).create_permissions()
+    # create default permissions
+    create_default_permissions(_SESSION, models)
+    log.info('created default global permissions definitions')
+    _SESSION().commit()
 
-    res = PermissionModel(_SESSION()).create_default_user_permissions(
-        models.User.DEFAULT_USER)
+    # fix default object permissions
+    create_default_object_permission(_SESSION, models)
+
+    log.info('created default permission')
     _SESSION().commit()