Sdy603’s gists

Sdy603 / send_ai_tool_metrics.js

Created December 4, 2025 14:27

	require("dotenv").config();
	const fs = require("fs");
	const path = require("path");
	const csv = require("csv-parser");
	const axios = require("axios");

	// Configuration via environment variables
	const DX_INSTANCE_URL =
	process.env.DX_INSTANCE_URL \|\| ".getdx.net";
	const DX_API_TOKEN =

Sdy603 / fetch_incidents_mttr.js

Created November 19, 2025 18:30

	'use strict';

	/**
	* export_incidents_mttr.js
	*
	* Streams a DX Postgres query to a CSV file.
	* - Uses DATABASE_URL from environment (preferred)
	* - Falls back to HARDCODED_DB_URL if set
	* - Normalizes postgres:// -> postgresql://
	* - Streams results to avoid memory issues

Sdy603 / dx_fetch_jira_incidents_POST_incidents_api.js

Created October 27, 2025 22:22

	// incidents_upsert.js
	// Classic Node.js (CommonJS)

	const { Client } = require('pg');
	const axios = require('axios');

	// Config
	const DEBUG = process.env.DEBUG === 'true'; // set to "true" to skip POSTs
	const DB_URL = process.env.DX_DB_URL; // e.g. postgres://user:pass@host:5432/dbname
	const API_URL = 'https://activecampaign.getdx.net/api/incidents.upsert';

Sdy603 / fetch_github_to_csv.js

Created October 24, 2025 15:03

	// fetch_github_to_csv.js
	// Fetch GitHub orgs, repos, PRs, and reviews -> write 4 CSVs.
	//
	// Usage:
	// mac/linux:
	// GITHUB_TOKEN=ghp_xxx node fetch_github_to_csv.js
	// windows (PowerShell):
	// $env:GITHUB_TOKEN="ghp_xxx"; node fetch_github_to_csv.js
	//
	// Optional env vars:

Sdy603 / fetch_jira_work_logs.js

Created October 10, 2025 19:52

	// Jira Worklogs + Summary with Original Estimate
	//
	/*
	Jira Worklogs + Estimates Sync
	Purpose:
	- Sync Jira worklogs into Postgres and build a per issue time summary with Original Estimate.
	Selection:
	- Processes only completed issues
	- Applies a grace window (COMPLETED_GRACE_DAYS)
	- Skips issues already snapshotted unless OVERWRITE_SUMMARY=true

Sdy603 / deployments_create_csv.js

Created September 30, 2025 12:20

	/**
	* deployment_backfill_run.js
	*
	* Reads deployments from a CSV file and posts them to the DX Deployments API.
	* Supports --dry-run to preview the first 10 records only (no API calls).
	*/

	const fs = require('fs');
	const path = require('path');
	const csv = require('csv-parser');

Sdy603 / fetch_work_item_relationships.js

Last active September 26, 2025 19:38

	/**
	* fetch_work_item_parents.js
	*
	* Backfill: WorkItemLinks WIQL, partitioned by Source.ChangedDate windows using DATE precision (YYYY-MM-DD)
	* Incremental: WorkItems WIQL by ChangedDate with DATE precision filter (YYYY-MM-DD)
	* Writes: batched multi row upserts into custom.ado_work_item_links
	* Schema columns used: child_work_item_source_id, parent_work_item_source_id, relation_url
	* MIN_ID applied to both parent and child
	* Direct ADO HTTPS without DX proxy
	* Dry run writes a SQL file

Sdy603 / enrich_duo_csv.js

Created September 18, 2025 17:38

	// enrich_duo_csv.js
	// CommonJS version. Only env var required: DATABASE_URL

	const fs = require("fs");
	const { parse } = require("csv-parse");
	const { stringify } = require("csv-stringify");
	const { Pool } = require("pg");

	const DATABASE_URL = process.env.DATABASE_URL;
	if (!DATABASE_URL) {

Sdy603 / fetch_work_item_classifications.js

Created September 15, 2025 21:25

	/**
	* Fetch ADO custom field "Classification" for Work Items and upsert into DX.
	* Usage: node fetch_classification.js
	*/

	const fs = require('fs');
	const path = require('path');
	const { Client } = require('pg');
	const axios = require('axios');

Sdy603 / fetch_user_tags.js

Last active September 22, 2025 16:18

	'use strict';

	/**
	* export_dx_users.js
	*
	* Streams a DX Postgres query to a CSV file.
	* - Uses DATABASE_URL from environment (preferred)
	* - Falls back to HARDCODED_DB_URL if set
	* - Normalizes postgres:// → postgresql://
	* - Streams results to avoid memory issues