fixed an error due to the way prepared statements inserts parameters by
using ST_GeomFromText with a linestring instead of trying to insert SQL
routines. (its a good thing this didn't work because that would be a
source of sql injection)

Changed geometrySearch/polygon from a POST back to GET since the error
had to do with the prepared statement rather than sending a body in a
GET.

Tests are in progress
Had to break other tests because of lat/lon y/x mixup. Will fix soon.

Made parameters required for geometry search

Users can give a lon,lat point and a radius and query for assets within
the circle

The envelope search returns the assets that are located within a
rectangle created from the bounds minLat, minLon, maxLat, maxLon.

Removing broken url-join usage.

* WIP Added controller for projects

* LWC for creating new projects.

Added an LWC for creating a new project in the open source database

* Added projects find tests

* Adding update/edit options from display table

* Added Tests and cleaned up code

* Adding newlines to end of files

* putting connection url back to deploy url

* Another new line

* Added titles and icons to lwcs

* Updating tests

* Updated Tests

* Added listener to refresh project table

Project table will refresh when a project is created in a different lwc

* Using URL instead of strings for url building

* Clearing inputs when successfully saved

* Fixing tests and removing unused variables

* Triggering tests

* triggering test

* changing expected type to Number

* Triggering tests

* Triggering tests

* triggering tests

* adding url join dependency

* fixing error

Added CORS methods to header

 Please enter the commit message for your changes. Lines starting

* Added skeleton tests/funcs for projects feature

All tests currently run and FAIL

Added TODOs that will need to be addressed before being feature
complete.

Added project modules to indexes.

Beginning implementation of projects find functionality

* Fixing copy and paste error.

* Added projectName validator and tests.

Projects find now can take a name parameter to find projects with a
specified name. This search is case insensitive.

Tests for the new validator pass

* Using && instead of & to evaluate validation

If the type of the variable we are evaluating is undefined, we do not
want to continue. Trying to call length on something that is not a
string can cause failures

* Completing projects.db find tests

* Added controller tests for project find

All project find tests pass

* Adding descriptions to sample projects

* Fixing table name

* Projects response code 200 tests pass

* Added Tests for finding projects with parameters

* Added test for invalid query

* Created Project enpoint and Validator

Added test for Validator

* Added Create Project Controller Module and Tests

* Added Project create db module and tests

* Adding semicolon

* Fixing property error

* Added Client Create Project Tests

Seperated GET and POST Tests

* Added tests and implementation for PUT/ update

All tests pass

* Updating tests to pass bad requests

* Adding API documentation

* Fixed some formatting. Removed old Todos.

Updated some comments

* using querybuilder for url testing

removed todos and some commented out code

* Fixing Grammar Error

* fixing more spelling mistakes

* Committing updated test sql

* Space

* Space

* Update index.js

* Update projects.db.test.js

* Update index.js

* Update projects.db.js

* Update validate.test.js

* Update projects.json

* Update Project.json

* Update validate.js

* Update index.js

Should have been committed with previous PR

* Added skeleton tests/funcs for projects feature

All tests currently run and FAIL

Added TODOs that will need to be addressed before being feature
complete.

Added project modules to indexes.

Beginning implementation of projects find functionality

* Fixing copy and paste error.

* Added projectName validator and tests.

Projects find now can take a name parameter to find projects with a
specified name. This search is case insensitive.

Tests for the new validator pass

* Using && instead of & to evaluate validation

If the type of the variable we are evaluating is undefined, we do not
want to continue. Trying to call length on something that is not a
string can cause failures

* Completing projects.db find tests

* Added controller tests for project find

All project find tests pass

* Adding descriptions to sample projects

* Fixing table name

* Projects response code 200 tests pass

* Added Tests for finding projects with parameters

* Added test for invalid query

* Created Project enpoint and Validator

Added test for Validator

* Added Create Project Controller Module and Tests

* Added Project create db module and tests

* Adding semicolon

* Fixing property error

* Added Client Create Project Tests

Seperated GET and POST Tests

* Added tests and implementation for PUT/ update

All tests pass

* Updating tests to pass bad requests

* Adding API documentation

* Fixed some formatting. Removed old Todos.

Updated some comments

* using querybuilder for url testing

removed todos and some commented out code

* Fixing Grammar Error

* fixing more spelling mistakes

Changed build stage names

* Changing checkout branch from master to git branch

Added basic information to the readme

Webhook test

Async fix