possible to use VIEWs as datasource

Open MichelTaal opened this issue 10 years ago • 2 comments

I'm using the FCModel in my new project, everything working well so far. I have a few VIEW in my sqlite database that I would like to access Model like the regular tables. Is this possible?

Mar 09 '15 12:03 MichelTaal

Honestly, I have no idea. I've never used views in SQLite and have no idea how they behave.

Mar 09 '15 13:03 marcoarment

Actually this is trivial. In order to use view you have just to solve the problem of the primary key. I needed this feature so I implemented it, you can find it here: https://github.com/mirion/FCModel/tree/mirion_dev/views_file_support

Jun 04 '15 13:06 mirion