Hello, I've been working on making a series of quizes in order to teach sqlite in a somewhat "gamificated" way (this is still in a very early state). Because of this I've made a question where students are asked to add an element to a table, leaving the contents of said element to their choice.
While I can easily check if a new element has been added since the table has an autoincrement which is used to order the table, using something like ^(number_of_elements_in_table +1).+ to make sure there is one more row on the table, I wanted to check the entire output, to make sure the students only insert a row on the table and nothing more, however pasting the actual output on the expected output doesn't seem to work.
After testing for a while the problem seems to be caused by each newline in the expected output but using \n and/or \r doesn't seem to work.
Shouldn't the output from the run result in a "correct" expected output? What am I doing wrong?
Thanks in advance and sorry if the question is written in an odd way, english isn't my first language.