def get_num_mf_derived_from(mf_id):
conn = db.db_conn_socket()
c = conn.cursor()
sql = """
SELECT * FROM `ms_media_files`
WHERE `derived_from_media_file_id` = %s
"""
return len(db.db_execute(c, sql, mf_id))
WHERE `derived_from_media_file_id` = %s
"""
return len(db.db_execute(c, sql, mf_id))
def get_num_m_derived_from(m_id):
conn = db.db_conn_socket()
c = conn.cursor()
sql = """
SELECT * FROM `ms_media`
WHERE `derived_from_media_id` = %s
"""
return len(db.db_execute(c, sql, mf_id))
conn = db.db_conn_socket()
c = conn.cursor()
sql = """
SELECT * FROM `ms_media_files` AS mf
LEFT JOIN `ms_media` AS m ON m.media_id = mf.media_id
LEFT JOIN `ms_specimens` AS s ON s.specimen_id = m.specimen_id
LEFT JOIN `ms_specimens_x_taxonomy` AS sxt ON sxt.specimen_id = s.specimen_id
LEFT JOIN `ms_taxonomy_names` AS t ON t.alt_id = sxt.alt_id
WHERE `recordset` = "bd7cfd55-bf55-46fc-878d-e6e11f574ccd"
"""
media = db.db_execute(c, sql)
m_stats = {}
def init_db(self):
conn = db.db_conn_socket()
c = conn.cursor()
return c