"""Region Model.

This Region model uses sqlalchemy.
"""

from owsresponse import response
from sqlalchemy import Column, Integer, String

from account.connectors import mysql


class Region(mysql.BaseModel):
    """Region DB Model."""

    __tablename__ = 'region'

    region_id = Column(Integer, primary_key=True)
    region_code = Column(String)
    region = Column(String)


def get_regions():
    """Get list of regions from region table."""
    with mysql.session_scope(read_only=True) as session:
        result = (
            session.query(Region.region_id, Region.region_code, Region.region)
            .order_by(Region.region)
            .all()
        )

        if result:
            return response.Response([r._asdict() for r in result])

    return response.create_not_found_response()