Extract the current compound ids in the database. Updates the self.compound_ids list

def get_compound_ids(self):
        """Extract the current compound ids in the database. Updates the self.compound_ids list
        """
        cursor = self.conn.cursor()
        cursor.execute('SELECT inchikey_id FROM metab_compound')
        self.conn.commit()
        for row in cursor:
            if not row[0] in self.compound_ids:
                self.compound_ids.append(row[0])