#!/usr/bin/env python
# coding=utf-8
# author = ruiruige
# email = whx20202@gmail.com
"""天气情况表

也就是天气历史的记录
"""


from sqlalchemy import Column, INT, DATE, Text, TIMESTAMP
from sqlalchemy import func
from myifttt.common.db.do.base_do import Base_do
from myifttt.common.db.db import Base

# 定义Weather_info对象:


class Weather_info(Base, Base_do):
    """[summary]

    [description]

    Extends:
        Base
        Base_do

    Variables:
        info_id {[type]} -- [description]
        city_alias {[type]} -- [description]
        city_id {[type]} -- [description]
        city_name {[type]} -- [description]
        today_temperature_high {[type]} -- [description]
        today_temperature_low {[type]} -- [description]
        tomorrow_temperature_high {[type]} -- [description]
        tomorrow_temperature_low {[type]} -- [description]
        text_day {[type]} -- [description]
        text_night {[type]} -- [description]
        info_date {[type]} -- [description]
        created_at {[type]} -- [description]
        updated_at {[type]} -- [description]
    """

    # 表的名字:
    __tablename__ = 'weather_info'

    # 表的结构:
    info_id = Column("id", INT, primary_key=True)
    city_alias = Column("city_alias", Text)
    city_id = Column("city_id", Text)
    city_name = Column("city_name", Text)
    today_temperature_high = Column("today_temperature_high", INT)
    today_temperature_low = Column("today_temperature_low", INT)
    tomorrow_temperature_high = Column("tomorrow_temperature_high", INT)
    tomorrow_temperature_low = Column("tomorrow_temperature_low", INT)
    text_day = Column("text_day", Text)
    text_night = Column("text_night", Text)
    info_date = Column("info_date", DATE, default=func.current_date())
    created_at = Column("created_at", TIMESTAMP,
                        default=func.now())
    updated_at = Column("updated_at", TIMESTAMP,
                        default=func.now())

7eb59454688ac43f6111792f498c9d5dc52e6855
<mask token>


class Weather_info(Base, Base_do):
    <mask token>
    <mask token>
    <mask token>
    <mask token>
    <mask token>
    <mask token>
    <mask token>
    <mask token>
    <mask token>
    <mask token>
    <mask token>
    <mask token>
    <mask token>
    <mask token>
    <mask token>

<mask token>


class Weather_info(Base, Base_do):
    <mask token>
    __tablename__ = 'weather_info'
    info_id = Column('id', INT, primary_key=True)
    city_alias = Column('city_alias', Text)
    city_id = Column('city_id', Text)
    city_name = Column('city_name', Text)
    today_temperature_high = Column('today_temperature_high', INT)
    today_temperature_low = Column('today_temperature_low', INT)
    tomorrow_temperature_high = Column('tomorrow_temperature_high', INT)
    tomorrow_temperature_low = Column('tomorrow_temperature_low', INT)
    text_day = Column('text_day', Text)
    text_night = Column('text_night', Text)
    info_date = Column('info_date', DATE, default=func.current_date())
    created_at = Column('created_at', TIMESTAMP, default=func.now())
    updated_at = Column('updated_at', TIMESTAMP, default=func.now())

<mask token>


class Weather_info(Base, Base_do):
    """[summary]

    [description]

    Extends:
        Base
        Base_do

    Variables:
        info_id {[type]} -- [description]
        city_alias {[type]} -- [description]
        city_id {[type]} -- [description]
        city_name {[type]} -- [description]
        today_temperature_high {[type]} -- [description]
        today_temperature_low {[type]} -- [description]
        tomorrow_temperature_high {[type]} -- [description]
        tomorrow_temperature_low {[type]} -- [description]
        text_day {[type]} -- [description]
        text_night {[type]} -- [description]
        info_date {[type]} -- [description]
        created_at {[type]} -- [description]
        updated_at {[type]} -- [description]
    """
    __tablename__ = 'weather_info'
    info_id = Column('id', INT, primary_key=True)
    city_alias = Column('city_alias', Text)
    city_id = Column('city_id', Text)
    city_name = Column('city_name', Text)
    today_temperature_high = Column('today_temperature_high', INT)
    today_temperature_low = Column('today_temperature_low', INT)
    tomorrow_temperature_high = Column('tomorrow_temperature_high', INT)
    tomorrow_temperature_low = Column('tomorrow_temperature_low', INT)
    text_day = Column('text_day', Text)
    text_night = Column('text_night', Text)
    info_date = Column('info_date', DATE, default=func.current_date())
    created_at = Column('created_at', TIMESTAMP, default=func.now())
    updated_at = Column('updated_at', TIMESTAMP, default=func.now())

