-
Notifications
You must be signed in to change notification settings - Fork 0
/
streamlit_app.py
59 lines (45 loc) · 1.82 KB
/
streamlit_app.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
# Import python packages
import streamlit as st
from snowflake.snowpark.functions import col
import requests
import pandas as pd
# Write directly to the app
st.title("Customize your Smoothie! :cup_with_straw:")
st.write(
"""
Choose the fruits you want in your custom Smoothie!
"""
)
name_on_order = st.text_input('Name on Smoothie:')
st.write('The name on your smoothie will be:', name_on_order)
cnx = st.connection("snowflake")
session = cnx.session()
my_dataframe = session.table("smoothies.public.fruit_options").select(col('FRUIT_NAME'), col('SEARCH_ON'))
# st.dataframe(data=my_dataframe, use_container_width=True)
# st.stop()
# Convert the Snowpark Dataframe to a Pandas Dataframe so we can use the LOC function
pd_df = my_dataframe.to_pandas()
# st.dataframe(pd_df)
# st.stop()
ingredients = st.multiselect(
'Choose up to 5 ingredients:',
my_dataframe,
max_selections=5
)
if ingredients:
ingredients_str = ''
for fruit in ingredients:
ingredients_str += fruit + ' '
search_on = pd_df.loc[pd_df['FRUIT_NAME'] == fruit, 'SEARCH_ON'].iloc[0]
st.write('The search value for ', fruit, ' is ', search_on, '.')
st.subheader(fruit + ' Nutrition Information')
fruityvice_response = requests.get("https://fruityvice.com/api/fruit/" + search_on)
fruityvice_df = st.dataframe(data=fruityvice_response.json(), use_container_width=True)
# st.write(ingredients_str)
my_insert_stmt = """ insert into smoothies.public.orders(ingredients, name_on_order)
values ('""" + ingredients_str + """','""" + name_on_order + """')"""
# st.write(my_insert_stmt)
time_to_insert = st.button('Submit Order')
if time_to_insert:
session.sql(my_insert_stmt).collect()
st.success(f'Your Smoothie is ordered, {name_on_order}!', icon="✅")