DbConnection

"""
Moudle for DB connection
"""
import sqlalchemy
from sqlalchemy import create_engine, ForeignKey
from sqlalchemy.ext.declarative import declarative_base

engine = create_engine('sqlite:///../AppData/AMS.db', echo=True)
Base = declarative_base()

erro stack

Traceback (most recent call last):
  File "DaemonProcess.py", line 23, in <module>
    session.commit()
  File "C:\Python27\lib\site-packages\sqlalchemy\orm\session.py", line 906, in commit
    self.transaction.commit()
  File "C:\Python27\lib\site-packages\sqlalchemy\orm\session.py", line 461, in commit
    self._prepare_impl()
  File "C:\Python27\lib\site-packages\sqlalchemy\orm\session.py", line 441, in _prepare_impl
    self.session.flush()
  File "C:\Python27\lib\site-packages\sqlalchemy\orm\session.py", line 2171, in flush
    self._flush(objects)
  File "C:\Python27\lib\site-packages\sqlalchemy\orm\session.py", line 2291, in _flush
    transaction.rollback(_capture_exception=True)
  File "C:\Python27\lib\site-packages\sqlalchemy\util\langhelpers.py", line 66, in __exit__
    compat.reraise(exc_type, exc_value, exc_tb)
  File "C:\Python27\lib\site-packages\sqlalchemy\orm\session.py", line 2255, in _flush
   flush_context.execute()
  File "C:\Python27\lib\site-packages\sqlalchemy\orm\unitofwork.py", line 389, in execute
    rec.execute(self)
  File "C:\Python27\lib\site-packages\sqlalchemy\orm\unitofwork.py", line 548, in execute
    uow
  File "C:\Python27\lib\site-packages\sqlalchemy\orm\persistence.py", line 156, in save_obj
    base_mapper, states, uowtransaction
  File "C:\Python27\lib\site-packages\sqlalchemy\orm\persistence.py", line 279, in _organize_states_for_save
    states):
  File "C:\Python27\lib\site-packages\sqlalchemy\orm\persistence.py", line 1105, in _connections_for_states
    connection = uowtransaction.transaction.connection(base_mapper)
  File "C:\Python27\lib\site-packages\sqlalchemy\orm\session.py", line 294, in connection
    return self._connection_for_bind(bind, execution_options)
  File "C:\Python27\lib\site-packages\sqlalchemy\orm\session.py", line 392, in _connection_for_bind
    conn = self._parent._connection_for_bind(bind, execution_options)
  File "C:\Python27\lib\site-packages\sqlalchemy\orm\session.py", line 403, in _connection_for_bind
    conn = bind.contextual_connect()
  File "C:\Python27\lib\site-packages\sqlalchemy\engine\base.py", line 2112, in contextual_connect
    self._wrap_pool_connect(self.pool.connect, None),
  File "C:\Python27\lib\site-packages\sqlalchemy\engine\base.py", line 2151, in _wrap_pool_connect
    e, dialect, self)
  File "C:\Python27\lib\site-packages\sqlalchemy\engine\base.py", line 1465, in _handle_dbapi_exception_noconnection
    exc_info
  File "C:\Python27\lib\site-packages\sqlalchemy\util\compat.py", line 203, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb, cause=cause)
  File "C:\Python27\lib\site-packages\sqlalchemy\engine\base.py", line 2147, in _wrap_pool_connect
    return fn()
  File "C:\Python27\lib\site-packages\sqlalchemy\pool.py", line 387, in connect
    return _ConnectionFairy._checkout(self)
  File "C:\Python27\lib\site-packages\sqlalchemy\pool.py", line 766, in _checkout
    fairy = _ConnectionRecord.checkout(pool)
  File "C:\Python27\lib\site-packages\sqlalchemy\pool.py", line 516, in checkout
    rec = pool._do_get()
  File "C:\Python27\lib\site-packages\sqlalchemy\pool.py", line 1229, in _do_get
    return self._create_connection()
  File "C:\Python27\lib\site-packages\sqlalchemy\pool.py", line 333, in _create_connection
    return _ConnectionRecord(self)
  File "C:\Python27\lib\site-packages\sqlalchemy\pool.py", line 461, in __init__
    self.__connect(first_connect_check=True)
  File "C:\Python27\lib\site-packages\sqlalchemy\pool.py", line 651, in __connect
    connection = pool._invoke_creator(self)
  File "C:\Python27\lib\site-packages\sqlalchemy\engine\strategies.py", line 105, in connect
    return dialect.connect(*cargs, **cparams)
  File "C:\Python27\lib\site-packages\sqlalchemy\engine\default.py", line 393, in connect
    return self.dbapi.connect(*cargs, **cparams)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file

model.py

"""
Module documentation for Settings table
"""
from sqlalchemy import Column, Integer, String
from sqlalchemy.types import Boolean
from DbConnection import Base, engine

class Settingstbl(Base):
    """
    Settings table DTO
    """
    __tablename__ = "Settingstbl"

    SettingstblID = Column(Integer, primary_key=True, nullable=False)
    Name = Column(String, nullable=False)
    Value = Column(String, nullable=False)
    Type = Column(Integer, nullable=False)
    IsActive = Column(Boolean, nullable=False)

# Create table
Base.metadata.create_all(engine)

p1.py

"""
Daemonprocess is the module which runs on unix machines as a daemonprocess
"""
import json
import requests
from sqlalchemy.orm import sessionmaker
from DbModels import DbConnection
from DbModels.SettingstblModel import SettingstblClass

AUTHHEADER = {}
AUTHHEADER['Authorization'] = "sdfgd="

url = 'http://172.16.4.156:8060/api/Settings/getsettingsbytype?assettag=sdS9&type=1'
response = requests.get(url, headers = AUTHHEADER)
if(response.ok):
    settingslist = json.loads(response.text or response.content)
    stbl = SettingstblClass(SettingstblID=3, Name='Ed Jones', Value='edspassword', Type=2, IsActive=1)
    print stbl.__tablename__
    
    Session = sessionmaker(bind=DbConnection.engine)
    session = Session()
    # our_user = session.query(SettingstblClass).filter_by(Name='Ed Jones').first() 
    # print our_user