def get_assets(status=False):
results = []
rows = session.query(Assets)
if status:
rows = rows.filter(Assets.assetstatus == status)
for row in rows:
p = Packet()
p.id = row.assetid
p.name = row.assetname
p.path = row.assetpath
p.status = row.assetstatus
results.append(p)
return results
def get_fail_assets():
results = []
cursor, conn = get_cursor()
cursor.execute(
"SELECT assetid, assetname, assetpath, assetstatus FROM Asset where \
assetstatus = 'Failure'")
records = cursor.fetchall()
for record in records:
p = Packet()
p.id = record[0]
p.name = record[1].strip()
p.path = record[2].strip()
results.append(p)
cursor.close()
conn.close()
return results