SENTRY_AUTH_TOKEN=<token>
SENTRY_ORG=based-hardware
SENTRY_PROJECT=omi-computer

POSTHOG_PERSONAL_API_KEY=phx_<key>
POSTHOG_PROJECT_ID=302298

./scripts/sentry-logs.sh <email>
# Example: ./scripts/sentry-logs.sh kodjima33@gmail.com

source .env && curl -s -H "Authorization: Bearer $SENTRY_AUTH_TOKEN" \
  "https://sentry.io/api/0/projects/$SENTRY_ORG/$SENTRY_PROJECT/issues/?query=user.email:<email>&limit=20" | python3 -c "
import sys, json
data = json.load(sys.stdin)
for issue in data[:20]:
    print(f\"[{issue.get('shortId')}] {issue.get('lastSeen', 'N/A')[:16]} - {issue.get('title', '')[:60]}\")
"

source .env && curl -s -H "Authorization: Bearer $POSTHOG_PERSONAL_API_KEY" \
  "https://us.posthog.com/api/projects/$POSTHOG_PROJECT_ID/events/?properties=%5B%7B%22key%22%3A%22email%22%2C%22value%22%3A%22<email>%22%2C%22type%22%3A%22person%22%7D%5D&orderBy=%5B%22-timestamp%22%5D&limit=50"

source .env && curl -s -X POST \
  -H "Authorization: Bearer $POSTHOG_PERSONAL_API_KEY" \
  -H "Content-Type: application/json" \
  "https://us.posthog.com/api/projects/$POSTHOG_PROJECT_ID/query/" \
  -d '{
    "query": {
      "kind": "HogQLQuery",
      "query": "SELECT any(person.properties.email) as email, countIf(event = '\''App Launched'\'') as launches, max(timestamp) as last_seen, any(properties.$app_version) as version, groupArray(event) as events FROM events WHERE person.properties.email = '\''<email>'\'' AND timestamp > now() - INTERVAL 7 DAY"
    }
  }'

const email = process.argv[2];
if (!email) { console.error('Usage: node user_report.js <email>'); process.exit(1); }

const POSTHOG_API_KEY = process.env.POSTHOG_PERSONAL_API_KEY;
const POSTHOG_PROJECT_ID = process.env.POSTHOG_PROJECT_ID || '302298';

async function main() {
  const afterDate = new Date();
  afterDate.setDate(afterDate.getDate() - 7);
  const afterDateStr = afterDate.toISOString().split('T')[0];

  const query = `
    SELECT
      any(person.properties.email) as email,
      countIf(event = 'App Launched' OR event = 'First Launch') as launch_count,
      countIf(event = 'Memory Created' OR event = 'Conversation Created') as activity_count,
      max(timestamp) as last_activity,
      any(properties.$app_version) as app_version,
      groupArray(event) as all_events
    FROM events
    WHERE person.properties.email = '${email}'
      AND timestamp > toDateTime('${afterDateStr}')
  `;

  const response = await fetch(`https://us.posthog.com/api/projects/${POSTHOG_PROJECT_ID}/query/`, {
    method: 'POST',
    headers: {
      'Authorization': `Bearer ${POSTHOG_API_KEY}`,
      'Content-Type': 'application/json',
    },
    body: JSON.stringify({ query: { kind: 'HogQLQuery', query } }),
  });

  if (!response.ok) {
    console.log('Error:', response.status, await response.text());
    return;
  }

  const data = await response.json();
  console.log(`=== User Report for ${email} ===`);
  if (data.results && data.results.length > 0) {
    const [em, launches, activity, lastSeen, version, events] = data.results[0];
    console.log('Email:', em);
    console.log('App Launches:', launches);
    console.log('Activities:', activity);
    console.log('Last Activity:', lastSeen);
    console.log('App Version:', version);

    const eventCounts = {};
    events.forEach(e => { eventCounts[e] = (eventCounts[e] || 0) + 1; });
    console.log('\nEvent breakdown:');
    Object.entries(eventCounts)
      .sort((a, b) => b[1] - a[1])
      .slice(0, 15)
      .forEach(([e, c]) => console.log('  ' + c + 'x ' + e));
  }
}

main().catch(console.error);

-- HogQL
SELECT max(timestamp), any(properties.$app_version)
FROM events
WHERE person.properties.email = 'user@example.com'
  AND event IN ('App Launched', 'First Launch')
  AND timestamp > now() - INTERVAL 7 DAY

source .env && curl -s -H "Authorization: Bearer $SENTRY_AUTH_TOKEN" \
  "https://sentry.io/api/0/projects/$SENTRY_ORG/$SENTRY_PROJECT/issues/?query=ScreenCaptureKit&statsPeriod=24h"

-- HogQL
SELECT
  countIf(event = 'Monitoring Started') as monitoring,
  countIf(event = 'Memory Created') as memories,
  countIf(event = 'Phone Mic Recording Started') as transcription
FROM events
WHERE person.properties.email = 'user@example.com'
  AND timestamp > now() - INTERVAL 30 DAY