How to use addCypressFiles method in Cypress

You can use Object.values in js to retrieve values from your object

Let's say you need to extract the value of the 3rd column, so your code will look like,

cy.task('DBQuery', query).then(function (recordset) {
    var rec = recordset
    const results = Object.values(rec[0])
    // results[index of the column] will output the results
    cy.log(results[3])
})

We can do a small modification to make your task easier,

cy.task('DBQuery', query).then(function (recordset) {
    var rec = recordset
    const Values = Object.values(rec[0]);
    const keys = Object.keys(rec[0]);
    let result = {};
    let index = 0;
    keys.forEach(key => {
        result[keys[index]] = Values[index];
        i++
    })
     //result.firstName will give you your results
     cy.log(result.firstName);
})

In this way, we are generating key-value pairs having the key as the column name. So you can use the column name to find the value.

Hope this helps.

cheers.

I think one difference could be found here: https://github.com/testing-library/cypress-testing-library#differences-from-dom-testing-library

find* commands will fail if more than one element is found that matches the criteria which is not how built-in Cypress commands work, but is provided for closer compatibility to other Testing Libraries.

That's not how contains() works. From the docs: https://docs.cypress.io/api/commands/contains.html#Single-Element

Only the first matched element will be returned

contains() also works with preferences, e.g. contains() yields <button> element even if it's higher in the tree when the deeper element is e.g. <span>. So it prefers <button> elements over deeper elements if you don't pass a selector argument the command. There're other examples in the docs for this command.

So it seems to me now that find* commands in the Cypress Testing Library more closely resemble the behaviour of other testing libraries as it's said in the docs. With contains(), you perhaps need more knowledge about how it works so you get elements you want and not some other ones because e.g. you don't understand how this preference logic works.

cy.request() makes an actual HTTP request to the url specified. This command should be used in cases where you do not want to load your actual application. Maybe you want to check an endpoint on your server, for example.

cy.route() is used to work with HTTP requests made within the application you are testing.

If you want to stub a response to an HTTP request that is being made within your application under test, you likely want to use a combination of cy.route() and .wait(). For example, to ensure that when we visit our application, a GET request is made by our application to /dummypath and that the response to this request is our stubbed {}, we would write:

describe('The new event page', () => {

  it('responds with the stub', () => {
    cy.server();
    cy.route('/dummypath', {}).as('getDummy');
    cy.visit('http://localhost:3002');         // the url to visit in your app
    cy.wait('@getDummy').its('responseBody')
      .should('be.an', 'object')
      .and('be.empty');
  });

});

Everytime you define .route('VERB', '/endpoint', ...) it overrides your previous definition. The simplest solution would be to override this endpoint after you finish your first call

This test will work for you, Filip.

cy.route('POST', 'access-tokens', '@loginFailResponse', {status: 401}).as('loginFail')
cy.get("form input[type='email']").type("bad@email.com")
cy.get("form input[type='password']").type("Bad password")
// this should fail
cy.get("form").submit()
cy.route('POST', 'access-tokens', '@loginSuccessResponse').as('loginSuccess')
cy.get("form input[type='password']").type("g00d@password.com")
// this should let me in
cy.get("form").submit()

You can shorten it a bit with jQuery operators.

$el.find(...) works since $el is a jQuery object.

Also change .invoke('text') to .text().

cy.get('.bms-scoreboard__game-tile')
  .each(($el) => {

    if ($el.hasClass('bms-scoreboard__game-tile--cancelled')) {

      // can work with jQuery operators here
      const text = $el.find('.bms-scoreboard__game-tile-status--cancelled').text()
      expect(text).equals('Cancelled')
    }

    if ($el.hasClass('bms-scoreboard__game-tile--pre-game')) {
      const text = $el.find('.bms-scoreboard__game-time--en').text()
      const gameTime = text.split(" ").pop()
      expect(['AM', 'PM']).to.include(gameTime)
    }

    if ($el.hasClass('bms-scoreboard__game-tile--final')) {
      const text = $el.find('.bms-scoreboard__game-time--en').text()
      const finalTitle = text.trim()
      expect(finalTitle).to.be.oneOf(['Final','Final (OT)'])
    }

    if ($el.hasClass('bms-scoreboard__game-tile--ongoing')) {
      const text = $el.find('.bms-scoreboard__game-time--en').text()
      const ongoingTitle = text.trim()
      expect(ongoingTitle).equals('Ongoing')
    }
  })

The text that you are getting is in string, you have to convert in into a Number (using parseInt) if you want to compare the two. And you can use this to access myAlias (As, under the hood, aliasing basic objects and primitives utilizes Mocha’s shared context object: that is, aliases are available as this.*)

cy.get('[data-cy=AmountAll]', {
    timeout: 15000
}).invoke('text').then((text) => {
    const amountAllBefore = parseInt(text.replace(/\D/g, '')) //this will only work if text.replace(/\D/g, '') returns a number but is string
    cy.wrap(amountAllBefore).as('myAlias')
})

cy.get('[data-cy=AmountAll]', {
    timeout: 15000
}).invoke('text').then((text) => {
    const amountAllAfter = = parseInt(text.replace(/\D/g, '')) //this will only work if text.replace(/\D/g, '') returns a number but is string
    expect(this.myAlias).to.be.greaterThan(amountAllAfter)
})

const dataTransfer = new DataTransfer();
    cy.get('dragNodeSelector').trigger("dragstart", {
      dataTransfer,
    });
    cy.get('dropcontainer').trigger("drop", { dataTransfer });

This code is valid for me. I think it is useful for you. You can try this.

This should be the condition you're looking for:

cy.get("body").then($body => {
  if ($body.find("button[data-cy=submitBtn]").length > 0) {   //evaluates as true
     cy.get("button[data-cy=submitBtn]")
     .click();
  }
});

I believe your question might be a duplicate of this one

Try adding this in support/index.js:

import './commands'
Cypress.on('uncaught:exception', (err, runnable) => {
  // returning false here prevents Cypress from failing the test
  return false
})

This should avoid the uncaught:exception in the click() method.