# -*- coding utf-8 -*-

from flask.ext.sqlalchemy import SQLAlchemy

from datetime import datetime

db = SQLAlchemy()

class Membership(db.Model):

    """ docstring """

    __tablename__ 'memberships'

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

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

    gid = db.Column(db.Integer, db.ForeignKey('groups.id'))

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

    user = db.relationship('User', backref='memberships', lazy='dynamic')

    group = db.relationship('Group', backref='memberships', lazy='dynamic')

    def __init__(self, uid, gid):

        self.uid = uid

        self.gid = gid

    def persist(self):        #To create record

        db.session.add(self)

        db.session.commit()

    def remove(self):                 # To delete a record

        db.session.delete(self)

        db.session.commit()

    def __repr__(self):

        return'<Membership %d>' % self.uid