How to find string in array using Mongoose?

Question

I have a schema through mongoose:

const mongoose = require('mongoose');

const recipeSchema = mongoose.Schema({

title: String,
chef: String,
updated: {type: Date, default: Date.now},
region: String,
ingredients: [String],
instructions: [String]
}, { collection: 'recipes' })

module.exports = mongoose.model('Recipes', recipeSchema);

I find the mongoose docs really difficult to understand. I am trying to search for a match of all substring within the 'ingredients' array. I read somewhere that it could be done like so:

 .find({ingredients: 'ing1'}) // not working

 .find({'ing1': {$in: ingredients}})  // not working

I find it pretty difficult to find in depth tutorials on mongoose as well. Im thinking about not using it at all anymore and just sticking to mongodb shell.

JohnnyHK · Accepted Answer · 2018-02-24 17:52:07Z

1

You can use a regex search to match substrings:

.find({ingredients: /ing1/})

answered Feb 24, 2018 at 17:52

JohnnyHK

313k70 gold badges632 silver badges479 bronze badges

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

1 Comment

DGwang Over a year ago

Thats perfect! Thank you.

user2347763 · Accepted Answer · 2018-02-24 20:18:40Z

The reason that you use mongoose is for testability.

Instead of having to work with a MongoDb instance, which, in Windows can be a pain with the .lock file and the service, mongoose creates the schema that you can test your code with.

The mongoose way is ideal for TDD/TFD.

Below is the model and the mocha test:

recipemodel.js 
    var mongoose = require('mongoose'),Schema=mongoose.Schema;
    var RecipeSchema = new mongoose.Schema({});
    RecipeSchema.statics.create = function (params, callback) {
   '\\ params is any schema that you pass from the test below
      var recipe = new RecipeSchema(params);
      recipe.save(function(err, result) {
        callback(err, result);
      });
      return recipe;
    };
    var recipemodel=mongoose.model('Model', RecipeSchema);
    module.exports = recipemodel;

You don't need to describe the schema, mongoose will create it for you when you pass the values of the collection from a mocha test, for example!

The mocha test is below:

  var mongooseMock = require('mongoose-mock'),
  proxyquire = require('proxyquire'),
  chai = require('chai'),
  expect = chai.expect,
  sinon = require('sinon'),
  sinonChai = require("sinon-chai");
  chai.use(sinonChai);

  describe('Mocksaving a recipe ingredient', function () { 
    var Recipe;
  beforeEach(function () {
    Recipe = proxyquire('./recipemodel', {'mongoose': mongooseMock});
  });

  it('checks if ingredient '+'ing1' + ' saved to mongoose schema', function 
  (done) {
    var callback = sinon.spy();
    var recipe = Recipe.create({ title: "faasos", chef: 
    'faasos',region:'Chennai',ingredients:'ing1',instructions:'abc' }, 
    callback);
    expect(recipe.save).calledOnce;
    expect(recipe.ingredients).equals('ing341');
    done();
    });    
});

The call to a sinon spy is simply to ensure that the call to the data in the schema got saved (mock saved!) and that the 'save' method did get called at least once. This logic flow is in sync with your actual logic, as you would use in code, when the save on a mongodb collection would be made.

Simply change the value to 'ing1' to make the test pass when you run the test.

For an array type, pass the values as below:

var recipe = Recipe.create({ title: "faasos", chef: 
'faasos',region:'Chennai',ingredients:'ing341,ing1',instructions:'abc' }, callback);
    expect(recipe.save).calledOnce;
expect(recipe.ingredients).to.include('ing1');

douche_satan · Accepted Answer · 2020-02-21 15:15:23Z

0

Try this:

.ingredients.find((i) => i === "ing1")

for all elements in the ingredients array, it looks if the content, here a string element, is strictly equal to "ing1"

edited Feb 21, 2020 at 15:15

answered Feb 21, 2020 at 0:58

douche_satan

1892 silver badges7 bronze badges

1 Comment

Suraj Kumar Over a year ago

You should describe your answer how it works for the future it is because an answer is also read by the others not only by the OP.

guseinxo · Accepted Answer · 2023-04-19 07:56:26Z

0

you can use this way

.find({ingredients: { $in: [yourIngredients] }});

answered Apr 19, 2023 at 7:56

guseinxo

414 bronze badges

1 Comment

Jeremy Caney Over a year ago

Remember that Stack Overflow isn't just intended to solve the immediate problem, but also to help future readers find solutions to similar problems, which requires understanding the underlying code. This is especially important for members of our community who are beginners, and not familiar with the syntax. Given that, can you edit your answer to include an explanation of what you're doing and why you believe it is the best approach?

Collectives™ on Stack Overflow

How to find string in array using Mongoose?

4 Answers 4

1 Comment

Comments

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related