-- Fetch all the Pages belonging to the Confluence
-- account of a particular user.
SELECT *
FROM fiber.confluence_page
WHERE account_id = '{user.confluence_id}'
-- Fetch all the Pages belonging to the Confluence
-- account of a particular user.
SELECT *
FROM fiber.confluence_page
WHERE account_id = '{user.confluence_id}'
Code
CREATE TABLE fiber.confluence_page (
id TEXT NOT NULL,
created_at TIMESTAMP WITH TIME ZONE,
updated_at TIMESTAMP WITH TIME ZONE,
account_id TEXT,
id TEXT,
status TEXT,
title TEXT,
space_id TEXT,
parent_id TEXT,
parent_type TEXT,
position INT,
author_id TEXT,
owner_id TEXT,
last_owner_id TEXT,
created_at TEXT,
version JSONB,
body JSONB,
links JSONB
)
CREATE TABLE fiber.confluence_page (
id TEXT NOT NULL,
created_at TIMESTAMP WITH TIME ZONE,
updated_at TIMESTAMP WITH TIME ZONE,
account_id TEXT,
id TEXT,
status TEXT,
title TEXT,
space_id TEXT,
parent_id TEXT,
parent_type TEXT,
position INT,
author_id TEXT,
owner_id TEXT,
last_owner_id TEXT,
created_at TEXT,
version JSONB,
body JSONB,
links JSONB
)
Model definition