Code 

Capstone Project Code Snippets

Gen AI Technologies used:

1. Agent

2. Function Calling

3. Grounding

4. Structured output / JSON

5. System Instruction tuning

Create local SQLite database

Populate local SQLite database with a curated list of my favorite restaurants in downtown Palo Alto and details with my dining preferences

Function Calling 1: defining ‘list_tables’ to inspect local database for tables

Function Calling 2: defining ‘describe_table’ to look up the table schema

Function Calling 3: defining Python Function ‘execute_query’ to execute an SQL statement, the return result

System Instructions: set rules and guidelines for model behavior

Model used: gemini-1.5-pro

Start Chat with Eat.Where.Now

Chat with Eat.Where.Now

Explanation…

Explanation…

Explanation…

Explanation…

Explanation…

Explanation…

Explanation…

Explanation…

Explanation…

Explanation…

Explanation…

Explanation…

Explanation…

Explanation…