# coding: utf-8
"""
class StationmetaGlobal (Base)
==============================
"""
from sqlalchemy import Column, DateTime, Float, ForeignKey, Integer, text, String, \
                       Text, CheckConstraint
from geoalchemy2.types import Geometry
from sqlalchemy.orm import relationship
from sqlalchemy.dialects.postgresql import JSONB, ARRAY
from sqlalchemy.ext.declarative import declarative_base
from shapely import wkt
from .models_core import StationmetaCore

Base = declarative_base()
metadata = Base.metadata


class StationmetaGlobal(Base):
    """ Table "public.stationmeta_global"

    +--------------------------------------+------------------+-----------+----------+------------------------------------------------+
    |                Column                |       Type       | Collation | Nullable |                    Default                     |
    +======================================+==================+===========+==========+================================================+
    | id                                   | integer          |           | not null | nextval('stationmeta_global_id_seq'::regclass) |
    +--------------------------------------+------------------+-----------+----------+------------------------------------------------+
    | population_density_year2010          | double precision |           | not null |                                                |
    +--------------------------------------+------------------+-----------+----------+------------------------------------------------+
    | max_population_density_25km_year2010 | double precision |           | not null |                                                |
    +--------------------------------------+------------------+-----------+----------+------------------------------------------------+
    | climatic_zone                        | integer          |           | not null |                                                |
    +--------------------------------------+------------------+-----------+----------+------------------------------------------------+
    | nightlight_1km_year2013              | double precision |           | not null |                                                |
    +--------------------------------------+------------------+-----------+----------+------------------------------------------------+
    | nightlight_5km_year2013              | double precision |           | not null |                                                |
    +--------------------------------------+------------------+-----------+----------+------------------------------------------------+
    | max_nightlight_25km_year2013         | double precision |           | not null |                                                |
    +--------------------------------------+------------------+-----------+----------+------------------------------------------------+
    | wheat_production_year2000            | double precision |           | not null |                                                |
    +--------------------------------------+------------------+-----------+----------+------------------------------------------------+
    | rice_production_year2000             | double precision |           | not null |                                                |
    +--------------------------------------+------------------+-----------+----------+------------------------------------------------+
    | edgar_htap_v2_nox_emissions_year2010 | double precision |           | not null |                                                |
    +--------------------------------------+------------------+-----------+----------+------------------------------------------------+
    | omi_no2_column_years2011to2015       | double precision |           | not null |                                                |
    +--------------------------------------+------------------+-----------+----------+------------------------------------------------+
    | htap_region_tier1                    | integer          |           | not null |                                                |
    +--------------------------------------+------------------+-----------+----------+------------------------------------------------+
    | etopo_alt                            | double precision |           | not null |                                                |
    +--------------------------------------+------------------+-----------+----------+------------------------------------------------+
    | etopo_min_alt_5km                    | double precision |           | not null |                                                |
    +--------------------------------------+------------------+-----------+----------+------------------------------------------------+
    | etopo_relative_alt                   | double precision |           | not null |                                                |
    +--------------------------------------+------------------+-----------+----------+------------------------------------------------+
    | dominant_landcover_year2012          | integer          |           | not null |                                                |
    +--------------------------------------+------------------+-----------+----------+------------------------------------------------+
    | toar1_category                       | integer          |           | not null |                                                |
    +--------------------------------------+------------------+-----------+----------+------------------------------------------------+
    | station_id                           | integer          |           | not null |                                                |
    +--------------------------------------+------------------+-----------+----------+------------------------------------------------+
    Indexes:
     "stationmeta_global_pkey" PRIMARY KEY, btree (id)
     "stationmeta_global_station_id_key" UNIQUE CONSTRAINT, btree (station_id)
    Check constraints:
     "stationmeta_global_climatic_zone_check" CHECK (climatic_zone >= 0)
     "stationmeta_global_dominant_landcover_year2012_check" CHECK (dominant_landcover_year2012 >= 0)
     "stationmeta_global_htap_region_tier1_check" CHECK (htap_region_tier1 >= 0)
     "stationmeta_global_toar1_category_check" CHECK (toar1_category >= 0)
    Foreign-key constraints:
     "stationmeta_global_station_id_29ff53dd_fk_stationmeta_core_id" FOREIGN KEY (station_id) REFERENCES stationmeta_core(id) DEFERRABLE INITIALLY DEFERRED
    """
    __tablename__ = 'stationmeta_global'
    __table_args__ = (
                         CheckConstraint('climatic_zone >= 0'),
                         CheckConstraint('dominant_landcover_year2012 >= 0'),
                         CheckConstraint('htap_region_tier1 >= 0'),
                         CheckConstraint('toar1_category >= 0')
                     )

    id = Column(Integer, primary_key=True, server_default=text("nextval('stationmeta_global_id_seq'::regclass)"))
    population_density_year2010 = Column(Float(53), nullable=False)
    max_population_density_25km_year2010 = Column(Float(53), nullable=False)
    climatic_zone = Column(Integer, nullable=False)
    nightlight_1km_year2013 = Column(Float(53), nullable=False)
    nightlight_5km_year2013 = Column(Float(53), nullable=False)
    max_nightlight_25km_year2013 = Column(Float(53), nullable=False)
    wheat_production_year2000 = Column(Float(53), nullable=False)
    rice_production_year2000 = Column(Float(53), nullable=False)
    edgar_htap_v2_nox_emissions_year2010 = Column(Float(53), nullable=False)
    omi_no2_column_years2011to2015 = Column(Float(53), nullable=False)
    htap_region_tier1 = Column(Integer, nullable=False)
    etopo_alt = Column(Float(53), nullable=False)
    etopo_min_alt_5km = Column(Float(53), nullable=False)
    etopo_relative_alt = Column(Float(53), nullable=False)
    dominant_landcover_year2012 = Column(Integer, nullable=False)
    toar1_category = Column(Integer, nullable=False)
# do not use string declaration here (not working for pytest)
# use the explicit class name here,
# see: https://groups.google.com/forum/#!topic/sqlalchemy/YjGhE4d6K4U
    station_id = Column(ForeignKey(StationmetaCore.id, deferrable=True, initially='DEFERRED'), nullable=False, unique=True)
    #how to reactivate the following?
#   station = relationship('StationmetaCore', uselist=False)