Need to scan db and either display a message or update item











up vote
0
down vote

favorite












I'm using Dynamo DB in AWS. I've reviewed some of the documentation and now have a semi functional lambda function. I'm not too familiar with nodejs but figured "it's javascript! just treat it like that!".



So this function is about scanning the database in the user_handle db and if a user already has an existing handle, then alert the user that the handle already exists. If the handle does not exist, then update the user_handle item.



So my function updates the handle if it doesn't exist, but if it does, then I need to see this in my response.



Here's my lambda function:



const AWS = require('aws-sdk'); const docClient = new AWS.DynamoDB.DocumentClient({region: 'us-west-1'});

exports.handler = (event, context, callback) => {
let e = JSON.parse(event.body)


var params = {
TableName: event.stageVariables.user,
Key: { 'userId' : e.userId },
UpdateExpression: 'set user_handle = :user_handle',
ExpressionAttributeValues: {
':user_handle' : e.user_handle,
}
};

var scanParams = {
TableName : event.stageVariables.user,
FilterExpression : 'user_handle = :user_handle',
ExpressionAttributeValues : {':user_handle' : e.user_handle}
};



docClient.scan(scanParams, function(err, data) {
if (err) {
console.log("ERROR:", err);
let response = {
"statusCode": err.statusCode,
"headers": {},
"body": JSON.stringify(err)
}
console.log("RESPONSE", response)
callback(response)
} else {
let response = {
"statusCode": 200,
"body": JSON.stringify({"Success": true})
}
callback(null, response)
// console.log("RESPONSE", response)
// console.log("DATA", data)
if( data.Count >= 1 ){

let handleExistsResponse = {
"statusCode": 200,
"body": JSON.stringify({"Success": false})
}
console.log("HANDLE IT", handleExistsResponse)
callback(null, handleExistsResponse)


} else {

docClient.update(params, function(err, data) {
if (err) {
console.log("ERROR:", err);
let response = {
"statusCode": err.statusCode,
"headers": {},
"body": JSON.stringify(err)
}
console.log(response)
callback(response)

} else {
let response = {
"statusCode": 200,
"body": JSON.stringify({"Success": true})
}
callback(null, response)
}
});

}
}
// console.log("DATA", data);
});


};


Here's the DB function in my React Native App:



export async function createUserHandle() {
return new Promise((resolve, reject) => {
let { auth } = store.getState()

let reqBody = {
userId: auth.user.username,
user_handle: auth.user_handle,
}


let path = '/u/create-user-handle'
let myInit = {
headers: { 'Content-Type': 'application/json' },
body: reqBody,
// response: true,
}

API.post(apiName, path, myInit)
.then((resp) => {
console.log('response from user handle', resp)
resolve(resp)
})
.catch((error) => {
console.warn('Create USER Handle ERROR', error)
reject(error)
})
})
}


In the Lambda I was hoping that if (data.Count >= 1){} can give me a response of false coming from



let handleExistsResponse = {
"statusCode": 200,
"body": JSON.stringify({"Success": false})
}


and if it is false, then I can display the appropriate message on the front end. but the response i'm getting is true if i console log it on the front end.



