It doesn't show me the data when I get the request through the postman, but with books it worked

Question

app.get('/usuarios',async function(req,res){
 var queryResult=await query(`select * from Usuarios`);
 console.log(queryResult);
 res.status(200).json(queryResult);

});

CREATE TABLE Libros
(
    id_libro         VARCHAR(10)        NOT NULL,
    cantidad         INTEGER            NOT NULL,
    titulo_libro     VARCHAR (250)      NOT NULL,
    CONSTRAINT PK__Libros__END
    PRIMARY KEY (id_libro),
    CONSTRAINT CK__LIBROS__cantidad__END
    CHECK (cantidad>0)

);
CREATE TABLE Usuarios
(
    id              VARCHAR(10)         NOT NULL,
    nombre          VARCHAR(100)        not NULL,
    username        VARCHAR(100)        NOT NULL,
    pas             VARCHAR(100)        NOT NULL,
    rol             CHAR(1)             NOT NULL, 
    CONSTRAINT PK__Usuarios__END
    PRIMARY KEY (id),
    CONSTRAINT CK__Usuarios__END
    CHECK (rol='s' or rol='b' or rol='S' or rol='B')

);

CREATE table Prestamos
(
    id_prestamo          VARCHAR (10)        not null,
    id_socio             VARCHAR(10)        not NULL,
    id_libro             VARCHAR(10)        NOT NULL,
    fecha_vencimiento    BIGINT              not null,
    CONSTRAINT PK__Prestamos__END
    PRIMARY KEY (id_prestamo),
    CONSTRAINT FK__Prestamos__Libros__END
    FOREIGN KEY (id_libro) REFERENCES Libros(id_libro),
    CONSTRAINT FK__Prestamos__Usuarios__END
    FOREIGN KEY (id_socio) REFERENCES Usuarios(id)


);

This code works

app.get('/libros',async function(req,res){
 var queryResult=await query(`select * from Libros`);
 console.log(queryResult);
 res.status(200).json(queryResult);

});

could you show your code with books, i assume there are data in usarios. What i would change are the backticks around the select. — nbk, Jan 27 '20 at 22:10
app.get('/libros',async function(req,res){ var queryResult=await query(`select * from Libros`); console.log(queryResult); res.status(200).json(queryResult); }); — Javier, Jan 27 '20 at 22:13
Did you check your select statement in workbench, if it gives any results. you casn also edot your posts to add information — nbk, Jan 27 '20 at 22:30

score 0 · Answer 1 · answered Jan 27 '20 at 22:25

0

This code work

app.get('/libros',async function(req,res){
 var queryResult=await query(`select * from Libros`);
 console.log(queryResult);
 res.status(200).json(queryResult);

});

answered Jan 27 '20 at 22:25

Javier

11
1
4

It doesn't show me the data when I get the request through the postman, but with books it worked

1 Answers1