2csv-pjibot_delivery.py 8.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173
  1. # -*- coding: utf-8 -*-
  2. import os
  3. import shutil
  4. import subprocess
  5. import time
  6. import oss2
  7. from resource import bagtocsv_robot
  8. import logging
  9. path1 = '/mnt/disk001/dcl_data_process/src/python2/pjibot_delivery/'
  10. path2 = '/mnt/disk001/pdf_outdoor/run/'
  11. path3 = '/mnt/disk001/dcl_data_process/src/python2/pjibot_delivery/csv/'
  12. logging.basicConfig(filename=path1 + 'log/2csv.log', level=logging.INFO,
  13. format='%(asctime)s - %(levelname)s - %(message)s')
  14. key1 = 'pjibot_delivery/'
  15. sleep_time = 30 # 每多少秒扫描一次
  16. def parse_csv(data_bag, parse_prefix, local_parse_dir, local_delete_list):
  17. try:
  18. bagtocsv_robot.parse(data_bag, local_parse_dir + '/csv/')
  19. bagname = data_bag.split('/')[-1].split('.')[0]
  20. local_csv_dir = os.path.join(local_parse_dir + '/csv/', bagname) # 最终生成四个csv文件的目录
  21. csv_file_name1 = 'trajectory_pji'
  22. local_csv_file_path1 = str(local_csv_dir) + '/' + str(csv_file_name1) + '.csv'
  23. oss_csv_object_key1 = parse_prefix + csv_file_name1 + '.csv'
  24. bucket.put_object_from_file(oss_csv_object_key1, local_csv_file_path1)
  25. csv_file_name2 = 'ego_pji'
  26. local_csv_file_path2 = str(local_csv_dir) + '/' + str(csv_file_name2) + '.csv'
  27. oss_csv_object_key2 = parse_prefix + csv_file_name2 + '.csv'
  28. bucket.put_object_from_file(oss_csv_object_key2, local_csv_file_path2)
  29. csv_file_name3 = 'pos_pji'
  30. local_csv_file_path3 = str(local_csv_dir) + '/' + str(csv_file_name3) + '.csv'
  31. oss_csv_object_key3 = parse_prefix + csv_file_name3 + '.csv'
  32. bucket.put_object_from_file(oss_csv_object_key3, local_csv_file_path3)
  33. csv_file_name4 = 'objects_pji'
  34. local_csv_file_path4 = str(local_csv_dir) + '/' + str(csv_file_name4) + '.csv'
  35. oss_csv_object_key4 = parse_prefix + csv_file_name4 + '.csv'
  36. bucket.put_object_from_file(oss_csv_object_key4, local_csv_file_path4)
  37. # 生成pdf
  38. try:
  39. os.chdir(path2)
  40. # 构造命令
  41. command1 = ['./pji_outdoor_real',
  42. os.path.join(local_csv_dir, ''), # 注意:这里可能不需要末尾的 '/',取决于程序要求
  43. os.path.join(local_csv_dir, ''), # 同上
  44. os.path.join(local_csv_dir, 'trajectory.png'),
  45. bagname]
  46. # 记录调用命令的信息
  47. logging.info("调用生成pdf 报告命令: %s" % ' '.join(command1))
  48. # 使用 subprocess.Popen 执行命令
  49. process = subprocess.Popen(command1, stdout=subprocess.PIPE, stderr=subprocess.PIPE)
  50. stdout, stderr = process.communicate() # 等待命令执行完成
  51. # 检查是否有输出或错误
  52. if stdout:
  53. logging.info("命令的标准输出:")
  54. logging.info(stdout.decode('utf-8')) # Python 2 中需要解码
  55. if stderr:
  56. logging.error("命令的错误输出:")
  57. logging.error(stderr.decode('utf-8')) # Python 2 中需要解码
  58. # 检查命令是否成功执行
  59. if process.returncode == 0:
  60. logging.info("命令执行成功")
  61. else:
  62. logging.error("命令执行失败,退出码: %s" % process.returncode)
  63. except OSError as e:
  64. # 如果更改目录失败或命令不存在等
  65. logging.error("在执行过程中发生错误: %s" % e)
  66. oss_csv_object_key5 = parse_prefix + 'report.pdf'
  67. bucket.put_object_from_file(oss_csv_object_key5, str(local_csv_dir) + '/report.pdf')
  68. logging.info("pdf 报告生成并上传完成。")
  69. # 记得删除
  70. local_delete_list.append(local_csv_file_path1)
  71. local_delete_list.append(local_csv_file_path2)
  72. local_delete_list.append(local_csv_file_path3)
  73. local_delete_list.append(local_csv_file_path4)
  74. local_delete_list.append(str(local_csv_dir) + '/report.pdf')
  75. except Exception as e2:
  76. # 当出现异常时执行的代码
  77. logging.exception("生成csv报错: %s", e2)
  78. # ------- 获取合并之后的bag包,解析出csv -------
  79. if __name__ == '__main__':
  80. # 1 创建阿里云对象
  81. auth = oss2.Auth('n8glvFGS25MrLY7j', 'xZ2Fozoarpfw0z28FUhtg8cu0yDc5d')
  82. endpoint = 'oss-cn-beijing-gqzl-d01-a.ops.gqzl-cloud.com'
  83. bucket = oss2.Bucket(auth, endpoint, 'open-bucket')
  84. while True:
  85. logging.info("开始新一轮扫描:", key1)
  86. try:
  87. local_delete_list = []
  88. oss_delete_list = []
  89. prefix_list = []
  90. # 2 获取已经上传完成的所有目录并分组
  91. for obj1 in oss2.ObjectIterator(bucket, prefix=key1):
  92. if 'data_merge' in str(obj1.key) and str(obj1.key).endswith('.bag'): # data_merge下的bag是等待解析的
  93. # 获取合并后的包
  94. merged_bag_object_key = str(obj1.key)
  95. merged_bag_object_key_split = merged_bag_object_key.split('/')
  96. merged_prefix = '/'.join(merged_bag_object_key_split[:-1]) # data_merge 目录
  97. parse_prefix = merged_prefix.replace('data_merge', 'data_parse')
  98. parse_prefix_full = merged_bag_object_key.replace('data_merge', 'data_parse').replace('.bag',
  99. '/') # data_parse 目录
  100. callback_undone = False
  101. csv1_done = False
  102. csv2_done = False
  103. csv3_done = False
  104. csv4_done = False
  105. pdf_done = False
  106. for obj2 in oss2.ObjectIterator(bucket, prefix=parse_prefix_full): # 判断 data_parse 目录下是否有解析后的文件
  107. if '/callback.json' in str(obj2.key):
  108. callback_undone = True
  109. if '/trajectory_pji.csv' in str(obj2.key):
  110. csv1_done = True
  111. if '/ego_pji.csv' in str(obj2.key):
  112. csv2_done = True
  113. if '/pos_pji.csv' in str(obj2.key):
  114. csv3_done = True
  115. if '/objects_pji.csv' in str(obj2.key):
  116. csv4_done = True
  117. if '/report.pdf' in str(obj2.key):
  118. pdf_done = True
  119. if not callback_undone: # 没有 callback.json
  120. continue
  121. if csv1_done and csv2_done and csv3_done and csv4_done and pdf_done:
  122. continue
  123. logging.info("开始生成场景还原csv: ", str(obj1.key))
  124. local_merged_bag_path = path3 + merged_bag_object_key
  125. local_merged_dir = '/'.join(local_merged_bag_path.split('/')[:-1])
  126. local_parse_dir = local_merged_dir.replace('data_merge', 'data_parse')
  127. if not os.path.exists(local_merged_dir):
  128. os.makedirs(local_merged_dir)
  129. if not os.path.exists(local_parse_dir):
  130. os.makedirs(local_parse_dir)
  131. merged_bag_full_name = merged_bag_object_key_split[-1]
  132. merged_bag_name = merged_bag_full_name.split('.')[0]
  133. try:
  134. bucket.get_object_to_file(merged_bag_object_key, local_merged_bag_path)
  135. except Exception as e:
  136. logging.exception("下载合并后的bag包失败: %s" % str(e))
  137. local_delete_list.append(local_merged_bag_path)
  138. # 2 生成 pos_orig.csv 和 pos_hmi.csv
  139. parse_csv(local_merged_bag_path, parse_prefix_full, local_parse_dir, local_delete_list)
  140. # 删除本地临时文件
  141. if len(local_delete_list) > 0:
  142. for local_delete in local_delete_list:
  143. try:
  144. os.remove(local_delete)
  145. except Exception as e:
  146. logging.exception("捕获到一个异常: %s" % str(e))
  147. except Exception as e:
  148. logging.exception("全局错误处理: %s" % str(e))
  149. time.sleep(sleep_time)