How to Integrate Bolt.new with Udacity

1-- supabase/migrations/001_learning_platform.sql
2CREATE TABLE programs (
3  id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
4  title TEXT NOT NULL,
5  slug TEXT UNIQUE NOT NULL,
6  description TEXT,
7  duration_weeks INTEGER,
8  level TEXT CHECK (level IN ('Beginner', 'Intermediate', 'Advanced')),
9  partner_companies TEXT[] DEFAULT '{}',
10  thumbnail_url TEXT,
11  published BOOLEAN DEFAULT false,
12  created_at TIMESTAMPTZ DEFAULT now()
13);
14
15CREATE TABLE modules (
16  id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
17  program_id UUID REFERENCES programs(id) ON DELETE CASCADE NOT NULL,
18  title TEXT NOT NULL,
19  description TEXT,
20  order_index INTEGER NOT NULL
21);
22
23CREATE TABLE projects (
24  id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
25  module_id UUID REFERENCES modules(id) ON DELETE CASCADE NOT NULL,
26  title TEXT NOT NULL,
27  description TEXT,
28  rubric JSONB DEFAULT '[]',
29  min_passing_score INTEGER DEFAULT 70,
30  order_index INTEGER NOT NULL
31);
32
33CREATE TABLE enrollments (
34  id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
35  learner_id UUID REFERENCES auth.users(id) ON DELETE CASCADE NOT NULL,
36  program_id UUID REFERENCES programs(id) ON DELETE CASCADE NOT NULL,
37  started_at TIMESTAMPTZ DEFAULT now(),
38  UNIQUE(learner_id, program_id)
39);
40
41CREATE TABLE submissions (
42  id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
43  project_id UUID REFERENCES projects(id) ON DELETE CASCADE NOT NULL,
44  learner_id UUID REFERENCES auth.users(id) ON DELETE CASCADE NOT NULL,
45  github_url TEXT NOT NULL,
46  notes TEXT,
47  status TEXT DEFAULT 'pending' CHECK (status IN ('pending', 'in_review', 'passed', 'failed')),
48  submitted_at TIMESTAMPTZ DEFAULT now()
49);
50
51-- RLS
52ALTER TABLE programs ENABLE ROW LEVEL SECURITY;
53ALTER TABLE modules ENABLE ROW LEVEL SECURITY;
54ALTER TABLE projects ENABLE ROW LEVEL SECURITY;
55ALTER TABLE enrollments ENABLE ROW LEVEL SECURITY;
56ALTER TABLE submissions ENABLE ROW LEVEL SECURITY;
57
58CREATE POLICY "Read published programs" ON programs FOR SELECT USING (published = true);
59CREATE POLICY "Read modules" ON modules FOR SELECT USING (true);
60CREATE POLICY "Read projects" ON projects FOR SELECT USING (true);
61CREATE POLICY "Own enrollments" ON enrollments USING (learner_id = auth.uid()) WITH CHECK (learner_id = auth.uid());
62CREATE POLICY "Own submissions" ON submissions USING (learner_id = auth.uid()) WITH CHECK (learner_id = auth.uid());

1// app/dashboard/page.tsx
2import { createClient } from '@/lib/supabase/server';
3import { redirect } from 'next/navigation';
4import Link from 'next/link';
5
6export default async function DashboardPage() {
7  const supabase = await createClient();
8  const { data: { user } } = await supabase.auth.getUser();
9  if (!user) redirect('/login');
10
11  // Fetch enrollments with program data
12  const { data: enrollments } = await supabase
13    .from('enrollments')
14    .select(`
15      id,
16      started_at,
17      programs (
18        id, title, slug, thumbnail_url, partner_companies,
19        modules ( id, order_index,
20          projects ( id )
21        )
22      )
23    `)
24    .eq('learner_id', user.id);
25
26  // Fetch user's passed submissions
27  const { data: passedSubs } = await supabase
28    .from('submissions')
29    .select('project_id')
30    .eq('learner_id', user.id)
31    .eq('status', 'passed');
32
33  const passedProjectIds = new Set(passedSubs?.map((s) => s.project_id) ?? []);
34
35  const programProgress = enrollments?.map((e) => {
36    const program = e.programs as { id: string; title: string; slug: string; thumbnail_url?: string; partner_companies: string[]; modules: { id: string; order_index: number; projects: { id: string }[] }[] };
37    const allProjects = program.modules.flatMap((m) => m.projects);
38    const passed = allProjects.filter((p) => passedProjectIds.has(p.id)).length;
39    const percentage = allProjects.length > 0 ? Math.round((passed / allProjects.length) * 100) : 0;
40    return { ...program, passed, total: allProjects.length, percentage };
41  }) ?? [];
42
43  return (
44    <div className="mx-auto max-w-5xl p-8">
45      <h1 className="mb-6 text-2xl font-bold">My Learning</h1>
46      {programProgress.length === 0 ? (
47        <div className="rounded-lg border p-12 text-center">
48          <p className="text-gray-500">You are not enrolled in any programs yet.</p>
49          <Link href="/programs" className="mt-4 inline-block rounded bg-blue-600 px-6 py-2 text-white">Browse Programs</Link>
50        </div>
51      ) : (
52        <div className="grid gap-6 md:grid-cols-2">
53          {programProgress.map((p) => (
54            <div key={p.id} className="rounded-xl border bg-white p-6 shadow-sm">
55              <h2 className="text-lg font-semibold">{p.title}</h2>
56              <p className="mt-1 text-sm text-gray-500">{p.passed}/{p.total} projects completed</p>
57              <div className="mt-3 h-2 w-full rounded-full bg-gray-100">
58                <div className="h-2 rounded-full bg-blue-600" style={{ width: `${p.percentage}%` }} />
59              </div>
60              <p className="mt-1 text-right text-xs text-gray-400">{p.percentage}%</p>
61              <Link href={`/programs/${p.slug}`} className="mt-4 block w-full rounded bg-blue-600 py-2 text-center text-sm font-medium text-white">
62                Continue
63              </Link>
64            </div>
65          ))}
66        </div>
67      )}
68    </div>
69  );
70}

