static_files = true

lang=en

cache_dir = %(here)s/data

repos_name = etelko

################################################################################

## WARNING: *THE LINE BELOW MUST BE UNCOMMENTED ON A PRODUCTION ENVIRONMENT*  ##

## Debug mode will enable the interactive debugging tool, allowing ANYONE to  ##

## execute malicious code after an exception is raised.                       ##

################################################################################

#set debug = false

################################

### LOGGING CONFIGURATION   ####

################################

[loggers]

keys = root, routes, pylons_app, sqlalchemy

[handlers]

keys = console

[formatters]

keys = generic

[handler_console]

class = StreamHandler

args = (sys.stderr,)

level = NOTSET

formatter = generic

################

## FORMATTERS ##

################

[formatter_generic]

format = %(asctime)s,%(msecs)03d %(levelname)-5.5s [%(name)s] %(message)s

#smtp_username = 

#smtp_password = 

#error_message = 'mercurial crash !'

[server:main]

use = egg:Paste#http

host = 127.0.0.1

port = 8001

[app:main]

use = egg:pylons_app

full_stack = true

lang=en

cache_dir = %(here)s/data

repos_name = etelko

################################################################################

## WARNING: *THE LINE BELOW MUST BE UNCOMMENTED ON A PRODUCTION ENVIRONMENT*  ##

## Debug mode will enable the interactive debugging tool, allowing ANYONE to  ##

## execute malicious code after an exception is raised.                       ##

################################################################################

#set debug = false

################################

[handler_console]

class = StreamHandler

args = (sys.stderr,)

level = NOTSET

formatter = generic

################

## FORMATTERS ##

################

[formatter_generic]

format = %(asctime)s,%(msecs)03d %(levelname)-5.5s [%(name)s] %(message)s

    app = RoutesMiddleware(app, config['routes.map'])

    app = SessionMiddleware(app, config)

    app = AuthBasicHandler(app, config['repos_name'] + ' mercurial repository', authfunc)

    if asbool(full_stack):

        # Handle Python exceptions

        app = ErrorHandler(app, global_conf, **config['pylons.errorware'])

        # Display error documents for 401, 403, 404 status codes (and

        # 500 when debug is disabled)

        if asbool(config['debug']):

            #don't handle 404, since mercurial does it for us.

        else:

            app = StatusCodeRedirect(app, [400, 401, 403, 500])

    # Establish the Registry for this application

    app = RegistryManager(app)

    if asbool(static_files):

        # Serve static files

        static_app = StaticURLParser(config['pylons.paths']['static_files'])

        app = Cascade([static_app, app])

        app.config = config

        c.staticurl = g.statics

        c.admin_user = session.get('admin_user')

        c.admin_username = session.get('admin_username')

    def index(self):

        # Return a rendered template

        if request.POST:

            #import Login Form validator class

            login_form = LoginForm()

            try:

                c.form_result = login_form.to_python(dict(request.params))

                    session['admin_user'] = True

                    session['admin_username'] = c.form_result['username']

                    session.save()

                    return redirect(url('admin_home'))

                else:

                    raise formencode.Invalid('Login Error', None, None,

                                             error_dict={'username':'invalid login',

                                                         'password':'invalid password'})

            except formencode.Invalid, error:

                c.form_result = error.value

                c.form_errors = error.error_dict or {}

from os.path import dirname as dn

from datetime import datetime

import crypt

log = logging.getLogger(__name__)

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

def get_sqlite_conn_cur():

    conn = sqlite3.connect(os.path.join(ROOT, 'auth.sqlite'))

    cur = conn.cursor()

    return conn, cur

def authfunc(environ, username, password):

    conn, cur = get_sqlite_conn_cur()

    password_crypt = crypt.crypt(password, '6a')

    try:

        cur.execute("SELECT * FROM users WHERE username=?", (username,))

        data = cur.fetchone()

    except sqlite3.OperationalError as e:

        data = None

        log.error(e)

    if data:

        if data[3]:

def create_user_table():

    '''

    Create a auth database

    '''

    conn, cur = get_sqlite_conn_cur()

    try:

        log.info('creating table %s', 'users')

        cur.execute('''DROP TABLE IF EXISTS users ''')

        cur.execute('''CREATE TABLE users

                        (id INTEGER PRIMARY KEY AUTOINCREMENT, 

                         username TEXT, 

                         password TEXT,

        log.info('creating table %s', 'user_logs')

        cur.execute('''DROP TABLE IF EXISTS user_logs ''')

        cur.execute('''CREATE TABLE user_logs

                        (id INTEGER PRIMARY KEY AUTOINCREMENT,

                            user_id INTEGER,

                            last_action TEXT, 

                            last_action_date DATETIME)''')

        conn.commit()

    except:

        conn.rollback()

        raise

    cur.close()

    conn, cur = get_sqlite_conn_cur()    

    password_crypt = crypt.crypt(password, '6a')

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

    try:

        conn.commit()

    except:

        conn.rollback()

        raise

if __name__ == "__main__":

    create_user_table()

    create_user('lukaszd', 'qweqwe')

    create_user('adriand', 'qweqwe')

    create_user('radek', 'qweqwe')

    create_user('skrzeka', 'qweqwe')

    create_user('bart', 'qweqwe')

    create_user('maho', 'qweqwe')

    create_user('michalg', 'qweqwe')

    #authfunc('', 'marcink', 'qweqwe')