( also, wouldn't mind a code review on this, probably my 3rd time writing a function like this. thanks!)










share|improve this question


























    up vote
    0
    down vote

    favorite












    I'm using Dynamo DB in AWS. I've reviewed some of the documentation and now have a semi functional lambda function. I'm not too familiar with nodejs but figured "it's javascript! just treat it like that!".



    So this function is about scanning the database in the user_handle db and if a user already has an existing handle, then alert the user that the handle already exists. If the handle does not exist, then update the user_handle item.



    So my function updates the handle if it doesn't exist, but if it does, then I need to see this in my response.



    Here's my lambda function:



    const AWS = require('aws-sdk'); const docClient = new AWS.DynamoDB.DocumentClient({region: 'us-west-1'});

    exports.handler = (event, context, callback) => {
    let e = JSON.parse(event.body)


    var params = {
    TableName: event.stageVariables.user,
    Key: { 'userId' : e.userId },
    UpdateExpression: 'set user_handle = :user_handle',
    ExpressionAttributeValues: {
    ':user_handle' : e.user_handle,
    }
    };

    var scanParams = {
    TableName : event.stageVariables.user,
    FilterExpression : 'user_handle = :user_handle',
    ExpressionAttributeValues : {':user_handle' : e.user_handle}
    };



    docClient.scan(scanParams, function(err, data) {
    if (err) {
    console.log("ERROR:", err);
    let response = {
    "statusCode": err.statusCode,
    "headers": {},
    "body": JSON.stringify(err)
    }
    console.log("RESPONSE", response)
    callback(response)
    } else {
    let response = {
    "statusCode": 200,
    "body": JSON.stringify({"Success": true})
    }
    callback(null, response)
    // console.log("RESPONSE", response)
    // console.log("DATA", data)
    if( data.Count >= 1 ){

    let handleExistsResponse = {
    "statusCode": 200,
    "body": JSON.stringify({"Success": false})
    }
    console.log("HANDLE IT", handleExistsResponse)
    callback(null, handleExistsResponse)


    } else {

    docClient.update(params, function(err, data) {
    if (err) {
    console.log("ERROR:", err);
    let response = {
    "statusCode": err.statusCode,
    "headers": {},
    "body": JSON.stringify(err)
    }
    console.log(response)
    callback(response)

    } else {
    let response = {
    "statusCode": 200,
    "body": JSON.stringify({"Success": true})
    }
    callback(null, response)
    }
    });

    }
    }
    // console.log("DATA", data);
    });


    };


    Here's the DB function in my React Native App:



    export async function createUserHandle() {
    return new Promise((resolve, reject) => {
    let { auth } = store.getState()

    let reqBody = {
    userId: auth.user.username,
    user_handle: auth.user_handle,
    }


    let path = '/u/create-user-handle'
    let myInit = {
    headers: { 'Content-Type': 'application/json' },
    body: reqBody,
    // response: true,
    }

    API.post(apiName, path, myInit)
    .then((resp) => {
    console.log('response from user handle', resp)
    resolve(resp)
    })
    .catch((error) => {
    console.warn('Create USER Handle ERROR', error)
    reject(error)
    })
    })
    }


    In the Lambda I was hoping that if (data.Count >= 1){} can give me a response of false coming from



    let handleExistsResponse = {
    "statusCode": 200,
    "body": JSON.stringify({"Success": false})
    }


    and if it is false, then I can display the appropriate message on the front end. but the response i'm getting is true if i console log it on the front end.



    ( also, wouldn't mind a code review on this, probably my 3rd time writing a function like this. thanks!)










    share|improve this question
























      up vote
      0
      down vote

      favorite









      up vote
      0
      down vote

      favorite











      I'm using Dynamo DB in AWS. I've reviewed some of the documentation and now have a semi functional lambda function. I'm not too familiar with nodejs but figured "it's javascript! just treat it like that!".



      So this function is about scanning the database in the user_handle db and if a user already has an existing handle, then alert the user that the handle already exists. If the handle does not exist, then update the user_handle item.



      So my function updates the handle if it doesn't exist, but if it does, then I need to see this in my response.



      Here's my lambda function:



      const AWS = require('aws-sdk'); const docClient = new AWS.DynamoDB.DocumentClient({region: 'us-west-1'});

      exports.handler = (event, context, callback) => {
      let e = JSON.parse(event.body)


      var params = {
      TableName: event.stageVariables.user,
      Key: { 'userId' : e.userId },
      UpdateExpression: 'set user_handle = :user_handle',
      ExpressionAttributeValues: {
      ':user_handle' : e.user_handle,
      }
      };

      var scanParams = {
      TableName : event.stageVariables.user,
      FilterExpression : 'user_handle = :user_handle',
      ExpressionAttributeValues : {':user_handle' : e.user_handle}
      };



      docClient.scan(scanParams, function(err, data) {
      if (err) {
      console.log("ERROR:", err);
      let response = {
      "statusCode": err.statusCode,
      "headers": {},
      "body": JSON.stringify(err)
      }
      console.log("RESPONSE", response)
      callback(response)
      } else {
      let response = {
      "statusCode": 200,
      "body": JSON.stringify({"Success": true})
      }
      callback(null, response)
      // console.log("RESPONSE", response)
      // console.log("DATA", data)
      if( data.Count >= 1 ){

      let handleExistsResponse = {
      "statusCode": 200,
      "body": JSON.stringify({"Success": false})
      }
      console.log("HANDLE IT", handleExistsResponse)
      callback(null, handleExistsResponse)


      } else {

      docClient.update(params, function(err, data) {
      if (err) {
      console.log("ERROR:", err);
      let response = {
      "statusCode": err.statusCode,
      "headers": {},
      "body": JSON.stringify(err)
      }
      console.log(response)
      callback(response)

      } else {
      let response = {
      "statusCode": 200,
      "body": JSON.stringify({"Success": true})
      }
      callback(null, response)
      }
      });

      }
      }
      // console.log("DATA", data);
      });


      };


      Here's the DB function in my React Native App:



      export async function createUserHandle() {
      return new Promise((resolve, reject) => {
      let { auth } = store.getState()

      let reqBody = {
      userId: auth.user.username,
      user_handle: auth.user_handle,
      }


      let path = '/u/create-user-handle'
      let myInit = {
      headers: { 'Content-Type': 'application/json' },
      body: reqBody,
      // response: true,
      }

      API.post(apiName, path, myInit)
      .then((resp) => {
      console.log('response from user handle', resp)
      resolve(resp)
      })
      .catch((error) => {
      console.warn('Create USER Handle ERROR', error)
      reject(error)
      })
      })
      }


      In the Lambda I was hoping that if (data.Count >= 1){} can give me a response of false coming from



      let handleExistsResponse = {
      "statusCode": 200,
      "body": JSON.stringify({"Success": false})
      }


      and if it is false, then I can display the appropriate message on the front end. but the response i'm getting is true if i console log it on the front end.



      ( also, wouldn't mind a code review on this, probably my 3rd time writing a function like this. thanks!)










      share|improve this question













      I'm using Dynamo DB in AWS. I've reviewed some of the documentation and now have a semi functional lambda function. I'm not too familiar with nodejs but figured "it's javascript! just treat it like that!".



      So this function is about scanning the database in the user_handle db and if a user already has an existing handle, then alert the user that the handle already exists. If the handle does not exist, then update the user_handle item.



      So my function updates the handle if it doesn't exist, but if it does, then I need to see this in my response.



      Here's my lambda function:



      const AWS = require('aws-sdk'); const docClient = new AWS.DynamoDB.DocumentClient({region: 'us-west-1'});

      exports.handler = (event, context, callback) => {
      let e = JSON.parse(event.body)


      var params = {
      TableName: event.stageVariables.user,
      Key: { 'userId' : e.userId },
      UpdateExpression: 'set user_handle = :user_handle',
      ExpressionAttributeValues: {
      ':user_handle' : e.user_handle,
      }
      };

      var scanParams = {
      TableName : event.stageVariables.user,
      FilterExpression : 'user_handle = :user_handle',
      ExpressionAttributeValues : {':user_handle' : e.user_handle}
      };



      docClient.scan(scanParams, function(err, data) {
      if (err) {
      console.log("ERROR:", err);
      let response = {
      "statusCode": err.statusCode,
      "headers": {},
      "body": JSON.stringify(err)
      }
      console.log("RESPONSE", response)
      callback(response)
      } else {
      let response = {
      "statusCode": 200,
      "body": JSON.stringify({"Success": true})
      }
      callback(null, response)
      // console.log("RESPONSE", response)
      // console.log("DATA", data)
      if( data.Count >= 1 ){

      let handleExistsResponse = {
      "statusCode": 200,
      "body": JSON.stringify({"Success": false})
      }
      console.log("HANDLE IT", handleExistsResponse)
      callback(null, handleExistsResponse)


      } else {

      docClient.update(params, function(err, data) {
      if (err) {
      console.log("ERROR:", err);
      let response = {
      "statusCode": err.statusCode,
      "headers": {},
      "body": JSON.stringify(err)
      }
      console.log(response)
      callback(response)

      } else {
      let response = {
      "statusCode": 200,
      "body": JSON.stringify({"Success": true})
      }
      callback(null, response)
      }
      });

      }
      }
      // console.log("DATA", data);
      });


      };


      Here's the DB function in my React Native App:



      export async function createUserHandle() {
      return new Promise((resolve, reject) => {
      let { auth } = store.getState()

      let reqBody = {
      userId: auth.user.username,
      user_handle: auth.user_handle,
      }


      let path = '/u/create-user-handle'
      let myInit = {
      headers: { 'Content-Type': 'application/json' },
      body: reqBody,
      // response: true,
      }

      API.post(apiName, path, myInit)
      .then((resp) => {
      console.log('response from user handle', resp)
      resolve(resp)
      })
      .catch((error) => {
      console.warn('Create USER Handle ERROR', error)
      reject(error)
      })
      })
      }


      In the Lambda I was hoping that if (data.Count >= 1){} can give me a response of false coming from



      let handleExistsResponse = {
      "statusCode": 200,
      "body": JSON.stringify({"Success": false})
      }


      and if it is false, then I can display the appropriate message on the front end. but the response i'm getting is true if i console log it on the front end.



      ( also, wouldn't mind a code review on this, probably my 3rd time writing a function like this. thanks!)







      node.js react-native aws-lambda






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Nov 15 at 16:12









      Dres

      15111




      15111
























          1 Answer
          1






          active

          oldest

          votes

















          up vote
          0
          down vote













          Figured it out..



          } else {
          let response = {
          "statusCode": 200,
          "body": JSON.stringify({"Success": true})
          }
          callback(null, response)
          // console.log("RESPONSE", response)
          // console.log("DATA", data)
          if( data.Count >= 1 ){


          The callback happening after the response kept the next call back after the condition to go through. I'm now getting the response I needed. Feels good :D



          Still wouldn't mind a code review :)






          share|improve this answer





















            Your Answer






            StackExchange.ifUsing("editor", function () {
            StackExchange.using("externalEditor", function () {
            StackExchange.using("snippets", function () {
            StackExchange.snippets.init();
            });
            });
            }, "code-snippets");

            StackExchange.ready(function() {
            var channelOptions = {
            tags: "".split(" "),
            id: "1"
            };
            initTagRenderer("".split(" "), "".split(" "), channelOptions);

            StackExchange.using("externalEditor", function() {
            // Have to fire editor after snippets, if snippets enabled
            if (StackExchange.settings.snippets.snippetsEnabled) {
            StackExchange.using("snippets", function() {
            createEditor();
            });
            }
            else {
            createEditor();
            }
            });

            function createEditor() {
            StackExchange.prepareEditor({
            heartbeatType: 'answer',
            convertImagesToLinks: true,
            noModals: true,
            showLowRepImageUploadWarning: true,
            reputationToPostImages: 10,
            bindNavPrevention: true,
            postfix: "",
            imageUploader: {
            brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
            contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
            allowUrls: true
            },
            onDemand: true,
            discardSelector: ".discard-answer"
            ,immediatelyShowMarkdownHelp:true
            });


            }
            });














            draft saved

            draft discarded


















            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53323568%2fneed-to-scan-db-and-either-display-a-message-or-update-item%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown

























            1 Answer
            1






            active

            oldest

            votes








            1 Answer
            1






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes








            up vote
            0
            down vote













            Figured it out..



            } else {
            let response = {
            "statusCode": 200,
            "body": JSON.stringify({"Success": true})
            }
            callback(null, response)
            // console.log("RESPONSE", response)
            // console.log("DATA", data)
            if( data.Count >= 1 ){


            The callback happening after the response kept the next call back after the condition to go through. I'm now getting the response I needed. Feels good :D



            Still wouldn't mind a code review :)






            share|improve this answer

























              up vote
              0
              down vote













              Figured it out..



              } else {
              let response = {
              "statusCode": 200,
              "body": JSON.stringify({"Success": true})
              }
              callback(null, response)
              // console.log("RESPONSE", response)
              // console.log("DATA", data)
              if( data.Count >= 1 ){


              The callback happening after the response kept the next call back after the condition to go through. I'm now getting the response I needed. Feels good :D



              Still wouldn't mind a code review :)






              share|improve this answer























                up vote
                0
                down vote










                up vote
                0
                down vote









                Figured it out..



                } else {
                let response = {
                "statusCode": 200,
                "body": JSON.stringify({"Success": true})
                }
                callback(null, response)
                // console.log("RESPONSE", response)
                // console.log("DATA", data)
                if( data.Count >= 1 ){


                The callback happening after the response kept the next call back after the condition to go through. I'm now getting the response I needed. Feels good :D



                Still wouldn't mind a code review :)






                share|improve this answer












                Figured it out..



                } else {
                let response = {
                "statusCode": 200,
                "body": JSON.stringify({"Success": true})
                }
                callback(null, response)
                // console.log("RESPONSE", response)
                // console.log("DATA", data)
                if( data.Count >= 1 ){


                The callback happening after the response kept the next call back after the condition to go through. I'm now getting the response I needed. Feels good :D



                Still wouldn't mind a code review :)







                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered Nov 15 at 16:39









                Dres

                15111




                15111






























                    draft saved

                    draft discarded




















































                    Thanks for contributing an answer to Stack Overflow!


                    • Please be sure to answer the question. Provide details and share your research!

                    But avoid



                    • Asking for help, clarification, or responding to other answers.

                    • Making statements based on opinion; back them up with references or personal experience.


                    To learn more, see our tips on writing great answers.





                    Some of your past answers have not been well-received, and you're in danger of being blocked from answering.


                    Please pay close attention to the following guidance:


                    • Please be sure to answer the question. Provide details and share your research!

                    But avoid



                    • Asking for help, clarification, or responding to other answers.

                    • Making statements based on opinion; back them up with references or personal experience.


                    To learn more, see our tips on writing great answers.




                    draft saved


                    draft discarded














                    StackExchange.ready(
                    function () {
                    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53323568%2fneed-to-scan-db-and-either-display-a-message-or-update-item%23new-answer', 'question_page');
                    }
                    );

                    Post as a guest















                    Required, but never shown





















































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown

































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown







                    Popular posts from this blog

                    mysqli_query(): Empty query in /home/lucindabrummitt/public_html/blog/wp-includes/wp-db.php on line 1924

                    How to change which sound is reproduced for terminal bell?

                    Can I use Tabulator js library in my java Spring + Thymeleaf project?