from sqlalchemy import Column, String
from base import db


class City(db.Model):
    __tablename__ = 'city'

    city_id = Column(String(255), primary_key=True)
    city_en = Column(String(255), nullable=False)
    city_cn = Column(String(255), nullable=False)
    country_code = Column(String(255))
    country_en = Column(String(255))
    country_cn = Column(String(255))
    province_en = Column(String(255))
    province_cn = Column(String(255))
    admin_district_en = Column(String(255))
    admin_district_cn = Column(String(255))
    latitude = Column(String(255))
    longitude = Column(String(255))
    ad_code = Column(String(255))

    def __to_dict__(self) -> dict:
        return {c.name: str(getattr(self, c.name)) for c in self.__table__.columns}