Detalhes do Erro: Error: ER_BAD_FIELD_ERROR: Unknown column 'cliente ' in 'field list' at Query.Sequence.packetToError (C:\Users\Raphael\Desktop\PROJETO\nodemodules\mysql\lib\protocol\sequences\Sequence.js:47:14) at Query.ErrorPacket (C:\Users\Raphael\Desktop\PROJETO\node_modules\mysql\lib\protocol\sequences\Query.js:79:18) at Protocol.parsePacket (C:\Users\Raphael\Desktop\PROJETO\nodemodules\mysql\lib\protocol\Protocol.js:291:23) at Parser.parsePacket (C:\Users\Raphael\Desktop\PROJETO\nodemodules\mysql\lib\protocol\Parser.js:433:10) at Parser.write (C:\Users\Raphael\Desktop\PROJETO\node_modules\mysql\lib\protocol\Parser.js:43:10) at Protocol.write (C:\Users\Raphael\Desktop\PROJETO\node_modules\mysql\lib\protocol\Protocol.js:38:16) at Socket. (C:\Users\Raphael\Desktop\PROJETO\node_modules\mysql\lib\Connection.js:88:28) at Socket. (C:\Users\Raphael\Desktop\PROJETO\node_modules\mysql\lib\Connection.js:526:10) at Socket.emit (node:events:390:28)
at addChunk (node:internal/streams/readable:324:12)
--------------------
at Protocol._enqueue (C:\Users\Raphael\Desktop\PROJETO\node_modules\mysql\lib\protocol\Protocol.js:144:48)
at Connection.query (C:\Users\Raphael\Desktop\PROJETO\node_modules\mysql\lib\Connection.js:198:25)
at Atendimento.adiciona (C:\Users\Raphael\Desktop\PROJETO\models\atendimentos.js:7:17)
at C:\Users\Raphael\Desktop\PROJETO\controllers\atendimentos.js:10:21
at Layer.handle [as handle_request] (C:\Users\Raphael\Desktop\PROJETO\node_modules\express\lib\router\layer.js:95:5)
at next (C:\Users\Raphael\Desktop\PROJETO\node_modules\express\lib\router\route.js:137:13)
at Route.dispatch (C:\Users\Raphael\Desktop\PROJETO\node_modules\express\lib\router\route.js:112:3)
at Layer.handle [as handle_request] (C:\Users\Raphael\Desktop\PROJETO\node_modules\express\lib\router\layer.js:95:5)
at C:\Users\Raphael\Desktop\PROJETO\node_modules\express\lib\router\index.js:281:22
at Function.process_params (C:\Users\Raphael\Desktop\PROJETO\node_modules\express\lib\router\index.js:335:12) { code: 'ER_BAD_FIELD_ERROR',
errno: 1054,
sqlMessage: "Unknown column 'cliente ' in 'field list'",
sqlState: '42S22',
index: 0,
sql: "INSERT INTO Atendimentos SET cliente = 'raphael', pet = 'belinha', servico = 'tosa', status = 'agendado', observacoes = 'muito boazinha'"}
Detalhes do POSTMAN: (https://cdn1.gnarususercontent.com.br/1/872382/c16c4169-175e-449c-a0c2-abf1e77f838a.png)
Códigos: **
**INDEX.JS
const customExpress = require('./config/customExpress');
const conexao = require('./infraestrutura/conexao')
const Tabelas = require('./infraestrutura/tabelas')
conexao.connect(erro => {
if(erro) {
console.log(erro)
} else {
console.log('conectado com sucesso')
Tabelas.init(conexao)
const app = customExpress();
app.listen(3000, () => console.log('servidor rodando na porta 3000'));
}})
** MODELS/ATENDIMENTOS.JS**
const conexao = require('../infraestrutura/conexao')
class Atendimento {
adiciona(atendimento) {
const sql = 'INSERT INTO Atendimentos SET ?'
conexao.query(sql, atendimento, (erro, resultados) => {
if(erro) {
console.log(erro)
} else {
console.log(resultados)
}})}}
module.exports = new Atendimento
INFRAESTRUTURA/CONEXAO.JS
const mysql = require('mysql')
const conexao = mysql.createConnection({
host: 'localhost',
port: 3306,
user: 'root',
password: 'admin',
database: 'agenda_petshop'
})
module.exports = conexao
**INFRAESTRUTURA/TABELAS.JS**
`class Tabelas {
init(conexao) {
this.conexao = conexao
this.criarAtendimentos()}
criarAtendimentos() {
const sql = 'CREATE TABLE IF NOT EXISTS Atendimentos (id int NOT NULL AUTO_INCREMENT, liente varchar(50) NOT NULL, pet varchar(20), servico varchar(20) NOT NULL, data datetime NOT NULL, dataCriacao datetime NOT NULL, status varchar(20) NOT NULL, observacoes text, PRIMARY KEY(id))'
this.conexao.query(sql, erro => {
if(erro) {
console.log(erro)
} else {
console.log('Tabela criada com sucesso')
}})}}module.exports = new Tabelas`
CONTROLLERS/ATENDIMENTOS.JS
const Atendimento = require('../models/atendimentos')
module.exports = app => {
app.get('/atendimentos', (req, res) => {
res.send('Você está na rota de atendimentos e está realizando um GET')
})
app.post('/atendimentos', (req, res) => {
const atendimento = req.body
Atendimento.adiciona(atendimento)
res.send('Adicionar atendimento')
})}
**MySQL:** (https://cdn1.gnarususercontent.com.br/1/872382/a7182c49-402f-44d3-bcb5-24480e4e34a6.png)
^N sobe pro MySQL
