case statement within insert

Поиск
Список
Период
Сортировка
От tango ward
Тема case statement within insert
Дата
Msg-id CAA6wQLJ7Ygy66GnB_Akc+GDcm6LbHt3XD9zX92Y7PiBRXZ=12A@mail.gmail.com
обсуждение исходный текст
Ответы Re: case statement within insert  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: case statement within insert  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: case statement within insert  (Francisco Olarte <folarte@peoplecall.com>)
Re: case statement within insert  ("Peter J. Holzer" <hjp-pgsql@hjp.at>)
Список pgsql-general


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?






В списке pgsql-general по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: Streaming Replication between PostGreSQL 9.2.2 on Red Hat andPostGreSQL 9.2.24 on Debian
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: case statement within insert