import requests
import json
import datetime

import pymysql.cursors
import pymysql
import uuid

db = pymysql.connect (host="cldy-hub-db-prod-do-user-1524670-0.a.db.ondigitalocean.com",
                     user="doadmin",
                     passwd="jmbly6e4obtma5z0",
                     db="defaultdb",
                     port=25060,
                     charset='utf8mb4',
                     cursorclass=pymysql.cursors.DictCursor)

DWSrenderURL = 'https://us.dws3.docmosis.com/api/render'

accessKey='ZmIyNTgxY2YtODU4Ny00YjQwLWI3MjgtNGEzMDQ1MDYxNTFjOjczMTQ1MTg'

with db.cursor() as cursor:
    sql = "select j.uuid, j.id, j.city, j.state_province, j.country, j.company, j.title, j.summary, j.type, j.preferred_employment, j.duration, j.experience_level, j.recruiter_id, j.sourcer_id, s.name sourcer_name, s.email sourcer_email from jobs j left join users s on j.sourcer_id = s.id where j.tenant_id = 6 and j.id = 9485 limit 1;"
    #sql = "select uuid, title from jobs limit 1;"
    cursor.execute(sql)
    records = cursor.fetchall()
    for record in records:
      dataStr = '{"uuid":"' + record['uuid'] + '", "title":"' + record['title'] + '"}'
      
      print (record)
      payload = '{"accessKey": "' + accessKey + '", "templateName":"jobs/template.docx", "outputName":"job_ad.pdf", "data":' + str(record) + '}'
      
      print(payload)

      headers = {'content-type': 'application/json'}
      r = requests.post(DWSrenderURL, data=payload, headers = headers)
      if r.status_code == requests.codes.ok:
        filename = record['uuid'] + "." + ".pdf"
        with open(filename, 'wb') as fd:
          for chunk in r.iter_content(4096):
            fd.write(chunk)            
          print("Saved to ", filename);
      else:
        print("Failed");