def get_emails(self, user_id): cursor = self.db.cursor() cursor.execute( 'SELECT id, email, type, auth_data from user_emails WHERE user_id=%s', [user_id]) rows = cursor.fetchall() result = [] if rows and len(rows) > 0: for row in rows: email = UserData.EmailSettings() email.id, email.email, email.type, email.auth_data = row result.append(email) return result