nodejs adminBro mysql没有适配器支持您提供的资源之一

Question

我一直试图用我现有的mysql自动更新数据库来实现Admin。我得到了简单的Admin面板，它工作得很好，但是当我尝试获取db时，我得到:没有适配器支持您提供的错误资源之一。请帮帮忙。

UserModel

import {Sequelize} from "sequelize";
import db from "../config/database.js";

const {DataTypes} = Sequelize;

const Users = db.define('user', {
    name: {
        type: DataTypes.STRING
    },
    surname: {
        type: DataTypes.STRING
    },
    email: {
        type: DataTypes.STRING
    },
    password: {
        type: DataTypes.STRING
    },
    refresh_token:{
        type: DataTypes.TEXT
    },
    token:{
        type: DataTypes.TEXT
    }

}, {
    freezeTableName: true,
    timestamps:false
});
(async () => {
    await db.sync()
})();

export default Users;

数据库

import { Sequelize } from "sequelize";

const db = new Sequelize('users', 'root', '*********', {
    host: "localhost",
    dialect: "mysql"
});

export default db;

adminBro

import AdminBro from "admin-bro";
import Users from '../models/UserModel.js'
const adminBro = new AdminBro({
    rootPath: '/admin',
    loginPath: '/admin/login',
    databases:[Users],
    branding: {
        companyName: 'Admin',
        softwareBrothers: false,
    }
});
export default adminBro

Answer 1

若要在AdminBro面板中查看整个db，请导入db文件并使用

请使用以下代码：

const AdminBro = require('admin-bro')
const AdminBroExpress = require('admin-bro-expressjs');
const AdminBroSequelize = require('admin-bro-sequelizejs');
const db = require('../database/models');

const express = require('express')
const app = express();

AdminBro.registerAdapter(AdminBroSequelize);

const adminBro = new AdminBro({
  databases: [db],
  rootPath: '/admin',
})

module.exports =  adminBro;

如果您想要单独的资源，那么遵循以下链接：添加资源和自定义资源

const adminBro = new AdminBro({
    resources: [User],
    //... other AdminBroOptions
  })