upsert2.sql

DO $$
DECLARE lastid bigint;
BEGIN
  LOCK TABLE netscanner_host_statistics IN SHARE ROW EXCLUSIVE MODE;

  SELECT id INTO lastid FROM netscanner_host_statistics WHERE  name = 'ya.ru' AND workspace_id = 1;

  IF NOT FOUND THEN
    INSERT INTO netscanner_host_statistics (name, workspace_id, count_of_hosts, created_at, updated_at) VALUES ('ya.ru', 1, 1, now(), now()) RETURNING id INTO lastid;
  ELSE
    UPDATE netscanner_host_statistics SET count_of_hosts = count_of_hosts + 1, updated_at = now() WHERE id = lastid;
  END IF;

  INSERT INTO netscanner_hosts_host_statistics (host_id, host_statistic_id) VALUES (398, lastid);
END $$;