On 05/25/2018 02:04 AM, tango ward wrote:
>
>
> 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%%'
Shouldn't the above be?:
subjcode like '%%PE%%' or subjcode 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?
>
>
>
>
>
>
--
Adrian Klaver
adrian.klaver@aklaver.com