# -*- coding utf-8 -*-

from flask.ext.sqlalchemy import SQLAlchemy

from datetime import datetime

db = SQLAlchemy()

class Group(db.Model):

    """

    docstring

    """

    __tablename__ = 'groups'

    id = db.Column(db.Integer, primary_key=True)

    name = db.Column(db.String(80), unique=True)

    created = db.Column(db.DateTime, default=datetime.utcnow)

    created_by = db.Column(db.Integer, db.ForeignKey('users.id'))

    creator = db.relationship('User', backref='groups', lazy='dynamic')

    def __init__(self, name):

        self.name = name

    def persist(self):        # add record

        db.session.add(self)

        db.session.commit()

    def delete(self):         # delete record

        db.session.delete(self)

        db.session.commit()

    @staticmethod

    def getByName(name):      #Query record by Group name

        tofind = Group.query.filter_by(name=name).first()

        return tofind

    @staticmethod             #Query record by ID

    def getById(id):

        return Group.query.get(id)

    def __repr__(self):

        return '<Group %r>' % self.name