Example #1
0
class Bucketlist(DB.Model):
    """This class represents the bucketlist table."""

    __tablename__ = 'bucketlists'

    id = DB.Column(DB.Integer,
                   DB.Sequence('bucketlist_id_seq'),
                   primary_key=True)
    name = DB.Column(DB.String(255))
    date_created = DB.Column(DB.DateTime, default=DB.func.current_timestamp())
    date_modified = DB.Column(DB.DateTime,
                              default=DB.func.current_timestamp(),
                              onupdate=DB.func.current_timestamp())

    def __init__(self, name):
        """initialize with name."""
        self.name = name

    def save(self):
        DB.session.add(self)
        DB.session.commit()

    @staticmethod
    def get_all():
        return Bucketlist.query.all()

    def delete(self):
        DB.session.delete(self)
        DB.session.commit()

    def __repr__(self):
        return "<Bucketlist: {}>".format(self.name)