Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Config option to allow updates on views #918

Open
chattago2002 opened this issue Sep 30, 2022 · 1 comment
Open

Config option to allow updates on views #918

chattago2002 opened this issue Sep 30, 2022 · 1 comment
Assignees

Comments

@chattago2002
Copy link

Hi.

I read that at the moment views aren't updatable (insert, update, delete) as also reported in the #823 question here.
Obviously when I try to update a view the response is 1015 error with message Operation 'update' not supported.

As reported in last comment of #823 views seems to be updated bypassing the check.
Is there the possibility to add an option (or something else) in the api configuration file to let this operation if necessary?

P.S. I'm using MySQL instead of SQL Server but this is not a difference.

Thank you

@mevdschee
Copy link
Owner

mevdschee commented Oct 1, 2022

Yeah, the primary key reflection does not work*, nor can all views be updated (only update-able views). To avoid support tickets I disabled the functionality. Although indeed we could allow it to be enabled with a configuration option, which is not a bad idea.

*) falling back to (name) convention based primary key detection (e.g. a column named "id").

@mevdschee mevdschee self-assigned this Oct 1, 2022
@mevdschee mevdschee changed the title Make views updatable Config options to allow updates on views Oct 1, 2022
@mevdschee mevdschee changed the title Config options to allow updates on views Config option to allow updates on views Oct 1, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants