def __init__(self, log_sql):

        self.dbname = 'hg_app.db'

        dburi = 'sqlite:////%s' % jn(ROOT, self.dbname)

        engine = create_engine(dburi, echo=log_sql) 

        init_model(engine)

        self.sa = Session()

    def check_for_db(self, override):

        log.info('checking for exisiting db')

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

            log.info('database exisist')

            if not override:

                raise Exception('database already exists')

    def create_tables(self, override=False):

        """

        Create a auth database

        """

        self.check_for_db(override)

        if override:

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

            os.remove(jn(ROOT, self.dbname))

        Base.metadata.create_all(checkfirst=override)

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

    def admin_prompt(self):

        import getpass

        username = raw_input('Specify admin username:')

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

        self.create_user(username, password, True)

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

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

        new_user = User()

        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

    def create_permissions(self):

                 ]

        for p in perms:

            new_perm = Permission()

            new_perm.permission_name = p[0]

            new_perm.permission_longname = p[1]

            try:

                self.sa.add(new_perm)

                self.sa.commit()

            except:

                self.sa.rollback()

                raise

if __name__ == '__main__':

    dbmanage = DbManage(log_sql=True)

    dbmanage.create_tables(override=True)

    dbmanage.admin_prompt()

    dbmanage.create_permissions()  

<%inherit file="/base/base.html"/>

<%!

from pylons_app.lib import filters

%>

<%def name="title()">

    ${_('Repository managment')}

</%def>

<%def name="breadcrumbs()">

    ${h.link_to(u'Home',h.url('/'))}

    / 

    ${h.link_to(c.repo_name,h.url('summary_home',repo_name=c.repo_name))}

    /

    ${_('summary')}

</%def>

<%def name="page_nav()">

	${self.menu('summary')}    

</%def>

<%def name="js()">

<script type="text/javascript" src="/js/yui/utilities/utilities.js"></script>

<script type="text/javascript">

var E = YAHOO.util.Event;

var D = YAHOO.util.Dom;

E.onDOMReady(function(e){

    id = 'clone_url';

	E.addListener(id,'click',function(e){

	    D.get('clone_url').select();

	})

})

</script>

</%def>

<%def name="main()">

    <h2 class="no-link no-border">${_('Mercurial Repository Overview')}</h2>

    <dl class="overview">

        <dt>${_('name')}</dt>

        <dd>${c.repo_info.name}</dd>

        <dt>${_('description')}</dt>

        <dd>${c.repo_info.description}</dd>

        <dt>${_('contact')}</dt>

        <dd>${c.repo_info.contact}</dd>

        <dt>${_('last change')}</dt>

        <dd>${c.repo_info.last_change|n,filters.age} - ${c.repo_info.last_change|n,filters.rfc822date}</dd>

        <dt>${_('clone url')}</dt>

        <dt>${_('download')}</dt>

        <dd>

       	%for cnt,archive in enumerate(c.repo_info._get_archives()):

       		 %if cnt >=1:

       		 |

       		 %endif

       		 ${h.link_to(c.repo_info.name+'.'+archive['type'],

       			h.url('files_archive_home',repo_name=c.repo_info.name,

       			revision='tip',fileformat=archive['extension']),class_="archive_logo")}

		%endfor

        </dd>

        <dt>${_('feeds')}</dt>

        <dd>

        	${h.link_to(_('RSS'),h.url('rss_feed_home',repo_name=c.repo_info.name),class_='rss_logo')}

			${h.link_to(_('Atom'),h.url('atom_feed_home',repo_name=c.repo_info.name),class_='atom_logo')}

        </dd>

    </dl>

    <h2>${h.link_to(_('Changes'),h.url('changelog_home',repo_name=c.repo_name))}</h2>

    <table>

	<%def name="message_slug(msg)">

		<%

		limit = 60

		if len(msg) > limit:

			return msg[:limit]+'...'

		else:

			return msg

		%>

	</%def>    

	%for cnt,cs in enumerate(c.repo_changesets):

		<tr class="parity${cnt%2}">

			<td>${cs._ctx.date()|n,filters.age}</td>

			<td>${cs.author|n,filters.person}</td>

			<td>r${cs.revision}</td>

			<td>

				${h.link_to(message_slug(cs.message),

				h.url('changeset_home',repo_name=c.repo_name,revision=cs._short),

				title=cs.message)}

			</td>

			<td>

				<span class="logtags">

					<span class="branchtag">${cs.branch}</span>

					%for tag in cs.tags:

						<span class="tagtag">${tag}</span>

					%endfor

				</span>

			</td>

			<td class="nowrap">