create table jobs_done (
    person text unique,
    num integer default 0
);

insert into jobs_done values("zia", 1);
.print "after first"
select * from jobs_done;
.print


insert into jobs_done values("zia", 1);
.print "after failed"
select * from jobs_done;

insert into jobs_done values("zia", 1)
    on conflict(person) do update set num = num + 1;
.print "\nafter upsert"
select * from jobs_done;
