bzion
bzion copied to clipboard
[WIP] Move to new QueryBuilder
~~Shame on me for deciding to sneak in such a huge change to BZiON's core in a planned point release... 😅 BUT Deeeeeeeeploy Jenkins!~~
This PR has been reassigned to a 0.11.0 release
This PR is dedicated to the restructuring of model statuses in the database and introducing a new query builder, powered by Pixie.
- In order to allow for both query builders to coexist, the Pixie powered version has been dubbed
QueryBuilderFlex
.- This class name is subject to change.
- The practice of using
status
columns for models has been deprecated.- Due to SET columns in MySQL being a bad idea, models will be making use of boolean columns for model states (e.g.
is_deleted
,is_draft
,is_public
). By making this switch, it'll also allow us to support more databases in the future since theSET
column type is not part of the SQL standard.
- Due to SET columns in MySQL being a bad idea, models will be making use of boolean columns for model states (e.g.
Progress
Model migration to new QueryBuilder and new status convention.
- [ ] ApiKey
- [x] Ban
- [ ] Conversation
- [ ] ConversationEvent
- [x] Country
- [x] Invitation
- [x] Map
- [ ] Match
- [ ] Message
- [x] News
- [x] NewsCategory
- [ ] Notification
- [x] Page
- [x] Permission
- [x] Player
- [ ] Role
- [x] Server
- [x] Team
- [x] Visit
Closes #163