upstream/kallithea Files · pylons_app/lib/db_manage.py

db manage added more logging, set custom logger and add optional print sql statments

marcink - - Load All Authors

File last commit:

r229:69a29242 default


                r229:69a29242

default

Download file

             db_manage.py
        
                    74 lines
            
             | 2.3 KiB
            
                | text/x-python
            
             |
                PythonLexer
            
             / pylons_app / lib / db_manage.py
          
                    History
                
                 |
                  Source
                 | Raw
                 |Copy content
                 |Copy permalink

        Marcin Kuzminski
    
added db_manage script

              r59
            
      import logging

        marcink
    
rewritten db manage script to use sqlalchemy. Fixed sqlalchemy models to more generic.

              r226
            
      from os.path import dirname as dn

      from sqlalchemy.engine import create_engine

        Marcin Kuzminski
    
added db_manage script

              r59
            
      import os

        marcink
    
fixed dbmanage script to work as standalone script

              r228
            
      import sys

      ROOT = dn(dn(dn(os.path.realpath(__file__))))

      sys.path.append(ROOT)

        marcink
    
rewritten db manage script to use sqlalchemy. Fixed sqlalchemy models to more generic.

              r226
            
      from pylons_app.model.db import Users

        marcink
    
db manage added more logging, set custom logger and add optional print sql statments

              r229
            
      from pylons_app.model.meta import Session, Base

        Marcin Kuzminski
    
added db_manage script

              r59
            
        marcink
    
rewritten db manage script to use sqlalchemy. Fixed sqlalchemy models to more generic.

              r226
            
      from pylons_app.lib.auth import get_crypt_password

      from pylons_app.model import init_model

        Marcin Kuzminski
    
added db_manage script

              r59
            
        marcink
    
db manage added more logging, set custom logger and add optional print sql statments

              r229
            
      log = logging.getLogger('db manage')

      log.setLevel(logging.DEBUG)

      console_handler = logging.StreamHandler()

      console_handler.setFormatter(logging.Formatter("%(asctime)s.%(msecs)03d" 

                                          " %(levelname)-5.5s [%(name)s] %(message)s"))

      log.addHandler(console_handler)

        Marcin Kuzminski
    
updated db manage script for creating interactive admin account and db

              r66
            
        marcink
    
rewritten db manage script to use sqlalchemy. Fixed sqlalchemy models to more generic.

              r226
            
      class DbManage(object):

        marcink
    
db manage added more logging, set custom logger and add optional print sql statments

              r229
            
          def __init__(self, log_sql):

              self.dbname = 'hg_app.db'

              dburi = 'sqlite:////%s' % os.path.join(ROOT, self.dbname)

              engine = create_engine(dburi, echo=log_sql) 

        marcink
    
rewritten db manage script to use sqlalchemy. Fixed sqlalchemy models to more generic.

              r226
            
              init_model(engine)

              self.sa = Session()

          def check_for_db(self, override):

        marcink
    
db manage added more logging, set custom logger and add optional print sql statments

              r229
            
              log.info('checking for exisiting db')

              if os.path.isfile(os.path.join(ROOT, self.dbname)):

                  log.info('database exisist')

                  if not override:

        marcink
    
rewritten db manage script to use sqlalchemy. Fixed sqlalchemy models to more generic.

              r226
            
                      raise Exception('database already exists')

        marcink
    
db manage added more logging, set custom logger and add optional print sql statments

              r229
            
        marcink
    
rewritten db manage script to use sqlalchemy. Fixed sqlalchemy models to more generic.

              r226
            
          def create_tables(self, override=False):

              """

              Create a auth database

              """

              self.check_for_db(override)

        marcink
    
db manage added more logging, set custom logger and add optional print sql statments

              r229
            
              if override:

                  log.info("database exisist and it's going to be destroyed")

        marcink
    
rewritten db manage script to use sqlalchemy. Fixed sqlalchemy models to more generic.

              r226
            
              Base.metadata.create_all(checkfirst=override)

        marcink
    
db manage added more logging, set custom logger and add optional print sql statments

              r229
            
              log.info('Created tables for %s', self.dbname)

        Marcin Kuzminski
    
added db_manage script

              r59
            
        marcink
    
rewritten db manage script to use sqlalchemy. Fixed sqlalchemy models to more generic.

              r226
            
          def admin_prompt(self):

              import getpass

        marcink
    
db manage added more logging, set custom logger and add optional print sql statments

              r229
            
              username = raw_input('Specify admin username:')

        marcink
    
rewritten db manage script to use sqlalchemy. Fixed sqlalchemy models to more generic.

              r226
            
              password = getpass.getpass('Specify admin password:')

              self.create_user(username, password, True)

          def create_user(self, username, password, admin=False):

        marcink
    
db manage added more logging, set custom logger and add optional print sql statments

              r229
            
              log.info('creating administrator user %s', username)

        marcink
    
rewritten db manage script to use sqlalchemy. Fixed sqlalchemy models to more generic.

              r226
            
              new_user = Users()

              new_user.username = username

              new_user.password = get_crypt_password(password)

              new_user.admin = admin

              new_user.active = True

              try:

                  self.sa.add(new_user)

                  self.sa.commit()

              except:

                  self.sa.rollback()

                  raise

        Marcin Kuzminski
    
updated db manage script for creating interactive admin account and db

              r66
            
      if __name__ == '__main__':

        marcink
    
db manage added more logging, set custom logger and add optional print sql statments

              r229
            
          dbmanage = DbManage(log_sql=True)

        marcink
    
