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.

Sign up for GitHub

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

Jump to bottom

Support SQLite views in database classes #2799

Closed
nilshoerrmann opened this issue Sep 2, 2020 · 1 comment · Fixed by #4253
Closed

Support SQLite views in database classes #2799

nilshoerrmann opened this issue Sep 2, 2020 · 1 comment · Fixed by #4253
Assignees
@lukasbestle
Labels
type: enhancement ✨ Suggests an enhancement; improves Kirby
Milestone
3.6.5

Comments

@nilshoerrmann
Copy link
Contributor

nilshoerrmann commented Sep 2, 2020 •
edited

When using Kirby's database classes – Database and Query– it's not possible to query a SQLite view because of the internal table validation. It would be nice if Kirby supported views as well.

https://sqlite.org/lang_createview.html
@lukasbestle lukasbestle self-assigned this Sep 2, 2020
@lukasbestle lukasbestle added this to the 3.5.0 milestone Sep 2, 2020
@lukasbestle lukasbestle added the type: bug 🐛 Is a bug; fixes a bug label Sep 2, 2020
@distantnative distantnative modified the milestones: 3.5.0, 3.6.0 Oct 3, 2020
@distantnative distantnative modified the milestones: 3.6.0, 3.7.0 May 31, 2021
@afbora afbora added type: enhancement ✨ Suggests an enhancement; improves Kirby and removed type: bug 🐛 Is a bug; fixes a bug labels Apr 5, 2022
afbora added a commit that referenced this issue Apr 5, 2022
@afbora
Support sqlite views #2799
8b2d05e
@afbora afbora mentioned this issue Apr 5, 2022
Merged
5 tasks
@afbora afbora linked a pull request Apr 5, 2022 that will close this issue
Support SQLite views #4253
Merged
5 tasks
@bastianallgeier
Copy link
Member

✅

@afbora afbora modified the milestones: 3.7.0, 3.6.5 Apr 6, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@lukasbestle lukasbestle

Labels
type: enhancement ✨ Suggests an enhancement; improves Kirby
Projects
None yet
Milestone
3.6.5
Development

Successfully merging a pull request may close this issue.

Support SQLite views getkirby/kirby
5 participants
@bastianallgeier @nilshoerrmann @lukasbestle @afbora @distantnative