{
  "_id": "507f1f77bcf86cd799439011",
  "email": "user@example.com",
  "displayName": "John Doe",
  "role": "user",
  "createdAt": "2026-01-20T10:00:00.000Z"
}

import mongoose from "mongoose";

export async function connectDB() {
  const uri = process.env.MONGO_URI;
  if (!uri) throw new Error("Missing MONGO_URI");
  await mongoose.connect(uri);
  console.log("✅ [db] connected");
}

import mongoose from "mongoose";

const UserSchema = new mongoose.Schema(
  {
    email: { type: String, unique: true, required: true, index: true },
    passwordHash: { type: String, required: true },
    displayName: { type: String, default: "" },
    role: { type: String, enum: ["user", "admin"], default: "user" },

    preferences: {
      notifications: {
        push: { type: Boolean, default: true },
        email: { type: Boolean, default: true },
        reminders: { type: Boolean, default: true }
      },
      theme: { type: String, enum: ['light', 'dark', 'system'], default: 'system' },
      language: { type: String, default: 'en' }
    },

    profile: {
      bio: { type: String, default: '' },
      avatar: { type: String, default: '' },
      phone: { type: String, default: '' }
    }
  },
  { timestamps: true }
);

export const User = mongoose.model("User", UserSchema);

import mongoose from "mongoose";

const NoteSchema = new mongoose.Schema(
  {
    userId: { 
      type: mongoose.Schema.Types.ObjectId, 
      ref: "User", 
      index: true, 
      required: true 
    },

    title: { type: String, default: "" },
    language: { type: String, default: "auto" }, // auto|th|en

    audio: {
      fileName: String,
      url: String,
      mimeType: String,
      durationMs: Number
    },

    image: {
      fileName: String,
      url: String,
      mimeType: String
    },

    transcript: { type: String, default: "" },

    summary: {
      lines: { type: [String], default: [] },    // 3–5 บรรทัด
      bullets: { type: [String], default: [] },  // หัวข้อย่อย
      keywords: { type: [String], default: [] }  // keyword
    },

    quote: {
      text: { type: String, default: "" },
      style: { type: String, default: "inspire" }, // inspire|deep|sharp|funny
      translation: { type: String, default: "" } // Thai translation
    },
    
    aiSource: { type: String, default: null },
    sourceUrl: { type: String, default: "" }, // Link to source (if Google)

    shareCount: { type: Number, default: 0 }, // Track social shares
    viewCount: { type: Number, default: 0 }, // Track views/clicks

    tags: { type: [String], default: [] }
  },
  { timestamps: true }
);

export const Note = mongoose.model("Note", NoteSchema);

userId: { 
  type: mongoose.Schema.Types.ObjectId, 
  ref: "User", 
  index: true, 
  required: true 
}

// ดึง Note พร้อมข้อมูล User
const note = await Note.findById(noteId).populate('userId');
console.log(note.userId.email); // เข้าถึง email ของ User ได้เลย

summary: {
  lines: { type: [String], default: [] },
  bullets: { type: [String], default: [] },
  keywords: { type: [String], default: [] }
}

{
  "summary": {
    "lines": ["บรรทัดที่ 1", "บรรทัดที่ 2"],
    "bullets": ["หัวข้อ 1", "หัวข้อ 2"],
    "keywords": ["คำสำคัญ1", "คำสำคัญ2"]
  }
}

shareCount: { type: Number, default: 0 },
viewCount: { type: Number, default: 0 }

// สร้าง User ใหม่
const user = await User.create({
  email: "test@example.com",
  passwordHash: "hashed_password",
  displayName: "Test User"
});

console.log(user._id); // MongoDB ObjectId

// หา User ทั้งหมด
const users = await User.find();

// หา User ตาม email
const user = await User.findOne({ email: "test@example.com" });

// หา User ตาม ID
const user = await User.findById(userId);

// หาด้วยเงื่อนไข
const admins = await User.find({ role: "admin" });

// แก้ไขด้วย findByIdAndUpdate
const user = await User.findByIdAndUpdate(
  userId,
  { displayName: "New Name" },
  { new: true } // return ข้อมูลใหม่
);

// แก้ไขหลายรายการ
await User.updateMany(
  { role: "user" },
  { $set: { "preferences.theme": "dark" } }
);

// ลบตาม ID
await User.findByIdAndDelete(userId);

// ลบตามเงื่อนไข
await User.deleteMany({ role: "user" });

const ProductSchema = new mongoose.Schema({
  name: {
    type: String,
    required: [true, "Product name is required"],
    minlength: [3, "Name must be at least 3 characters"],
    maxlength: [100, "Name cannot exceed 100 characters"],
    trim: true // ตัด whitespace
  },
  
  price: {
    type: Number,
    required: true,
    min: [0, "Price cannot be negative"],
    max: [1000000, "Price too high"]
  },
  
  email: {
    type: String,
    match: [/^\S+@\S+\.\S+$/, "Invalid email format"]
  },
  
  status: {
    type: String,
    enum: {
      values: ["active", "inactive", "pending"],
      message: "{VALUE} is not a valid status"
    }
  }
});

const UserSchema = new mongoose.Schema({
  age: {
    type: Number,
    validate: {
      validator: function(v) {
        return v >= 18 && v <= 100;
      },
      message: props => `${props.value} is not a valid age!`
    }
  }
});

// User Model
const UserSchema = new mongoose.Schema({
  email: String
});

// Note Model
const NoteSchema = new mongoose.Schema({
  userId: { type: mongoose.Schema.Types.ObjectId, ref: "User" },
  content: String
});

// ดึงข้อมูล
const note = await Note.findById(noteId).populate('userId');
console.log(note.userId.email);

const StudentSchema = new mongoose.Schema({
  name: String,
  courses: [{ type: mongoose.Schema.Types.ObjectId, ref: "Course" }]
});

const CourseSchema = new mongoose.Schema({
  title: String,
  students: [{ type: mongoose.Schema.Types.ObjectId, ref: "Student" }]
});

const UserSchema = new mongoose.Schema({
  email: { type: String, index: true }, // Single field index
  username: { type: String, unique: true }, // Unique index
});

// Compound Index (หลายฟิลด์)
UserSchema.index({ email: 1, role: 1 });

// Text Index (สำหรับ full-text search)
UserSchema.index({ bio: "text" });

// TODO: สร้าง Schema สำหรับ Product ที่มี:
// - name (String, required, min 3 chars)
// - price (Number, required, min 0)
// - category (String, enum: ["electronics", "clothing", "food"])
// - inStock (Boolean, default true)
// - tags (Array of Strings)

// TODO: สร้าง Comment Schema ที่:
// - อ้างอิงไปยัง User (userId)
// - อ้างอิงไปยัง Note (noteId)
// - มี content (String, required)
// - มี timestamps

// TODO: เขียนโค้ดเพื่อ:
// 1. สร้าง User ใหม่
// 2. หา User ทั้งหมดที่เป็น admin
// 3. แก้ไข displayName ของ User
// 4. ลบ User ที่มี email ที่กำหนด