import base64
import requests
import json
import os
from os import path
import shutil
import glob
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)



with db.cursor() as cursor:
    sql = "SELECT `resume_json` FROM resumes where id = 178 limit 1"
    cursor.execute(sql)
    files = cursor.fetchall()
    for doc in files:
        #print(doc['resume_json'])
        
        data = doc['resume_json']
        
        #json_data = json.dumps(data)
        json_data = json.loads(data)
        
        
        
        #loader = json.loads(json_data)
        
        #print(json_data['ResumeParserData']['TemplateOutput']['TemplateOutputData'])
            
        #files_dict = json.loads(str(data.encode('unicode_escape'), 'utf-8'))
        with open(json_data['ResumeParserData']['TemplateOutput']['TemplateOutputFileName'], 'wb') as file:
            bytes = base64.b64encode(json_data['ResumeParserData']['TemplateOutput']['TemplateOutputData'].encode(encoding='UTF-8'))
            file.write(bytes)