User can search for a restaurant

[itsahsiao]

Requires the following:

• [x] Search form html
• [x] Search results html
• [x] Route to handle /search
• [x] Route to return /search-results, which database querying occurs to find restaurants

May need search engine, not just use search form and database querying? Need to look into.

If not enough time, backup plan is to show list of all restaurants.

[itsahsiao]

Researched about full text search engines for Python, SQLAlchemy, and Flask. Narrowed research down to two possibilities/methods to try:

SQLALchemy-Searchable https://sqlalchemy-searchable.readthedocs.io/en/latest/index.html

Flask-WhooshAlchemy http://blog.miguelgrinberg.com/post/the-flask-mega-tutorial-part-x-full-text-search https://github.com/gyllstromk/Flask-WhooshAlchemy

[itsahsiao]

• Created test_search_model.py to try implementing SQLAlchemy-Searchable, as need to modify Restaurant model to define the TSVectorType column, so that user can search by name and address of restaurant
• Imported test_search_model into server.py and seed.py, so that if it does not work, can revert back to model
• Created alternative database altbreadcrumbs and linked to it in test_search_model.py, in order to try if this works. Otherwise, can revert everythng back and still have existing db breadcrumbs
• Created search html (with the search form then passed into base template instead) and search_results html
• Under /search route, queried Restaurant in the database and used the search function to pass query and user input in, to return results.
• Tried functionality on web app and feature appears to be working!!

As SQLAlchemy-Searchable is working, will stick with it and use it.