Flaschengeist/flaschengeist
Flaschengeist
/
flaschengeist
9
0
Fork 0
Code Issues 20 Pull Requests Packages Projects Releases 2 Wiki Activity

feature/migrations, closes #19 #20

Merged
crimsen merged 28 commits from feature/migrations into develop 2023-03-02 05:37:11 +00:00
Conversation 1 Commits 28 Files Changed 51 +1640 -710
ferfissimo commented 2021-12-20 01:19:43 +00:00
Owner
Copy Link

This is work in progress!

Adding migrations is important, #19, as this allows users to update the database without manual interaction.

TODO:
Some more work is needed, as currently removing / disabling a plugin might break migrations -> can not identifiy which version is the current migration.

Planned workflow:
Every DB change on develop -> new migration file
stable release on main -> merge migrations into one file (cleanup)

So every user on stable can upgrade and downgrade its db and same on develop, but we do not need to provide X migration files for every development step.
So we can clean up at every stable relase, dropping stable migrations is not needed I think, but can be done with some delay.

This is **work in progress!** Adding migrations is important, #19, as this allows users to update the database without manual interaction. TODO: Some more work is needed, as currently removing / disabling a plugin might break migrations -> can not identifiy which version is the current migration. Planned workflow: Every DB change on develop -> new migration file stable release on main -> merge migrations into one file (cleanup) So every user on stable can upgrade and downgrade its db and same on develop, but we do not need to provide X migration files for every development step. So we can clean up at every stable relase, dropping stable migrations is not needed I think, but can be done with some delay.
ferfissimo added the
💡 enhancement
🎒 backend
 labels 2021-12-20 01:19:43 +00:00
ferfissimo added 6 commits 2021-12-20 01:19:44 +00:00
b03df823d7 feat(db): Add database migration support, implements #19 
Migrations allow us to keep track of database changes and upgrading databases if needed.
continuous-integration/woodpecker the build failed Details
88718676f8 feat(docs): Add documentation on how to install tables
ferfissimo added 1 commit 2021-12-21 21:53:46 +00:00
continuous-integration/woodpecker the build failed Details
2b6472b655 docs(migrations): Some documentation ++
ferfissimo force-pushed feature/migrations from 2b6472b655 to 1201505586 2021-12-21 23:57:12 +00:00 Compare
ferfissimo added 2 commits 2021-12-23 01:46:04 +00:00
ferfissimo added 1 commit 2021-12-23 01:49:25 +00:00
continuous-integration/woodpecker the build failed Details
75c530cecb feat(cli): Added CLI command for handling plugins 
* Install / Uninstall plugins
* List plugins
ferfissimo force-pushed feature/migrations from 75c530cecb to 8e18a11fc8 2021-12-23 01:50:14 +00:00 Compare
ferfissimo added 2 commits 2021-12-23 02:07:45 +00:00
continuous-integration/woodpecker the build failed Details
5ff906086b fix(app): Skip plugins with not satisfied dependencies.
ferfissimo force-pushed feature/migrations from 5ff906086b to 2fcc7ffc5b 2022-02-22 22:42:55 +00:00 Compare
ferfissimo force-pushed feature/migrations from 2fcc7ffc5b to b9ff049705 2022-02-22 22:46:18 +00:00 Compare
ferfissimo force-pushed feature/migrations from b9ff049705 to 44a7abab82 2022-02-22 22:48:24 +00:00 Compare
ferfissimo force-pushed feature/migrations from 44a7abab82 to aeb4c39a12 2022-02-22 23:05:22 +00:00 Compare
ferfissimo commented 2022-02-22 23:05:48 +00:00
Author
Owner
Copy Link

Now based on #24