1// app/actions/submissions.ts
2'use server';
3import { createClient } from '@/lib/supabase/server';
4import { redirect } from 'next/navigation';
5
6export async function submitProject(formData: FormData) {
7  const supabase = await createClient();
8  const { data: { user } } = await supabase.auth.getUser();
9  if (!user) redirect('/login');
10
11  const projectId = formData.get('projectId') as string;
12  const githubUrl = formData.get('githubUrl') as string;
13  const notes = formData.get('notes') as string;
14
15  // Validate GitHub URL
16  const isGitHubUrl = /^https:\/\/github\.com\/[\w.-]+\/[\w.-]+/.test(githubUrl);
17  if (!isGitHubUrl) {
18    return { error: 'Please enter a valid GitHub repository URL (https://github.com/username/repo)' };
19  }
20
21  // Check for existing pending or in_review submission
22  const { data: existing } = await supabase
23    .from('submissions')
24    .select('id, status')
25    .eq('project_id', projectId)
26    .eq('learner_id', user.id)
27    .in('status', ['pending', 'in_review'])
28    .maybeSingle();
29
30  if (existing) {
31    return { error: `You already have a submission ${existing.status === 'pending' ? 'waiting for review' : 'currently under review'}` };
32  }
33
34  const { error } = await supabase.from('submissions').insert({
35    project_id: projectId,
36    learner_id: user.id,
37    github_url: githubUrl,
38    notes: notes || null,
39    status: 'pending',
40  });
41
42  if (error) {
43    return { error: `Submission failed: ${error.message}` };
44  }
45
46  return { success: true };
47}

1// app/api/fcc/certifications/route.ts
2import { NextResponse } from 'next/server';
3
4interface GitHubContentItem {
5  name: string;
6  path: string;
7  type: 'file' | 'dir';
8  url: string;
9}
10
11export async function GET() {
12  const token = process.env.GITHUB_TOKEN;
13  const headers: HeadersInit = {
14    Accept: 'application/vnd.github.v3+json',
15    'User-Agent': 'Bolt-Learning-App/1.0',
16  };
17  if (token) headers['Authorization'] = `Bearer ${token}`;
18
19  try {
20    const response = await fetch(
21      'https://api.github.com/repos/freeCodeCamp/freeCodeCamp/contents/curriculum/challenges/english',
22      { headers, next: { revalidate: 3600 } } // Cache for 1 hour
23    );
24
25    if (!response.ok) {
26      if (response.status === 403) {
27        return NextResponse.json(
28          { error: 'GitHub API rate limit exceeded. Add GITHUB_TOKEN to .env to increase limit.' },
29          { status: 429 }
30        );
31      }
32      return NextResponse.json({ error: `GitHub API error: ${response.status}` }, { status: 500 });
33    }
34
35    const items: GitHubContentItem[] = await response.json();
36    const certifications = items
37      .filter((item) => item.type === 'dir')
38      .map((item) => ({
39        name: item.name
40          .replace(/-/g, ' ')
41          .replace(/\b\w/g, (c) => c.toUpperCase()),
42        slug: item.name,
43        path: item.path,
44      }));
45
46    return NextResponse.json({ certifications });
47  } catch (error) {
48    const message = error instanceof Error ? error.message : 'Request failed';
49    return NextResponse.json({ error: message }, { status: 500 });
50  }
51}