comparison pylons_app/lib/db_manage.py @ 345:0e87466a117e

updated installation instruction, made more user friendly way of creating all needed configs. All is done now from paster setup-app
author Marcin Kuzminski <marcin@python-works.com>
date Thu, 01 Jul 2010 00:57:45 +0200
parents 504feff57b49
children 1ef52a70f3b7
comparison
equal deleted inserted replaced
344:674e0085ccc7 345:0e87466a117e
25 """ 25 """
26 26
27 from os.path import dirname as dn, join as jn 27 from os.path import dirname as dn, join as jn
28 import os 28 import os
29 import sys 29 import sys
30 import uuid
30 ROOT = dn(dn(dn(os.path.realpath(__file__)))) 31 ROOT = dn(dn(dn(os.path.realpath(__file__))))
31 sys.path.append(ROOT) 32 sys.path.append(ROOT)
32 33
33 from pylons_app.lib.auth import get_crypt_password 34 from pylons_app.lib.auth import get_crypt_password
34 from pylons_app.model import init_model 35 from pylons_app.model import init_model
39 40
40 log = logging.getLogger('db manage') 41 log = logging.getLogger('db manage')
41 log.setLevel(logging.DEBUG) 42 log.setLevel(logging.DEBUG)
42 console_handler = logging.StreamHandler() 43 console_handler = logging.StreamHandler()
43 console_handler.setFormatter(logging.Formatter("%(asctime)s.%(msecs)03d" 44 console_handler.setFormatter(logging.Formatter("%(asctime)s.%(msecs)03d"
44 " %(levelname)-5.5s [%(name)s] %(message)s")) 45 " %(levelname)-5.5s [%(name)s] %(message)s"))
45 log.addHandler(console_handler) 46 log.addHandler(console_handler)
46 47
47 class DbManage(object): 48 class DbManage(object):
48 def __init__(self, log_sql): 49 def __init__(self, log_sql):
49 self.dbname = 'hg_app.db' 50 self.dbname = 'hg_app.db'
83 84
84 log.info('creating default user') 85 log.info('creating default user')
85 #create default user for handling default permissions. 86 #create default user for handling default permissions.
86 def_user = User() 87 def_user = User()
87 def_user.username = 'default' 88 def_user.username = 'default'
88 def_user.password = 'default' 89 def_user.password = get_crypt_password(str(uuid.uuid1())[:8])
89 def_user.name = 'default' 90 def_user.name = 'default'
90 def_user.lastname = 'default' 91 def_user.lastname = 'default'
91 def_user.email = 'default@default' 92 def_user.email = 'default@default.com'
92 def_user.admin = False 93 def_user.admin = False
93 def_user.active = False 94 def_user.active = False
94 95
95 self.sa.add(def_user) 96 self.sa.add(def_user)
96 97
129 self.sa.add(new_perm) 130 self.sa.add(new_perm)
130 self.sa.commit() 131 self.sa.commit()
131 except: 132 except:
132 self.sa.rollback() 133 self.sa.rollback()
133 raise 134 raise
134
135
136
137 if __name__ == '__main__':
138 dbmanage = DbManage(log_sql=True)
139 dbmanage.create_tables(override=True)
140 dbmanage.admin_prompt()
141 dbmanage.create_permissions()
142
143