sign_data_job.py 1.1 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344
  1. #!/usr/bin/env python3
  2. # -*- coding: utf-8 -*-
  3. from models.base import *
  4. from config import settings
  5. from utils import *
  6. from database import get_local_db, get_share_db
  7. from sqlalchemy import text
  8. from sqlalchemy.sql import func
  9. from sqlalchemy.orm import Session
  10. from extensions import logger
  11. import traceback
  12. import base64
  13. from datetime import datetime
  14. from common.enc import sys_user_data
  15. from utils.redis_util import *
  16. # 对数据进行加密处理
  17. def sign_data_proc():
  18. lock_key = "sign_data_proc"
  19. if redis_lock(lock_key):
  20. logger.info(datetime.now())
  21. # 系统用户表
  22. sign_tbl_user()
  23. # sign_tbl_role()
  24. # sign_tbl_menu()
  25. # sign_tbl_role_menu()
  26. # sign_tbl_user_role()
  27. with get_share_db() as db:
  28. logger.info('sharedb ok!!!!!!!!!1')
  29. c1 = db.query(ChemicalCompany).count()
  30. print('c1: ', c1)
  31. redis_unlock(lock_key)
  32. def sign_tbl_user():
  33. print('sign_tbl_user =====>>>')
  34. with get_local_db() as db:
  35. rows = db.query(SysUser).filter(SysUser.sign == '').all()
  36. for row in rows:
  37. sys_user_data.sign_row(db, row)