Queries

[lexadecimals]

Good job on all of your tests. Very impressive that you managed to set them up and write so many :corn:

At the moment all of your queries are coming from one query in the db_build.js file where you are sending through a different sql string. What you need to do now is

1- take this query outside of the db_build file. 2 - create separate queries for each query you want to make to the database.

So, you could create a folder called queries and have a page full of individual queries. Or, you could put each of these queries into their own file.

You will then need to update the tests so that they are calling the specific query rather than writing the query in a string inside the test.

Example of file of queries:

[lexadecimals]

I've got a better example with error handling. one sec ....

[lexadecimals]