kallithea: rhodecode/lib/db_manage.py annotate

annotate rhodecode/lib/db_manage.py @ 1203:6832ef664673 beta

source code cleanup: remove trailing white space, normalize file endings

author	Marcin Kuzminski <marcin@python-works.com>
date	Sun, 03 Apr 2011 18:23:15 +0200
parents	9c45e11493fb
children	a671db5bdd58

rev	line source
835 08d2dcd71666 fixed imports on migrate, added getting current version from database Marcin Kuzminski <marcin@python-works.com> parents: 834 diff changeset	1 # -- coding: utf-8 --
08d2dcd71666 fixed imports on migrate, added getting current version from database Marcin Kuzminski <marcin@python-works.com> parents: 834 diff changeset	2 """
08d2dcd71666 fixed imports on migrate, added getting current version from database Marcin Kuzminski <marcin@python-works.com> parents: 834 diff changeset	3 rhodecode.lib.db_manage
08d2dcd71666 fixed imports on migrate, added getting current version from database Marcin Kuzminski <marcin@python-works.com> parents: 834 diff changeset	4 ~~~~~~~~~~~~~~~~~~~~~~~
08d2dcd71666 fixed imports on migrate, added getting current version from database Marcin Kuzminski <marcin@python-works.com> parents: 834 diff changeset	5
838 12eb1a018199 db migrations: Marcin Kuzminski <marcin@python-works.com> parents: 837 diff changeset	6 Database creation, and setup module for RhodeCode. Used for creation
12eb1a018199 db migrations: Marcin Kuzminski <marcin@python-works.com> parents: 837 diff changeset	7 of database as well as for migration operations
1203 6832ef664673 source code cleanup: remove trailing white space, normalize file endings Marcin Kuzminski <marcin@python-works.com> parents: 1138 diff changeset	8
835 08d2dcd71666 fixed imports on migrate, added getting current version from database Marcin Kuzminski <marcin@python-works.com> parents: 834 diff changeset	9 :created_on: Apr 10, 2010
08d2dcd71666 fixed imports on migrate, added getting current version from database Marcin Kuzminski <marcin@python-works.com> parents: 834 diff changeset	10 :author: marcink
1203 6832ef664673 source code cleanup: remove trailing white space, normalize file endings Marcin Kuzminski <marcin@python-works.com> parents: 1138 diff changeset	11 :copyright: (C) 2009-2011 Marcin Kuzminski <marcin@python-works.com>
835 08d2dcd71666 fixed imports on migrate, added getting current version from database Marcin Kuzminski <marcin@python-works.com> parents: 834 diff changeset	12 :license: GPLv3, see COPYING for more details.
08d2dcd71666 fixed imports on migrate, added getting current version from database Marcin Kuzminski <marcin@python-works.com> parents: 834 diff changeset	13 """
252 3782a6d698af licensing updates, code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 249 diff changeset	14 # This program is free software; you can redistribute it and/or
3782a6d698af licensing updates, code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 249 diff changeset	15 # modify it under the terms of the GNU General Public License
3782a6d698af licensing updates, code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 249 diff changeset	16 # as published by the Free Software Foundation; version 2
3782a6d698af licensing updates, code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 249 diff changeset	17 # of the License or (at your opinion) any later version of the license.
1203 6832ef664673 source code cleanup: remove trailing white space, normalize file endings Marcin Kuzminski <marcin@python-works.com> parents: 1138 diff changeset	18 #
252 3782a6d698af licensing updates, code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 249 diff changeset	19 # This program is distributed in the hope that it will be useful,
3782a6d698af licensing updates, code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 249 diff changeset	20 # but WITHOUT ANY WARRANTY; without even the implied warranty of
3782a6d698af licensing updates, code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 249 diff changeset	21 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
3782a6d698af licensing updates, code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 249 diff changeset	22 # GNU General Public License for more details.
1203 6832ef664673 source code cleanup: remove trailing white space, normalize file endings Marcin Kuzminski <marcin@python-works.com> parents: 1138 diff changeset	23 #
252 3782a6d698af licensing updates, code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 249 diff changeset	24 # You should have received a copy of the GNU General Public License
3782a6d698af licensing updates, code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 249 diff changeset	25 # along with this program; if not, write to the Free Software
3782a6d698af licensing updates, code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 249 diff changeset	26 # Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston,
3782a6d698af licensing updates, code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 249 diff changeset	27 # MA 02110-1301, USA.
3782a6d698af licensing updates, code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 249 diff changeset	28
249 bad9ccac26b7 fixed import errors on db_manage Marcin Kuzminski <marcin@python-works.com> parents: 243 diff changeset	29 import os
bad9ccac26b7 fixed import errors on db_manage Marcin Kuzminski <marcin@python-works.com> parents: 243 diff changeset	30 import sys
327 0e87466a117e updated installation instruction, made more user friendly way of creating all needed configs. All is done now from paster setup-app Marcin Kuzminski <marcin@python-works.com> parents: 307 diff changeset	31 import uuid
835 08d2dcd71666 fixed imports on migrate, added getting current version from database Marcin Kuzminski <marcin@python-works.com> parents: 834 diff changeset	32 import logging
08d2dcd71666 fixed imports on migrate, added getting current version from database Marcin Kuzminski <marcin@python-works.com> parents: 834 diff changeset	33 from os.path import dirname as dn, join as jn
08d2dcd71666 fixed imports on migrate, added getting current version from database Marcin Kuzminski <marcin@python-works.com> parents: 834 diff changeset	34
08d2dcd71666 fixed imports on migrate, added getting current version from database Marcin Kuzminski <marcin@python-works.com> parents: 834 diff changeset	35 from rhodecode import __dbversion__
08d2dcd71666 fixed imports on migrate, added getting current version from database Marcin Kuzminski <marcin@python-works.com> parents: 834 diff changeset	36 from rhodecode.model import meta
249 bad9ccac26b7 fixed import errors on db_manage Marcin Kuzminski <marcin@python-works.com> parents: 243 diff changeset	37
1116 716911af91e1 Added api_key into user, api key get's generated again after password change Marcin Kuzminski <marcin@python-works.com> parents: 1094 diff changeset	38 from rhodecode.lib.auth import get_crypt_password, generate_api_key
547 1e757ac98988 renamed project to rhodecode Marcin Kuzminski <marcin@python-works.com> parents: 533 diff changeset	39 from rhodecode.lib.utils import ask_ok
1e757ac98988 renamed project to rhodecode Marcin Kuzminski <marcin@python-works.com> parents: 533 diff changeset	40 from rhodecode.model import init_model
549 f99075170eb4 more renames for rhode code !! Marcin Kuzminski <marcin@python-works.com> parents: 547 diff changeset	41 from rhodecode.model.db import User, Permission, RhodeCodeUi, RhodeCodeSettings, \
835 08d2dcd71666 fixed imports on migrate, added getting current version from database Marcin Kuzminski <marcin@python-works.com> parents: 834 diff changeset	42 UserToPerm, DbMigrateVersion
08d2dcd71666 fixed imports on migrate, added getting current version from database Marcin Kuzminski <marcin@python-works.com> parents: 834 diff changeset	43
239 b18f89d6d17f Adde draft for permissions systems, made all needed decorators, and checks. For future usage in the system. Marcin Kuzminski <marcin@python-works.com> parents: 234 diff changeset	44 from sqlalchemy.engine import create_engine
835 08d2dcd71666 fixed imports on migrate, added getting current version from database Marcin Kuzminski <marcin@python-works.com> parents: 834 diff changeset	45
351 d09381593b12 updated db manage script, and remove broken test Marcin Kuzminski <marcin@python-works.com> parents: 350 diff changeset	46 log = logging.getLogger(__name__)
66 163464441e0d updated db manage script for creating interactive admin account and db Marcin Kuzminski <marcin@python-blog.com> parents: 59 diff changeset	47
226 c6526b7531e9 rewritten db manage script to use sqlalchemy. Fixed sqlalchemy models to more generic. Marcin Kuzminski <marcin@python-works.com> parents: 88 diff changeset	48 class DbManage(object):
781 7ae66bddf48d fixed db manage, to work on other databases than sqlite Marcin Kuzminski <marcin@python-works.com> parents: 773 diff changeset	49 def __init__(self, log_sql, dbconf, root, tests=False):
7ae66bddf48d fixed db manage, to work on other databases than sqlite Marcin Kuzminski <marcin@python-works.com> parents: 773 diff changeset	50 self.dbname = dbconf.split('/')[-1]
459 7c978511c951 implemented basic (startup) nose test suite. Marcin Kuzminski <marcin@python-works.com> parents: 417 diff changeset	51 self.tests = tests
552 2642f128ad46 removed egg info, update files for distutils build Marcin Kuzminski <marcin@python-works.com> parents: 549 diff changeset	52 self.root = root
781 7ae66bddf48d fixed db manage, to work on other databases than sqlite Marcin Kuzminski <marcin@python-works.com> parents: 773 diff changeset	53 self.dburi = dbconf
907 2f83756f3041 Fixed dbmigrate issues. Marcin Kuzminski <marcin@python-works.com> parents: 902 diff changeset	54 self.log_sql = log_sql
2f83756f3041 Fixed dbmigrate issues. Marcin Kuzminski <marcin@python-works.com> parents: 902 diff changeset	55 self.db_exists = False
2f83756f3041 Fixed dbmigrate issues. Marcin Kuzminski <marcin@python-works.com> parents: 902 diff changeset	56 self.init_db()
2f83756f3041 Fixed dbmigrate issues. Marcin Kuzminski <marcin@python-works.com> parents: 902 diff changeset	57
2f83756f3041 Fixed dbmigrate issues. Marcin Kuzminski <marcin@python-works.com> parents: 902 diff changeset	58 def init_db(self):
2f83756f3041 Fixed dbmigrate issues. Marcin Kuzminski <marcin@python-works.com> parents: 902 diff changeset	59 engine = create_engine(self.dburi, echo=self.log_sql)
226 c6526b7531e9 rewritten db manage script to use sqlalchemy. Fixed sqlalchemy models to more generic. Marcin Kuzminski <marcin@python-works.com> parents: 88 diff changeset	60 init_model(engine)
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	61 self.sa = meta.Session()
7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	62
226 c6526b7531e9 rewritten db manage script to use sqlalchemy. Fixed sqlalchemy models to more generic. Marcin Kuzminski <marcin@python-works.com> parents: 88 diff changeset	63 def create_tables(self, override=False):
837 60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	64 """Create a auth database
226 c6526b7531e9 rewritten db manage script to use sqlalchemy. Fixed sqlalchemy models to more generic. Marcin Kuzminski <marcin@python-works.com> parents: 88 diff changeset	65 """
837 60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	66
1138 9c45e11493fb fixed ldap settings creation, we need to fill in some bool defaults properly to make it work fine Marcin Kuzminski <marcin@python-works.com> parents: 1116 diff changeset	67 log.info("Any existing database is going to be destroyed")
9c45e11493fb fixed ldap settings creation, we need to fill in some bool defaults properly to make it work fine Marcin Kuzminski <marcin@python-works.com> parents: 1116 diff changeset	68 if self.tests:
9c45e11493fb fixed ldap settings creation, we need to fill in some bool defaults properly to make it work fine Marcin Kuzminski <marcin@python-works.com> parents: 1116 diff changeset	69 destroy = True
9c45e11493fb fixed ldap settings creation, we need to fill in some bool defaults properly to make it work fine Marcin Kuzminski <marcin@python-works.com> parents: 1116 diff changeset	70 else:
9c45e11493fb fixed ldap settings creation, we need to fill in some bool defaults properly to make it work fine Marcin Kuzminski <marcin@python-works.com> parents: 1116 diff changeset	71 destroy = ask_ok('Are you sure to destroy old database ? [y/n]')
9c45e11493fb fixed ldap settings creation, we need to fill in some bool defaults properly to make it work fine Marcin Kuzminski <marcin@python-works.com> parents: 1116 diff changeset	72 if not destroy:
9c45e11493fb fixed ldap settings creation, we need to fill in some bool defaults properly to make it work fine Marcin Kuzminski <marcin@python-works.com> parents: 1116 diff changeset	73 sys.exit()
9c45e11493fb fixed ldap settings creation, we need to fill in some bool defaults properly to make it work fine Marcin Kuzminski <marcin@python-works.com> parents: 1116 diff changeset	74 if destroy:
9c45e11493fb fixed ldap settings creation, we need to fill in some bool defaults properly to make it work fine Marcin Kuzminski <marcin@python-works.com> parents: 1116 diff changeset	75 meta.Base.metadata.drop_all()
964 84bb5b8b498d changed dev and tests to postgressql for more error proof setup. Marcin Kuzminski <marcin@python-works.com> parents: 907 diff changeset	76
351 d09381593b12 updated db manage script, and remove broken test Marcin Kuzminski <marcin@python-works.com> parents: 350 diff changeset	77 checkfirst = not override
d09381593b12 updated db manage script, and remove broken test Marcin Kuzminski <marcin@python-works.com> parents: 350 diff changeset	78 meta.Base.metadata.create_all(checkfirst=checkfirst)
229 69a29242ba61 db manage added more logging, set custom logger and add optional print sql statments Marcin Kuzminski <marcin@python-works.com> parents: 228 diff changeset	79 log.info('Created tables for %s', self.dbname)
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	80
834 8924ed0e4f36 added current db version into rhodecode, Marcin Kuzminski <marcin@python-works.com> parents: 781 diff changeset	81
8924ed0e4f36 added current db version into rhodecode, Marcin Kuzminski <marcin@python-works.com> parents: 781 diff changeset	82
8924ed0e4f36 added current db version into rhodecode, Marcin Kuzminski <marcin@python-works.com> parents: 781 diff changeset	83 def set_db_version(self):
8924ed0e4f36 added current db version into rhodecode, Marcin Kuzminski <marcin@python-works.com> parents: 781 diff changeset	84 try:
8924ed0e4f36 added current db version into rhodecode, Marcin Kuzminski <marcin@python-works.com> parents: 781 diff changeset	85 ver = DbMigrateVersion()
8924ed0e4f36 added current db version into rhodecode, Marcin Kuzminski <marcin@python-works.com> parents: 781 diff changeset	86 ver.version = __dbversion__
8924ed0e4f36 added current db version into rhodecode, Marcin Kuzminski <marcin@python-works.com> parents: 781 diff changeset	87 ver.repository_id = 'rhodecode_db_migrations'
8924ed0e4f36 added current db version into rhodecode, Marcin Kuzminski <marcin@python-works.com> parents: 781 diff changeset	88 ver.repository_path = 'versions'
8924ed0e4f36 added current db version into rhodecode, Marcin Kuzminski <marcin@python-works.com> parents: 781 diff changeset	89 self.sa.add(ver)
8924ed0e4f36 added current db version into rhodecode, Marcin Kuzminski <marcin@python-works.com> parents: 781 diff changeset	90 self.sa.commit()
8924ed0e4f36 added current db version into rhodecode, Marcin Kuzminski <marcin@python-works.com> parents: 781 diff changeset	91 except:
8924ed0e4f36 added current db version into rhodecode, Marcin Kuzminski <marcin@python-works.com> parents: 781 diff changeset	92 self.sa.rollback()
8924ed0e4f36 added current db version into rhodecode, Marcin Kuzminski <marcin@python-works.com> parents: 781 diff changeset	93 raise
8924ed0e4f36 added current db version into rhodecode, Marcin Kuzminski <marcin@python-works.com> parents: 781 diff changeset	94 log.info('db version set to: %s', __dbversion__)
8924ed0e4f36 added current db version into rhodecode, Marcin Kuzminski <marcin@python-works.com> parents: 781 diff changeset	95
839 ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	96
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	97 def upgrade(self):
1203 6832ef664673 source code cleanup: remove trailing white space, normalize file endings Marcin Kuzminski <marcin@python-works.com> parents: 1138 diff changeset	98 """Upgrades given database schema to given revision following
900 07f248329a3b updated migration for version 1.2 Marcin Kuzminski <marcin@python-works.com> parents: 890 diff changeset	99 all needed steps, to perform the upgrade
1203 6832ef664673 source code cleanup: remove trailing white space, normalize file endings Marcin Kuzminski <marcin@python-works.com> parents: 1138 diff changeset	100
839 ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	101 """
841 78b3d2d730f2 fixed import problems Marcin Kuzminski <marcin@python-works.com> parents: 839 diff changeset	102
78b3d2d730f2 fixed import problems Marcin Kuzminski <marcin@python-works.com> parents: 839 diff changeset	103 from rhodecode.lib.dbmigrate.migrate.versioning import api
78b3d2d730f2 fixed import problems Marcin Kuzminski <marcin@python-works.com> parents: 839 diff changeset	104 from rhodecode.lib.dbmigrate.migrate.exceptions import \
78b3d2d730f2 fixed import problems Marcin Kuzminski <marcin@python-works.com> parents: 839 diff changeset	105 DatabaseNotControlledError
78b3d2d730f2 fixed import problems Marcin Kuzminski <marcin@python-works.com> parents: 839 diff changeset	106
839 ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	107 upgrade = ask_ok('You are about to perform database upgrade, make '
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	108 'sure You backed up your database before. '
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	109 'Continue ? [y/n]')
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	110 if not upgrade:
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	111 sys.exit('Nothing done')
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	112
843 3b21ba5f7cb0 fixed path issues in upgrade script Marcin Kuzminski <marcin@python-works.com> parents: 841 diff changeset	113 repository_path = jn(dn(dn(dn(os.path.realpath(__file__)))),
3b21ba5f7cb0 fixed path issues in upgrade script Marcin Kuzminski <marcin@python-works.com> parents: 841 diff changeset	114 'rhodecode/lib/dbmigrate')
839 ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	115 db_uri = self.dburi
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	116
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	117 try:
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	118 curr_version = api.db_version(db_uri, repository_path)
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	119 msg = ('Found current database under version'
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	120 ' control with version %s' % curr_version)
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	121
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	122 except (RuntimeError, DatabaseNotControlledError), e:
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	123 curr_version = 1
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	124 msg = ('Current database is not under version control. Setting'
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	125 ' as version %s' % curr_version)
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	126 api.version_control(db_uri, repository_path, curr_version)
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	127
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	128 print (msg)
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	129
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	130 if curr_version == __dbversion__:
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	131 sys.exit('This database is already at the newest version')
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	132
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	133 #======================================================================
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	134 # UPGRADE STEPS
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	135 #======================================================================
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	136 class UpgradeSteps(object):
1203 6832ef664673 source code cleanup: remove trailing white space, normalize file endings Marcin Kuzminski <marcin@python-works.com> parents: 1138 diff changeset	137 """Those steps follow schema versions so for example schema
900 07f248329a3b updated migration for version 1.2 Marcin Kuzminski <marcin@python-works.com> parents: 890 diff changeset	138 for example schema with seq 002 == step_2 and so on.
07f248329a3b updated migration for version 1.2 Marcin Kuzminski <marcin@python-works.com> parents: 890 diff changeset	139 """
839 ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	140
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	141 def __init__(self, klass):
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	142 self.klass = klass
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	143
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	144 def step_0(self):
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	145 #step 0 is the schema upgrade, and than follow proper upgrades
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	146 print ('attempting to do database upgrade to version %s' \
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	147 % __dbversion__)
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	148 api.upgrade(db_uri, repository_path, __dbversion__)
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	149 print ('Schema upgrade completed')
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	150
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	151 def step_1(self):
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	152 pass
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	153
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	154 def step_2(self):
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	155 print ('Patching repo paths for newer version of RhodeCode')
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	156 self.klass.fix_repo_paths()
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	157
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	158 print ('Patching default user of RhodeCode')
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	159 self.klass.fix_default_user()
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	160
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	161 log.info('Changing ui settings')
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	162 self.klass.create_ui_settings()
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	163
890 042d38683d42 implemented #89 google analytics code Marcin Kuzminski <marcin@python-works.com> parents: 843 diff changeset	164 def step_3(self):
042d38683d42 implemented #89 google analytics code Marcin Kuzminski <marcin@python-works.com> parents: 843 diff changeset	165 print ('Adding additional settings into RhodeCode db')
042d38683d42 implemented #89 google analytics code Marcin Kuzminski <marcin@python-works.com> parents: 843 diff changeset	166 self.klass.fix_settings()
839 ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	167
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	168 upgrade_steps = [0] + range(curr_version + 1, __dbversion__ + 1)
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	169
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	170 #CALL THE PROPER ORDER OF STEPS TO PERFORM FULL UPGRADE
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	171 for step in upgrade_steps:
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	172 print ('performing upgrade step %s' % step)
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	173 callable = getattr(UpgradeSteps(self), 'step_%s' % step)()
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	174
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	175
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	176
837 60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	177 def fix_repo_paths(self):
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	178 """Fixes a old rhodecode version path into new one without a '*'
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	179 """
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	180
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	181 paths = self.sa.query(RhodeCodeUi)\
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	182 .filter(RhodeCodeUi.ui_key == '/')\
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	183 .scalar()
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	184
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	185 paths.ui_value = paths.ui_value.replace('*', '')
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	186
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	187 try:
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	188 self.sa.add(paths)
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	189 self.sa.commit()
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	190 except:
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	191 self.sa.rollback()
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	192 raise
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	193
838 12eb1a018199 db migrations: Marcin Kuzminski <marcin@python-works.com> parents: 837 diff changeset	194 def fix_default_user(self):
12eb1a018199 db migrations: Marcin Kuzminski <marcin@python-works.com> parents: 837 diff changeset	195 """Fixes a old default user with some 'nicer' default values,
12eb1a018199 db migrations: Marcin Kuzminski <marcin@python-works.com> parents: 837 diff changeset	196 used mostly for anonymous access
12eb1a018199 db migrations: Marcin Kuzminski <marcin@python-works.com> parents: 837 diff changeset	197 """
12eb1a018199 db migrations: Marcin Kuzminski <marcin@python-works.com> parents: 837 diff changeset	198 def_user = self.sa.query(User)\
12eb1a018199 db migrations: Marcin Kuzminski <marcin@python-works.com> parents: 837 diff changeset	199 .filter(User.username == 'default')\
12eb1a018199 db migrations: Marcin Kuzminski <marcin@python-works.com> parents: 837 diff changeset	200 .one()
12eb1a018199 db migrations: Marcin Kuzminski <marcin@python-works.com> parents: 837 diff changeset	201
12eb1a018199 db migrations: Marcin Kuzminski <marcin@python-works.com> parents: 837 diff changeset	202 def_user.name = 'Anonymous'
12eb1a018199 db migrations: Marcin Kuzminski <marcin@python-works.com> parents: 837 diff changeset	203 def_user.lastname = 'User'
12eb1a018199 db migrations: Marcin Kuzminski <marcin@python-works.com> parents: 837 diff changeset	204 def_user.email = 'anonymous@rhodecode.org'
12eb1a018199 db migrations: Marcin Kuzminski <marcin@python-works.com> parents: 837 diff changeset	205
12eb1a018199 db migrations: Marcin Kuzminski <marcin@python-works.com> parents: 837 diff changeset	206 try:
12eb1a018199 db migrations: Marcin Kuzminski <marcin@python-works.com> parents: 837 diff changeset	207 self.sa.add(def_user)
12eb1a018199 db migrations: Marcin Kuzminski <marcin@python-works.com> parents: 837 diff changeset	208 self.sa.commit()
12eb1a018199 db migrations: Marcin Kuzminski <marcin@python-works.com> parents: 837 diff changeset	209 except:
12eb1a018199 db migrations: Marcin Kuzminski <marcin@python-works.com> parents: 837 diff changeset	210 self.sa.rollback()
12eb1a018199 db migrations: Marcin Kuzminski <marcin@python-works.com> parents: 837 diff changeset	211 raise
12eb1a018199 db migrations: Marcin Kuzminski <marcin@python-works.com> parents: 837 diff changeset	212
890 042d38683d42 implemented #89 google analytics code Marcin Kuzminski <marcin@python-works.com> parents: 843 diff changeset	213 def fix_settings(self):
042d38683d42 implemented #89 google analytics code Marcin Kuzminski <marcin@python-works.com> parents: 843 diff changeset	214 """Fixes rhodecode settings adds ga_code key for google analytics
042d38683d42 implemented #89 google analytics code Marcin Kuzminski <marcin@python-works.com> parents: 843 diff changeset	215 """
837 60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	216
890 042d38683d42 implemented #89 google analytics code Marcin Kuzminski <marcin@python-works.com> parents: 843 diff changeset	217 hgsettings3 = RhodeCodeSettings('ga_code', '')
907 2f83756f3041 Fixed dbmigrate issues. Marcin Kuzminski <marcin@python-works.com> parents: 902 diff changeset	218
890 042d38683d42 implemented #89 google analytics code Marcin Kuzminski <marcin@python-works.com> parents: 843 diff changeset	219 try:
042d38683d42 implemented #89 google analytics code Marcin Kuzminski <marcin@python-works.com> parents: 843 diff changeset	220 self.sa.add(hgsettings3)
042d38683d42 implemented #89 google analytics code Marcin Kuzminski <marcin@python-works.com> parents: 843 diff changeset	221 self.sa.commit()
042d38683d42 implemented #89 google analytics code Marcin Kuzminski <marcin@python-works.com> parents: 843 diff changeset	222 except:
042d38683d42 implemented #89 google analytics code Marcin Kuzminski <marcin@python-works.com> parents: 843 diff changeset	223 self.sa.rollback()
042d38683d42 implemented #89 google analytics code Marcin Kuzminski <marcin@python-works.com> parents: 843 diff changeset	224 raise
837 60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	225
597 53128b6b9a4d added password validation, second try on paster setup-app, Marcin Kuzminski <marcin@python-works.com> parents: 569 diff changeset	226 def admin_prompt(self, second=False):
459 7c978511c951 implemented basic (startup) nose test suite. Marcin Kuzminski <marcin@python-works.com> parents: 417 diff changeset	227 if not self.tests:
7c978511c951 implemented basic (startup) nose test suite. Marcin Kuzminski <marcin@python-works.com> parents: 417 diff changeset	228 import getpass
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	229
7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	230
597 53128b6b9a4d added password validation, second try on paster setup-app, Marcin Kuzminski <marcin@python-works.com> parents: 569 diff changeset	231 def get_password():
53128b6b9a4d added password validation, second try on paster setup-app, Marcin Kuzminski <marcin@python-works.com> parents: 569 diff changeset	232 password = getpass.getpass('Specify admin password (min 6 chars):')
53128b6b9a4d added password validation, second try on paster setup-app, Marcin Kuzminski <marcin@python-works.com> parents: 569 diff changeset	233 confirm = getpass.getpass('Confirm password:')
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	234
597 53128b6b9a4d added password validation, second try on paster setup-app, Marcin Kuzminski <marcin@python-works.com> parents: 569 diff changeset	235 if password != confirm:
53128b6b9a4d added password validation, second try on paster setup-app, Marcin Kuzminski <marcin@python-works.com> parents: 569 diff changeset	236 log.error('passwords mismatch')
53128b6b9a4d added password validation, second try on paster setup-app, Marcin Kuzminski <marcin@python-works.com> parents: 569 diff changeset	237 return False
53128b6b9a4d added password validation, second try on paster setup-app, Marcin Kuzminski <marcin@python-works.com> parents: 569 diff changeset	238 if len(password) < 6:
53128b6b9a4d added password validation, second try on paster setup-app, Marcin Kuzminski <marcin@python-works.com> parents: 569 diff changeset	239 log.error('password is to short use at least 6 characters')
53128b6b9a4d added password validation, second try on paster setup-app, Marcin Kuzminski <marcin@python-works.com> parents: 569 diff changeset	240 return False
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	241
597 53128b6b9a4d added password validation, second try on paster setup-app, Marcin Kuzminski <marcin@python-works.com> parents: 569 diff changeset	242 return password
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	243
459 7c978511c951 implemented basic (startup) nose test suite. Marcin Kuzminski <marcin@python-works.com> parents: 417 diff changeset	244 username = raw_input('Specify admin username:')
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	245
597 53128b6b9a4d added password validation, second try on paster setup-app, Marcin Kuzminski <marcin@python-works.com> parents: 569 diff changeset	246 password = get_password()
53128b6b9a4d added password validation, second try on paster setup-app, Marcin Kuzminski <marcin@python-works.com> parents: 569 diff changeset	247 if not password:
53128b6b9a4d added password validation, second try on paster setup-app, Marcin Kuzminski <marcin@python-works.com> parents: 569 diff changeset	248 #second try
53128b6b9a4d added password validation, second try on paster setup-app, Marcin Kuzminski <marcin@python-works.com> parents: 569 diff changeset	249 password = get_password()
53128b6b9a4d added password validation, second try on paster setup-app, Marcin Kuzminski <marcin@python-works.com> parents: 569 diff changeset	250 if not password:
53128b6b9a4d added password validation, second try on paster setup-app, Marcin Kuzminski <marcin@python-works.com> parents: 569 diff changeset	251 sys.exit()
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	252
491 fefffd6fd5f4 Added some more tests, rewrite testing schema, to autogenerate fresh db, new index. Marcin Kuzminski <marcin@python-works.com> parents: 471 diff changeset	253 email = raw_input('Specify admin email:')
fefffd6fd5f4 Added some more tests, rewrite testing schema, to autogenerate fresh db, new index. Marcin Kuzminski <marcin@python-works.com> parents: 471 diff changeset	254 self.create_user(username, password, email, True)
459 7c978511c951 implemented basic (startup) nose test suite. Marcin Kuzminski <marcin@python-works.com> parents: 417 diff changeset	255 else:
7c978511c951 implemented basic (startup) nose test suite. Marcin Kuzminski <marcin@python-works.com> parents: 417 diff changeset	256 log.info('creating admin and regular test users')
533 53aa1ee1af86 updated tests for new version 6char password etc... Marcin Kuzminski <marcin@python-works.com> parents: 491 diff changeset	257 self.create_user('test_admin', 'test12', 'test_admin@mail.com', True)
53aa1ee1af86 updated tests for new version 6char password etc... Marcin Kuzminski <marcin@python-works.com> parents: 491 diff changeset	258 self.create_user('test_regular', 'test12', 'test_regular@mail.com', False)
53aa1ee1af86 updated tests for new version 6char password etc... Marcin Kuzminski <marcin@python-works.com> parents: 491 diff changeset	259 self.create_user('test_regular2', 'test12', 'test_regular2@mail.com', False)
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	260
837 60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	261 def create_ui_settings(self):
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	262 """Creates ui settings, fills out hooks
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	263 and disables dotencode
1203 6832ef664673 source code cleanup: remove trailing white space, normalize file endings Marcin Kuzminski <marcin@python-works.com> parents: 1138 diff changeset	264
837 60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	265 """
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	266 #HOOKS
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	267 hooks1_key = 'changegroup.update'
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	268 hooks1_ = self.sa.query(RhodeCodeUi)\
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	269 .filter(RhodeCodeUi.ui_key == hooks1_key).scalar()
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	270
837 60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	271 hooks1 = RhodeCodeUi() if hooks1_ is None else hooks1_
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	272 hooks1.ui_section = 'hooks'
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	273 hooks1.ui_key = hooks1_key
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	274 hooks1.ui_value = 'hg update >&2'
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	275 hooks1.ui_active = False
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	276
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	277 hooks2_key = 'changegroup.repo_size'
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	278 hooks2_ = self.sa.query(RhodeCodeUi)\
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	279 .filter(RhodeCodeUi.ui_key == hooks2_key).scalar()
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	280
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	281 hooks2 = RhodeCodeUi() if hooks2_ is None else hooks2_
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	282 hooks2.ui_section = 'hooks'
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	283 hooks2.ui_key = hooks2_key
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	284 hooks2.ui_value = 'python:rhodecode.lib.hooks.repo_size'
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	285
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	286 hooks3 = RhodeCodeUi()
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	287 hooks3.ui_section = 'hooks'
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	288 hooks3.ui_key = 'pretxnchangegroup.push_logger'
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	289 hooks3.ui_value = 'python:rhodecode.lib.hooks.log_push_action'
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	290
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	291 hooks4 = RhodeCodeUi()
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	292 hooks4.ui_section = 'hooks'
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	293 hooks4.ui_key = 'preoutgoing.pull_logger'
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	294 hooks4.ui_value = 'python:rhodecode.lib.hooks.log_pull_action'
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	295
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	296 #For mercurial 1.7 set backward comapatibility with format
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	297 dotencode_disable = RhodeCodeUi()
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	298 dotencode_disable.ui_section = 'format'
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	299 dotencode_disable.ui_key = 'dotencode'
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	300 dotencode_disable.ui_value = 'false'
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	301
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	302 try:
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	303 self.sa.add(hooks1)
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	304 self.sa.add(hooks2)
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	305 self.sa.add(hooks3)
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	306 self.sa.add(hooks4)
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	307 self.sa.add(dotencode_disable)
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	308 self.sa.commit()
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	309 except:
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	310 self.sa.rollback()
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	311 raise
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	312
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	313
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	314 def create_ldap_options(self):
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	315 """Creates ldap settings"""
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	316
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	317 try:
1138 9c45e11493fb fixed ldap settings creation, we need to fill in some bool defaults properly to make it work fine Marcin Kuzminski <marcin@python-works.com> parents: 1116 diff changeset	318 for k, v in [('ldap_active', 'false'), ('ldap_host', ''),
9c45e11493fb fixed ldap settings creation, we need to fill in some bool defaults properly to make it work fine Marcin Kuzminski <marcin@python-works.com> parents: 1116 diff changeset	319 ('ldap_port', '389'), ('ldap_ldaps', 'false'),
9c45e11493fb fixed ldap settings creation, we need to fill in some bool defaults properly to make it work fine Marcin Kuzminski <marcin@python-works.com> parents: 1116 diff changeset	320 ('ldap_tls_reqcert', ''), ('ldap_dn_user', ''),
9c45e11493fb fixed ldap settings creation, we need to fill in some bool defaults properly to make it work fine Marcin Kuzminski <marcin@python-works.com> parents: 1116 diff changeset	321 ('ldap_dn_pass', ''), ('ldap_base_dn', ''),
9c45e11493fb fixed ldap settings creation, we need to fill in some bool defaults properly to make it work fine Marcin Kuzminski <marcin@python-works.com> parents: 1116 diff changeset	322 ('ldap_filter', ''), ('ldap_search_scope', ''),
9c45e11493fb fixed ldap settings creation, we need to fill in some bool defaults properly to make it work fine Marcin Kuzminski <marcin@python-works.com> parents: 1116 diff changeset	323 ('ldap_attr_login', ''), ('ldap_attr_firstname', ''),
9c45e11493fb fixed ldap settings creation, we need to fill in some bool defaults properly to make it work fine Marcin Kuzminski <marcin@python-works.com> parents: 1116 diff changeset	324 ('ldap_attr_lastname', ''), ('ldap_attr_email', '')]:
837 60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	325
1138 9c45e11493fb fixed ldap settings creation, we need to fill in some bool defaults properly to make it work fine Marcin Kuzminski <marcin@python-works.com> parents: 1116 diff changeset	326
9c45e11493fb fixed ldap settings creation, we need to fill in some bool defaults properly to make it work fine Marcin Kuzminski <marcin@python-works.com> parents: 1116 diff changeset	327 setting = RhodeCodeSettings(k, v)
837 60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	328 self.sa.add(setting)
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	329 self.sa.commit()
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	330 except:
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	331 self.sa.rollback()
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	332 raise
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	333
1094 44661d2a7b61 fixes #120 websetup command runs os.access on given path checking for write access Marcin Kuzminski <marcin@python-works.com> parents: 991 diff changeset	334 def config_prompt(self, test_repo_path='', retries=3):
44661d2a7b61 fixes #120 websetup command runs os.access on given path checking for write access Marcin Kuzminski <marcin@python-works.com> parents: 991 diff changeset	335 if retries == 3:
44661d2a7b61 fixes #120 websetup command runs os.access on given path checking for write access Marcin Kuzminski <marcin@python-works.com> parents: 991 diff changeset	336 log.info('Setting up repositories config')
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	337
459 7c978511c951 implemented basic (startup) nose test suite. Marcin Kuzminski <marcin@python-works.com> parents: 417 diff changeset	338 if not self.tests and not test_repo_path:
7c978511c951 implemented basic (startup) nose test suite. Marcin Kuzminski <marcin@python-works.com> parents: 417 diff changeset	339 path = raw_input('Specify valid full path to your repositories'
351 d09381593b12 updated db manage script, and remove broken test Marcin Kuzminski <marcin@python-works.com> parents: 350 diff changeset	340 ' you can change this later in application settings:')
459 7c978511c951 implemented basic (startup) nose test suite. Marcin Kuzminski <marcin@python-works.com> parents: 417 diff changeset	341 else:
7c978511c951 implemented basic (startup) nose test suite. Marcin Kuzminski <marcin@python-works.com> parents: 417 diff changeset	342 path = test_repo_path
1094 44661d2a7b61 fixes #120 websetup command runs os.access on given path checking for write access Marcin Kuzminski <marcin@python-works.com> parents: 991 diff changeset	343 path_ok = True
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	344
1094 44661d2a7b61 fixes #120 websetup command runs os.access on given path checking for write access Marcin Kuzminski <marcin@python-works.com> parents: 991 diff changeset	345 #check proper dir
341 1ef52a70f3b7 Made config file free configuration based on database and capable of beeing manage via application settings + some code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 327 diff changeset	346 if not os.path.isdir(path):
1094 44661d2a7b61 fixes #120 websetup command runs os.access on given path checking for write access Marcin Kuzminski <marcin@python-works.com> parents: 991 diff changeset	347 path_ok = False
44661d2a7b61 fixes #120 websetup command runs os.access on given path checking for write access Marcin Kuzminski <marcin@python-works.com> parents: 991 diff changeset	348 log.error('Entered path is not a valid directory: %s [%s/3]',
44661d2a7b61 fixes #120 websetup command runs os.access on given path checking for write access Marcin Kuzminski <marcin@python-works.com> parents: 991 diff changeset	349 path, retries)
44661d2a7b61 fixes #120 websetup command runs os.access on given path checking for write access Marcin Kuzminski <marcin@python-works.com> parents: 991 diff changeset	350
44661d2a7b61 fixes #120 websetup command runs os.access on given path checking for write access Marcin Kuzminski <marcin@python-works.com> parents: 991 diff changeset	351 #check write access
44661d2a7b61 fixes #120 websetup command runs os.access on given path checking for write access Marcin Kuzminski <marcin@python-works.com> parents: 991 diff changeset	352 if not os.access(path, os.W_OK):
44661d2a7b61 fixes #120 websetup command runs os.access on given path checking for write access Marcin Kuzminski <marcin@python-works.com> parents: 991 diff changeset	353 path_ok = False
44661d2a7b61 fixes #120 websetup command runs os.access on given path checking for write access Marcin Kuzminski <marcin@python-works.com> parents: 991 diff changeset	354
44661d2a7b61 fixes #120 websetup command runs os.access on given path checking for write access Marcin Kuzminski <marcin@python-works.com> parents: 991 diff changeset	355 log.error('No write permission to given path: %s [%s/3]',
44661d2a7b61 fixes #120 websetup command runs os.access on given path checking for write access Marcin Kuzminski <marcin@python-works.com> parents: 991 diff changeset	356 path, retries)
44661d2a7b61 fixes #120 websetup command runs os.access on given path checking for write access Marcin Kuzminski <marcin@python-works.com> parents: 991 diff changeset	357
44661d2a7b61 fixes #120 websetup command runs os.access on given path checking for write access Marcin Kuzminski <marcin@python-works.com> parents: 991 diff changeset	358
44661d2a7b61 fixes #120 websetup command runs os.access on given path checking for write access Marcin Kuzminski <marcin@python-works.com> parents: 991 diff changeset	359 if retries == 0:
341 1ef52a70f3b7 Made config file free configuration based on database and capable of beeing manage via application settings + some code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 327 diff changeset	360 sys.exit()
1094 44661d2a7b61 fixes #120 websetup command runs os.access on given path checking for write access Marcin Kuzminski <marcin@python-works.com> parents: 991 diff changeset	361 if path_ok is False:
44661d2a7b61 fixes #120 websetup command runs os.access on given path checking for write access Marcin Kuzminski <marcin@python-works.com> parents: 991 diff changeset	362 retries -= 1
44661d2a7b61 fixes #120 websetup command runs os.access on given path checking for write access Marcin Kuzminski <marcin@python-works.com> parents: 991 diff changeset	363 return self.config_prompt(test_repo_path, retries)
44661d2a7b61 fixes #120 websetup command runs os.access on given path checking for write access Marcin Kuzminski <marcin@python-works.com> parents: 991 diff changeset	364
44661d2a7b61 fixes #120 websetup command runs os.access on given path checking for write access Marcin Kuzminski <marcin@python-works.com> parents: 991 diff changeset	365
44661d2a7b61 fixes #120 websetup command runs os.access on given path checking for write access Marcin Kuzminski <marcin@python-works.com> parents: 991 diff changeset	366 return path
44661d2a7b61 fixes #120 websetup command runs os.access on given path checking for write access Marcin Kuzminski <marcin@python-works.com> parents: 991 diff changeset	367
44661d2a7b61 fixes #120 websetup command runs os.access on given path checking for write access Marcin Kuzminski <marcin@python-works.com> parents: 991 diff changeset	368 def create_settings(self, path):
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	369
837 60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	370 self.create_ui_settings()
673 dd532af216d9 #49 Enabled anonymous access for web interface controllable from permissions pannel Marcin Kuzminski <marcin@python-works.com> parents: 657 diff changeset	371
837 60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	372 #HG UI OPTIONS
549 f99075170eb4 more renames for rhode code !! Marcin Kuzminski <marcin@python-works.com> parents: 547 diff changeset	373 web1 = RhodeCodeUi()
341 1ef52a70f3b7 Made config file free configuration based on database and capable of beeing manage via application settings + some code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 327 diff changeset	374 web1.ui_section = 'web'
1ef52a70f3b7 Made config file free configuration based on database and capable of beeing manage via application settings + some code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 327 diff changeset	375 web1.ui_key = 'push_ssl'
1ef52a70f3b7 Made config file free configuration based on database and capable of beeing manage via application settings + some code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 327 diff changeset	376 web1.ui_value = 'false'
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	377
549 f99075170eb4 more renames for rhode code !! Marcin Kuzminski <marcin@python-works.com> parents: 547 diff changeset	378 web2 = RhodeCodeUi()
341 1ef52a70f3b7 Made config file free configuration based on database and capable of beeing manage via application settings + some code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 327 diff changeset	379 web2.ui_section = 'web'
1ef52a70f3b7 Made config file free configuration based on database and capable of beeing manage via application settings + some code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 327 diff changeset	380 web2.ui_key = 'allow_archive'
1ef52a70f3b7 Made config file free configuration based on database and capable of beeing manage via application settings + some code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 327 diff changeset	381 web2.ui_value = 'gz zip bz2'
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	382
549 f99075170eb4 more renames for rhode code !! Marcin Kuzminski <marcin@python-works.com> parents: 547 diff changeset	383 web3 = RhodeCodeUi()
341 1ef52a70f3b7 Made config file free configuration based on database and capable of beeing manage via application settings + some code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 327 diff changeset	384 web3.ui_section = 'web'
1ef52a70f3b7 Made config file free configuration based on database and capable of beeing manage via application settings + some code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 327 diff changeset	385 web3.ui_key = 'allow_push'
1ef52a70f3b7 Made config file free configuration based on database and capable of beeing manage via application settings + some code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 327 diff changeset	386 web3.ui_value = '*'
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	387
549 f99075170eb4 more renames for rhode code !! Marcin Kuzminski <marcin@python-works.com> parents: 547 diff changeset	388 web4 = RhodeCodeUi()
341 1ef52a70f3b7 Made config file free configuration based on database and capable of beeing manage via application settings + some code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 327 diff changeset	389 web4.ui_section = 'web'
1ef52a70f3b7 Made config file free configuration based on database and capable of beeing manage via application settings + some code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 327 diff changeset	390 web4.ui_key = 'baseurl'
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	391 web4.ui_value = '/'
7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	392
549 f99075170eb4 more renames for rhode code !! Marcin Kuzminski <marcin@python-works.com> parents: 547 diff changeset	393 paths = RhodeCodeUi()
341 1ef52a70f3b7 Made config file free configuration based on database and capable of beeing manage via application settings + some code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 327 diff changeset	394 paths.ui_section = 'paths'
1ef52a70f3b7 Made config file free configuration based on database and capable of beeing manage via application settings + some code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 327 diff changeset	395 paths.ui_key = '/'
631 05528ad948c4 Hacking for git support,and new faster repo scan Marcin Kuzminski <marcin@python-works.com> parents: 629 diff changeset	396 paths.ui_value = path
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	397
7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	398
704 26237de9b613 Added settings model, and Exceptions lib. Marcin Kuzminski <marcin@python-works.com> parents: 673 diff changeset	399 hgsettings1 = RhodeCodeSettings('realm', 'RhodeCode authentication')
26237de9b613 Added settings model, and Exceptions lib. Marcin Kuzminski <marcin@python-works.com> parents: 673 diff changeset	400 hgsettings2 = RhodeCodeSettings('title', 'RhodeCode')
890 042d38683d42 implemented #89 google analytics code Marcin Kuzminski <marcin@python-works.com> parents: 843 diff changeset	401 hgsettings3 = RhodeCodeSettings('ga_code', '')
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	402
7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	403
341 1ef52a70f3b7 Made config file free configuration based on database and capable of beeing manage via application settings + some code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 327 diff changeset	404 try:
1ef52a70f3b7 Made config file free configuration based on database and capable of beeing manage via application settings + some code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 327 diff changeset	405 self.sa.add(web1)
1ef52a70f3b7 Made config file free configuration based on database and capable of beeing manage via application settings + some code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 327 diff changeset	406 self.sa.add(web2)
1ef52a70f3b7 Made config file free configuration based on database and capable of beeing manage via application settings + some code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 327 diff changeset	407 self.sa.add(web3)
1ef52a70f3b7 Made config file free configuration based on database and capable of beeing manage via application settings + some code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 327 diff changeset	408 self.sa.add(web4)
1ef52a70f3b7 Made config file free configuration based on database and capable of beeing manage via application settings + some code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 327 diff changeset	409 self.sa.add(paths)
381 55377fdc1fc6 cleared global application settings. Marcin Kuzminski <marcin@python-works.com> parents: 371 diff changeset	410 self.sa.add(hgsettings1)
55377fdc1fc6 cleared global application settings. Marcin Kuzminski <marcin@python-works.com> parents: 371 diff changeset	411 self.sa.add(hgsettings2)
890 042d38683d42 implemented #89 google analytics code Marcin Kuzminski <marcin@python-works.com> parents: 843 diff changeset	412 self.sa.add(hgsettings3)
704 26237de9b613 Added settings model, and Exceptions lib. Marcin Kuzminski <marcin@python-works.com> parents: 673 diff changeset	413
341 1ef52a70f3b7 Made config file free configuration based on database and capable of beeing manage via application settings + some code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 327 diff changeset	414 self.sa.commit()
1ef52a70f3b7 Made config file free configuration based on database and capable of beeing manage via application settings + some code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 327 diff changeset	415 except:
1ef52a70f3b7 Made config file free configuration based on database and capable of beeing manage via application settings + some code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 327 diff changeset	416 self.sa.rollback()
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	417 raise
837 60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	418
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	419 self.create_ldap_options()
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	420
341 1ef52a70f3b7 Made config file free configuration based on database and capable of beeing manage via application settings + some code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 327 diff changeset	421 log.info('created ui config')
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	422
491 fefffd6fd5f4 Added some more tests, rewrite testing schema, to autogenerate fresh db, new index. Marcin Kuzminski <marcin@python-works.com> parents: 471 diff changeset	423 def create_user(self, username, password, email='', admin=False):
229 69a29242ba61 db manage added more logging, set custom logger and add optional print sql statments Marcin Kuzminski <marcin@python-works.com> parents: 228 diff changeset	424 log.info('creating administrator user %s', username)
234 a0116e944da1 changed naming convention for db modules. Marcin Kuzminski <marcin@python-works.com> parents: 229 diff changeset	425 new_user = User()
226 c6526b7531e9 rewritten db manage script to use sqlalchemy. Fixed sqlalchemy models to more generic. Marcin Kuzminski <marcin@python-works.com> parents: 88 diff changeset	426 new_user.username = username
c6526b7531e9 rewritten db manage script to use sqlalchemy. Fixed sqlalchemy models to more generic. Marcin Kuzminski <marcin@python-works.com> parents: 88 diff changeset	427 new_user.password = get_crypt_password(password)
1116 716911af91e1 Added api_key into user, api key get's generated again after password change Marcin Kuzminski <marcin@python-works.com> parents: 1094 diff changeset	428 new_user.api_key = generate_api_key(username)
555 03676d39dd0a added fault tolerant case when celeryconfig is not present in the directory. Marcin Kuzminski <marcin@python-works.com> parents: 552 diff changeset	429 new_user.name = 'RhodeCode'
262 a4be1ebb214f updated db manage with some defaults Marcin Kuzminski <marcin@python-works.com> parents: 252 diff changeset	430 new_user.lastname = 'Admin'
491 fefffd6fd5f4 Added some more tests, rewrite testing schema, to autogenerate fresh db, new index. Marcin Kuzminski <marcin@python-works.com> parents: 471 diff changeset	431 new_user.email = email
226 c6526b7531e9 rewritten db manage script to use sqlalchemy. Fixed sqlalchemy models to more generic. Marcin Kuzminski <marcin@python-works.com> parents: 88 diff changeset	432 new_user.admin = admin
c6526b7531e9 rewritten db manage script to use sqlalchemy. Fixed sqlalchemy models to more generic. Marcin Kuzminski <marcin@python-works.com> parents: 88 diff changeset	433 new_user.active = True
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	434
226 c6526b7531e9 rewritten db manage script to use sqlalchemy. Fixed sqlalchemy models to more generic. Marcin Kuzminski <marcin@python-works.com> parents: 88 diff changeset	435 try:
459 7c978511c951 implemented basic (startup) nose test suite. Marcin Kuzminski <marcin@python-works.com> parents: 417 diff changeset	436 self.sa.add(new_user)
7c978511c951 implemented basic (startup) nose test suite. Marcin Kuzminski <marcin@python-works.com> parents: 417 diff changeset	437 self.sa.commit()
7c978511c951 implemented basic (startup) nose test suite. Marcin Kuzminski <marcin@python-works.com> parents: 417 diff changeset	438 except:
7c978511c951 implemented basic (startup) nose test suite. Marcin Kuzminski <marcin@python-works.com> parents: 417 diff changeset	439 self.sa.rollback()
7c978511c951 implemented basic (startup) nose test suite. Marcin Kuzminski <marcin@python-works.com> parents: 417 diff changeset	440 raise
7c978511c951 implemented basic (startup) nose test suite. Marcin Kuzminski <marcin@python-works.com> parents: 417 diff changeset	441
7c978511c951 implemented basic (startup) nose test suite. Marcin Kuzminski <marcin@python-works.com> parents: 417 diff changeset	442 def create_default_user(self):
7c978511c951 implemented basic (startup) nose test suite. Marcin Kuzminski <marcin@python-works.com> parents: 417 diff changeset	443 log.info('creating default user')
7c978511c951 implemented basic (startup) nose test suite. Marcin Kuzminski <marcin@python-works.com> parents: 417 diff changeset	444 #create default user for handling default permissions.
7c978511c951 implemented basic (startup) nose test suite. Marcin Kuzminski <marcin@python-works.com> parents: 417 diff changeset	445 def_user = User()
7c978511c951 implemented basic (startup) nose test suite. Marcin Kuzminski <marcin@python-works.com> parents: 417 diff changeset	446 def_user.username = 'default'
7c978511c951 implemented basic (startup) nose test suite. Marcin Kuzminski <marcin@python-works.com> parents: 417 diff changeset	447 def_user.password = get_crypt_password(str(uuid.uuid1())[:8])
1116 716911af91e1 Added api_key into user, api key get's generated again after password change Marcin Kuzminski <marcin@python-works.com> parents: 1094 diff changeset	448 def_user.api_key = generate_api_key('default')
673 dd532af216d9 #49 Enabled anonymous access for web interface controllable from permissions pannel Marcin Kuzminski <marcin@python-works.com> parents: 657 diff changeset	449 def_user.name = 'Anonymous'
dd532af216d9 #49 Enabled anonymous access for web interface controllable from permissions pannel Marcin Kuzminski <marcin@python-works.com> parents: 657 diff changeset	450 def_user.lastname = 'User'
dd532af216d9 #49 Enabled anonymous access for web interface controllable from permissions pannel Marcin Kuzminski <marcin@python-works.com> parents: 657 diff changeset	451 def_user.email = 'anonymous@rhodecode.org'
459 7c978511c951 implemented basic (startup) nose test suite. Marcin Kuzminski <marcin@python-works.com> parents: 417 diff changeset	452 def_user.admin = False
7c978511c951 implemented basic (startup) nose test suite. Marcin Kuzminski <marcin@python-works.com> parents: 417 diff changeset	453 def_user.active = False
7c978511c951 implemented basic (startup) nose test suite. Marcin Kuzminski <marcin@python-works.com> parents: 417 diff changeset	454 try:
341 1ef52a70f3b7 Made config file free configuration based on database and capable of beeing manage via application settings + some code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 327 diff changeset	455 self.sa.add(def_user)
226 c6526b7531e9 rewritten db manage script to use sqlalchemy. Fixed sqlalchemy models to more generic. Marcin Kuzminski <marcin@python-works.com> parents: 88 diff changeset	456 self.sa.commit()
c6526b7531e9 rewritten db manage script to use sqlalchemy. Fixed sqlalchemy models to more generic. Marcin Kuzminski <marcin@python-works.com> parents: 88 diff changeset	457 except:
c6526b7531e9 rewritten db manage script to use sqlalchemy. Fixed sqlalchemy models to more generic. Marcin Kuzminski <marcin@python-works.com> parents: 88 diff changeset	458 self.sa.rollback()
c6526b7531e9 rewritten db manage script to use sqlalchemy. Fixed sqlalchemy models to more generic. Marcin Kuzminski <marcin@python-works.com> parents: 88 diff changeset	459 raise
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	460
239 b18f89d6d17f Adde draft for permissions systems, made all needed decorators, and checks. For future usage in the system. Marcin Kuzminski <marcin@python-works.com> parents: 234 diff changeset	461 def create_permissions(self):
240 7c4fa2a66195 small fixes Marcin Kuzminski <marcin@python-works.com> parents: 239 diff changeset	462 #module.(access\|create\|change\|delete)_[name]
296 29370bb76fa6 first permissions commit: added permission managment on repository edit. Changed db rmissions, validators. Marcin Kuzminski <marcin@python-works.com> parents: 264 diff changeset	463 #module.(read\|write\|owner)
29370bb76fa6 first permissions commit: added permission managment on repository edit. Changed db rmissions, validators. Marcin Kuzminski <marcin@python-works.com> parents: 264 diff changeset	464 perms = [('repository.none', 'Repository no access'),
29370bb76fa6 first permissions commit: added permission managment on repository edit. Changed db rmissions, validators. Marcin Kuzminski <marcin@python-works.com> parents: 264 diff changeset	465 ('repository.read', 'Repository read access'),
29370bb76fa6 first permissions commit: added permission managment on repository edit. Changed db rmissions, validators. Marcin Kuzminski <marcin@python-works.com> parents: 264 diff changeset	466 ('repository.write', 'Repository write access'),
29370bb76fa6 first permissions commit: added permission managment on repository edit. Changed db rmissions, validators. Marcin Kuzminski <marcin@python-works.com> parents: 264 diff changeset	467 ('repository.admin', 'Repository admin access'),
307 504feff57b49 added permission functions to webhelpers, updated dbmanage permissions Marcin Kuzminski <marcin@python-works.com> parents: 296 diff changeset	468 ('hg.admin', 'Hg Administrator'),
417 3ed2d46a2ca7 permission refactoring, Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	469 ('hg.create.repository', 'Repository create'),
3ed2d46a2ca7 permission refactoring, Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	470 ('hg.create.none', 'Repository creation disabled'),
3ed2d46a2ca7 permission refactoring, Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	471 ('hg.register.none', 'Register disabled'),
1116 716911af91e1 Added api_key into user, api key get's generated again after password change Marcin Kuzminski <marcin@python-works.com> parents: 1094 diff changeset	472 ('hg.register.manual_activate', 'Register new user with RhodeCode without manual activation'),
716911af91e1 Added api_key into user, api key get's generated again after password change Marcin Kuzminski <marcin@python-works.com> parents: 1094 diff changeset	473 ('hg.register.auto_activate', 'Register new user with RhodeCode without auto activation'),
371 5cd6616b8673 routes python 2.5 compatible Marcin Kuzminski <marcin@python-works.com> parents: 367 diff changeset	474 ]
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	475
239 b18f89d6d17f Adde draft for permissions systems, made all needed decorators, and checks. For future usage in the system. Marcin Kuzminski <marcin@python-works.com> parents: 234 diff changeset	476 for p in perms:
b18f89d6d17f Adde draft for permissions systems, made all needed decorators, and checks. For future usage in the system. Marcin Kuzminski <marcin@python-works.com> parents: 234 diff changeset	477 new_perm = Permission()
b18f89d6d17f Adde draft for permissions systems, made all needed decorators, and checks. For future usage in the system. Marcin Kuzminski <marcin@python-works.com> parents: 234 diff changeset	478 new_perm.permission_name = p[0]
b18f89d6d17f Adde draft for permissions systems, made all needed decorators, and checks. For future usage in the system. Marcin Kuzminski <marcin@python-works.com> parents: 234 diff changeset	479 new_perm.permission_longname = p[1]
b18f89d6d17f Adde draft for permissions systems, made all needed decorators, and checks. For future usage in the system. Marcin Kuzminski <marcin@python-works.com> parents: 234 diff changeset	480 try:
b18f89d6d17f Adde draft for permissions systems, made all needed decorators, and checks. For future usage in the system. Marcin Kuzminski <marcin@python-works.com> parents: 234 diff changeset	481 self.sa.add(new_perm)
b18f89d6d17f Adde draft for permissions systems, made all needed decorators, and checks. For future usage in the system. Marcin Kuzminski <marcin@python-works.com> parents: 234 diff changeset	482 self.sa.commit()
b18f89d6d17f Adde draft for permissions systems, made all needed decorators, and checks. For future usage in the system. Marcin Kuzminski <marcin@python-works.com> parents: 234 diff changeset	483 except:
b18f89d6d17f Adde draft for permissions systems, made all needed decorators, and checks. For future usage in the system. Marcin Kuzminski <marcin@python-works.com> parents: 234 diff changeset	484 self.sa.rollback()
b18f89d6d17f Adde draft for permissions systems, made all needed decorators, and checks. For future usage in the system. Marcin Kuzminski <marcin@python-works.com> parents: 234 diff changeset	485 raise
417 3ed2d46a2ca7 permission refactoring, Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	486
3ed2d46a2ca7 permission refactoring, Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	487 def populate_default_permissions(self):
3ed2d46a2ca7 permission refactoring, Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	488 log.info('creating default user permissions')
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	489
417 3ed2d46a2ca7 permission refactoring, Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	490 default_user = self.sa.query(User)\
3ed2d46a2ca7 permission refactoring, Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	491 .filter(User.username == 'default').scalar()
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	492
417 3ed2d46a2ca7 permission refactoring, Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	493 reg_perm = UserToPerm()
3ed2d46a2ca7 permission refactoring, Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	494 reg_perm.user = default_user
3ed2d46a2ca7 permission refactoring, Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	495 reg_perm.permission = self.sa.query(Permission)\
3ed2d46a2ca7 permission refactoring, Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	496 .filter(Permission.permission_name == 'hg.register.manual_activate')\
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	497 .scalar()
7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	498
417 3ed2d46a2ca7 permission refactoring, Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	499 create_repo_perm = UserToPerm()
3ed2d46a2ca7 permission refactoring, Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	500 create_repo_perm.user = default_user
3ed2d46a2ca7 permission refactoring, Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	501 create_repo_perm.permission = self.sa.query(Permission)\
3ed2d46a2ca7 permission refactoring, Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	502 .filter(Permission.permission_name == 'hg.create.repository')\
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	503 .scalar()
7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	504
417 3ed2d46a2ca7 permission refactoring, Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	505 default_repo_perm = UserToPerm()
3ed2d46a2ca7 permission refactoring, Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	506 default_repo_perm.user = default_user
3ed2d46a2ca7 permission refactoring, Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	507 default_repo_perm.permission = self.sa.query(Permission)\
3ed2d46a2ca7 permission refactoring, Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	508 .filter(Permission.permission_name == 'repository.read')\
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	509 .scalar()
7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	510
417 3ed2d46a2ca7 permission refactoring, Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	511 try:
3ed2d46a2ca7 permission refactoring, Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	512 self.sa.add(reg_perm)
3ed2d46a2ca7 permission refactoring, Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	513 self.sa.add(create_repo_perm)
3ed2d46a2ca7 permission refactoring, Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	514 self.sa.add(default_repo_perm)
3ed2d46a2ca7 permission refactoring, Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	515 self.sa.commit()
3ed2d46a2ca7 permission refactoring, Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	516 except:
3ed2d46a2ca7 permission refactoring, Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	517 self.sa.rollback()
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	518 raise

Mercurial > kallithea

annotate rhodecode/lib/db_manage.py @ 1203:6832ef664673 beta