GitHub sync

// From github.service.ts
const getLanguages = async ({ token, url }) => {
  const res = await fetch(url, {
    headers: { Authorization: `Bearer ${token}` }
  });
  const languages = await res.json();
  return languages; // { "TypeScript": 45032, "JavaScript": 12843, ... }
};

// From github.service.ts
export const getUserContributionsGraph = async (
  token: string,
  username: string,
  createdAt: string
) => {
  const firstContributionYear = getYear(parseISO(createdAt));
  const currentYear = getYear(new Date());
  const allContributions = [];

  // Fetch contributions year by year
  for (let year = firstContributionYear; year <= currentYear; year++) {
    const yearStart = startOfYear(new Date(year, 0, 1));
    const yearEnd = endOfYear(new Date(year, 0, 1));

    const contributionsQuery = `
      query UserContributions($username: String!, $from: DateTime, $to: DateTime) {
        user(login: $username) {
          contributionsCollection(from: $from, to: $to) {
            contributionCalendar {
              totalContributions
              weeks {
                contributionDays {
                  color
                  contributionCount
                  date
                  weekday
                }
                firstDay
              }
            }
          }
        }
      }
    `;

    const yearData = await makeGraphQLQuery(token, contributionsQuery, {
      username,
      from: format(yearStart, "yyyy-MM-dd'T'HH:mm:ssXXX"),
      to: format(yearEnd, "yyyy-MM-dd'T'HH:mm:ssXXX")
    });

    allContributions.push({ year, data: yearData });
  }

  return allContributions;
};

model User {
  id           String   @id
  username     String?  @unique
  firstname    String
  lastname     String
  email        String   @unique
  profileImg   String
  bio          String?
  tagline      String?
  location     String?
  website      String?
  githubLink   String?
  followers    Int      @default(0)
  following    Int      @default(0)
  skills       String[]
  repos        Repo[]
  experiences  Experience[]
  educations   Education[]
}

model Repo {
  id          String    @id @default(uuid())
  name        String
  description String?
  topics      String[]
  languages   Json
  stars       Int       @default(0)
  forks       Int       @default(0)
  deployments Int       @default(0)
  thumbnail   String?
  repoLink    String
  liveLink    String?
  isPinned    Boolean   @default(false)
  isIncluded  Boolean   @default(true)
  userId      String
  owner       User      @relation(fields: [userId], references: [id])
}

// From dashboard.service.ts
export const createOrUpdateRepo = async (userId: string, data: Repo) => {
  await prisma.repo.upsert({
    where: { id: data.id },
    update: { ...data },
    create: { ...data, userId, isIncluded: true } // Default to included
  });
};

model Repo {
  isPinned    Boolean   @default(false)
  isIncluded  Boolean   @default(true)
}