-- Fetch all the Boards belonging to the Pinterest
-- account of a particular user.
SELECT *
FROM fiber.pinterest_board
WHERE account_id = '{user.pinterest_id}'
-- Fetch all the Boards belonging to the Pinterest
-- account of a particular user.
SELECT *
FROM fiber.pinterest_board
WHERE account_id = '{user.pinterest_id}'
Code
CREATE TABLE fiber.pinterest_board (
id TEXT NOT NULL,
created_at TIMESTAMP WITH TIME ZONE,
updated_at TIMESTAMP WITH TIME ZONE,
account_id TEXT,
board_pins_modified_at TEXT,
name TEXT,
description TEXT,
collaborator_count INT,
pin_count INT,
follower_count INT,
media JSONB,
owner JSONB,
privacy TEXT
)
CREATE TABLE fiber.pinterest_board (
id TEXT NOT NULL,
created_at TIMESTAMP WITH TIME ZONE,
updated_at TIMESTAMP WITH TIME ZONE,
account_id TEXT,
board_pins_modified_at TEXT,
name TEXT,
description TEXT,
collaborator_count INT,
pin_count INT,
follower_count INT,
media JSONB,
owner JSONB,
privacy TEXT
)
Model definition