Will web2py support database view? When?

[heidan]

hi,

Is there a way to work with database views using the DAL? I've got a
bunch of views in my database that handle common queries. BUt didn't
see good answers and neither find interface in DAL.

Is there any plan to support database view and when? Anyway accessing
view is performing better than query in controller scripts.

Cheers,
heidan

[Vasile Ermicioi]

if  you can query your views with sql that should be possible with dal too,

just declare your views as web2py tables and set migrate=False (no need to create tables)

something like

db.define_table('your_view_name',

    Field('field1'),

    Field('field2'),

    migrate=False)

[Mohamed Zenadi]

Hey,

I don't know if you can just follow the Django way, in which you simply create a model for your db view. 

Cheers

[mdipierro]

yes

[David Ripplinger]

I'm not familiar with the Django way. Web2py is my first serious attempt at web programming. What is the Django way, or (alternatively) what is the cleanest way, to use database views in web2py? Should I just do the define_table with migrate=False described by Vasile in this thread, or is there another way I should know about?

[Niphlod]

defining a "fake table" that points to the view and set migrate=False is definitely the best (and recommended) way to do it.