from pylons_app.model.meta import Base

from sqlalchemy.orm import relation, backref

from sqlalchemy import *

from vcs.utils.lazy import LazyProperty

class HgAppSettings(Base):

    __tablename__ = 'hg_app_settings'

    __table_args__ = (UniqueConstraint('app_settings_name'), {'useexisting':True})

    app_settings_id = Column("app_settings_id", INTEGER(), nullable=False, unique=True, default=None, primary_key=True)

    app_settings_name = Column("app_settings_name", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)

    app_settings_value = Column("app_settings_value", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)

class HgAppUi(Base):

    __tablename__ = 'hg_app_ui'

    __table_args__ = {'useexisting':True}

    ui_id = Column("ui_id", INTEGER(), nullable=False, unique=True, default=None, primary_key=True)

    ui_section = Column("ui_section", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)

    ui_key = Column("ui_key", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)

    ui_value = Column("ui_value", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)

    ui_active = Column("ui_active", BOOLEAN(), nullable=True, unique=None, default=True)

class User(Base): 

    __tablename__ = 'users'

    __table_args__ = {'useexisting':True}

    user_id = Column("user_id", INTEGER(), nullable=False, unique=True, default=None, primary_key=True)

    username = Column("username", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)

    password = Column("password", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)

    active = Column("active", BOOLEAN(), nullable=True, unique=None, default=None)

    admin = Column("admin", BOOLEAN(), nullable=True, unique=None, default=False)

    name = Column("name", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)

    lastname = Column("lastname", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)

    email = Column("email", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)

    last_login = Column("last_login", DATETIME(timezone=False), nullable=True, unique=None, default=None)

    user_log = relation('UserLog')

    @LazyProperty

    def full_contact(self):

        return '%s %s <%s>' % (self.name, self.lastname, self.email)

    def __repr__(self):

        return "<User('%s:%s')>" % (self.user_id, self.username)

class UserLog(Base): 

    __tablename__ = 'user_logs'

    __table_args__ = {'useexisting':True}

    user_log_id = Column("user_log_id", INTEGER(), nullable=False, unique=True, default=None, primary_key=True)

    user_id = Column("user_id", INTEGER(), ForeignKey(u'users.user_id'), nullable=False, unique=None, default=None)

    user_ip = Column("user_ip", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None) 

    repository = Column("repository", TEXT(length=None, convert_unicode=False, assert_unicode=None), ForeignKey(u'repositories.repo_name'), nullable=False, unique=None, default=None)

    action = Column("action", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)

    action_date = Column("action_date", DATETIME(timezone=False), nullable=True, unique=None, default=None)

    user = relation('User')

class Repository(Base):

    __tablename__ = 'repositories'

    __table_args__ = (UniqueConstraint('repo_name'), {'useexisting':True},)

    repo_id = Column("repo_id", INTEGER(), nullable=False, unique=True, default=None, primary_key=True)

    repo_name = Column("repo_name", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=False, unique=True, default=None)

    user_id = Column("user_id", INTEGER(), ForeignKey(u'users.user_id'), nullable=False, unique=False, default=None)

    private = Column("private", BOOLEAN(), nullable=True, unique=None, default=None)

    description = Column("description", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)

    user = relation('User')

    repo_to_perm = relation('RepoToPerm', cascade='all')

class Permission(Base):

    __tablename__ = 'permissions'

    __table_args__ = {'useexisting':True}

    permission_id = Column("permission_id", INTEGER(), nullable=False, unique=True, default=None, primary_key=True)

    permission_name = Column("permission_name", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)

    permission_longname = Column("permission_longname", TEXT(length=None, convert_unicode=False, assert_unicode=None), nullable=True, unique=None, default=None)

    def __repr__(self):

        return "<Permission('%s:%s')>" % (self.permission_id, self.permission_name)

class RepoToPerm(Base):

    __tablename__ = 'repo_to_perm'

    __table_args__ = (UniqueConstraint('user_id', 'repository_id'), {'useexisting':True})

    repo_to_perm_id = Column("repo_to_perm_id", INTEGER(), nullable=False, unique=True, default=None, primary_key=True)

    user_id = Column("user_id", INTEGER(), ForeignKey(u'users.user_id'), nullable=False, unique=None, default=None)

    permission_id = Column("permission_id", INTEGER(), ForeignKey(u'permissions.permission_id'), nullable=False, unique=None, default=None)

    repository_id = Column("repository_id", INTEGER(), ForeignKey(u'repositories.repo_id'), nullable=False, unique=None, default=None) 

    user = relation('User')

    permission = relation('Permission')

    repository = relation('Repository')

