bzion icon indicating copy to clipboard operation
bzion copied to clipboard

[WIP] Move to new QueryBuilder

Open allejo opened this issue 6 years ago • 5 comments

~~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 the SET column type is not part of the SQL standard.

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

allejo avatar Feb 02 '18 07:02 allejo