Mercurial > kallithea
changeset 1023:e7478ac19f9f beta
updated db migrations to schema 3
author | Marcin Kuzminski <marcin@python-works.com> |
---|---|
date | Fri, 11 Feb 2011 00:35:48 +0100 |
parents | 4f834b0abcd3 |
children | 22c147726ea6 |
files | rhodecode/lib/dbmigrate/versions/003_version_1_2_0.py rhodecode/model/db.py |
diffstat | 2 files changed, 43 insertions(+), 5 deletions(-) [+] |
line wrap: on
line diff
--- a/rhodecode/lib/dbmigrate/versions/003_version_1_2_0.py Fri Feb 11 00:13:09 2011 +0100 +++ b/rhodecode/lib/dbmigrate/versions/003_version_1_2_0.py Fri Feb 11 00:35:48 2011 +0100 @@ -22,20 +22,58 @@ #========================================================================== # Add table `groups`` #========================================================================== - from rhodecode.model.db import Group - Group().__table__.create() +# from rhodecode.model.db import Group +# Group().__table__.create() #========================================================================== # Add table `group_to_perm` #========================================================================== - from rhodecode.model.db import GroupToPerm - GroupToPerm().__table__.create() +# from rhodecode.model.db import GroupToPerm +# GroupToPerm().__table__.create() + + #========================================================================== + # Add table `users_groups` + #========================================================================== +# from rhodecode.model.db import UsersGroup +# UsersGroup().__table__.create() + + #========================================================================== + # Add table `users_groups_members` + #========================================================================== + from rhodecode.model.db import UsersGroupMember + UsersGroupMember().__table__.create() + + #========================================================================== + # Add table `users_group_to_perm` + #========================================================================== + from rhodecode.model.db import UsersGroupToPerm + UsersGroupToPerm().__table__.create() + + + #========================================================================== + # Upgrade of `users` table + #========================================================================== + from rhodecode.model.db import User + + #add column + ldap_dn = Column("ldap_dn", String(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None) + ldap_dn.create(User().__table__) + + + #remove old column + is_ldap = Column("is_ldap", Boolean(), nullable=False, unique=None, default=False) + is_ldap.drop(User().__table__) + #========================================================================== # Upgrade of `repositories` table #========================================================================== from rhodecode.model.db import Repository + #ADD downloads column# + enable_downloads = Column("downloads", Boolean(), nullable=True, unique=None, default=True) + enable_downloads.create(Repository().__table__) + #ADD group_id column# group_id = Column("group_id", Integer(), ForeignKey('groups.group_id'), nullable=True, unique=False, default=None)
--- a/rhodecode/model/db.py Fri Feb 11 00:13:09 2011 +0100 +++ b/rhodecode/model/db.py Fri Feb 11 00:35:48 2011 +0100 @@ -180,7 +180,7 @@ user = relationship('User', lazy='joined') users_group = relationship('UsersGroup') - def __init__(self, gr_id, u_id): + def __init__(self, gr_id='', u_id=''): self.users_group_id = gr_id self.user_id = u_id