**Всем привет наткнулся на проблему и нужен совет для решения данной проблемы.**
------------------------------------------------------------------------
*В конце вылетает не хорошая ошибка. Код не сложный буду рад любой помощи*
Error: Route.post() requires a callback function but got a [object Object]
at Route.<computed> [as post] (D:\dev\project_1\node_modules\express\lib\router\route.js:202:15)
at Function.app.<computed> [as post] (D:\dev\project_1\node_modules\express\lib\application.js:482:19)
at Object.<anonymous> (D:\dev\project_1\server.js:12:5)
at Module._compile (internal/modules/cjs/loader.js:1063:30)
at Object.Module._extensions..js (internal/modules/cjs/loader.js:1092:10)
at Module.load (internal/modules/cjs/loader.js:928:32)
at Function.Module._load (internal/modules/cjs/loader.js:769:14)
at Function.executeUserEntryPoint [as runMain] (internal/modules/run_main.js:72:12)
at internal/main/run_main_module.js:17:47
[nodemon] app crashed - waiting for file changes before starting...
//Создаю сервер
"use strict";
const express = require("express");
const connection = require("./config/db.connect.js");
const createTable = require ('./models/Users.js')
const app = express();
global.app = app;
const PORT = 5000;
app.use(express.json());
app.post("/createtable", createTable);
const startApp = () => {
try {
app.listen(PORT, () => {
console.log(`Server started on port ${PORT}`);
});
} catch (error) {
console.log(error);
}
};
startApp();
//Подключаюсь к БД (MySQL)
"use strict";
const mysql = require('mysql')
const connection = mysql.createConnection({
host: "sqlserver.local",
user: "root",
database: "node_users",
password: "password",
});
connection.connect((err) => {
if (err) {
return console.error("Ошибка: " + err.messsage);
} else {
console.log("Connected to MySQL");
}
});
connection.end((err) => {
if (err) {
return console.log("Ошибка выхода: " + err.message);
} else {
console.log("Подключение закрыто");
}
});
global.connection = connection
module.exports = connection
//Пытаюсь создать таблицу
"use strict";
exports.createTable = ('/createtable', (req, res) => {
let sql = "INSERT INTO users (id int AUTO_INCREMENT, fullname VARCHAR (255), address VARCHAR (255), PRIMARY KEY(id) )"
db.query = (sql, (err, result) => {
if(err){
throw err
}
else {
console.log('USERS created')
}
})
});