class ZoneSchedule:
    def __init__(self, name, job_id, zone_job, job_enabled, job_start_time, job_stop_time,
                 job_duration, job_running, monday, tuesday, wednesday, thursday, friday,
                 saturday, sunday, forced_stopped_manually):
        self.name = name
        self.job_id = job_id
        self.zone_job = zone_job
        self.job_enabled = job_enabled
        self.job_start_time = job_start_time
        self.job_stop_time = job_stop_time
        self.job_duration = job_duration
        self.job_running = job_running
        self.monday = monday
        self.tuesday = tuesday
        self.wednesday = wednesday
        self.thursday = thursday
        self.friday = friday
        self.saturday = saturday
        self.sunday = sunday
        self.forced_stopped_manually = forced_stopped_manually

    @classmethod
    def config_zoneschedule(cls, zone_name):
        with engine.begin() as conn:
            stmt = select([scheduled_jobs]).where(scheduled_jobs.c.zone.in_(zone_name))
            return [
                cls(
                    name=row[scheduled_jobs.c.zone],
                    job_id=row[scheduled_jobs.c.job_id],
                    zone_job=row[scheduled_jobs.c.zone_job],
                    job_enabled=row[scheduled_jobs.c.job_enabled],
                    job_start_time=row[scheduled_jobs.c.job_start_time],
                    job_stop_time=row[scheduled_jobs.c.job_stop_time],
                    job_duration=row[scheduled_jobs.c.job_duration],
                    job_running=row[scheduled_jobs.c.job_running],
                    monday=row[scheduled_jobs.c.monday],
                    tuesday=row[scheduled_jobs.c.tuesday],
                    wednesday=row[scheduled_jobs.c.wednesday],
                    thursday=row[scheduled_jobs.c.thursday],
                    friday=row[scheduled_jobs.c.friday],
                    saturday=row[scheduled_jobs.c.saturday],
                    sunday=row[scheduled_jobs.c.sunday],
                    forced_stopped_manually=row[scheduled_jobs.c.forced_stop_manually]
                )
                for row in conn.execute(stmt).fetchall()
            ]