<mask token>
from sqlalchemy import Column, INT, DATE, Text, TIMESTAMP
from sqlalchemy import func
from myifttt.common.db.do.base_do import Base_do
from myifttt.common.db.db import Base


class Weather_info(Base, Base_do):
    """[summary]

    [description]

    Extends:
        Base
        Base_do

    Variables:
        info_id {[type]} -- [description]
        city_alias {[type]} -- [description]
        city_id {[type]} -- [description]
        city_name {[type]} -- [description]
        today_temperature_high {[type]} -- [description]
        today_temperature_low {[type]} -- [description]
        tomorrow_temperature_high {[type]} -- [description]
        tomorrow_temperature_low {[type]} -- [description]
        text_day {[type]} -- [description]
        text_night {[type]} -- [description]
        info_date {[type]} -- [description]
        created_at {[type]} -- [description]
        updated_at {[type]} -- [description]
    """
    __tablename__ = 'weather_info'
    info_id = Column('id', INT, primary_key=True)
    city_alias = Column('city_alias', Text)
    city_id = Column('city_id', Text)
    city_name = Column('city_name', Text)
    today_temperature_high = Column('today_temperature_high', INT)
    today_temperature_low = Column('today_temperature_low', INT)
    tomorrow_temperature_high = Column('tomorrow_temperature_high', INT)
    tomorrow_temperature_low = Column('tomorrow_temperature_low', INT)
    text_day = Column('text_day', Text)
    text_night = Column('text_night', Text)
    info_date = Column('info_date', DATE, default=func.current_date())
    created_at = Column('created_at', TIMESTAMP, default=func.now())
    updated_at = Column('updated_at', TIMESTAMP, default=func.now())

#!/usr/bin/env python
# coding=utf-8
# author = ruiruige
# email = whx20202@gmail.com
"""天气情况表

也就是天气历史的记录
"""


from sqlalchemy import Column, INT, DATE, Text, TIMESTAMP
from sqlalchemy import func
from myifttt.common.db.do.base_do import Base_do
from myifttt.common.db.db import Base

# 定义Weather_info对象:


class Weather_info(Base, Base_do):
    """[summary]

    [description]

    Extends:
        Base
        Base_do

    Variables:
        info_id {[type]} -- [description]
        city_alias {[type]} -- [description]
        city_id {[type]} -- [description]
        city_name {[type]} -- [description]
        today_temperature_high {[type]} -- [description]
        today_temperature_low {[type]} -- [description]
        tomorrow_temperature_high {[type]} -- [description]
        tomorrow_temperature_low {[type]} -- [description]
        text_day {[type]} -- [description]
        text_night {[type]} -- [description]
        info_date {[type]} -- [description]
        created_at {[type]} -- [description]
        updated_at {[type]} -- [description]
    """

    # 表的名字:
    __tablename__ = 'weather_info'

    # 表的结构:
    info_id = Column("id", INT, primary_key=True)
    city_alias = Column("city_alias", Text)
    city_id = Column("city_id", Text)
    city_name = Column("city_name", Text)
    today_temperature_high = Column("today_temperature_high", INT)
    today_temperature_low = Column("today_temperature_low", INT)
    tomorrow_temperature_high = Column("tomorrow_temperature_high", INT)
    tomorrow_temperature_low = Column("tomorrow_temperature_low", INT)
    text_day = Column("text_day", Text)
    text_night = Column("text_night", Text)
    info_date = Column("info_date", DATE, default=func.current_date())
    created_at = Column("created_at", TIMESTAMP,
                        default=func.now())
    updated_at = Column("updated_at", TIMESTAMP,
                        default=func.now())