class UserToPerm(Base):

    __tablename__ = 'user_to_perm'

    user_to_perm_id = Column("user_to_perm_id", INTEGER(), nullable=False, unique=True, default=None, primary_key=True)

    user_id = Column("user_id", INTEGER(), ForeignKey(u'users.user_id'), nullable=False, unique=None, default=None)

    permission_id = Column("permission_id", INTEGER(), ForeignKey(u'permissions.permission_id'), nullable=False, unique=None, default=None)

    user = relation('User')

    permission = relation('Permission')

## -*- coding: utf-8 -*-

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" id="mainhtml">

<head>

    <title>${next.title()}</title>

    <link rel="icon" href="/images/hgicon.png" type="image/png" />

    <meta http-equiv="Content-Type" content="text/html;charset=utf-8" />

    <meta name="robots" content="index, nofollow"/>

    <!-- stylesheets -->

    ${self.css()}

    <!-- scripts -->

    ${self.js()}

</head>

<body>

    <!-- header -->

    <div id="header">

        <!-- user -->

        <ul id="logged-user">

            <li class="first">

	            <div class="gravatar">

	            	<img alt="gravatar" src="${h.gravatar_url(c.hg_app_user.email,24)}" />

	            </div>

	            <div class="account">

	            	${h.link_to('%s %s'%(c.hg_app_user.name,c.hg_app_user.lastname),h.url('admin_settings_my_account'))}<br/>

	            	${h.link_to(c.hg_app_user.username,h.url('admin_settings_my_account'))}

	            </div>	

            </li>

            <li class="last highlight">${h.link_to(u'Logout',h.url('logout_home'))}</li>

        </ul>

        <!-- end user -->

        <div id="header-inner">

            <div id="home">

                <a href="${h.url('hg_home')}"></a>

            </div>

            <!-- logo -->

            <div id="logo">

                <h1><a href="${h.url('hg_home')}">${c.hg_app_name}</a></h1>

            </div>

            <!-- end logo -->

            <!-- quick menu -->

            ${self.page_nav()}

            <!-- end quick -->

            <div class="corner tl"></div>

            <div class="corner tr"></div>

        </div>

    </div>     

    <!-- end header -->

	<!-- CONTENT -->

	<div id="content"> 

        <div class="flash_msg">

            <% messages = h.flash.pop_messages() %>

            % if messages:

            <ul id="flash-messages">

                % for message in messages:

                <li class="${message.category}_msg">${message}</li>

                % endfor

            </ul>

            % endif

        </div>	    

	    <div id="main"> 

	        ${next.main()}

	    </div>

	</div> 

    <!-- END CONTENT -->

	<!-- footer -->

	<div id="footer">

	    <p>Hg App ${c.hg_app_version} &copy; 2010 by Marcin Kuzminski</p>

        <script type="text/javascript">${h.tooltip.activate()}</script>	    

	</div>

	<!-- end footer -->

</body>

</html>

### MAKO DEFS ### 

<%def name="page_nav()">

	${self.menu()}

</%def>

