How to query a view using sqlalchemy? [duplicate]

Question

I query an existing table with the following code:

class Minicomputer(Base):
    __table__ = Base.metadata.tables[' minicomputer']

    def __repr__(self):
        return '<Masterlist %r>' % self.Hostname

Minicomputer.query.filter_by(name='CJ_1').first() returns the result, now I want to query via an existing view named mast_list. How do I do it?

Nidhin Bose J. · Accepted Answer · 2016-08-11 07:37:52Z

0

Do you mean to pass the name as an argument to the view and query?

Like this:

@app.route('/master/<string:name>')
def mast_list(name):
 return Minicomputer.query.filter_by(name=name).first()

answered Aug 11, 2016 at 7:37

Nidhin Bose J.

1,09215 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Flasking Over a year ago

it's a view use CREATE VIEW not a table

Collectives™ on Stack Overflow

How to query a view using sqlalchemy? [duplicate]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related