models.py

class LoginBonusMaster(Base):
    __tablename__ = 'login_bonus_master'

    id = Column(Integer, primary_key=True, index=True)
    message_title = Column(Text)
    message_content = Column(Text)
    _daily_reward_id_list = Column('daily_reward_id_list')
    termview_flag = Column(Integer)
    infinite_flag = Column(Integer)
    start_at = Column(DateTime)
    end_at = Column(DateTime)
    priority = Column(Integer)

    @hybrid_property
    def daily_reward_id_list(self):
        return [float(x) for x in self._daily_reward_id_list.split(',')]
    @daily_reward_id_list.setter
    def daily_reward_id_list(self, value):
        self._daily_reward_id_list += ';%s' % value

    @hybrid_property
    def rewards(self):
        #item = [float(x) for x in self._daily_reward_id_list.split(',')][0]
        #return item
        items = [float(x) for x in self._daily_reward_id_list.split(',')]
        r = get_class_by_tablename('reward_master')
        print(items)
        reward_list = s1.query(r).filter(r.id.in_(items)).all()
        return reward_list


class Reward(Base):
    __tablename__ = "reward_master"

    id = Column(Integer, primary_key=True, index=True)
    receive_grace = Column(Integer, nullable=True)
    present_type = Column(Integer)
    present_id = Column(Integer, nullable=True)#,ForeignKey("users.id"))
    present_value = Column(Integer)
    present_custom_parameter = Column(String, nullable=True)
    box_rarity = Column(String, nullable=True)

    @hybrid_property
    def name(self):
        if self.present_type == 5:
            return 'Material'
        elif self.present_type == 11:
            return 'Crystals'

schemas.py

class LoginBonusBase(BaseModel):
    message_title: str
    message_content: str
    daily_reward_id_list: Any
    termview_flag: int
    infinite_flag: int
    start_at: datetime
    end_at: datetime
    priority: int
class LoginBonusMaster(LoginBonusBase):
    id: int
    class Config:
        orm_mode = True
    rewards: Any


class RewardBase(BaseModel):
    receive_grace: Union[int, str]
    present_type: int
    present_id: Union[int, str] # str-None
    present_value: int
    present_custom_parameter: Union[Json, Any] = None # NULL
    box_rarity: Union[int, str] = None
class Reward(RewardBase):
    id: int
    class Config:
        orm_mode = True
    name: Any