services.py 383 B

1234567891011121314151617
  1. import json
  2. import os
  3. __dir__ = os.path.dirname(__file__)
  4. with open(f"{__dir__}/services.csv", encoding='utf-8') as f:
  5. data = f.readlines()
  6. script = ""
  7. for index, row in enumerate(data):
  8. if index == 0:
  9. continue
  10. parts = row.split(";")
  11. script += f"INSERT INTO services (name, price, code) VALUES ('{parts[1]}', {parts[2]}, {parts[0]});\n"
  12. print(script)