check-users.js 934 B

123456789101112131415161718192021222324252627282930313233
  1. const { PrismaClient } = require('@prisma/client');
  2. const prisma = new PrismaClient();
  3. async function checkUsers() {
  4. try {
  5. const users = await prisma.user.findMany();
  6. console.log('用户总数:', users.length);
  7. console.log('用户列表:');
  8. users.forEach(u => {
  9. console.log(` ID: ${u.id}, 手机: ${u.phone}, 会员等级: ${u.memberLevel}`);
  10. });
  11. if (users.length === 0) {
  12. console.log('\n数据库为空,需要创建测试用户...');
  13. // 创建测试用户
  14. const testUser = await prisma.user.create({
  15. data: {
  16. phone: '13812341234',
  17. memberLevel: 0,
  18. dailyUsage: 0,
  19. lastUsageDate: new Date().toISOString().slice(0, 10)
  20. }
  21. });
  22. console.log('✅ 测试用户创建成功:', testUser);
  23. }
  24. } catch (error) {
  25. console.error('错误:', error);
  26. } finally {
  27. await prisma.$disconnect();
  28. }
  29. }
  30. checkUsers();