Hi,

I have an issue when passing a password with a character '?' needing to be percent encoded (as specified in https://www.mongodb.com/docs/manual/reference/connection-string/)

When using this in cypress.config.ts with escaped '?'

mongodb: {        
	uri: 'mongodb://myLogin:passwd%[email protected]',
        database: 'mydatabase',
        collection: 'mycollection',
      },

I get error authentication failed when using cy.mindMany

When using this in cypress.config.ts with unescaped '?'

      mongodb: {
        uri: 'mongodb://myLogin:[email protected]',
        database: 'mydatabase',
        collection: 'mycollection',
      },

I get error Password contains unescaped characters when using cy.mindMany

I can connect to the mongodb using Studio 3T with no problem:

Environment:

• Cypress: 12.8.1
• cypress-mongodb: 5.3.0
• TypeScript: 4.9.5
• mongoDB: 5.0.6

Is escaping of chars in password supported?
Thx

The insertOne command throws the error Pipeline must be an object, although it doesn't receive any pipeline parameter.

Checked the source code and could solve it changing args.pipeline by args.document in the insertOne util.

As our application touches 2-3 databases while writing e2e tests, currently the feasibility does not exists for this plugin. Please enable a connect/disconnect method which will be useful in connecting and disconnecting the databases whenever required.

When attempting to use deleteOne with _id it does not work for me but when I use other key/values I can get it to delete. I dont know what I am doing wrong. I can use another mongo package and delete by _id and new ObjectId('634d732c5bcba068900dfc94'). I am using import { ObjectId } from 'mongodb';

This code works:
const filter = { 'merchant': 1234, 'isActive': true } const options = { collection: 'Locations' } cy.deleteOne(filter, options).then((results: any) => { cy.log('results', results) // Yielded: 1 document deleted })

This code fails:
const filter = { _id: new ObjectId('634d732c5bcba068900dfc94') } const options = { collection: 'Locations' } cy.deleteOne(filter, options).then((results: any) => { cy.log('results', results) // Yielded: 0 document deleted })

Can we please add the function to list collections in the database?

This is my e2e.js file

import './commands';
import './StepDefinition/Global';
import 'cypress-mochawesome-reporter/register';
import 'cypress-xpath';
import { addCommands } from 'cypress-mongodb/dist/index-browser';
addCommands();

This is cypress config file

const addCucumberPreprocessorPlugin =
require('@badeball/cypress-cucumber-preprocessor').addCucumberPreprocessorPlugin;
const createEsbuildPlugin =
require('@badeball/cypress-cucumber-preprocessor/esbuild').createEsbuildPlugin;
const cypressmongodb = require('cypress-mongodb');

module.exports = defineConfig({
env: {
mongodb: {
uri: '',
database: 'database_name',
collection: 'collection_name'
}
},
setupNodeEvents(on, config) {
cypressmongodb.configurePlugin(on);
require('cypress-mochawesome-reporter/plugin')(on);
}
});

mongodb_stepdef.js

import { When, Given, Then } from '@badeball/cypress-cucumber-preprocessor';
const collection_data = {

uri: '',
database: '',
collection: ''
}
Given('It Should create new collections', () => {
//create collection
cy.createCollection(collection_data.collection).then((result) => {
assert.strictEqual(result, 'Collection created');
});
});

mongodb.feature
Feature: Testing MongoDB Integration with Cypress

Scenario: Insert data into MongoDB
Given It Should create new collections

Package.json
"dependencies": {
"@badeball/cypress-cucumber-preprocessor": "latest",
"@bahmutov/cypress-esbuild-preprocessor": "2.1.5",
"@faker-js/faker": "^8.0.2",
"@percy/cypress": "^3.1.2",
"cypress": "^13.8.0",
"cypress-mochawesome-reporter": "^3.2.2",
"cypress-mongodb": "^6.2.0",
"cypress-xpath": "^2.0.1",
"dotenv": "^16.0.1",
"esbuild": "^0.15.9",
"fast-csv": "^4.3.6",
"install": "^0.13.0",
"mongodb": "3.6.6",
"xlsx": "^0.18.5"
},
"cypress-cucumber-preprocessor": {
"stepDefinitions": "cypress/e2e/**//.{js,ts}",
},
"devDependencies": {
"cypress-multi-reporters": "^1.6.3",
"cypress-v10-preserve-cookie": "^1.2.1"
}
}

Great library, the API is simple and I'm thankful for TypeScript support.

The Problem

I want to hard code the _id on an inserted user. When I pass the

import { ObjectId } from "MongoDB";

describe("login", () => {
  beforeEach(() => {
    cy.deleteMany({}, "users");
    const objectId = new ObjectId();

    const user = {
      _id: objectId,
      ...otherFields
    };

    cy.insertOne(user, "users").then((res) => {
      cy.log(JSON.stringify(res));
    });

When I run this, the objectId is inserted as a string on the mongoDb model (see Compass screenshot below).

If I remove the _id field in the payload, the system is able to autogenerate a valid ObjectId on the mongo entry.

What's going on? Why is the ObjectId object being converted to a string on the insert?

I looked into the forceServerObjectId on the insert options but haven't had any success figuring it out.

I'm trying to use that with cucumber preprocessor but it doesn't recognize the commands

and in terminal

i have this in my e2e config file

e2e: {
    reporter: require.resolve("@badeball/cypress-cucumber-preprocessor/pretty-reporter"),
    // We've imported your old cypress plugins here.
    // You may want to clean this up later by importing these.
    setupNodeEvents( cypressOn, config ) {
         const on = require('cypress-on-fix')(cypressOn);

      // This is required for the preprocessor to be able to generate JSON reports after each run, and more,
      addCucumberPreprocessorPlugin(on, config);

      on(
        "file:preprocessor",
        createBundler({
          plugins: [createEsbuildPlugin(config)],
        })
      );
      configurePlugin(on)

      return config;

    }

any way to use it? thx)

I am getting the below error if I try to use mongo or bson plugins

Hi,

According to documentation, we need to configure mongodb access with this pattern (in cypress.config.ts):

{
    module.exports = defineConfig({
        env: {
            mongodb: {
                uri: "mongodb://login:password@url",
                database: "database_name",
                collection: "collection_name"
            }
        }
    });
}

What if I want/need to use these properties which are set by CI when launching tests?

    env: {
      MONGODB_SERVER: '<url>',
      MONGODB_BASE: '<database_name>',
      MONGODB_LOGIN: '<login>',
      MONGODB_PASS: 'passW0rd',
      MONGO_COLLECTION: 'collection',

=>

      mongodb: {
        uri: 'mongodb://MONGODB_LOGIN:MONGODB_PASS@MONGODB_SERVER',
        database: 'MONGODB_BASE',
        collection: 'MONGO_COLLECTION',
      },

Thanks for your help!

args.pipeline._id = new ObjectId(args.pipeline._id);

This is causing me problems. Please add this as an option not force all strings to be automatically ObjectId.
I rely on it to stay a string.

https://www.mongodb.com/docs/manual/reference/method/ObjectId/

It would be great if there was an ability to add { "upsert": true } to the options for updateOne so that I could insert a new record when one does not exist.

Sorry, I don't know how to replicate it. Could it be ssl=true?

As per your provided configuration, When we added the below lines and run our spec file we got this error.

In your cypress/support/e2e.js add the following:
const mongo = require('cypress-mongodb');
mongo.addCommands();

Spec file snapshot attahced for refernece.

Error snapshot is attached for reference.

Pakage,json
{ "name": "cypress", "version": "1.0.0", "description": "", "main": "index.js", "scripts": { "test": "echo \"Error: no test specified\" && exit 1" }, "keywords": [], "author": "", "license": "ISC", "dependencies": { "cypress": "^10.9.0", "cypress-downloadfile": "^1.2.3", "npm-check-updates": "^16.3.11" }, "devDependencies": { "cypress-file-upload": "^5.0.8", "cypress-mochawesome-reporter": "^3.2.3", "cypress-xpath": "^2.0.1", "multiple-cucumber-html-reporter": "^3.0.1" } }

Hello,

Currently does not return changed or deleted data from a collection in the result

In version 5.2 of mongo, it is possible to use the function findOneAndUpdate() or findOneAndDelete passing as option returnDocument 'after' or 'before' to return the changed or deleted result.

It's cool any mongoDB command has the option to return the result in the console.

Note: I noticed that apparently there is a conflict when updating to a new version of mongoDB

This doesn't work. "Item" is defined earlier in the document.

    const filter = {
      name: item.name
      slug: item.slug,
      url: item.url
    };
    const document = { $set: { 
      category: item.category,
      image: item.image,
      url: item.url,
      price: item.price
    } };
    const options = {"collection": "coll", "database": "db"} 
    cy.updateOne(filter, document, options).then((res) => {
      cy.log("update attempted", res)
   })

It doesn't seem possible to use a filter in either the findOne or updateOne methods. The only method I can get to work is insertOne with all the same values above only without the filter.

Hi! I'm working on a cypress & typescript project. I have installed cypress-mongodb and it's great.
However, I struggled to find references on how to do things properly (examples of good practices).

For instance, I ended up doing something like this:

cy.findMany(
      { email: "[email protected]" },
      { collection: "users" }
    ).should((result: any) => {
      expect(result?.length).to.equal(1);
      const firstElement = result[0];
      expect(firstElement.email).to.equal("[email protected]");
      expect(firstElement.firstName).to.equal("Norberto");
      expect(firstElement.lastName).to.equal("Herz");
      expect(firstElement.provider).to.equal("password");
      expect(firstElement).not.to.have.property("password");
    });

Do you think this approach is correct?
Is there any better option than typing result as any?
Do you know if I am supposed to use then/should and that list of expects inside?

I got that working after hours of searching, not founding documentation, and trial and error.

P.S.: I'd love to start writing some docs once I have a clear idea of what I'm doing.

Hi,

First up, thanks for the super useful package, it has helped a lot!

Kind of a silly question (please let me know if this is not the right place to ask).

For a document to be added:

const document = {
  text: 'whatever'
  createdAt: new Date()
}

From my normal application (a Meteor application), inserting this results in a createdAt field that is of a Date type. However, doing the same within cypress:

cy.insertOne({
  text: 'whatever'
  createdAt: new Date()
});

... leads to a document where the createdAt field is of type string.

Is there something straightforward that I am missing? I have tried looking around but all documentation and queries regarding this seem to indicate that mongo should be automatically defaulting to an object type.

Thanks in advance!

Looks like filtering documents using _id with UUID does not work.

cypress-mongodb version: 5.1.2
mongo version: 4.4
collection is sharded

Example with findOne but it fails with ie. findOne > deleteOne too:

const { UUID } = require('bson');
it('nested findOne number > ID UUID', () => {
    cy.findOne({ queryNo: 12345678 }, { collection: 'collection' }).then(res => { // works
      // const ID = res['_id']
      const ID = JSON.stringify(res['_id']) // fbebd5d8-2b0c-43ef-8f08-9060747b751b
      cy.findOne({ _id: UUID(ID) }, { collection: 'collection' }).then(res => { // does not work
        console.log(JSON.stringify(res), 'nested findOne number > _id')
      })
    });
  })

Any thoughts/solutions?

Hi,

I'm using the Insert One method to insert data into my db, however it always returns my data as an object plus with an default set like the following:

-object()
--data
-default
---object
----data

I am unclear as to why its seeding my data in this form but is there anyway to just store it without either objects or defaults and just the data itself??

Appreciate the help, thanks!

Lisa

The mongo update command is missing.

The option to edit a data in the collection was missing.

No array filter found for identifier 'xxx' in path 'appInstance.$[].dataAccess.$[xxx].entities.$[].populateFilterExpression