qingli_04月数据.py 684 B

123456789101112131415161718192021
  1. wind_farms = {
  2. "WOF35900004": "平陆风电场",
  3. "WOF35100072": "阳曲风电场",
  4. "WOF35100073": "古交风电场",
  5. "WOF35200074": "马家梁风电场",
  6. "WOF35400075": "太谷风电场",
  7. "WOF35900076": "坡底风电场",
  8. "WOF35300077": "西潘风电场",
  9. "WOF35900078": "芮城风电场",
  10. "WOF34900079": "右玉风光互补电站",
  11. "WOF35800080": "贺家沟",
  12. "WOF35800081": "石楼风电场",
  13. "WOF35800082": "盂县风光互补电站"
  14. }
  15. types = ['warn', 'fault', 'minute', 'second']
  16. for code, name in wind_farms.items():
  17. for type in types:
  18. sql = f'alter table {code}_{type} TRUNCATE PARTITION p202504'
  19. print(sql)