Can't get data from Google Datastore from Node.js

Question

I can't get data from the method getuserpost. The web page stucks and doesn't show anything.

The rest of the code works well adding and deleting data and then redirecting to the home page but that method does not show the JSON output. I have tried with res.send and res.render but nothing.

Does someone know what's wrong with this code?

app.get('/getuser', (req, res) => {
    res.render('getuser');
});
//DOESN'T WORK
app.post('/getuserpost', (req, res) => {
    const query = datastore.createQuery('usersTable').filter('girl', req.body.girl_field).order('timestamp', { descending: true }).limit(10);
    datastore.runQuery(query).then((results) => {
        const entities = results[0];
        res.json(entities[0]);
    });
});

This is the HTML for that method:

<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta http-equiv="X-UA-Compatible" content="ie=edge">
    <title>Document</title>
</head>

<body>
    <form action="/getuserpost/" method="POST">     
        <label for="girl_name">Enter girl: </label>
        <input id="girl_name" type="text" name="girl_field" value="Default girl for user">
        <input type="submit" value="OK">
    </form>
    <br>
    <a href="/home">Home</a>
    <br>
    <a href="/adduser">Add user</a>
    <br>
    <a href="/updateuser">Update user</a>
    <br>
    <a href="/deleteuser">Delete user</a>
    <br>
</body>

</html>

I'm using Google Datastore with Google App Engine.

Go to logging and select your deployed app. Also, you can check network tab in the browser, to see what has been returned by the server. — Artsiom Miksiuk
– Artsiom Miksiuk, Commented Jan 16, 2018 at 19:45
When I press ok, it doen't do nothing. The wheel of charge in the expolorer is running and running without doing nothing — Cesar SC
– Cesar SC, Commented Jan 16, 2018 at 19:55
"Error: Unsupported field value, undefined, was provided" I don't understand because I can add and delete but not read — Cesar SC
– Cesar SC, Commented Jan 16, 2018 at 20:09

Artsiom Miksiuk · Accepted Answer · 2018-01-16 21:03:22Z

1

I guess you missed operator option in filter.

.filter('girl', "=", req.body.girl_field)

answered Jan 16, 2018 at 21:03

Artsiom Miksiuk

4,36310 gold badges39 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Cesar SC Over a year ago

I have tried that, but doesn't work. The delete method works and doesn't use that "=" sign. I have deleted all old error messages in App Engine I have used the get user web several times but no new errors arise. I have used "gcloud app deploy index.yaml" before using "gcloud app deploy" and neither. I have seen the "Network" tab in the explorer and nothing is showed.

Cesar SC Over a year ago

When I use Postman I receive this: <html> <head> <title>502 Bad Gateway</title> </head> <body bgcolor="white"> <center> <h1>502 Bad Gateway</h1> </center> <hr> <center>nginx</center> </body> </html>

Dathan Over a year ago

operator is optional in case of =

Cesar SC · Accepted Answer · 2018-01-17 13:55:24Z

1

SOLUTION FOR READING DATA FROM "DATASTORE" IN "APP ENGINE" USING "NODE JS":

app.get('/getuser', (req, res) => {
res.render('getuser');
});
//WORKS
app.post('/getuserpost', (req, res) => {
    const query = datastore.createQuery('usersData').filter('girl', 
req.body.girl_field);
    datastore.runQuery(query).then((results) => {
        const entities = results[0];
        datastore.get(entities[0][datastore.KEY], (err, entity) => {
            if (!err) {
                res.send(entity);
            }
        });
    });
});

answered Jan 17, 2018 at 13:55

Cesar SC

197 bronze badges

2 Comments

Artsiom Miksiuk Over a year ago

You are doing something wrong. Entities already should contains data. We've using such approach every where in our project. Did you logged what is inside entities?

Cesar SC Over a year ago

You are right, the code works as well without the datastore.get() method. The problem was all time the "const query" variable. I got rid of the methods after "filter" in the query and the code worked perfect. Thanks

Cesar SC · Accepted Answer · 2018-01-17 12:16:45Z

app.get('/getuser', (req, res) => {
res.render('getuser');
});
//WORKS
app.post('/getuserpost', (req, res) => {
    /*const query = datastore.createQuery('usersData').filter('girl', 
req.body.girl_field).order('timestamp', { descending: true }).limit(10);
    datastore.runQuery(query).then((results) => {
       const entities = results[0];
        datastore.get(entities[0][datastore.KEY], (err, entity)=>{
            if(!err){
                res.json(entity);
            }else{
                console.log(err);
            }
        });
    });*/
    res.send("output");

});

The problem is with the code inside getuserpost, when I comment the code It works but when I delete res.send("output") and uncomment the code It stucks. This commented version doesn't work neither. This delete method below works and its query works

app.get('/deleteuser', (req, res) => {
    res.render('deleteuser');
});
//WORKS
app.post('/deleteuserpost', (req, res) => {
    const query = datastore.createQuery('usersData').filter('car', req.body.car_field);
    datastore.runQuery(query).then((results) => {
        const entities = results[0];
        datastore.delete(entities[0][datastore.KEY], (err) => {
            if (!err) {
                res.redirect('/');
            }
        });
    });
});

Cesar SC · Accepted Answer · 2018-01-17 23:24:27Z

0

SOLUTION FOR ADDING DATA FROM "DATASTORE" IN "APP ENGINE" USING "NODE JS":

//WORKS
app.post('/adduserpost', (req, res) => {

    const user = {
        timestamp: new Date,
        name: req.body.name_field,
        girl: req.body.girl_field,
        car: req.body.car_field
    }

    datastore.save({
        key: datastore.key('usersData'),
        data: user
    }).then(() => {
        res.redirect('/');
    }).catch((err) => {
        res.redirect('/');
    });

});

answered Jan 17, 2018 at 23:24

Cesar SC

197 bronze badges

1 Comment

Cesar SC Over a year ago

This is unbelievable. I am writing CRUD methods that work for me to help other people who see this in the future and I am penalized. I quit

Cesar SC · Accepted Answer · 2018-01-17 23:28:57Z

0

SOLUTION FOR UPDATING DATA FROM "DATASTORE" IN "APP ENGINE" USING "NODE JS":

//WORKS
app.post('/updateuserpost', (req, res) => {
    const query = datastore.createQuery('usersData').filter('car', req.body.car_field);
    datastore.runQuery(query).then((results) => {
        let entities = results[0];
        entities[0].car = req.body.new_car_field;
        const entity = {
            key: entities[0][datastore.KEY],
            data: entities[0],
          };

          datastore.update(entity).then(() => {
            res.redirect('/');
          });
    });
});

answered Jan 17, 2018 at 23:28

Cesar SC

197 bronze badges

Comments

Dathan · Accepted Answer · 2018-01-20 18:37:31Z

0

You need composite indexing for the fields girl and timestamp. Docs on composite indexes here.

Your yaml file should contain the following

- kind: usersTable
  properties:
  - name: girl
  - name: timestamp
    direction: desc

To apply the composite indexes, run the following command

gcloud -q datastore create-indexes path/to/yaml/file

answered Jan 20, 2018 at 18:37

Dathan

4,6134 gold badges27 silver badges46 bronze badges

Collectives™ on Stack Overflow

Can't get data from Google Datastore from Node.js

6 Answers 6

3 Comments

2 Comments

Comments

1 Comment

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

3 Comments

2 Comments

Comments

1 Comment

Comments

Comments

Related