EquipmentInfoService.py 4.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899
  1. # -*- encoding: utf-8 -*-
  2. """
  3. @File : EquipmentInfoService.py
  4. @Time : 2022/4/14 17:28
  5. @Author : stephen
  6. @Email : zhangdongming@asj6.wecom.work
  7. @Software: PyCharm
  8. """
  9. import logging
  10. import random
  11. from django.db import transaction
  12. from Model.models import EquipmentInfoMonday, EquipmentInfoTuesday, EquipmentInfoWednesday, EquipmentInfoThursday, \
  13. EquipmentInfoFriday, EquipmentInfoSaturday, EquipmentInfoSunday, EquipmentInfo1, EquipmentInfo2, EquipmentInfo3, \
  14. EquipmentInfo4, EquipmentInfo5, EquipmentInfo6, EquipmentInfo7, EquipmentInfo8, EquipmentInfo9, EquipmentInfo10, \
  15. EquipmentInfo11, EquipmentInfo12, EquipmentInfo13, EquipmentInfo14, EquipmentInfo15, EquipmentInfo16, \
  16. EquipmentInfo17, EquipmentInfo18, EquipmentInfo19, EquipmentInfo20
  17. from Object.utils import LocalDateTimeUtil
  18. class EquipmentInfoService:
  19. @staticmethod
  20. def get_equipment_info_obj(dt, **kwargs):
  21. """
  22. 根据日期判断是星期几,返回相应的对象实例
  23. @param dt: 日期 例:2022-03-03
  24. @param kwargs: 设备信息属性值
  25. @return: 星期一至星期天equipment_info对象实例
  26. """
  27. logger = logging.getLogger('info')
  28. week = LocalDateTimeUtil.date_to_week(dt)
  29. equipment_info = None
  30. if week == 1:
  31. equipment_info = EquipmentInfoMonday(**kwargs)
  32. elif week == 2:
  33. equipment_info = EquipmentInfoTuesday(**kwargs)
  34. elif week == 3:
  35. equipment_info = EquipmentInfoWednesday(**kwargs)
  36. elif week == 4:
  37. equipment_info = EquipmentInfoThursday(**kwargs)
  38. elif week == 5:
  39. equipment_info = EquipmentInfoFriday(**kwargs)
  40. elif week == 6:
  41. equipment_info = EquipmentInfoSaturday(**kwargs)
  42. elif week == 7:
  43. equipment_info = EquipmentInfoSunday(**kwargs)
  44. logger.info(type(equipment_info))
  45. logger.info('model数据为:'.format(equipment_info))
  46. return equipment_info
  47. @staticmethod
  48. def equipment_info_bulk_create(week_val, equipment_info_list):
  49. """
  50. 根据week_val判断,进行表对象选择存储
  51. @param week_val: 星期一至星期天,int类型
  52. @param equipment_info_list: 设备信息实例列表
  53. @return: True or False
  54. """
  55. try:
  56. with transaction.atomic():
  57. if equipment_info_list and len(equipment_info_list) > 0:
  58. if week_val == 0:
  59. return False
  60. if week_val == 1:
  61. EquipmentInfoMonday.objects.bulk_create(equipment_info_list)
  62. elif week_val == 2:
  63. EquipmentInfoTuesday.objects.bulk_create(equipment_info_list)
  64. elif week_val == 3:
  65. EquipmentInfoWednesday.objects.bulk_create(equipment_info_list)
  66. elif week_val == 4:
  67. EquipmentInfoThursday.objects.bulk_create(equipment_info_list)
  68. elif week_val == 5:
  69. EquipmentInfoFriday.objects.bulk_create(equipment_info_list)
  70. elif week_val == 6:
  71. EquipmentInfoSaturday.objects.bulk_create(equipment_info_list)
  72. elif week_val == 7:
  73. EquipmentInfoSunday.objects.bulk_create(equipment_info_list)
  74. return True
  75. return False
  76. except Exception as e:
  77. er_log = logging.getLogger('django')
  78. er_log.exception(repr(e))
  79. er_log.error(repr(e))
  80. return False
  81. @staticmethod
  82. def randoms_insert_equipment_info(**kwargs):
  83. """
  84. 随机一个推送数据表存储数据
  85. """
  86. equipment_info_list = [
  87. EquipmentInfo1(), EquipmentInfo2(), EquipmentInfo3(), EquipmentInfo4(), EquipmentInfo5(),
  88. EquipmentInfo6(), EquipmentInfo7(), EquipmentInfo8(),EquipmentInfo9(), EquipmentInfo10(),
  89. EquipmentInfo11(), EquipmentInfo12(), EquipmentInfo13(), EquipmentInfo14(),EquipmentInfo15(),
  90. EquipmentInfo16(), EquipmentInfo17(), EquipmentInfo18(),EquipmentInfo19(), EquipmentInfo20()]
  91. random_model = random.choice(equipment_info_list)
  92. random_model(**kwargs).save()