CREATE TABLE api.livewires(
  livewire text NOT NULL,
  wireident uuid NOT NULL UNIQUE DEFAULT gen_random_uuid(),
  owner text NOT NULL REFERENCES authentic.users (email),
  company text NOT NULL GENERATED ALWAYS AS (split_part(owner, '@', 2)) STORED,
  description text,
  created_at timestamptz NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
  isready boolean NOT NULL DEFAULT False,
  ispublic boolean NOT NULL DEFAULT False,
  g geometry(Polygon, 4326) NOT NULL DEFAULT st_buffer(st_makepoint(0, 0), 4),
  CONSTRAINT livewire_name CHECK (char_length(livewire) > 5),
  UNIQUE (wireident, owner),
  PRIMARY KEY (livewire, company)
);
COMMENT ON TABLE api.livewires IS 'This table shows the list of livewires';

ALTER TABLE api.livewires ENABLE ROW LEVEL SECURITY;

CREATE POLICY "Owner can see a livewire" ON api.livewires FOR SELECT USING
  (owner = current_setting('request.jwt.claims', true)::json ->> 'email' );

CREATE POLICY "Public livewire can be seen by all" ON api.livewires FOR SELECT USING
  (split_part(current_setting('request.jwt.claims', true)::json ->> 'email', '@', 2) = company
	AND ispublic AND isready);

CREATE POLICY "Only owners can update livewire stuff" ON api.livewires FOR UPDATE USING
  (owner = current_setting('request.jwt.claims', true)::json ->> 'email');

CREATE POLICY "Only owners can delete a livewire" ON api.livewires FOR DELETE USING
  (owner = current_setting('request.jwt.claims', true)::json ->> 'email');

CREATE POLICY "Only owners can insert a livewire" ON api.livewires FOR INSERT WITH CHECK
  (owner = current_setting('request.jwt.claims', true)::json ->> 'email');