-- Fetch all the Collaborators belonging to the
-- Github account of a particular user.
SELECT *
FROM fiber.github_collaborator
WHERE account_id = '{user.github_id}'
-- Fetch all the Collaborators belonging to the
-- Github account of a particular user.
SELECT *
FROM fiber.github_collaborator
WHERE account_id = '{user.github_id}'
Code
CREATE TABLE fiber.github_collaborator (
id TEXT NOT NULL,
created_at TIMESTAMP WITH TIME ZONE,
updated_at TIMESTAMP WITH TIME ZONE,
account_id TEXT,
repository TEXT,
login TEXT,
node_id TEXT,
avatar_url TEXT,
gravatar_id TEXT,
url TEXT,
html_url TEXT,
followers_url TEXT,
following_url TEXT,
gists_url TEXT,
starred_url TEXT,
subscriptions_url TEXT,
organizations_url TEXT,
repos_url TEXT,
events_url TEXT,
received_events_url TEXT,
type TEXT,
site_admin BOOLEAN,
role_name TEXT,
permissions JSONB
)
CREATE TABLE fiber.github_collaborator (
id TEXT NOT NULL,
created_at TIMESTAMP WITH TIME ZONE,
updated_at TIMESTAMP WITH TIME ZONE,
account_id TEXT,
repository TEXT,
login TEXT,
node_id TEXT,
avatar_url TEXT,
gravatar_id TEXT,
url TEXT,
html_url TEXT,
followers_url TEXT,
following_url TEXT,
gists_url TEXT,
starred_url TEXT,
subscriptions_url TEXT,
organizations_url TEXT,
repos_url TEXT,
events_url TEXT,
received_events_url TEXT,
type TEXT,
site_admin BOOLEAN,
role_name TEXT,
permissions JSONB
)
Model definition