"""RuleConditionField model."""

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

from vector_job_rules.connectors import mysql


class RuleConditionField(mysql.BaseModel):
    """RuleConditionField Model."""

    __tablename__ = 'rule_condition_field'

    rule_condition_field_id = Column(
        'rule_condition_field_id', Integer, primary_key=True
    )
    name = Column('name', String, unique=True)
    rule_condition_field_type = Column('type', String, key='type')
    description = Column('description', String)


DEFAULT_FIELDS = {
    RuleConditionField.rule_condition_field_id,
    RuleConditionField.name,
    RuleConditionField.rule_condition_field_type,
    RuleConditionField.description,
}


def get_fields():
    """Get all rule condition fields.

    Returns:
        response.Response
    """
    with mysql.db_session() as session:
        rows = session.query(
            *DEFAULT_FIELDS,
        ).all()

        response_data = [row._asdict() for row in rows]

        return response.Response(response_data)