Beispiel #1
0
class UserModel(alchemy.Model):
    __tablename__ = 'user'

    id = alchemy.Column(alchemy.Integer, primary_key=True)
    name = alchemy.Column(alchemy.String(80))
    password = alchemy.Column(alchemy.String(80))

    def __init__(self, name, password):
        self.name = name
        self.password = password

    def json(self):
        return {'name': self.name, 'password': self.password}

    @classmethod
    def find_by_name(cls, name):
        return cls.query.filter_by(name=name).first()

    def save_to_db(self):
        alchemy.session.add(self)
        alchemy.session.commit()

    def delete_from_db(self):
        alchemy.session.delete(self)
        alchemy.session.commit()
Beispiel #2
0
class EpisodeModel(alchemy.Model):
    __tablename__ = 'episode'

    id = alchemy.Column(alchemy.Integer, primary_key=True)
    name = alchemy.Column(alchemy.String(80))
    season = alchemy.Column(alchemy.Float(precision=2))

    show_id = alchemy.Column(alchemy.Integer, alchemy.ForeignKey('shows.id'))

    #episode = alchemy.relationship('show.ShowModel')

    def __init__(self, name, season, show_id):
        self.name = name
        self.season = season
        self.show_id = show_id

    def json(self):
        return {'name': self.name, 'season': self.season}

    @classmethod
    def find_by_name(cls, name):
        return cls.query.filter_by(name=name).first()

    def save_to_db(self):
        alchemy.session.add(self)
        alchemy.session.commit()

    def delete_from_db(self):
        alchemy.session.delete(self)
        alchemy.session.commit()
Beispiel #3
0
class UserModel(alchemy.Model):
    __tablename__ = 'user'

    id = alchemy.Column(alchemy.Integer, primary_key=True)
    username = alchemy.Column(alchemy.String(100), unique=True)
    password = alchemy.Column(alchemy.String(94))

    def __init__(self, username, password):
        self.username = username
        self.password = password

    def json(self):
        return {'username': self.username, 'password': self.password}

    @classmethod
    def find_by_username(cls, username):
        return cls.query.filter.by(username=username).first()

    @classmethod
    def find_by_id(cls, id):
        return cls.query.filter.by(id=id).first()

    def save_to_db(self):
        alchemy.session.add(self)
        alchemy.session.commit()

    def delete_from_db(self):
        alchemy.session.delete(self)
        alchemy.session.commit()
Beispiel #4
0
class EpisodeModel(alchemy.Model):
    __tablename__ = "episode"

    id = alchemy.Column(alchemy.Integer, primary_key=True)
    name = alchemy.Column(alchemy.String(80))
    season = alchemy.Column(alchemy.Integer)

    show_id = alchemy.Column(alchemy.Integer, alchemy.ForeignKey('shows.id'))

    def __init__(self, name, season, show_id):
        self.name = name
        self.season = season
        self.show_id = show_id

    def json(self):
        return {"name": self.name, "season": self.season}

    def save_to_db(self):
        alchemy.session.add(self)
        alchemy.session.commit()

    def delete_from_db(self):
        alchemy.session.delete(self)
        alchemy.session.commit()

    @classmethod
    def find_by_name(cls, name):
        return cls.query.filter_by(name=name).first()
Beispiel #5
0
class ShowModel(alchemy.Model):
    __tablename__ = 'show'

    id = alchemy.Column(alchemy.Integer, primary_key=True)
    name = alchemy.Column(alchemy.String(80))


    episodes = alchemy.relationship(episode.EpisodeModel, lazy='dynamic')

    def __init__(self, name):
        self.name = name

    def json(self):
        return {'id': self.id, 'name': self.name, 'episode':[episode.json() for episode in self.episodes.all()]}

    def save_to_db(self):
        alchemy.session.add(self)
        alchemy.session.commit()

    @classmethod
    def find_by_name(cls,name):
        return cls.query.filter_by(name=name).first()

    @classmethod
    def find_by_id(cls, id):
        return cls.query.filter_by(id=id).first()

    def delete_from_db(self):
        alchemy.session.delete(self)
        alchemy.session.commit()

    def update_show(self):
        alchemy.session.update(self)
        alchemy.session.commit()
class ShowModel(alchemy.Model):
    __tablename__ = "shows"

    id = alchemy.Column(alchemy.Integer, primary_key=True)
    name = alchemy.Column(alchemy.String(80))

    #episodios - fazer algo para carregar automaticamente os episodios
    episodes = alchemy.relationship(episode.EpisodeModel, lazy="dynamic")

    def __init__(self, name):
        self.name = name

    def json(self):
        return {
            "id": self.id,
            "name": self.name,
            "episodes": [episode.json() for episode in self.episodes.all()]
        }

    def save_to_db(self):
        alchemy.session.add(self)
        alchemy.session.commit()

    def delete_from_db(self):
        alchemy.session.delete(self)
        alchemy.session.commit()

    @classmethod
    def find_by_name(cls, name):
        return cls.query.filter_by(name=name).first()

    @classmethod
    def find_by_id(cls, id):
        return cls.query.filter_by(id=id).first()

    @classmethod
    def find_all(cls):
        return cls.query.all()
Beispiel #7
0
class Employee(alchemy.Model):
    __tablename__ = 'employee'

    id = alchemy.Column(alchemy.Integer, primary_key=True)
    name = alchemy.Column(alchemy.String(80))
    email = alchemy.Column(alchemy.String(80))
    department = alchemy.Column(alchemy.String(80))
    salary = alchemy.Column(alchemy.Float(15, 2))
    birth_date = alchemy.Column(alchemy.Date)

    def __init__(self, name, email, department, salary, birth_date):
        self.name = name
        self.email = email
        self.department = department
        self.salary = float(salary)
        self.birth_date = datetime.strptime(birth_date, '%m-%d-%Y')

    def json(self):
        return {
            'id': self.id,
            'name': self.name,
            'email': self.email,
            'department': self.department,
            'salary': str(round(self.salary, 2)),
            'birth_date': self.birth_date.strftime('%m-%d-%Y')
        }

    def save_to_db(self):
        alchemy.session.add(self)
        alchemy.session.commit()

    @classmethod
    def find_by_name(cls, name):
        return cls.query.filter_by(name=name).first()

    @classmethod
    def find_by_id(cls, id):
        return cls.query.filter_by(id=id).first()

    def delete_from_db(self):
        alchemy.session.delete(self)
        alchemy.session.commit()

    def update(self):
        alchemy.session.commit()