Storing a boolean value in MongoDB as a string

Question

Storing a boolean value in MongoDB as a string

const myObject = { school: true, address: false };     
const myArray = [];
        
myArray.push(myObject);

updateSchool(myArray);

function updateSchool(thisSchool) {
  $.ajax
    ({
    type: "POST",
    url: '/update_school',
    data: {
        school: thisSchool, 
    },
   }
   })

within App.js:

app.post('/update_school', function(request, response) {
   ......
    db.collection("School").updateOne({_id: request.session.username},{$set: 
    {School:request.body.school}}, function(err, result){
    ...... }
    }

When storing boolean values in MongoDB, they are stored as strings like

[{school:"true", address:"false"}]

Can anyone assist me with the process of storing Boolean values in MongoDB properly? Thank you.

javascript mongodb

Answer 1

Answer №1

When you provide an object as data in $.ajax(), it will be converted to a URL encoded string (

application/x-www-form-urlencoded

) which does not support boolean data type according to the documentation found here:

When data is an object, jQuery creates the data string from the object's key/value pairs unless the processData option is set to false. For instance, { a: "bc", d: "e,f" } becomes the string "a=bc&d=e%2Cf"

To properly save boolean values, manual parsing is necessary on the server side or sending the payload as JSON (application/json). Below is how you can achieve the latter using jquery:

function writeObj(obj) {
  document.write('<pre>' + JSON.stringify(obj, null, 4) + '</pre>');
}

function updateSchool(thisSchool) {
  $.ajax({
      type: "POST",
      // url: '/update_school',
      url: 'https://httpbin.org/anything',
      contentType: 'application/json',
      data: JSON.stringify({
        school: thisSchool,
      }),
    })
    .done(writeObj)
    .fail(writeObj);
}

var myobj = {
  school: true,
  address: false
};
var myArray = [];
myArray.push(myobj);
updateSchool(myArray);

<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>

Answer 2

When you provide an object as data in $.ajax(), it will be converted to a URL encoded string (

application/x-www-form-urlencoded

) which does not support boolean data type according to the documentation found here:

When data is an object, jQuery creates the data string from the object's key/value pairs unless the processData option is set to false. For instance, { a: "bc", d: "e,f" } becomes the string "a=bc&d=e%2Cf"

To properly save boolean values, manual parsing is necessary on the server side or sending the payload as JSON (application/json). Below is how you can achieve the latter using jquery:

function writeObj(obj) {
  document.write('<pre>' + JSON.stringify(obj, null, 4) + '</pre>');
}

function updateSchool(thisSchool) {
  $.ajax({
      type: "POST",
      // url: '/update_school',
      url: 'https://httpbin.org/anything',
      contentType: 'application/json',
      data: JSON.stringify({
        school: thisSchool,
      }),
    })
    .done(writeObj)
    .fail(writeObj);
}

var myobj = {
  school: true,
  address: false
};
var myArray = [];
myArray.push(myobj);
updateSchool(myArray);

<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>

Storing a boolean value in MongoDB as a string

Answer №1

Similar questions

When running `npm start`, if you encounter an error message that says `npm ERR`,

The Raycaster in Three.js seems to be malfunctioning as the IntersectObjects method is providing intersection distances that are inconsistent and illogical

Using Vue.js to pass a variable from a parent component to a child component

Using [(ngModel)] in Angular does not capture changes made to input values by JavaScript

Toggle the flag status of a checkbox based on the response provided in dialogues (Angular)

Creating a form in PHP with the power of JavaScript, AJAX, and jQuery

Transform ternary conditional operators into if-else statements

Utilize a pair of arrays to assign distinct values in JavaScript

Execute a JavaScript function when an element loaded via Ajax in a Spring MVC framework triggers the onChange event

Engaging with JSON data inputs

What is the best way to iterate through an Object.entry and multiply one value by another key value within a loop?

Are there any resources available for optimizing performance on iOS and Android browsers?

Problem with displaying images and videos in a lightbox gallery

Click on the child element while it is already being clicked by manually implementing the 'declick' function in Javascript

React function causing website to freeze upon dispatch

Unable to remove element from database using Mongoose $pull

Nested JavaScript function expression

Display the preloaded element as the first item using Javascript

Error: Attempting to use hooks outside the scope of a function component in react-native. Hooks can only be called within the body of a

Creating a design utilizing HTML columns with a set height and the ability to scroll horizontally