def getStatusCount2(self): session = DBConnector().getNewSession() query = text(""" SELECT fileStatus, companyStatus, if(listed=1,'LISTED','NOT_LISTED') as listedStatus, entityStatus, priceStatus, factStatus, count(*) as values_ FROM fa_file_data fd join fa_company c on c.oid = fd.companyOID group by fileStatus, companyStatus, listed, entityStatus, priceStatus, factStatus""") return session.execute(query, '')
def getStatusCount3(self): session = DBConnector().getNewSession() query = text(""" SELECT factStatus, copyStatus, calculateStatus, expressionStatus, count(*) as values_ FROM fa_file_data fd join fa_company c on c.oid = fd.companyOID where c.listed = 1 group by factStatus, copyStatus, calculateStatus, expressionStatus""") return session.execute(query, '')
def getLastFileDataByCIK(self, CIK, session): session = DBConnector().getNewSession() params = { 'CIK' : CIK} query = text(""" select fileName from fa_file_data fd join fa_company c on fd.companyOID = c.OID where CIK = :CIK and documentPeriodEndDate = ( select max(documentPeriodEndDate) from fa_file_data fd join fa_company c on fd.companyOID = c.OID where CIK = :CIK group by companyOID); """) return session.execute(query, params)