24 lines
764 B
Python
24 lines
764 B
Python
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}
|