Skip to content

Instantly share code, notes, and snippets.

@ShekharReddy4
Last active August 23, 2017 14:50
Show Gist options
  • Save ShekharReddy4/ad60910260c99787969eb9fbfa633231 to your computer and use it in GitHub Desktop.
Save ShekharReddy4/ad60910260c99787969eb9fbfa633231 to your computer and use it in GitHub Desktop.
"""
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()
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
"""
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)
"""
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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment