Advertisement
tatu611088

mukodo csv generator intranet idopontfoglalo

Oct 21st, 2019
118
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.42 KB | None | 0 0
  1. import csv
  2. from datetime import datetime, timedelta
  3.  
  4. year = int(input('Írd be az évet: '))
  5. month = int(input('írd be a hónapot: '))
  6. day = int(input('Írd be a napot: '))
  7. het = int(input('Írd be hány hetet generáljak le: '))
  8. nap = str(input('Írd be melyik napra generáljam (sz/p): '))
  9.  
  10. filename = year,month,day,het,nap
  11. filename = str(filename)
  12. date1 = datetime(year, month, day)
  13. idopont_pentek = ['09:00:00', '09:15:00', '09:30:00', '09:45:00', '10:00:00', '10:15:00', '10:45:00', '11:00:00', '11:15:00', '11:30:00']
  14. idopont_szerda = ['12:00:00', '12:15:00', '12:30:00', '12:45:00', '13:00:00', '13:15:00', '13:45:00', '14:00:00', '14:15:00', '14:30:00']
  15. day = []
  16. #print(day)
  17. if nap == 'sz':
  18. day = idopont_szerda
  19. elif nap == 'p':
  20. day = idopont_pentek
  21. else:
  22. print ('rossz betűt ütöttél le')
  23. exit(0)
  24. body= '1'
  25.  
  26. date2 = date1
  27. date2 =str(date2)
  28.  
  29. print (day)
  30.  
  31.  
  32.  
  33. with open(filename+'.csv', mode='w') as csv_file:
  34. fieldnames = ['body','idopont']
  35. #writer = csv.DictWriter(csv_file, fieldnames=fieldnames)
  36. writer = csv.DictWriter(csv_file, delimiter =',', fieldnames=fieldnames)
  37. writer.writeheader()
  38. #writer.writerows()
  39.  
  40. for i in range(het):
  41. for i in range(len(day)):
  42.  
  43. writer.writerow({'body': body, 'idopont': date1.strftime("%Y") + "-" + date1.strftime("%m") + "-" + date1.strftime("%d") + ' ' + day[i]})
  44.  
  45. date1 = date1 + timedelta(7)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement