Last active
August 23, 2017 14:50
-
-
Save ShekharReddy4/ad60910260c99787969eb9fbfa633231 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
""" | |
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() |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
""" | |
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) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
""" | |
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