How can i use sql views ? #814
-
|
I am wondering if there is a way to create and use sql view with sea-orm. |
Beta Was this translation helpful? Give feedback.
Replies: 4 comments 4 replies
-
|
@EtienneProthon hello! I am working on this: SeaQL/sea-query#179 |
Beta Was this translation helpful? Give feedback.
-
|
Is there anything i can do to help you on this PR ? What is the current state ? |
Beta Was this translation helpful? Give feedback.
-
|
Hey @EtienneProthon, SeaORM rely on SeaQuery to construct all necessary SQL statement. Since the support of view statements are under development. You cannot create / modify view with SeaORM nor SeaQuery. But I think you can still query view with SeaORM just like what you can do to a ordinary table. |
Beta Was this translation helpful? Give feedback.
-
|
Yes you can select from view, but not creating them for now |
Beta Was this translation helpful? Give feedback.
-
|
Yes i know i can select from them, for the moment i will create them from raw on the migration part. Thanks for your quick answers ! |
Beta Was this translation helpful? Give feedback.
-
|
I've just found this discussion facing the same issue. |
Beta Was this translation helpful? Give feedback.
-
|
Just do like you would with normal table (create the model etc...) it will generate the sql request to query it but don't try to update or delete because as it's a view it will not work. |
Beta Was this translation helpful? Give feedback.
-
|
Thanks!! @EtienneProthon |
Beta Was this translation helpful? Give feedback.
Hey @EtienneProthon, SeaORM rely on SeaQuery to construct all necessary SQL statement. Since the support of view statements are under development. You cannot create / modify view with SeaORM nor SeaQuery.
But I think you can still query view with SeaORM just like what you can do to a ordinary table.