Postgresql how to convert insert value as parameters

Question

I have a insert sql:

cur.execute(f"""INSERT INTO patients_patient (patient_id, patient_name) VALUES
                      (1,'Jane'),(2,'John')""")

I tired use parameters in query and pass the values separately:

cur.execute(f"""INSERT INTO patients_patient (patient_id, patient_name) VALUES
                      (%s,%s),(%s,%s)""",(1,'Jane'),(2,'John'))

Error:

cur.execute(f"""INSERT INTO patients_patient (patient_id, patient_name) VALUES
TypeError: function takes at most 2 arguments (3 given)

any friend can help?

Tim Biegeleisen · Accepted Answer · 2021-11-13 07:31:32Z

2

Try using executemany() here:

sql = 'INSERT INTO patients_patient (patient_id, patient_name) VALUES (?, ?)'
values = [(1, 'Jane'), (2, 'John')]
cur.executemany(sql, values)

If you don't know a priori how many tuples to expect in the VALUES clause, then you may build it dynamically:

sql = 'INSERT INTO patients_patient (patient_id, patient_name) VALUES '
values = [(1, 'Jane'), (2, 'John')]
sql += '(%s' + ',%s'*(len(values)-1) + ')'
cur.executemany(sql, values)

edited Nov 13, 2021 at 7:31

answered Nov 13, 2021 at 7:26

Tim Biegeleisen

526k32 gold badges324 silver badges399 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

William Over a year ago

Hi Tim,thanks,I have another one: cur.execute(f"""INSERT INTO patients_event_type (type_name) VALUES ('HR'),('RR')""") it not works,can you help me?

Tim Biegeleisen Over a year ago

Well for starters why are you using execute() instead of executeMany() ?

William Over a year ago

The sql I post here works,but I copyed your last code ,it not work for this one.I want to change this one is because I want to use parameters.

William Over a year ago

Hi friend also help with this related one ? stackoverflow.com/questions/69952301/…

Collectives™ on Stack Overflow

Postgresql how to convert insert value as parameters

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related