def pairs_per_brand():
conn = data_hooks.db_connect()
pairs_per_brand = data_api.generate_pairs_per_brand_df(conn)
response = Response(pairs_per_brand.to_csv(index=False))
response.headers['Content-Type'] = 'text/csv'
response.headers['Access-Control-Allow-Origin'] = '*'
return response
def add_manufacturer():
form = ManufacturerAddForm()
if form.validate_on_submit():
conn = data_hooks.db_connect()
inserted_id = data_hooks.manufacturer_insert(
conn, form.manufacturer_name.data, form.collaborator_name.data)
flash(inserted_id)
conn.close()
return redirect(url_for('index'))
return render_template('manufacturer_add.html',
title='Event logged',
form=form)
def log_sneaker_event():
form = SneakerEventForm()
if form.validate_on_submit():
conn = data_hooks.db_connect()
event = data_hooks.sneaker_event_insert(
conn,
form.sneaker_id.data,
form.event_type.data,
config=data_hooks.readConfigs())
flash(event)
conn.close()
return redirect(url_for('index'))
return render_template('sneaker_event.html',
title='Event logged',
form=form)
def add_sneakers():
form = SneakerAddForm()
if form.validate_on_submit():
conn = data_hooks.db_connect()
inserted_id = data_hooks.sneaker_insert(conn, form.sneaker_name.data,
form.color.data,
form.purchase_price.data,
form.manufacturer_id.data)
if inserted_id:
event = data_hooks.sneaker_event_insert(conn,
inserted_id,
'add',
config=None)
flash('Inserted ID: ' + str(inserted_id))
conn.close()
return redirect(url_for('index'))
return render_template('sneaker_add.html', title='Event logged', form=form)
def sms_reply():
"""Respond to incoming calls with a simple text message."""
user_term = request.values.get('Body', None)
resp = MessagingResponse()
conn = data_hooks.db_connect()
if user_term.isnumeric() == False:
#List sneakers if user sends a string
sneakers_dict = dict(
data_hooks.available_sneakers_search(conn, user_term.lower()))
formatted_sneakers_list = '\n'.join([
'%s - %s' % (key, value)
for (key, value) in sorted(sneakers_dict.items())
])
if len(formatted_sneakers_list) > 0:
resp.message(
"Which pair exactly?\n\n {}\n\nEnter another search term to try again."
.format(formatted_sneakers_list))
else:
resp.message(
"That search didn't return any results. Try again. Or don't, life is meaningless."
)
else:
#Update database if user sends a sneaker ID
#validate given sneaker ID is in the database
available_ids = data_hooks.list_available_sneaker_ids(conn)
if int(user_term) in available_ids:
data_hooks.sneaker_event_insert(conn=conn,
sneaker_id=user_term,
event_type='wear',
event_time=datetime.utcnow(),
config=None)
resp.message(
"Wear recorded for sneaker_id {}. Wear them while you still can."
.format(user_term))
else:
resp.message(
"That sneaker_id doesn't exist in the SNQL database or isn't owned (yet). Try searching again or entering a sneaker_id directly. Or don't, life is meaningless."
)
return str(resp)
def remove_sneakers():
form = SneakerTrashOrGiveForm()
if form.validate_on_submit():
conn = data_hooks.db_connect()
event = data_hooks.sneaker_event_insert(
conn=conn,
sneaker_id=form.sneaker_to_remove.data,
event_type=form.remove_type.data,
event_time=form.remove_date.data or datetime.utcnow(),
config=None)
remove_update = data_hooks.sneaker_remove(
conn=conn,
sneaker_id=form.sneaker_to_remove.data,
remove_type=form.remove_type.data,
event_time=form.remove_date.data or datetime.utcnow())
flash(event, remove_update)
conn.close()
return redirect(url_for('index'))
return render_template('sneaker_remove.html',
title='Event logged',
form=form)
def __init__(self, *args, **kwargs):
super().__init__(*args, **kwargs)
self.sneaker_to_remove.choices = data_hooks.list_available_sneakers(data_hooks.db_connect())
def __init__(self, *args, **kwargs):
super().__init__(*args, **kwargs)
self.manufacturer_id.choices = data_hooks.list_available_manufacturers(data_hooks.db_connect())