import { mongoose, Schema } from '@fastgpt/service/common/mongo';

const UserSchema = new Schema({
  username: { type: String, required: true, unique: true },
  password: { type: String, required: true, select: false },  // 默认不查询
  email: { type: String, required: true },
  createdAt: { type: Date, default: Date.now }
});

// 索引
UserSchema.index({ username: 1 });
UserSchema.index({ email: 1 });

// 虚拟字段
UserSchema.virtual('fullName').get(function() {
  return `${this.firstName} ${this.lastName}`;
});

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

// ❌ 不好的实践
const users = await User.find({}).toArray();  // 可能返回大量数据

// ✅ 好的实践
const users = await User.find({})
  .project({ username: 1, email: 1 })  // 只查询需要的字段
  .limit(20)  // 限制结果数量
  .skip(page * 20)
  .toArray();