def getDeathPerson(): conn = db.getConnection() curs = conn.cursor() sql = "SELECT count(person_id) as death_count FROM death;" curs.execute(sql) data = data_frame(curs) conn.close() post_pool.putconn(conn) return data
def getVisit():
conn = db.getConnection()
curs = conn.cursor()
sql = "SELECT visit_concept_id, COUNT(visit_concept_id) AS visit \
FROM visit_occurrence GROUP BY visit_concept_id;"
curs.execute(sql)
data = data_frame(curs)
conn.close()
post_pool.putconn(conn)
return data
def getSerchConcept(serchIdx):
serch = serchIdx
conn = db.getConnection()
curs = conn.cursor()
sql = f"SELECT concept_name, concept_id FROM concept WHERE concept_id = {serch};"
curs.execute(sql)
data = data_frame(curs)
conn.close()
post_pool.putconn(conn)
return data
def getAllGender():
conn = db.getConnection()
curs = conn.cursor()
sql = "SELECT c.concept_name, COUNT(p.gender_concept_id) \
FROM person p INNER JOIN concept c \
ON c.concept_id = p.gender_concept_id \
GROUP BY c.concept_name, p.gender_concept_id;"
curs.execute(sql)
data = data_frame(curs)
conn.close()
post_pool.putconn(conn)
return data
def getGenderVisit():
conn = db.getConnection()
curs = conn.cursor()
sql = "SELECT COUNT(p.gender_concept_id) AS gender_count , c.concept_name AS Gender\
FROM person p \
INNER JOIN visit_occurrence v \
ON p.person_id = v.person_id \
INNER JOIN concept c \
ON c.concept_id = p.gender_concept_id \
GROUP BY p.gender_concept_id , c.concept_name;"
curs.execute(sql)
data = data_frame(curs)
conn.close()
post_pool.putconn(conn)
return data