kallithea: rhodecode/lib/db_manage.py annotate

annotate rhodecode/lib/db_manage.py @ 1116:716911af91e1 beta

Added api_key into user, api key get's generated again after password change updated ini files

author	Marcin Kuzminski <marcin@python-works.com>
date	Sun, 06 Mar 2011 00:06:28 +0100
parents	44661d2a7b61
children	9c45e11493fb

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
835 08d2dcd71666 fixed imports on migrate, added getting current version from database Marcin Kuzminski <marcin@python-works.com> parents: 834 diff changeset	8
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
902 07a6e8c65526 fixed copyright year to 2011 Marcin Kuzminski <marcin@python-works.com> parents: 900 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.
3782a6d698af licensing updates, code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 249 diff changeset	18 #
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.
3782a6d698af licensing updates, code cleanups Marcin Kuzminski <marcin@python-works.com> parents: 249 diff changeset	23 #
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 check_for_db(self, override):
552 2642f128ad46 removed egg info, update files for distutils build Marcin Kuzminski <marcin@python-works.com> parents: 549 diff changeset	64 db_path = jn(self.root, self.dbname)
781 7ae66bddf48d fixed db manage, to work on other databases than sqlite Marcin Kuzminski <marcin@python-works.com> parents: 773 diff changeset	65 if self.dburi.startswith('sqlite'):
7ae66bddf48d fixed db manage, to work on other databases than sqlite Marcin Kuzminski <marcin@python-works.com> parents: 773 diff changeset	66 log.info('checking for existing db in %s', db_path)
7ae66bddf48d fixed db manage, to work on other databases than sqlite Marcin Kuzminski <marcin@python-works.com> parents: 773 diff changeset	67 if os.path.isfile(db_path):
7ae66bddf48d fixed db manage, to work on other databases than sqlite Marcin Kuzminski <marcin@python-works.com> parents: 773 diff changeset	68
7ae66bddf48d fixed db manage, to work on other databases than sqlite Marcin Kuzminski <marcin@python-works.com> parents: 773 diff changeset	69 self.db_exists = True
7ae66bddf48d fixed db manage, to work on other databases than sqlite Marcin Kuzminski <marcin@python-works.com> parents: 773 diff changeset	70 if not override:
7ae66bddf48d fixed db manage, to work on other databases than sqlite Marcin Kuzminski <marcin@python-works.com> parents: 773 diff changeset	71 raise Exception('database already exists')
964 84bb5b8b498d changed dev and tests to postgressql for more error proof setup. Marcin Kuzminski <marcin@python-works.com> parents: 907 diff changeset	72 return 'sqlite'
84bb5b8b498d changed dev and tests to postgressql for more error proof setup. Marcin Kuzminski <marcin@python-works.com> parents: 907 diff changeset	73 if self.dburi.startswith('postgresql'):
84bb5b8b498d changed dev and tests to postgressql for more error proof setup. Marcin Kuzminski <marcin@python-works.com> parents: 907 diff changeset	74 self.db_exists = True
84bb5b8b498d changed dev and tests to postgressql for more error proof setup. Marcin Kuzminski <marcin@python-works.com> parents: 907 diff changeset	75 return 'postgresql'
84bb5b8b498d changed dev and tests to postgressql for more error proof setup. Marcin Kuzminski <marcin@python-works.com> parents: 907 diff changeset	76
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	77
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	78 def create_tables(self, override=False):
837 60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	79 """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	80 """
837 60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	81
964 84bb5b8b498d changed dev and tests to postgressql for more error proof setup. Marcin Kuzminski <marcin@python-works.com> parents: 907 diff changeset	82 db_type = self.check_for_db(override)
597 53128b6b9a4d added password validation, second try on paster setup-app, Marcin Kuzminski <marcin@python-works.com> parents: 569 diff changeset	83 if self.db_exists:
552 2642f128ad46 removed egg info, update files for distutils build Marcin Kuzminski <marcin@python-works.com> parents: 549 diff changeset	84 log.info("database exist and it's going to be destroyed")
459 7c978511c951 implemented basic (startup) nose test suite. Marcin Kuzminski <marcin@python-works.com> parents: 417 diff changeset	85 if self.tests:
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	86 destroy = True
459 7c978511c951 implemented basic (startup) nose test suite. Marcin Kuzminski <marcin@python-works.com> parents: 417 diff changeset	87 else:
7c978511c951 implemented basic (startup) nose test suite. Marcin Kuzminski <marcin@python-works.com> parents: 417 diff changeset	88 destroy = ask_ok('Are you sure to destroy old database ? [y/n]')
351 d09381593b12 updated db manage script, and remove broken test Marcin Kuzminski <marcin@python-works.com> parents: 350 diff changeset	89 if not destroy:
d09381593b12 updated db manage script, and remove broken test Marcin Kuzminski <marcin@python-works.com> parents: 350 diff changeset	90 sys.exit()
d09381593b12 updated db manage script, and remove broken test Marcin Kuzminski <marcin@python-works.com> parents: 350 diff changeset	91 if self.db_exists and destroy:
964 84bb5b8b498d changed dev and tests to postgressql for more error proof setup. Marcin Kuzminski <marcin@python-works.com> parents: 907 diff changeset	92 if db_type == 'sqlite':
84bb5b8b498d changed dev and tests to postgressql for more error proof setup. Marcin Kuzminski <marcin@python-works.com> parents: 907 diff changeset	93 os.remove(jn(self.root, self.dbname))
84bb5b8b498d changed dev and tests to postgressql for more error proof setup. Marcin Kuzminski <marcin@python-works.com> parents: 907 diff changeset	94 if db_type == 'postgresql':
84bb5b8b498d changed dev and tests to postgressql for more error proof setup. Marcin Kuzminski <marcin@python-works.com> parents: 907 diff changeset	95 meta.Base.metadata.drop_all()
84bb5b8b498d changed dev and tests to postgressql for more error proof setup. Marcin Kuzminski <marcin@python-works.com> parents: 907 diff changeset	96
351 d09381593b12 updated db manage script, and remove broken test Marcin Kuzminski <marcin@python-works.com> parents: 350 diff changeset	97 checkfirst = not override
d09381593b12 updated db manage script, and remove broken test Marcin Kuzminski <marcin@python-works.com> parents: 350 diff changeset	98 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	99 log.info('Created tables for %s', self.dbname)
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	100
834 8924ed0e4f36 added current db version into rhodecode, Marcin Kuzminski <marcin@python-works.com> parents: 781 diff changeset	101
8924ed0e4f36 added current db version into rhodecode, Marcin Kuzminski <marcin@python-works.com> parents: 781 diff changeset	102
8924ed0e4f36 added current db version into rhodecode, Marcin Kuzminski <marcin@python-works.com> parents: 781 diff changeset	103 def set_db_version(self):
8924ed0e4f36 added current db version into rhodecode, Marcin Kuzminski <marcin@python-works.com> parents: 781 diff changeset	104 try:
8924ed0e4f36 added current db version into rhodecode, Marcin Kuzminski <marcin@python-works.com> parents: 781 diff changeset	105 ver = DbMigrateVersion()
8924ed0e4f36 added current db version into rhodecode, Marcin Kuzminski <marcin@python-works.com> parents: 781 diff changeset	106 ver.version = __dbversion__
8924ed0e4f36 added current db version into rhodecode, Marcin Kuzminski <marcin@python-works.com> parents: 781 diff changeset	107 ver.repository_id = 'rhodecode_db_migrations'
8924ed0e4f36 added current db version into rhodecode, Marcin Kuzminski <marcin@python-works.com> parents: 781 diff changeset	108 ver.repository_path = 'versions'
8924ed0e4f36 added current db version into rhodecode, Marcin Kuzminski <marcin@python-works.com> parents: 781 diff changeset	109 self.sa.add(ver)
8924ed0e4f36 added current db version into rhodecode, Marcin Kuzminski <marcin@python-works.com> parents: 781 diff changeset	110 self.sa.commit()
8924ed0e4f36 added current db version into rhodecode, Marcin Kuzminski <marcin@python-works.com> parents: 781 diff changeset	111 except:
8924ed0e4f36 added current db version into rhodecode, Marcin Kuzminski <marcin@python-works.com> parents: 781 diff changeset	112 self.sa.rollback()
8924ed0e4f36 added current db version into rhodecode, Marcin Kuzminski <marcin@python-works.com> parents: 781 diff changeset	113 raise
8924ed0e4f36 added current db version into rhodecode, Marcin Kuzminski <marcin@python-works.com> parents: 781 diff changeset	114 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	115
839 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 def upgrade(self):
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	118 """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	119 all needed steps, to perform the upgrade
839 ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	120
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	121 """
841 78b3d2d730f2 fixed import problems Marcin Kuzminski <marcin@python-works.com> parents: 839 diff changeset	122
78b3d2d730f2 fixed import problems Marcin Kuzminski <marcin@python-works.com> parents: 839 diff changeset	123 from rhodecode.lib.dbmigrate.migrate.versioning import api
78b3d2d730f2 fixed import problems Marcin Kuzminski <marcin@python-works.com> parents: 839 diff changeset	124 from rhodecode.lib.dbmigrate.migrate.exceptions import \
78b3d2d730f2 fixed import problems Marcin Kuzminski <marcin@python-works.com> parents: 839 diff changeset	125 DatabaseNotControlledError
78b3d2d730f2 fixed import problems Marcin Kuzminski <marcin@python-works.com> parents: 839 diff changeset	126
839 ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	127 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	128 '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	129 '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	130 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	131 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	132
843 3b21ba5f7cb0 fixed path issues in upgrade script Marcin Kuzminski <marcin@python-works.com> parents: 841 diff changeset	133 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	134 '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	135 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	136
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	137 try:
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	138 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	139 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	140 ' 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	141
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	142 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	143 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	144 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	145 ' 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	146 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	147
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	148 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	149
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	150 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	151 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	152
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 # 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	155 #======================================================================
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	156 class UpgradeSteps(object):
900 07f248329a3b updated migration for version 1.2 Marcin Kuzminski <marcin@python-works.com> parents: 890 diff changeset	157 """Those steps follow schema versions so for example schema
07f248329a3b updated migration for version 1.2 Marcin Kuzminski <marcin@python-works.com> parents: 890 diff changeset	158 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	159 """
839 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 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	162 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	163
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	164 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	165 #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	166 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	167 % __dbversion__)
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	168 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	169 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	170
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	171 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	172 pass
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	173
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	174 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	175 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	176 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	177
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	178 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	179 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	180
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	181 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	182 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	183
890 042d38683d42 implemented #89 google analytics code Marcin Kuzminski <marcin@python-works.com> parents: 843 diff changeset	184 def step_3(self):
042d38683d42 implemented #89 google analytics code Marcin Kuzminski <marcin@python-works.com> parents: 843 diff changeset	185 print ('Adding additional settings into RhodeCode db')
042d38683d42 implemented #89 google analytics code Marcin Kuzminski <marcin@python-works.com> parents: 843 diff changeset	186 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	187
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	188 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	189
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	190 #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	191 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	192 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	193 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	194
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	195
ad66bd0e5601 moved db migration do db manage script, added my cycles for upgrades Marcin Kuzminski <marcin@python-works.com> parents: 838 diff changeset	196
837 60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	197 def fix_repo_paths(self):
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	198 """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	199 """
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	200
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	201 paths = self.sa.query(RhodeCodeUi)\
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	202 .filter(RhodeCodeUi.ui_key == '/')\
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	203 .scalar()
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	204
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	205 paths.ui_value = paths.ui_value.replace('*', '')
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	206
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	207 try:
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	208 self.sa.add(paths)
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	209 self.sa.commit()
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	210 except:
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	211 self.sa.rollback()
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	212 raise
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	213
838 12eb1a018199 db migrations: Marcin Kuzminski <marcin@python-works.com> parents: 837 diff changeset	214 def fix_default_user(self):
12eb1a018199 db migrations: Marcin Kuzminski <marcin@python-works.com> parents: 837 diff changeset	215 """Fixes a old default user with some 'nicer' default values,
12eb1a018199 db migrations: Marcin Kuzminski <marcin@python-works.com> parents: 837 diff changeset	216 used mostly for anonymous access
12eb1a018199 db migrations: Marcin Kuzminski <marcin@python-works.com> parents: 837 diff changeset	217 """
12eb1a018199 db migrations: Marcin Kuzminski <marcin@python-works.com> parents: 837 diff changeset	218 def_user = self.sa.query(User)\
12eb1a018199 db migrations: Marcin Kuzminski <marcin@python-works.com> parents: 837 diff changeset	219 .filter(User.username == 'default')\
12eb1a018199 db migrations: Marcin Kuzminski <marcin@python-works.com> parents: 837 diff changeset	220 .one()
12eb1a018199 db migrations: Marcin Kuzminski <marcin@python-works.com> parents: 837 diff changeset	221
12eb1a018199 db migrations: Marcin Kuzminski <marcin@python-works.com> parents: 837 diff changeset	222 def_user.name = 'Anonymous'
12eb1a018199 db migrations: Marcin Kuzminski <marcin@python-works.com> parents: 837 diff changeset	223 def_user.lastname = 'User'
12eb1a018199 db migrations: Marcin Kuzminski <marcin@python-works.com> parents: 837 diff changeset	224 def_user.email = 'anonymous@rhodecode.org'
12eb1a018199 db migrations: Marcin Kuzminski <marcin@python-works.com> parents: 837 diff changeset	225
12eb1a018199 db migrations: Marcin Kuzminski <marcin@python-works.com> parents: 837 diff changeset	226 try:
12eb1a018199 db migrations: Marcin Kuzminski <marcin@python-works.com> parents: 837 diff changeset	227 self.sa.add(def_user)
12eb1a018199 db migrations: Marcin Kuzminski <marcin@python-works.com> parents: 837 diff changeset	228 self.sa.commit()
12eb1a018199 db migrations: Marcin Kuzminski <marcin@python-works.com> parents: 837 diff changeset	229 except:
12eb1a018199 db migrations: Marcin Kuzminski <marcin@python-works.com> parents: 837 diff changeset	230 self.sa.rollback()
12eb1a018199 db migrations: Marcin Kuzminski <marcin@python-works.com> parents: 837 diff changeset	231 raise
12eb1a018199 db migrations: Marcin Kuzminski <marcin@python-works.com> parents: 837 diff changeset	232
890 042d38683d42 implemented #89 google analytics code Marcin Kuzminski <marcin@python-works.com> parents: 843 diff changeset	233 def fix_settings(self):
042d38683d42 implemented #89 google analytics code Marcin Kuzminski <marcin@python-works.com> parents: 843 diff changeset	234 """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	235 """
837 60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	236
890 042d38683d42 implemented #89 google analytics code Marcin Kuzminski <marcin@python-works.com> parents: 843 diff changeset	237 hgsettings3 = RhodeCodeSettings('ga_code', '')
907 2f83756f3041 Fixed dbmigrate issues. Marcin Kuzminski <marcin@python-works.com> parents: 902 diff changeset	238
890 042d38683d42 implemented #89 google analytics code Marcin Kuzminski <marcin@python-works.com> parents: 843 diff changeset	239 try:
042d38683d42 implemented #89 google analytics code Marcin Kuzminski <marcin@python-works.com> parents: 843 diff changeset	240 self.sa.add(hgsettings3)
042d38683d42 implemented #89 google analytics code Marcin Kuzminski <marcin@python-works.com> parents: 843 diff changeset	241 self.sa.commit()
042d38683d42 implemented #89 google analytics code Marcin Kuzminski <marcin@python-works.com> parents: 843 diff changeset	242 except:
042d38683d42 implemented #89 google analytics code Marcin Kuzminski <marcin@python-works.com> parents: 843 diff changeset	243 self.sa.rollback()
042d38683d42 implemented #89 google analytics code Marcin Kuzminski <marcin@python-works.com> parents: 843 diff changeset	244 raise
837 60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 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 def admin_prompt(self, second=False):
459 7c978511c951 implemented basic (startup) nose test suite. Marcin Kuzminski <marcin@python-works.com> parents: 417 diff changeset	247 if not self.tests:
7c978511c951 implemented basic (startup) nose test suite. Marcin Kuzminski <marcin@python-works.com> parents: 417 diff changeset	248 import getpass
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	249
7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	250
597 53128b6b9a4d added password validation, second try on paster setup-app, Marcin Kuzminski <marcin@python-works.com> parents: 569 diff changeset	251 def get_password():
53128b6b9a4d added password validation, second try on paster setup-app, Marcin Kuzminski <marcin@python-works.com> parents: 569 diff changeset	252 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	253 confirm = getpass.getpass('Confirm password:')
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	254
597 53128b6b9a4d added password validation, second try on paster setup-app, Marcin Kuzminski <marcin@python-works.com> parents: 569 diff changeset	255 if password != confirm:
53128b6b9a4d added password validation, second try on paster setup-app, Marcin Kuzminski <marcin@python-works.com> parents: 569 diff changeset	256 log.error('passwords mismatch')
53128b6b9a4d added password validation, second try on paster setup-app, Marcin Kuzminski <marcin@python-works.com> parents: 569 diff changeset	257 return False
53128b6b9a4d added password validation, second try on paster setup-app, Marcin Kuzminski <marcin@python-works.com> parents: 569 diff changeset	258 if len(password) < 6:
53128b6b9a4d added password validation, second try on paster setup-app, Marcin Kuzminski <marcin@python-works.com> parents: 569 diff changeset	259 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	260 return False
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	261
597 53128b6b9a4d added password validation, second try on paster setup-app, Marcin Kuzminski <marcin@python-works.com> parents: 569 diff changeset	262 return password
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	263
459 7c978511c951 implemented basic (startup) nose test suite. Marcin Kuzminski <marcin@python-works.com> parents: 417 diff changeset	264 username = raw_input('Specify admin username:')
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	265
597 53128b6b9a4d added password validation, second try on paster setup-app, Marcin Kuzminski <marcin@python-works.com> parents: 569 diff changeset	266 password = get_password()
53128b6b9a4d added password validation, second try on paster setup-app, Marcin Kuzminski <marcin@python-works.com> parents: 569 diff changeset	267 if not password:
53128b6b9a4d added password validation, second try on paster setup-app, Marcin Kuzminski <marcin@python-works.com> parents: 569 diff changeset	268 #second try
53128b6b9a4d added password validation, second try on paster setup-app, Marcin Kuzminski <marcin@python-works.com> parents: 569 diff changeset	269 password = get_password()
53128b6b9a4d added password validation, second try on paster setup-app, Marcin Kuzminski <marcin@python-works.com> parents: 569 diff changeset	270 if not password:
53128b6b9a4d added password validation, second try on paster setup-app, Marcin Kuzminski <marcin@python-works.com> parents: 569 diff changeset	271 sys.exit()
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	272
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	273 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	274 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	275 else:
7c978511c951 implemented basic (startup) nose test suite. Marcin Kuzminski <marcin@python-works.com> parents: 417 diff changeset	276 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	277 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	278 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	279 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	280
837 60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	281 def create_ui_settings(self):
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	282 """Creates ui settings, fills out hooks
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	283 and disables dotencode
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	284
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 #HOOKS
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	287 hooks1_key = 'changegroup.update'
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	288 hooks1_ = self.sa.query(RhodeCodeUi)\
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	289 .filter(RhodeCodeUi.ui_key == hooks1_key).scalar()
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	290
837 60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	291 hooks1 = RhodeCodeUi() if hooks1_ is None else hooks1_
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	292 hooks1.ui_section = 'hooks'
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	293 hooks1.ui_key = hooks1_key
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	294 hooks1.ui_value = 'hg update >&2'
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	295 hooks1.ui_active = False
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	296
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	297 hooks2_key = 'changegroup.repo_size'
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	298 hooks2_ = self.sa.query(RhodeCodeUi)\
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	299 .filter(RhodeCodeUi.ui_key == hooks2_key).scalar()
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	300
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	301 hooks2 = RhodeCodeUi() if hooks2_ is None else hooks2_
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	302 hooks2.ui_section = 'hooks'
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	303 hooks2.ui_key = hooks2_key
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	304 hooks2.ui_value = 'python:rhodecode.lib.hooks.repo_size'
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	305
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	306 hooks3 = RhodeCodeUi()
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	307 hooks3.ui_section = 'hooks'
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	308 hooks3.ui_key = 'pretxnchangegroup.push_logger'
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	309 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	310
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	311 hooks4 = RhodeCodeUi()
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	312 hooks4.ui_section = 'hooks'
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	313 hooks4.ui_key = 'preoutgoing.pull_logger'
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	314 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	315
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	316 #For mercurial 1.7 set backward comapatibility with format
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	317 dotencode_disable = RhodeCodeUi()
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	318 dotencode_disable.ui_section = 'format'
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	319 dotencode_disable.ui_key = 'dotencode'
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	320 dotencode_disable.ui_value = 'false'
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	321
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	322 try:
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	323 self.sa.add(hooks1)
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	324 self.sa.add(hooks2)
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	325 self.sa.add(hooks3)
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	326 self.sa.add(hooks4)
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	327 self.sa.add(dotencode_disable)
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	328 self.sa.commit()
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	329 except:
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	330 self.sa.rollback()
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	331 raise
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	332
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	333
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	334 def create_ldap_options(self):
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	335 """Creates ldap settings"""
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	336
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	337 try:
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	338 for k in ['ldap_active', 'ldap_host', 'ldap_port', 'ldap_ldaps',
991 b232a36cc51f Improve LDAP authentication Thayne Harbaugh <thayne@fusionio.com> parents: 964 diff changeset	339 'ldap_tls_reqcert', 'ldap_dn_user', 'ldap_dn_pass',
b232a36cc51f Improve LDAP authentication Thayne Harbaugh <thayne@fusionio.com> parents: 964 diff changeset	340 'ldap_base_dn', 'ldap_filter', 'ldap_search_scope',
b232a36cc51f Improve LDAP authentication Thayne Harbaugh <thayne@fusionio.com> parents: 964 diff changeset	341 'ldap_attr_login', 'ldap_attr_firstname', 'ldap_attr_lastname',
b232a36cc51f Improve LDAP authentication Thayne Harbaugh <thayne@fusionio.com> parents: 964 diff changeset	342 'ldap_attr_email']:
837 60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	343
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	344 setting = RhodeCodeSettings(k, '')
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	345 self.sa.add(setting)
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	346 self.sa.commit()
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	347 except:
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	348 self.sa.rollback()
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	349 raise
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	350
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	351 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	352 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	353 log.info('Setting up repositories config')
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	354
459 7c978511c951 implemented basic (startup) nose test suite. Marcin Kuzminski <marcin@python-works.com> parents: 417 diff changeset	355 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	356 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	357 ' 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	358 else:
7c978511c951 implemented basic (startup) nose test suite. Marcin Kuzminski <marcin@python-works.com> parents: 417 diff changeset	359 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	360 path_ok = True
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	361
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	362 #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	363 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	364 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	365 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	366 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	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 #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	369 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	370 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	371
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	372 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	373 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	374
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	375
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	376 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	377 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	378 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	379 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	380 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	381
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	382
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	383 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	384
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	385 def create_settings(self, path):
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	386
837 60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	387 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	388
837 60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	389 #HG UI OPTIONS
549 f99075170eb4 more renames for rhode code !! Marcin Kuzminski <marcin@python-works.com> parents: 547 diff changeset	390 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	391 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	392 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	393 web1.ui_value = 'false'
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	394
549 f99075170eb4 more renames for rhode code !! Marcin Kuzminski <marcin@python-works.com> parents: 547 diff changeset	395 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	396 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	397 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	398 web2.ui_value = 'gz zip bz2'
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	399
549 f99075170eb4 more renames for rhode code !! Marcin Kuzminski <marcin@python-works.com> parents: 547 diff changeset	400 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	401 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	402 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	403 web3.ui_value = '*'
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	404
549 f99075170eb4 more renames for rhode code !! Marcin Kuzminski <marcin@python-works.com> parents: 547 diff changeset	405 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	406 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	407 web4.ui_key = 'baseurl'
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	408 web4.ui_value = '/'
7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	409
549 f99075170eb4 more renames for rhode code !! Marcin Kuzminski <marcin@python-works.com> parents: 547 diff changeset	410 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	411 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	412 paths.ui_key = '/'
631 05528ad948c4 Hacking for git support,and new faster repo scan Marcin Kuzminski <marcin@python-works.com> parents: 629 diff changeset	413 paths.ui_value = path
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	414
7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	415
704 26237de9b613 Added settings model, and Exceptions lib. Marcin Kuzminski <marcin@python-works.com> parents: 673 diff changeset	416 hgsettings1 = RhodeCodeSettings('realm', 'RhodeCode authentication')
26237de9b613 Added settings model, and Exceptions lib. Marcin Kuzminski <marcin@python-works.com> parents: 673 diff changeset	417 hgsettings2 = RhodeCodeSettings('title', 'RhodeCode')
890 042d38683d42 implemented #89 google analytics code Marcin Kuzminski <marcin@python-works.com> parents: 843 diff changeset	418 hgsettings3 = RhodeCodeSettings('ga_code', '')
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	419
7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 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 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	422 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	423 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	424 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	425 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	426 self.sa.add(paths)
381 55377fdc1fc6 cleared global application settings. Marcin Kuzminski <marcin@python-works.com> parents: 371 diff changeset	427 self.sa.add(hgsettings1)
55377fdc1fc6 cleared global application settings. Marcin Kuzminski <marcin@python-works.com> parents: 371 diff changeset	428 self.sa.add(hgsettings2)
890 042d38683d42 implemented #89 google analytics code Marcin Kuzminski <marcin@python-works.com> parents: 843 diff changeset	429 self.sa.add(hgsettings3)
704 26237de9b613 Added settings model, and Exceptions lib. Marcin Kuzminski <marcin@python-works.com> parents: 673 diff changeset	430
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	431 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	432 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	433 self.sa.rollback()
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	434 raise
837 60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	435
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	436 self.create_ldap_options()
60cbde084047 fixed wrong migration schema Marcin Kuzminski <marcin@python-works.com> parents: 835 diff changeset	437
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	438 log.info('created ui config')
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	439
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	440 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	441 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	442 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	443 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	444 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	445 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	446 new_user.name = 'RhodeCode'
262 a4be1ebb214f updated db manage with some defaults Marcin Kuzminski <marcin@python-works.com> parents: 252 diff changeset	447 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	448 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	449 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	450 new_user.active = True
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	451
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	452 try:
459 7c978511c951 implemented basic (startup) nose test suite. Marcin Kuzminski <marcin@python-works.com> parents: 417 diff changeset	453 self.sa.add(new_user)
7c978511c951 implemented basic (startup) nose test suite. Marcin Kuzminski <marcin@python-works.com> parents: 417 diff changeset	454 self.sa.commit()
7c978511c951 implemented basic (startup) nose test suite. Marcin Kuzminski <marcin@python-works.com> parents: 417 diff changeset	455 except:
7c978511c951 implemented basic (startup) nose test suite. Marcin Kuzminski <marcin@python-works.com> parents: 417 diff changeset	456 self.sa.rollback()
7c978511c951 implemented basic (startup) nose test suite. Marcin Kuzminski <marcin@python-works.com> parents: 417 diff changeset	457 raise
7c978511c951 implemented basic (startup) nose test suite. Marcin Kuzminski <marcin@python-works.com> parents: 417 diff changeset	458
7c978511c951 implemented basic (startup) nose test suite. Marcin Kuzminski <marcin@python-works.com> parents: 417 diff changeset	459 def create_default_user(self):
7c978511c951 implemented basic (startup) nose test suite. Marcin Kuzminski <marcin@python-works.com> parents: 417 diff changeset	460 log.info('creating default user')
7c978511c951 implemented basic (startup) nose test suite. Marcin Kuzminski <marcin@python-works.com> parents: 417 diff changeset	461 #create default user for handling default permissions.
7c978511c951 implemented basic (startup) nose test suite. Marcin Kuzminski <marcin@python-works.com> parents: 417 diff changeset	462 def_user = User()
7c978511c951 implemented basic (startup) nose test suite. Marcin Kuzminski <marcin@python-works.com> parents: 417 diff changeset	463 def_user.username = 'default'
7c978511c951 implemented basic (startup) nose test suite. Marcin Kuzminski <marcin@python-works.com> parents: 417 diff changeset	464 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	465 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	466 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	467 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	468 def_user.email = 'anonymous@rhodecode.org'
459 7c978511c951 implemented basic (startup) nose test suite. Marcin Kuzminski <marcin@python-works.com> parents: 417 diff changeset	469 def_user.admin = False
7c978511c951 implemented basic (startup) nose test suite. Marcin Kuzminski <marcin@python-works.com> parents: 417 diff changeset	470 def_user.active = False
7c978511c951 implemented basic (startup) nose test suite. Marcin Kuzminski <marcin@python-works.com> parents: 417 diff changeset	471 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	472 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	473 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	474 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	475 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	476 raise
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	477
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	478 def create_permissions(self):
240 7c4fa2a66195 small fixes Marcin Kuzminski <marcin@python-works.com> parents: 239 diff changeset	479 #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	480 #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	481 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	482 ('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	483 ('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	484 ('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	485 ('hg.admin', 'Hg Administrator'),
417 3ed2d46a2ca7 permission refactoring, Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	486 ('hg.create.repository', 'Repository create'),
3ed2d46a2ca7 permission refactoring, Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	487 ('hg.create.none', 'Repository creation disabled'),
3ed2d46a2ca7 permission refactoring, Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	488 ('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	489 ('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	490 ('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	491 ]
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	492
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	493 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	494 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	495 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	496 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	497 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	498 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	499 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	500 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	501 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	502 raise
417 3ed2d46a2ca7 permission refactoring, Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	503
3ed2d46a2ca7 permission refactoring, Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	504 def populate_default_permissions(self):
3ed2d46a2ca7 permission refactoring, Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	505 log.info('creating default user permissions')
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	506
417 3ed2d46a2ca7 permission refactoring, Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	507 default_user = self.sa.query(User)\
3ed2d46a2ca7 permission refactoring, Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	508 .filter(User.username == 'default').scalar()
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	509
417 3ed2d46a2ca7 permission refactoring, Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	510 reg_perm = UserToPerm()
3ed2d46a2ca7 permission refactoring, Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	511 reg_perm.user = default_user
3ed2d46a2ca7 permission refactoring, Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	512 reg_perm.permission = self.sa.query(Permission)\
3ed2d46a2ca7 permission refactoring, Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	513 .filter(Permission.permission_name == 'hg.register.manual_activate')\
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	514 .scalar()
7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	515
417 3ed2d46a2ca7 permission refactoring, Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	516 create_repo_perm = UserToPerm()
3ed2d46a2ca7 permission refactoring, Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	517 create_repo_perm.user = default_user
3ed2d46a2ca7 permission refactoring, Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	518 create_repo_perm.permission = self.sa.query(Permission)\
3ed2d46a2ca7 permission refactoring, Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	519 .filter(Permission.permission_name == 'hg.create.repository')\
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	520 .scalar()
7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	521
417 3ed2d46a2ca7 permission refactoring, Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	522 default_repo_perm = UserToPerm()
3ed2d46a2ca7 permission refactoring, Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	523 default_repo_perm.user = default_user
3ed2d46a2ca7 permission refactoring, Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	524 default_repo_perm.permission = self.sa.query(Permission)\
3ed2d46a2ca7 permission refactoring, Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	525 .filter(Permission.permission_name == 'repository.read')\
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	526 .scalar()
7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	527
417 3ed2d46a2ca7 permission refactoring, Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	528 try:
3ed2d46a2ca7 permission refactoring, Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	529 self.sa.add(reg_perm)
3ed2d46a2ca7 permission refactoring, Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	530 self.sa.add(create_repo_perm)
3ed2d46a2ca7 permission refactoring, Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	531 self.sa.add(default_repo_perm)
3ed2d46a2ca7 permission refactoring, Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	532 self.sa.commit()
3ed2d46a2ca7 permission refactoring, Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	533 except:
3ed2d46a2ca7 permission refactoring, Marcin Kuzminski <marcin@python-works.com> parents: 392 diff changeset	534 self.sa.rollback()
629 7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	535 raise
7e536d1af60d Code refactoring,models renames Marcin Kuzminski <marcin@python-works.com> parents: 597 diff changeset	536

Mercurial > kallithea

annotate rhodecode/lib/db_manage.py @ 1116:716911af91e1 beta