3 Be_ @s$ddlZddlZddlZddZdS)Nc Cs"tjddddddtjjd}d}|j}|j||j}td |jtd xV|D]N}td |d td |dtd|dtd|ddtd|ddqTWt j |d ddddgd}|j dd}|j}|j||j}td |jt j |ddddddgd}|j d|j dS)Nz9cldy-hub-db-dev-do-user-1524670-0.a.db.ondigitalocean.comZappuserZs7xnwc7aeyq9vbzkZ defaultdbiaZutf8mb4)hostuserpasswddbportcharsetZ cursorclasszJselect id, title, details, city, state_province from jobs order by id desczTotal number of rows is: z Printing each recordzId = idztitle = titlez details = detailszcity = Zcity zstate_province = Zstate_province)columnszC/var/www/html/talenthub/backend/ai/resume-to-job-match/jobs_des.csvzselect r.id, r.person_id, p.job_profile as title, r.resume_details, p.city, p.state_province from resumes r, person p where r.person_id = p.id and r.person_id is not null and r.resume_details is not null order by r.id desc resume_id person_idresume_detailszF/var/www/html/talenthub/backend/ai/resume-to-job-match/resumes_des.csv) pymysqlconnectZcursorsZ DictCursorcursorexecutefetchallprintrowcountpd DataFrameto_csvclose)rZsql_select_Queryrrecordsrowj_dfr_dfrQ/var/www/html/talenthub/backend/ai/resume-to-job-match/export_jobs_resumes_csv.pyget_jobs_resumes_csvs<         r!)pandasrZpymysql.cursorsrr!rrrr s