import pyodbc
import csv

cnxn = pyodbc.connect("DRIVER={MySQL ODBC 8.0 Unicode Driver}; SERVER=<mysql-server>;DATABASE=<database>; UID=<user>; PASSWORD=<password>;") 
crsr = cnxn.cursor()


# Fail query

crsr.execute('''select distinct `pa11`.`CUSTOMER_ID` `CUSTOMER_ID`,
 CONCAT(`a12`.`CUST_LAST_NAME`, `a12`.`CUST_FIRST_NAME`) `CustCol_12`,
 CONCAT((Case when `pa11`.`WJXBFS1` = ? then ? else ? end), `pa11`.`WJXBFS1`) `WJXBFS1`
from (select `a11`.`CUSTOMER_ID` `CUSTOMER_ID`,
 max(CONCAT(`a11`.`CUST_LAST_NAME`, `a11`.`CUST_FIRST_NAME`)) `WJXBFS1`
 from `lu_customer` `a11`
 group by `a11`.`CUSTOMER_ID`
 ) `pa11`
 join `lu_customer` `a12`
 on (`pa11`.`CUSTOMER_ID` = `a12`.`CUSTOMER_ID`)''', ["丁勤毅","真","假"])




# PASS query

# crsr.execute('''select distinct `pa11`.`CUSTOMER_ID` `CUSTOMER_ID`,
#  CONCAT(`a12`.`CUST_LAST_NAME`, `a12`.`CUST_FIRST_NAME`) `CustCol_12`,
#  CONCAT((Case when `pa11`.`WJXBFS1` = '丁勤毅' then '真' else '假' end), `pa11`.`WJXBFS1`) `WJXBFS1`
# from (select `a11`.`CUSTOMER_ID` `CUSTOMER_ID`,
#  max(CONCAT(`a11`.`CUST_LAST_NAME`, `a11`.`CUST_FIRST_NAME`)) `WJXBFS1`
#  from `lu_customer` `a11`
#  group by `a11`.`CUSTOMER_ID`
#  ) `pa11`
#  join `lu_customer` `a12`
#  on (`pa11`.`CUSTOMER_ID` = `a12`.`CUSTOMER_ID`)''')
 

output = crsr.fetchall()
cnxn.commit()

print(output)