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