# -*- coding: utf-8 -*-
# Copyright (C) 2009-2010, Luis Pedro Coelho <lpc@cmu.edu>
# vim: set ts=4 sts=4 sw=4 expandtab smartindent:
#
# Permission is hereby granted, free of charge, to any person obtaining a copy
#  of this software and associated documentation files (the "Software"), to deal
#  in the Software without restriction, including without limitation the rights
#  to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
#  copies of the Software, and to permit persons to whom the Software is
#  furnished to do so, subject to the following conditions:
#
# The above copyright notice and this permission notice shall be included in
#  all copies or substantial portions of the Software.
#
# THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
#  IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
#  FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
#  AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
#  LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
#  OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN
#  THE SOFTWARE.

from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
from sqlalchemy.ext.declarative import declarative_base
from os import path

_paths = [
    path.join(path.abspath(path.dirname(__file__)), '..', '..'),
    '.',
    ]
database_file = 'waldo.sqlite3'
for _basep in _paths:
    _fullp = path.join(_basep, 'waldo.sqlite3')
    if path.exists(_fullp):
        database_file = _fullp

Base = declarative_base()
engine = create_engine('sqlite:///' + database_file, echo=False)
metadata = Base.metadata
metadata.bind = engine
create_session = sessionmaker(bind=engine)

def create_tables():
    '''
    create_tables()

    Creates all tables in database.
    '''
    metadata.create_all()


@@ -41,17 +41,17 @@
 2009-201
-0
+1
 , Luis P
@@ -1348,16 +1348,71 @@
 ort path
+%0Aimport logging%0A%0Alogging = logging.getLogger('backend')
 %0A%0A_paths
@@ -1490,16 +1490,38 @@
    '.',%0A
+    '/var/lib/waldo',%0A
     %5D%0Ada
@@ -1648,16 +1648,16 @@
 fullp):%0A
-
         
@@ -1678,16 +1678,89 @@
 = _fullp
+%0A        logging.info('Using database: %25s' %25 database_file)%0A        break
 %0A%0ABase =

Use /var/lib/waldo/