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)
