python.AtlasGeoDBInterface.AtlasGeoDBInterface_SQLite Class Reference

Collaboration diagram for python.AtlasGeoDBInterface.AtlasGeoDBInterface_SQLite:

Public Member Functions
def	__init__ (self, geoTag, sqliteDBFullPath, verbose=False)
def	ConnectToDB (self)
def	GetData (self, tableName)

Public Attributes
	db
	bVerbose
	dbFile

Detailed Description

Definition at line 235 of file AtlasGeoDBInterface.py.

Constructor & Destructor Documentation

__init__()

def python.AtlasGeoDBInterface.AtlasGeoDBInterface_SQLite.__init__	(		self,
			geoTag,
			sqliteDBFullPath,
			verbose = False
	)

Definition at line 237 of file AtlasGeoDBInterface.py.

    def __init__(self,geoTag,sqliteDBFullPath,verbose=False):
 
        self.db=None
        self.bVerbose=verbose
 
        if sqliteDBFullPath:
            self.dbFile=sqliteDBFullPath
        else:
            from AthenaCommon.Utils.unixtools import find_datafile
            pathlist = os.getenv('CALIBPATH').split(os.pathsep)
            self.dbFile=find_datafile("Geometry/"+geoTag+".db",pathlist)
 

Member Function Documentation

ConnectToDB()

def python.AtlasGeoDBInterface.AtlasGeoDBInterface_SQLite.ConnectToDB

(

self

)

Definition at line 249 of file AtlasGeoDBInterface.py.

    def ConnectToDB(self):
 
        try:
            self.db=sqlite3.connect(self.dbFile)
        except Exception as e:
            Logging.log.fatal(f'Failed to open SQLite database {self.dbFile}. {e}')
        Logging.log.debug(f'Connected to SQLite database {self.dbFile}')
 

GetData()

def python.AtlasGeoDBInterface.AtlasGeoDBInterface_SQLite.GetData	(		self,
			tableName
	)

Definition at line 257 of file AtlasGeoDBInterface.py.

    def GetData(self,tableName):
 
        # Check the existence of the table in the DB
        cur = self.db.cursor()
        querystring = "SELECT tbl_name FROM sqlite_master WHERE type='table' AND tbl_name='"+tableName+"'"
        cur.execute(querystring)
        checkTable = cur.fetchall()
        if len(checkTable)==0:
            Logging.log.info(f'Table {tableName} not found in the SQLite DB. Falling back on the default config')
            return []
 
        # Fetch the data
        cur = self.db.cursor()
        querystring = "SELECT * FROM "+tableName+" order by "+tableName+"_data_id"
        cur.execute(querystring)
        rows = cur.fetchall()
 
        ncols=len(cur.description)
        dbData=[]
        for row in rows:
            dbDataRow={}
            for i in range(1,ncols):
                dbDataRow[cur.description[i][0]]=row[i]
            Logging.log.debug(f'Fetched Data Row for {tableName}')
            Logging.log.debug(f'{dbDataRow}')
            dbData.append(dbDataRow)
 
        return dbData

Member Data Documentation

bVerbose

python.AtlasGeoDBInterface.AtlasGeoDBInterface_SQLite.bVerbose

Definition at line 240 of file AtlasGeoDBInterface.py.

db

python.AtlasGeoDBInterface.AtlasGeoDBInterface_SQLite.db

Definition at line 239 of file AtlasGeoDBInterface.py.

dbFile

python.AtlasGeoDBInterface.AtlasGeoDBInterface_SQLite.dbFile

Definition at line 243 of file AtlasGeoDBInterface.py.

---

The documentation for this class was generated from the following file:

• AtlasGeoDBInterface.py