Tools to clean up Mongodb database and delete archived cards / list / boards (after few months)
Need to have below Python module : pymongo
pip install pymongo
You need to have authentification setup on Mongo database and port opened (if docker) and create user :
use admin
db.createUser({user: "admin",pwd: "admin123",roles: [ "readWrite"]})
WekanCleanUp will manage below actions :
- Set in lowecase email of users in database (alert if duplicated email)
- Delete archived boards older that day_to_keep_board_arch
- Delete live boards (with no cards into) older than day_to_keep_board_nocard
- Removing from boards deleting users (if user deleted from database...)
- Delete archived lists older that day_to_keep_list_arch
- Delete archived cards older that day_to_keep_card_arch
- Delete all the orphans objects at the end (lists,cards,checklists,cards_comments,attachements,files,chunks,activities)
You need to update parameters before executing it
# Parameters
day_to_keep_board_arch = 30
day_to_keep_list_arch = 30
day_to_keep_card_arch = 60
day_to_keep_board_nocard = 15
mongo_user = 'admin'
mongo_password = 'admin123'
mongo_server = 'localhost'
mongo_port = '27017'