Using views

[dleavitt802]

Any suggestions on how to use views from within sqlite_orm? Can the sync_schema functionality create views and can they be accessed the same way as tables?

[fnc12]

Hi. View is not implemented right now but it exists in TODO list. The way how I see view API is:
There are two options of creating view:

1. static view specified in make_storage function call. It will call CREATE VIEW during sync_schema
2. dynamic view specified with a storage's member function like storage.create_view<ViewClass>(make_table(...));. It will call CREATE TEMP VIEW at once.

Also you need to have a class in C++ to map to your view.

What do you think?

[fnc12]

What view do you need? TEMP or not?

[dleavitt802]

Both capabilities would be great but either will suffice. I have a query with six joins to the same part table from a table with foreign keys to those parts that I could not figure out how to do “join as alias” with with this API to make them distinct, so I have manually made a view to flatten it out but I’m not then sure how to do view access with it yet. So there’s another question, how to get the as alias to work with joins? Dan

[fnc12]

You can use aliases in the lib until views are not implemented

[gbittoun]

Hello,

I’d also like to be able to read a view… Read only is enough for me today. is there already a way for doing so ? (There doesn’t seem to be any but I ask just in case :) ). I tried with a make_table method but obviously, it didn’t work.

Thanks,
PS: this lib is great ! \o/

[fnc12]

Hello. Views feature is not implemented right now unfortunately. It exists in TODO list. You can implement it by yourself or wait until I or anyone else implement it.