a-h-abid · April 1, 2026 04:37
diff --git a/readme.md b/readme.md
diff --git a/gitlab-commits.mjs b/gitlab-commits.mjs
 // gitlab-commits.mjs
 // Usage: node gitlab-commits.mjs > commits.csv

 const GITLAB_URL = 'https://your-gitlab.example.com';
 const TOKEN = 'your_personal_access_token';
 const AUTHOR_EMAIL = 'user@example.com';
 const SINCE = '2024-01-01T00:00:00Z';
 const UNTIL = '2024-12-31T23:59:59Z';

 async function fetchAllPages(path, params = {}) {
  const results = [];
  let page = 1;

  while (true) {
    const qs = new URLSearchParams({ ...params, page, per_page: 100 }).toString();
    const res = await fetch(`${GITLAB_URL}/api/v4/${path}?${qs}`, {
      headers: { 'PRIVATE-TOKEN': TOKEN },
    });

    if (!res.ok) throw new Error(`API error ${res.status} on ${path}`);

    const data = await res.json();
    if (!data.length) break;

    results.push(...data);

    const totalPages = parseInt(res.headers.get('x-total-pages') || '1');
    if (page >= totalPages) break;
    page++;
  }

  return results;
 }

 function escapeCsv(value) {
  if (value === null || value === undefined) return '';
  const str = String(value).replace(/\r?\n|\r/g, ' '); // flatten newlines
  return /[",\n]/.test(str) ? `"${str.replace(/"/g, '""')}"` : str;
 }

 function toCsvRow(fields) {
  return fields.map(escapeCsv).join(',');
 }

 async function main() {
  console.error('Fetching accessible projects...');
  const projects = await fetchAllPages('projects', { membership: true, simple: true });
  console.error(`Found ${projects.length} projects. Scanning commits...`);

  const seen = new Set(); // deduplicate commits appearing on multiple branches

  // CSV header to stdout
  console.log(toCsvRow(['project', 'short_id', 'id', 'date', 'title', 'message']));

  for (const project of projects) {
    try {
      const commits = await fetchAllPages(`projects/${project.id}/repository/commits`, {
        all: true,
        since: SINCE,
        until: UNTIL,
        with_stats: false,
      });

      const mine = commits.filter(c => {
        if (c.author_email !== AUTHOR_EMAIL) return false;
        if (seen.has(c.id)) return false;
        seen.add(c.id);
        return true;
      });

      if (mine.length > 0) {
        console.error(`  ${project.path_with_namespace}: ${mine.length} commit(s)`);
        mine.forEach(c => {
          console.log(toCsvRow([
            project.path_with_namespace,
            c.short_id,
            c.id,
            c.authored_date,
            c.title,
            c.message,
          ]));
        });
      }
    } catch (err) {
      console.error(`  Skipping ${project.path_with_namespace}: ${err.message}`);
    }
  }

  console.error(`\nDone. ${seen.size} unique commits written.`);
 }

 main().catch(console.error);
Column	Description
`project`	Full project path (e.g. `group/repo`)
`short_id`	Abbreviated commit SHA (e.g. `a1b2c3d4`)
`id`	Full commit SHA
`date`	Authored date in ISO 8601 format
`title`	First line of the commit message
`message`	Full commit message
Symptom	Likely Cause	Fix
`API error 401`	Invalid or expired token	Regenerate your PAT
`API error 403`	Token missing `read_api` scope	Recreate token with correct scope
`Skipping <project>: ...`	Repo is empty or archived	Expected — script skips gracefully
No commits found	Wrong `AUTHOR_EMAIL`	Verify the email matches GitLab commit history
Duplicate rows	Should not happen — open an issue	Deduplication is done via commit SHA
	// gitlab-commits.mjs
	// Usage: node gitlab-commits.mjs > commits.csv

	const GITLAB_URL = 'https://your-gitlab.example.com';
	const TOKEN = 'your_personal_access_token';
	const AUTHOR_EMAIL = 'user@example.com';
	const SINCE = '2024-01-01T00:00:00Z';
	const UNTIL = '2024-12-31T23:59:59Z';

	async function fetchAllPages(path, params = {}) {
	const results = [];
	let page = 1;

	while (true) {
	const qs = new URLSearchParams({ ...params, page, per_page: 100 }).toString();
	const res = await fetch(`${GITLAB_URL}/api/v4/${path}?${qs}`, {
	headers: { 'PRIVATE-TOKEN': TOKEN },
	});

	if (!res.ok) throw new Error(`API error ${res.status} on ${path}`);

	const data = await res.json();
	if (!data.length) break;

	results.push(...data);

	const totalPages = parseInt(res.headers.get('x-total-pages') \|\| '1');
	if (page >= totalPages) break;
	page++;
	}

	return results;
	}

	function escapeCsv(value) {
	if (value === null \|\| value === undefined) return '';
	const str = String(value).replace(/\r?\n\|\r/g, ' '); // flatten newlines
	return /[",\n]/.test(str) ? `"${str.replace(/"/g, '""')}"` : str;
	}

	function toCsvRow(fields) {
	return fields.map(escapeCsv).join(',');
	}

	async function main() {
	console.error('Fetching accessible projects...');
	const projects = await fetchAllPages('projects', { membership: true, simple: true });
	console.error(`Found ${projects.length} projects. Scanning commits...`);

	const seen = new Set(); // deduplicate commits appearing on multiple branches

	// CSV header to stdout
	console.log(toCsvRow(['project', 'short_id', 'id', 'date', 'title', 'message']));

	for (const project of projects) {
	try {
	const commits = await fetchAllPages(`projects/${project.id}/repository/commits`, {
	all: true,
	since: SINCE,
	until: UNTIL,
	with_stats: false,
	});

	const mine = commits.filter(c => {
	if (c.author_email !== AUTHOR_EMAIL) return false;
	if (seen.has(c.id)) return false;
	seen.add(c.id);
	return true;
	});

	if (mine.length > 0) {
	console.error(` ${project.path_with_namespace}: ${mine.length} commit(s)`);
	mine.forEach(c => {
	console.log(toCsvRow([
	project.path_with_namespace,
	c.short_id,
	c.id,
	c.authored_date,
	c.title,
	c.message,
	]));
	});
	}
	} catch (err) {
	console.error(` Skipping ${project.path_with_namespace}: ${err.message}`);
	}
	}

	console.error(`\nDone. ${seen.size} unique commits written.`);
	}

	main().catch(console.error);