Files
niumalll/backend/test_models.js

32 lines
932 B
JavaScript
Raw Permalink Normal View History

const models = require('./src/models');
console.log('Available models:', Object.keys(models));
console.log('User model exists:', !!models.User);
console.log('Admin model exists:', !!models.Admin);
if (models.User) {
console.log('User model table name:', models.User.tableName);
}
if (models.Admin) {
console.log('Admin model table name:', models.Admin.tableName);
}
// 测试数据库连接
if (models.User && models.User.sequelize) {
models.User.sequelize.authenticate()
.then(() => {
console.log('Database connection successful');
return models.User.sequelize.query('SELECT id, username, user_type FROM users LIMIT 5;', {
type: models.User.sequelize.QueryTypes.SELECT
});
})
.then(result => {
console.log('Users data:', result);
})
.catch(err => {
console.error('Database error:', err.message);
});
} else {
console.log('Sequelize instance not found');
}