Re: case statement within insert

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