# No shebang line, this module is meant to be imported
#
# Copyright 2015 Ambient Entertainment GmbH & Co. KG
#
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
#
#    http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.

"""
Job Group Model
===============

Model for job groups
"""
from pyfarm.master.application import db
from pyfarm.models.core.cfg import (
    TABLE_JOB_GROUP, TABLE_JOB_TYPE, TABLE_USER, MAX_JOBGROUP_NAME_LENGTH)
from pyfarm.models.core.mixins import UtilityMixins
from pyfarm.models.core.types import id_column, IDTypeWork

class JobGroup(db.Model, UtilityMixins):
    """
    Used to group jobs together for better presentation in the UI
    """
    __tablename__ = TABLE_JOB_GROUP

    id = id_column(IDTypeWork)
    title = db.Column(db.String(MAX_JOBGROUP_NAME_LENGTH), nullable=False)
    main_jobtype_id = db.Column(IDTypeWork,
                                db.ForeignKey("%s.id" % TABLE_JOB_TYPE),
                                nullable=False,
                                doc="ID of the jobtype of the main job in this "
                                    "group. Purely for display and "
                                    "filtering.")
    user_id = db.Column(db.Integer, db.ForeignKey("%s.id" % TABLE_USER),
                        doc="The id of the user who owns these jobs")
    main_jobtype = db.relationship("JobType",
                                   backref=db.backref("jobgroups",
                                                      lazy="dynamic"),
                                   doc="The jobtype of the main job in this "
                                       "group")
    user = db.relationship("User",
                           backref=db.backref("jobgroups",
                                              lazy="dynamic"),
                           doc="The user who owns these jobs")

# No shebang line, this module is meant to be imported
#
# Copyright 2015 Ambient Entertainment GmbH & Co. KG
# Copyright 2015 Oliver Palmer
#
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
#
#    http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.

"""
Job Group Model
===============

Model for job groups
"""

from pyfarm.master.application import db
from pyfarm.models.core.cfg import (
    TABLE_JOB_GROUP, TABLE_JOB_TYPE, TABLE_USER, MAX_JOBGROUP_NAME_LENGTH)
from pyfarm.models.core.mixins import UtilityMixins
from pyfarm.models.core.types import id_column, IDTypeWork


class JobGroup(db.Model, UtilityMixins):
    """
    Used to group jobs together for better presentation in the UI
    """
    __tablename__ = TABLE_JOB_GROUP

    id = id_column(IDTypeWork)

    title = db.Column(
        db.String(MAX_JOBGROUP_NAME_LENGTH),
        nullable=False,
        doc="The title of the job group's name"
    )

    main_jobtype_id = db.Column(
        IDTypeWork,
        db.ForeignKey("%s.id" % TABLE_JOB_TYPE),
        nullable=False,
        doc="ID of the jobtype of the main job in this "
            "group. Purely for display and filtering.")

    user_id = db.Column(
        db.Integer,
        db.ForeignKey("%s.id" % TABLE_USER),
        doc="The id of the user who owns these jobs"
    )

    #
    # Relationships
    #
    main_jobtype = db.relationship(
        "JobType",
        backref=db.backref("jobgroups", lazy="dynamic"),
        doc="The jobtype of the main job in this group")

    user = db.relationship(
        "User",
        backref=db.backref("jobgroups", lazy="dynamic"),
        doc="The user who owns these jobs"
    )

reformat JobGroup to match other tables