const fetch = (...args) => import('node-fetch').then(({default: fetch}) => fetch(...args));
|
|
// 配置
|
const GRAPHQL_URL = 'http://localhost:8080/api/graphql';
|
|
// 检查登录记录的GraphQL查询
|
const CHECK_LOGIN_RECORDS_QUERY = `
|
query {
|
loginRecords: getAllLoginRecords {
|
id
|
userId
|
wxOpenid
|
wxSessionKey
|
loginTime
|
loginIp
|
deviceInfo
|
user {
|
id
|
username
|
phone
|
}
|
}
|
}
|
`;
|
|
async function checkLoginRecords() {
|
console.log('🔍 检查数据库中的登录记录...\n');
|
|
try {
|
const response = await fetch(GRAPHQL_URL, {
|
method: 'POST',
|
headers: {
|
'Content-Type': 'application/json',
|
},
|
body: JSON.stringify({
|
query: CHECK_LOGIN_RECORDS_QUERY
|
})
|
});
|
|
const result = await response.json();
|
|
if (result.errors) {
|
console.log('❌ GraphQL查询失败:', result.errors[0].message);
|
return;
|
}
|
|
const records = result.data.loginRecords;
|
console.log(`📊 找到 ${records.length} 条登录记录:\n`);
|
|
records.forEach((record, index) => {
|
console.log(`记录 ${index + 1}:`);
|
console.log(` - ID: ${record.id}`);
|
console.log(` - 用户ID: ${record.userId}`);
|
console.log(` - 微信OpenID: ${record.wxOpenid}`);
|
console.log(` - SessionKey: ${record.wxSessionKey ? record.wxSessionKey.substring(0, 10) + '...' : '无'}`);
|
console.log(` - 登录时间: ${record.loginTime}`);
|
console.log(` - 登录IP: ${record.loginIp}`);
|
console.log(` - 设备信息: ${record.deviceInfo}`);
|
if (record.user) {
|
console.log(` - 用户名: ${record.user.username}`);
|
console.log(` - 手机号: ${record.user.phone || '未设置'}`);
|
}
|
console.log('');
|
});
|
|
// 分析数据
|
const testDataRecords = records.filter(r =>
|
r.wxOpenid && (r.wxOpenid.includes('test') || r.wxOpenid.includes('mock'))
|
);
|
|
const realDataRecords = records.filter(r =>
|
r.wxOpenid && !r.wxOpenid.includes('test') && !r.wxOpenid.includes('mock')
|
);
|
|
console.log('📈 数据分析:');
|
console.log(` - 测试数据记录: ${testDataRecords.length} 条`);
|
console.log(` - 真实数据记录: ${realDataRecords.length} 条`);
|
|
if (testDataRecords.length > 0) {
|
console.log('\n⚠️ 发现测试数据记录:');
|
testDataRecords.forEach(record => {
|
console.log(` - OpenID: ${record.wxOpenid}`);
|
});
|
}
|
|
if (realDataRecords.length > 0) {
|
console.log('\n✅ 发现真实数据记录:');
|
realDataRecords.forEach(record => {
|
console.log(` - OpenID: ${record.wxOpenid.substring(0, 10)}...`);
|
});
|
}
|
|
} catch (error) {
|
console.error('❌ 检查登录记录失败:', error.message);
|
}
|
}
|
|
// 运行检查
|
checkLoginRecords();
|
