liamgarrison / locationsearchdemo Goto Github PK

Please create a database in sqlite3

Prior to importing please run in your sqlite3 shell .mode tabs

then import the .tvs file found@ @https://gitlab.com/virtualtrips/code-challenge

This will ensure that the first row in the databases become the column headers, which we use to access in our sql statements.

Please call the table locations

Please create a variables.env file

add into it two variables

PORT - for the port you want to run the app on

DATABASE = the ABSOLOUTE path of the database that now holds your location table.

hit npm run dev