<%def name="menu(current=None)">

		<% 

		def is_current(selected):

			if selected == current:

		%>

		%if current not in ['home','admin']:

           <script type="text/javascript">

            YAHOO.util.Event.onDOMReady(function(){

                YAHOO.util.Event.addListener('repo_switcher','click',function(){

                    if(YAHOO.util.Dom.hasClass('repo_switcher','selected')){

                        YAHOO.util.Dom.setStyle('switch_repos','display','none');

                        YAHOO.util.Dom.setStyle('repo_switcher','background','');

                        YAHOO.util.Dom.removeClass('repo_switcher','selected');

                        YAHOO.util.Dom.get('repo_switcher').removeAttribute('style');

                    }

                    else{

                        YAHOO.util.Dom.setStyle('switch_repos','display','');

                        YAHOO.util.Dom.addClass('repo_switcher','selected');

                    }

                    });

                YAHOO.util.Event.addListener('repos_list','change',function(e){

                    var wa = YAHOO.util.Dom.get('repos_list').value;

                    var url = "${h.url('summary_home',repo_name='__REPO__')}".replace('__REPO__',wa);

                    window.location = url;

                })

               });

            </script>

		   ##REGULAR MENU            

	        <ul id="quick">

				<!-- repo switcher -->

				<li>

					<a id="repo_switcher" title="${_('Switch repository')}" href="#">

                    <span class="icon">

                        <img src="/images/icons/database.png" alt="${_('Products')}" />

                    </span>

                    <span>&darr;</span>					

					</a>

					<div id="switch_repos" style="display:none;">

						<select id="repos_list" size="10">

						%for repo in c.repo_switcher_list:

							<option value="${repo}">${repo}</option>

						%endfor

						</select>

					</div>			

				</li>

	            <li ${is_current('summary')}>

	               <a title="${_('Summary')}" href="${h.url('summary_home',repo_name=c.repo_name)}">

	               <span class="icon">

	                   <img src="/images/icons/clipboard_16.png" alt="${_('Summary')}" />

	               </span>

	               <span>${_('Summary')}</span>                 

	               </a>	            

	            </li>

                <li ${is_current('shortlog')}>

                   <a title="${_('Shortlog')}" href="${h.url('shortlog_home',repo_name=c.repo_name)}">

                   <span class="icon">

                       <img src="/images/icons/application_double.png" alt="${_('Shortlog')}" />

                   </span>

                   <span>${_('Shortlog')}</span>                 

                   </a>             

                </li>	            

                <li ${is_current('changelog')}>

                   <a title="${_('Changelog')}" href="${h.url('changelog_home',repo_name=c.repo_name)}">

                   <span class="icon">

                       <img src="/images/icons/time.png" alt="${_('Changelog')}" />

                   </span>

                   <span>${_('Changelog')}</span>                 

                   </a>             

                </li>   	            

                <li ${is_current('branches')}>

                   <a title="${_('Branches')}" href="${h.url('branches_home',repo_name=c.repo_name)}">

                   <span class="icon">

                       <img src="/images/icons/arrow_branch.png" alt="${_('Branches')}" />

                   </span>

                   <span>${_('Branches')}</span>                 

                   </a>             

                </li> 	            

                <li ${is_current('tags')}>

                   <a title="${_('Tags')}" href="${h.url('tags_home',repo_name=c.repo_name)}">

                   <span class="icon">

                       <img src="/images/icons/tag_blue.png" alt="${_('Tags')}" />

                   </span>

                   <span>${_('Tags')}</span>                 

                   </a>             

                </li>

                <li ${is_current('files')}>

                   <a title="${_('Files')}" href="${h.url('files_home',repo_name=c.repo_name)}">

                   <span class="icon">

                       <img src="/images/icons/file.png" alt="${_('Files')}" />

                   </span>

                   <span>${_('Files')}</span>                 

                   </a>             

                </li>                            

				%if h.HasRepoPermissionAll('repository.admin')(c.repo_name):

                <li ${is_current('settings')}>

                   <a title="${_('Settings')}" href="${h.url('repo_settings_home',repo_name=c.repo_name)}">

                   <span class="icon">

                       <img src="/images/icons/cog_edit.png" alt="${_('Settings')}" />

                   </span>

                   <span>${_('Settings')}</span>                 

                   </a>             

                </li>				

				%endif					        

	        </ul>

		%else:

		    ##ROOT MENU

            <ul id="quick">

                <li>

                    <a title="${_('Home')}"  href="${h.url('hg_home')}">

                    <span class="icon">

                        <img src="/images/icons/home_16.png" alt="${_('Home')}" />

                    </span>

                    <span>${_('Home')}</span>                 

                    </a>        

                </li>

                <li>

                    <a title="${_('Search')}"  href="${h.url('search')}">

                    <span class="icon">

                        <img src="/images/icons/search_16.png" alt="${_('Search')}" />

                    </span>

                    <span>${_('Search')}</span>                 

                    </a>        

                </li>

				%if h.HasPermissionAll('hg.admin')('access admin main page'):

                <li ${is_current('admin')}>

                   <a title="${_('Admin')}" href="${h.url('admin_home')}">

                   <span class="icon">

                       <img src="/images/icons/cog_edit.png" alt="${_('Admin')}" />

                   </span>

                   <span>${_('Admin')}</span>                 

                   </a>    

				    <ul>

				        <li>${h.link_to(_('repositories'),h.url('repos'),class_='repos')}</li>

				        <li>${h.link_to(_('users'),h.url('users'),class_='users')}</li>

				        <li>${h.link_to(_('permissions'),h.url('permissions'),class_='permissions')}</li>

				        <li>${h.link_to(_('settings'),h.url('admin_settings'),class_='settings')}</li>        

				    </ul>

                </li>

				%endif

			</ul>

		%endif    

</%def>

<%def name="css()">

<link rel="stylesheet" type="text/css" href="/css/reset.css" />

<link rel="stylesheet" type="text/css" href="/css/style.css" media="screen" />

<link rel="stylesheet" type="text/css" href="/css/style_full.css" />

<link id="color" rel="stylesheet" type="text/css" href="/css/colors/blue.css" />

<link rel="stylesheet" type="text/css" href="/css/pygments.css"  />

<link rel="stylesheet" type="text/css" href="/css/diff.css"  />

</%def>

<%def name="js()">

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

<!--[if IE]><script language="javascript" type="text/javascript" src="/js/excanvas.min.js"></script><![endif]-->

<script type="text/javascript" src="/js/yui/container/container-min.js"></script>

<script type="text/javascript" src="/js/yui/datasource/datasource-min.js"></script>

<script type="text/javascript" src="/js/yui/autocomplete/autocomplete-min.js"></script>

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

</%def>

<%def name="breadcrumbs()">

    <div class="breadcrumbs">

    ${self.breadcrumbs_links()}

    </div>

</%def>