I want to insert data from mysql into a table in postgresql. I want to check when the subjectcode contains PE or NSTP so I can assign True or False to another column in destination DB.
# Source data: # Source data: MySQL curr_msql.execute(''' SELECT code, subjectname FROM test_subj ''') # Destination for row in curr_msql: curr_psql.execute(''' INSERT INTO subs ( created, modified, subjcode, subjname, is_pe_or_nstp) VALUES (current_timestamp, current_timestamp, %s, %s, CASE WHEN code like '%%PE%%' or code like '%%NSTP%%' THEN True ELSE False END) ''', (row['code'], row['subjectname'])) I am getting TypeError: not all arguments converted during string formatting. Any advice pls?