task/seed.mjs at main · botcode-com/task · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
import { createClient } from "@supabase/supabase-js";

const supabase = createClient(
  process.env.NEXT_PUBLIC_SUPABASE_URL,
  process.env.SUPABASE_SERVICE_ROLE_KEY
);

const doctors = [
  { email: "doctor1@test.com", password: "doctor123", name: "Doctor 1", specialty: "General" },
  { email: "doctor2@test.com", password: "doctor123", name: "Doctor 2", specialty: "Cardiology" },
  { email: "doctor3@test.com", password: "doctor123", name: "Doctor 3", specialty: "Dermatology" },
];

const patients = [
  { email: "patient1@test.com", password: "patient123", name: "Patient 1" },
  { email: "patient2@test.com", password: "patient123", name: "Patient 2" },
  { email: "patient3@test.com", password: "patient123", name: "Patient 3" },
];

const doctorIds = {};
const patientIds = {};

for (const doctor of doctors) {
  const { data, error } = await supabase.auth.admin.createUser({
    email: doctor.email,
    password: doctor.password,
    email_confirm: true,
  });
  if (error) { console.error("create user", doctor.email, error.message); continue; }

  doctorIds[doctor.email] = data.user.id;

  const { error: e } = await supabase.from("doctors").insert({
    id: data.user.id,
    name: doctor.name,
    email: doctor.email,
    specialty: doctor.specialty,
  });
  if (e) console.error("insert doctor", doctor.email, e.message);
  else console.log("created", doctor.email);
}

for (const patient of patients) {
  const { data, error } = await supabase.auth.admin.createUser({
    email: patient.email,
    password: patient.password,
    email_confirm: true,
  });
  if (error) { console.error("create user", patient.email, error.message); continue; }

  patientIds[patient.email] = data.user.id;

  const { error: e } = await supabase.from("patients").insert({
    id: data.user.id,
    name: patient.name,
    email: patient.email,
  });
  if (e) console.error("insert patient", patient.email, e.message);
  else console.log("created", patient.email);
}

const d1 = doctorIds["doctor1@test.com"];
const d2 = doctorIds["doctor2@test.com"];
const d3 = doctorIds["doctor3@test.com"];
const p1 = patientIds["patient1@test.com"];

const { data: slots, error: slotsError } = await supabase.from("slots").insert([
  { doctor_id: d1, start_time: "2026-04-28 09:00:00+00", end_time: "2026-04-28 10:00:00+00", is_booked: true  },
  { doctor_id: d1, start_time: "2026-04-29 10:00:00+00", end_time: "2026-04-29 11:00:00+00", is_booked: false },
  { doctor_id: d1, start_time: "2026-05-04 09:00:00+00", end_time: "2026-05-04 10:00:00+00", is_booked: false },
  { doctor_id: d1, start_time: "2026-05-06 11:00:00+00", end_time: "2026-05-06 12:00:00+00", is_booked: false },
  { doctor_id: d2, start_time: "2026-04-28 11:00:00+00", end_time: "2026-04-28 12:00:00+00", is_booked: false },
  { doctor_id: d2, start_time: "2026-04-30 09:00:00+00", end_time: "2026-04-30 10:00:00+00", is_booked: false },
  { doctor_id: d2, start_time: "2026-05-05 10:00:00+00", end_time: "2026-05-05 11:00:00+00", is_booked: false },
  { doctor_id: d2, start_time: "2026-05-07 09:00:00+00", end_time: "2026-05-07 10:00:00+00", is_booked: false },
  { doctor_id: d3, start_time: "2026-04-29 09:00:00+00", end_time: "2026-04-29 10:00:00+00", is_booked: false },
  { doctor_id: d3, start_time: "2026-04-30 11:00:00+00", end_time: "2026-04-30 12:00:00+00", is_booked: false },
  { doctor_id: d3, start_time: "2026-05-04 11:00:00+00", end_time: "2026-05-04 12:00:00+00", is_booked: false },
  { doctor_id: d3, start_time: "2026-05-07 10:00:00+00", end_time: "2026-05-07 11:00:00+00", is_booked: false },
]).select();

if (slotsError) { console.error("insert slots", slotsError.message); process.exit(1); }
console.log("created slots");

const bookedSlot = slots.find((s) => s.doctor_id === d1 && s.is_booked === true);

const { error: apptError } = await supabase.from("appointments").insert({
  patient_id: p1,
  doctor_id: d1,
  slot_id: bookedSlot.id,
  status: "active",
});
if (apptError) console.error("insert appointment", apptError.message);
else console.log("created pre-existing appointment");

console.log("done");