update medicines.sql

drop table if exists medicines_import;

CREATE TABLE medicines_import (
	country text NOT NULL,
	code text NOT NULL,
	name text NOT NULL,
	quantity int4 NOT NULL,
	unit text NOT NULL,
	CONSTRAINT medicines_pkey PRIMARY KEY (code, country)
);

copy medicines_import (country, code, name, quantity, unit) from '/Users/sergi.martinez/dev/newmeds.csv' DELIMITER ',' csv header; 

insert into medicines(country, code, name, quantity, unit)
(select country, code, name, quantity, unit from medicines_import)
ON CONFLICT (country, code) DO UPDATE  
SET  name = excluded.name, quantity = excluded.quantity, unit = excluded.unit;  

select * from medicines m order by code;