 
 insert into jobsample values (4, 1, 3, now(), 1);
 
-update state set status = "MADE" where name like '%Create Library%' and status != 'FINAL';
+update state set status = "COMPLETED" where name like '%Create Library%' and status != 'FINALIZED';
 
 
 -- BREAK POINT --
 
 -- --
 -- rereceive library?
-update state set status = "RECEIVED" where name like '%Receiv%' and status != 'FINAL';
+update state set status = "COMPLETED" where name like '%Receiv%' and status != 'FINALIZED';
 
 -- --
 -- simulates flowcell creation

(16, 2);

 -- assign both on library side and flowcell side
update state set status = "ASSIGNED" where name like '%Assign Library%' and status != 'FINAL';


-- BREAK POINT --


-- --
-- simulate pi/da/boneshaker approval
update state set status = "COMPLETED" where name like '%Appr%';


-- --
-- simulate quote job
update state set status = "COMPLETED" where name like '%Quote%';

-- --
-- simulate sample received  (should set isreceived flag and play w/ that
update state set status = "COMPLETED" where name like '%Receiv%' and status != 'FINALIZED';


-- BREAK POINT --
