bahia | commandline acceptance testing - aruba | Unit Testing library

I think the problem is in the object you call in html2canvas. I made a codesandbox where I use an accordion and capture the open element to render it on a canvas.

The steps are:

1. Get the panel that is open
2. Get the panel dimensions to resize the canvas and clean the canvas
3. Paint on the canvas
4. Download image

I leave below the most important function

You need conditional aggregation:

As suggested in the comments, you could try like this:

https://docs.aws.amazon.com/redshift/latest/dg/r_patternmatching_condition_like.html

LIKE performs a case-sensitive pattern match. ILIKE performs a case-insensitive pattern match for single-byte UTF-8 (ASCII) characters. To perform a case-insensitive pattern match for multibyte characters, use the LOWER function on expression and pattern with a LIKE condition.

I think the problem is coming from that Redshift does not actually understand Unicode.

Redshift stores into a varchar whatever bit-patterns you put in there, valid Unicode or not.

When it performs comparisons, it's performing a byte-by-byte comparison, not a character-by-character comparison.

I think there are some functions which understand Unicode, such as upper() and lower() - they're written separately to the main code base. You have to understand Unicode to change the case of a multi-byte UTF-8 character; but LIKE and ILIKE do not, they're operators, not functions, so they are from the core database code base, which is not Unicode aware. You have to do some work for them, using the Unicode-aware functions, to allow them to function correctly.

BTW, it was a fascenating question and answer also. Thankyou for asking.

The question is not very clear in parts and the example files do not have much structure to them. See the code below as an example and do note that getting the Name looks a bit weak to me (though it does seem to work for the example files).

Apologies if there is something obviously wrong in the output. I cannot speak Portuguese so I did not look too hard at the exact words.

Maybe:

You can check the below lines of code

You can simplify the process of adding Regioes but you also seem to have a problem with the encoding of the character sets within the data. I read your data with the following code:

If you managed to extract that string, then you could apply SUBSTR + INSTR combination to it, e.g.

Unfortunately, I believe there is NO choice for you to do this. The reason is that with new frontend technologies the html is rendered asynchronous and it requires "real" environment for javascript to be able to run and load the page. For example, with Ajax, you will need a real browser (Chrome, Firefox) to make it work. So, my suggestion is you should keep digging deeper into Selenium and mimic the click event to click each page (clicking on page number like 1..2..3 until the end) then wait until the data loaded, then read the html and extract the data you need. Regards.