Is possible to mapping view with class using mapper in SqlAlchemy?

by

Finally I found it.

We can create class for sql view’s. Here is simple example.

class ViewName(Base):
    __table__ = Table('viewname', Base.metadata,
        Column('id', Integer, primary_key=True),
        Column('foreign_key', Integer, ForeignKey('sometablename.id'),
            autoload=True, autoload_with=engine
        )

That’s it. We can access “viewname” table using ViewName class.

Thank you for all who are respond me.

More Related Contents:

  1. SQL Alchemy ORM returning a single column, how to avoid common post processing
  2. Efficiently updating database using SQLAlchemy ORM
  3. Why is SQLAlchemy insert with sqlite 25 times slower than using sqlite3 directly?
  4. SQLAlchemy ManyToMany secondary table with additional fields
  5. Bulk insert with SQLAlchemy ORM
  6. How can I verify Column data types in the SQLAlchemy ORM?
  7. SQLAlchemy: engine, connection and session difference
  8. sqlalchemy: create relations but without foreign key constraint in db?
  9. SQLAlchemy: how to filter date field?
  10. flask-sqlalchemy or sqlalchemy
  11. How to update sqlalchemy orm object by a python dict
  12. SQLALchemy dynamic filter_by
  13. SQLAlchemy ordering by count on a many to many relationship
  14. Python 2.7 IndentationError [closed]
  15. How to detect key presses?
  16. Using both Python 2.x and Python 3.x in IPython Notebook
  17. List vs generator comprehension speed with join function [duplicate]
  18. Launch a completely independent process
  19. Why does str(float) return more digits in Python 3 than Python 2?
  20. Add pygame module in PyCharm IDE
  21. How to pass an operator to a python function?
  22. How to pass dictionary items as function arguments in python? [duplicate]
  23. SQLAlchemy printing raw SQL from create()
  24. Mixing files and loops
  25. Read Outlook Events via Python
  26. python pandas to_sql with sqlalchemy : how to speed up exporting to MS SQL?
  27. Python 2.7 on Ubuntu
  28. SQLAlchemy – can you add custom methods to the query object?
  29. Reverse engineer SQLAlchemy declarative class definition from existing MySQL database?
  30. What is the easiest way to achieve realtime plotting in pyqtgraph

Leave a Comment