Now based on #24
ferfissimo added 1 commit 2022-02-23 14:12:51 +00:00
ci/woodpecker/push/lint Pipeline was successful Details
ci/woodpecker/push/test Pipeline was successful Details
ci/woodpecker/pr/lint Pipeline was successful Details
ci/woodpecker/pr/test Pipeline was successful Details
0b5b73edc3 fix(migrations): Fix rebase issues
ferfissimo force-pushed feature/migrations from 0b5b73edc3 to 507eb8d711 2022-02-23 14:24:31 +00:00 Compare
ferfissimo force-pushed feature/migrations from 507eb8d711 to 8fbdac365f 2022-02-23 14:37:16 +00:00 Compare
ferfissimo force-pushed feature/migrations from 8fbdac365f to 5038582406 2022-02-23 14:40:39 +00:00 Compare
ferfissimo force-pushed feature/migrations from 5038582406 to 1ac164b860 2022-03-07 13:36:52 +00:00 Compare
ferfissimo force-pushed feature/migrations from 1ac164b860 to 573bea2da0 2022-03-08 16:23:04 +00:00 Compare
ferfissimo added 3 commits 2022-07-31 13:49:13 +00:00
3d6b37f0a5 [plugins] Add missing IDs and fix initial migration file 
Signed-off-by: Ferdinand Thiessen <rpm@fthiessen.de>
6c73a63eb5 [cli] Make sure plugin permissions are installed 
Signed-off-by: Ferdinand Thiessen <rpm@fthiessen.de>
74ceb1b1f3 [cli] Added install command to install the database and all plugins 
Signed-off-by: Ferdinand Thiessen <rpm@fthiessen.de>
ferfissimo force-pushed feature/migrations from 74ceb1b1f3 to e9fbce0da7 2022-07-31 14:33:59 +00:00 Compare
ferfissimo force-pushed feature/migrations from e9fbce0da7 to 2880076705 2022-07-31 17:07:44 +00:00 Compare
ferfissimo force-pushed feature/migrations from 2880076705 to a289664f10 2022-08-18 17:59:38 +00:00 Compare
ferfissimo force-pushed feature/migrations from a289664f10 to 74ca9b247d 2022-08-18 18:01:38 +00:00 Compare
ferfissimo force-pushed feature/migrations from 74ca9b247d to ee38e46c12 2022-08-18 21:00:35 +00:00 Compare
ferfissimo added 2 commits 2022-08-25 10:07:39 +00:00
e22e38b304 Implement custom UA parsing, allowing to update Flask and Werkzeug 
Signed-off-by: Ferdinand Thiessen <rpm@fthiessen.de>
4248825af0 Revert future imports for annotations, PEP563 is still defered 
Signed-off-by: Ferdinand Thiessen <rpm@fthiessen.de>
ferfissimo added 7 commits 2022-08-25 16:45:45 +00:00
973b4527df [core] UA parsing: Add backwards compatibility for platform names 
Signed-off-by: Ferdinand Thiessen <rpm@fthiessen.de>
e2254b71b0 [core][plugin] Unify plugin model and real plugins 
Plugins are now extensions of the database model,
allowing plugins to access all their properties.

Signed-off-by: Ferdinand Thiessen <rpm@fthiessen.de>
6ad8cd1728 [cli] Users and roles can be now managed using the cli 
Signed-off-by: Ferdinand Thiessen <rpm@fthiessen.de>
aa8f8f6e64 [core][plugin] Allow blueprints to be set on instance level 
This ensures blueprints are read from the plugin instance
instead of the class, allowing custom routes to be added within the
`load()` function.

Signed-off-by: Ferdinand Thiessen <rpm@fthiessen.de>
0698327ef5 [core][deps] Use sqlalchemy_utils instead of copy-paste code for merging references 
This fixes issues when using SQLite

Signed-off-by: Ferdinand Thiessen <rpm@fthiessen.de>
88a4dc24f2 [db] Fix automatic migration upgrade for plugins and core 
Signed-off-by: Ferdinand Thiessen <rpm@fthiessen.de>
9e8117e554 [plugins] Fix scheduler accessing database while unbound from session 
Signed-off-by: Ferdinand Thiessen <rpm@fthiessen.de>
ferfissimo added 1 commit 2022-08-26 15:05:36 +00:00
9f729bda6c [plugins] Fix `auth_ldap`, `balance`, and `pricelist` compatibility 
Signed-off-by: Ferdinand Thiessen <rpm@fthiessen.de>
crimsen added 2 commits 2023-02-17 14:30:22 +00:00
crimsen added 1 commit 2023-02-17 15:41:06 +00:00
crimsen added 1 commit 2023-02-17 16:52:25 +00:00
crimsen added 1 commit 2023-02-17 19:40:34 +00:00
crimsen added 1 commit 2023-02-18 14:11:47 +00:00
crimsen added 1 commit 2023-02-18 14:48:59 +00:00
crimsen changed title from WIP: feature/migrations, closes #19 to feature/migrations, closes #19 2023-03-02 05:36:10 +00:00
crimsen merged commit cfbb557539 into develop 2023-03-02 05:37:11 +00:00
Sign in to join this conversation.
Reviewers
No reviewers
Labels
Clear labels   
🛃 types

Issue with @flaschengeist/types

  
👪 users

Issue with @flaschengeist/users

  
invalid

Something is wrong

  
wontfix

This won't be fixed

  
🚀 announcement

news from the project

  
🎒 backend

issue related to backend

  
🐞 bug

Something is not working

  
🐋 docker

issue with the docker files

  
💡 enhancement

New feature

  
📺 frontend

issue related to frontend

  
🤔 question

More information is needed

  
🔗duplicate

This issue or pull request already exists

No Label
🛃 types
👪 users
invalid
wontfix
🚀 announcement
🎒 backend
🐞 bug
🐋 docker
💡 enhancement
📺 frontend
🤔 question
🔗duplicate
Milestone
Clear milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
No Assignees
2 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Depends on
#24 feat(plugins): Load metadata from entry points / distribution
Flaschengeist/flaschengeist
Reference: Flaschengeist/flaschengeist#20
No description provided.
Delete Branch "feature/migrations"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?