rewritten db manage script to use sqlalchemy. Fixed sqlalchemy models to more generic.

              r226
            
          dbmanage.create_tables(override=True)

          dbmanage.admin_prompt()  

        Marcin Kuzminski
    
updated db manage script for creating interactive admin account and db

              r66

	Site-wide shortcuts
/	Use quick search box
g h	Goto home page
g g	Goto my private gists page
g G	Goto my public gists page
g 0-9	Goto bookmarked items from 0-9
n r	New repository page
n g	New gist page

	Repositories
g s	Goto summary page
g c	Goto changelog page
g f	Goto files page
g F	Goto files page with file search activated
g p	Goto pull requests page
g o	Goto repository settings
g O	Goto repository access permissions settings
t s	Toggle sidebar on some pages

Marcin Kuzminski added db_manage script	r59	import logging
marcink rewritten db manage script to use sqlalchemy. Fixed sqlalchemy models to more generic.	r226	from os.path import dirname as dn
		from sqlalchemy.engine import create_engine
Marcin Kuzminski added db_manage script	r59	import os
marcink fixed dbmanage script to work as standalone script	r228	import sys
		ROOT = dn(dn(dn(os.path.realpath(__file__))))
		sys.path.append(ROOT)

marcink rewritten db manage script to use sqlalchemy. Fixed sqlalchemy models to more generic.	r226	from pylons_app.model.db import Users
marcink db manage added more logging, set custom logger and add optional print sql statments	r229	from pylons_app.model.meta import Session, Base
Marcin Kuzminski added db_manage script	r59
marcink rewritten db manage script to use sqlalchemy. Fixed sqlalchemy models to more generic.	r226	from pylons_app.lib.auth import get_crypt_password
		from pylons_app.model import init_model
Marcin Kuzminski added db_manage script	r59
marcink db manage added more logging, set custom logger and add optional print sql statments	r229	log = logging.getLogger('db manage')
		log.setLevel(logging.DEBUG)
		console_handler = logging.StreamHandler()
		console_handler.setFormatter(logging.Formatter("%(asctime)s.%(msecs)03d"
		" %(levelname)-5.5s [%(name)s] %(message)s"))
		log.addHandler(console_handler)
Marcin Kuzminski updated db manage script for creating interactive admin account and db	r66
marcink rewritten db manage script to use sqlalchemy. Fixed sqlalchemy models to more generic.	r226	class DbManage(object):
marcink db manage added more logging, set custom logger and add optional print sql statments	r229	def __init__(self, log_sql):
		self.dbname = 'hg_app.db'
		dburi = 'sqlite:////%s' % os.path.join(ROOT, self.dbname)
		engine = create_engine(dburi, echo=log_sql)
marcink rewritten db manage script to use sqlalchemy. Fixed sqlalchemy models to more generic.	r226	init_model(engine)
		self.sa = Session()

		def check_for_db(self, override):
marcink db manage added more logging, set custom logger and add optional print sql statments	r229	log.info('checking for exisiting db')
		if os.path.isfile(os.path.join(ROOT, self.dbname)):
		log.info('database exisist')
		if not override:
marcink rewritten db manage script to use sqlalchemy. Fixed sqlalchemy models to more generic.	r226	raise Exception('database already exists')
marcink db manage added more logging, set custom logger and add optional print sql statments	r229
marcink rewritten db manage script to use sqlalchemy. Fixed sqlalchemy models to more generic.	r226	def create_tables(self, override=False):
		"""
		Create a auth database
		"""
		self.check_for_db(override)
marcink db manage added more logging, set custom logger and add optional print sql statments	r229	if override:
		log.info("database exisist and it's going to be destroyed")
marcink rewritten db manage script to use sqlalchemy. Fixed sqlalchemy models to more generic.	r226	Base.metadata.create_all(checkfirst=override)
marcink db manage added more logging, set custom logger and add optional print sql statments	r229	log.info('Created tables for %s', self.dbname)
Marcin Kuzminski added db_manage script	r59
marcink rewritten db manage script to use sqlalchemy. Fixed sqlalchemy models to more generic.	r226	def admin_prompt(self):
		import getpass
marcink db manage added more logging, set custom logger and add optional print sql statments	r229	username = raw_input('Specify admin username:')
marcink rewritten db manage script to use sqlalchemy. Fixed sqlalchemy models to more generic.	r226	password = getpass.getpass('Specify admin password:')
		self.create_user(username, password, True)

		def create_user(self, username, password, admin=False):
marcink db manage added more logging, set custom logger and add optional print sql statments	r229	log.info('creating administrator user %s', username)
marcink rewritten db manage script to use sqlalchemy. Fixed sqlalchemy models to more generic.	r226
		new_user = Users()
		new_user.username = username
		new_user.password = get_crypt_password(password)
		new_user.admin = admin
		new_user.active = True

		try:
		self.sa.add(new_user)
		self.sa.commit()
		except:
		self.sa.rollback()
		raise
Marcin Kuzminski updated db manage script for creating interactive admin account and db	r66
		if __name__ == '__main__':
marcink db manage added more logging, set custom logger and add optional print sql statments	r229	dbmanage = DbManage(log_sql=True)
marcink rewritten db manage script to use sqlalchemy. Fixed sqlalchemy models to more generic.	r226	dbmanage.create_tables(override=True)
		dbmanage.admin_prompt()
Marcin Kuzminski updated db manage script for creating interactive admin account and db	r66