def get_by_id(self, id): """Retrieve a record from the database by ID""" query = text(""" SELECT id, name FROM tblBreakfast WHERE id=:id; """) return self.fetchone(query, id=id)