profile_cleaner.py 931 B

1234567891011121314151617181920212223242526
  1. #! /usr/bin/env python
  2. # -*- coding: utf-8 -*-
  3. # vim:fenc=utf-8
  4. """
  5. 用户画像信息提取在不断迭代中,可能需清除旧的用户画像信息避免干扰,故提供此工具
  6. """
  7. import sys
  8. import os
  9. sys.path.append(os.curdir)
  10. import configs
  11. from user_manager import MySQLUserManager
  12. if __name__ == '__main__':
  13. config = configs.get()
  14. user_db_config = config['storage']['user']
  15. staff_db_config = config['storage']['staff']
  16. user_manager = MySQLUserManager(user_db_config['mysql'], user_db_config['table'], staff_db_config['table'])
  17. user_ids_to_clean = ['7881299986081786', '7881303544096524', '7881300732152777', '7881301752098239', '7881299457990953', '7881302872936170',]
  18. for user_id in user_ids_to_clean:
  19. profile = user_manager.get_user_profile(user_id)
  20. profile['name'] = ''
  21. profile['preferred_nickname'] = ''
  22. user_manager.save_user_profile(user_id, profile)