prettyprinter | composable pretty printer for Python | 3D Printing library

The controller method is only returning Product object which is a JSON {} and in the andExpect method you are asserting with array of JSON [{}], remove the Optional and only pass product object

Assignment statements in Python do not copy objects, they create bindings between a target and an object. So when you are doing nameDict[n] = zeroItemDict it means a shallow copy of zeroItemDict is assigned to every key of nameList. Any changes made to zeroItemDict will reflect in all of the copies made.
To avoid this use copy.deepcopy when you're assigning zeroItemDict like this nameDict[n] = copy.deepcopy(zeroItemDict).

Note: The difference between shallow and deep copying is only relevant for compound objects

Read more about shallow and deep copy operations.

I’m not confident this is the “right” way, but here’s a way:

You create soup inside scrape_page_metadata and it is local varible which doesn't exist outside scrape_page_metadata. In while-loop you should rather use scrape_page_metadata() instead of functions Jeti_DC_16(), Jeti_DC_16_v2(), Jeti_DS_16(), Jeti_DS_16_v2()

And this functions gives you metadata which you should check instead of if(Jeti_DC_16, Jeti_DC_16_v2, Jeti_DS_16, Jeti_DS_16_v2)

More or less (you have to use correct value in place of ... because I don't know what you want to compare)

You can build a lookup function that searches for values based on your rules (get_val). Additionally, this function takes in a match list (match) of valid indices which tells the function to only traverse sublists in the dictionary that have a matching index. This way, the search function can "learn" from previous searches and only return values based on the sublist positioning of previous searches:

Although I firmly believe that your YAML structure is not the one you should have (more on that lower), here would be a query matching your expected output:

Running the command:

You are redefining the Doc type and Pretty class, so first you should delete the data and class definitions and use the ones imported from Data.Text.Prettyprint.Doc (or Prettyprinter in more recent versions of the library). Next, you want to make an instance of Pretty for Exp, whereas currently you’re writing an instance for Bool (which already exists):

I believe your goal as follows.

• You want to retrieve the values from the merged cells using gspread of python.

In your sample Spreadsheet, for example, the cells "A1:L12" are merged. Under this condition, when the values are retrieved from the merged cells of "A1:L12" using Sheets API, just to confirm, the value "row_merged" has been put to cell D2 originally. Value "col_merged" is in D6 initially. Since it's merged, the expected result should be found on all merged cells is retrieved only cell "A1". So in order to retrieve the same values from all cells of "A1:L12", it is required to put the values to the cells "A2:L12". Unfortunately, it seems that there are no methods for directly achieving this situation in Sheets API. So, in this answer, I would like to propose this using a script.

By the way, about result = ws.acell('A2') in your script, this cell is not merged and it's empty. So in this case, I think that the empty value is correct. I thought that you might have wanted to check the cell "B1". In this answer, this is also considered.