-- Fetch all the Projects belonging to the Gitlab
-- account of a particular user.
SELECT *
FROM fiber.gitlab_project
WHERE account_id = '{user.gitlab_id}'
-- Fetch all the Projects belonging to the Gitlab
-- account of a particular user.
SELECT *
FROM fiber.gitlab_project
WHERE account_id = '{user.gitlab_id}'
Code
CREATE TABLE fiber.gitlab_project (
id TEXT NOT NULL,
created_at TIMESTAMP WITH TIME ZONE,
updated_at TIMESTAMP WITH TIME ZONE,
account_id TEXT,
description TEXT,
name TEXT,
name_with_namespace TEXT,
path TEXT,
path_with_namespace TEXT,
default_branch TEXT,
tag_list TEXT[],
topics TEXT[],
ssh_url_to_repo TEXT,
http_url_to_repo TEXT,
web_url TEXT,
avatar_url TEXT,
star_count INT,
last_activity_at TIMESTAMP WITH TIME ZONE,
namespace JSONB
)
CREATE TABLE fiber.gitlab_project (
id TEXT NOT NULL,
created_at TIMESTAMP WITH TIME ZONE,
updated_at TIMESTAMP WITH TIME ZONE,
account_id TEXT,
description TEXT,
name TEXT,
name_with_namespace TEXT,
path TEXT,
path_with_namespace TEXT,
default_branch TEXT,
tag_list TEXT[],
topics TEXT[],
ssh_url_to_repo TEXT,
http_url_to_repo TEXT,
web_url TEXT,
avatar_url TEXT,
star_count INT,
last_activity_at TIMESTAMP WITH TIME ZONE,
namespace JSONB
)
Model definition
