def delete():
id_to_delete = request.form['trip_event_id']
FileAttachment.delete().where(
FileAttachment.parent_event == id_to_delete).execute()
PhotoAttachment.delete().where(
PhotoAttachment.parent_event == id_to_delete).execute()
TripEvent.delete().where(TripEvent.id == id_to_delete).execute()
trip_deleted = TripEvent.get_or_none(TripEvent.id == id_to_delete) == None
result = jsonify({
'status': trip_deleted,
})
return result
def new_photo(id):
trip_event = TripEvent.get_or_none(TripEvent.id == id)
new_photo = None
if trip_event and 'photo' in request.files:
uploaded_photo = request.files['photo']
parent_trip = trip_event.parent_trip
parent_user = parent_trip.parent_user
upload_to_s3(
uploaded_photo, S3_BUCKET,
f'photos/{parent_trip.id}/{trip_event.id}/{parent_user.id}')
new_photo = PhotoAttachment.create(
url=
f"{parent_trip.id}/{trip_event.id}/{parent_user.id}/{uploaded_photo.filename}",
parent_event=trip_event.id,
title=uploaded_photo.filename)
photo_uploaded = (new_photo != None)
returned_data = None
if photo_uploaded:
returned_data = new_photo.as_dict()
result = jsonify({'status': photo_uploaded, 'data': returned_data})
return result
def new_file(id):
trip_event = TripEvent.get_or_none(TripEvent.id == id)
new_file = None
if trip_event and 'file' in request.files:
uploaded_file = request.files['file']
parent_trip = trip_event.parent_trip
parent_user = parent_trip.parent_user
upload_to_s3(
uploaded_file, S3_BUCKET,
f'files/{parent_trip.id}/{trip_event.id}/{parent_user.id}')
new_file = FileAttachment.create(
url=
f"{parent_trip.id}/{trip_event.id}/{parent_user.id}/{uploaded_file.filename}",
parent_event=trip_event.id,
title=uploaded_file.filename)
file_uploaded = (new_file != None)
returned_data = None
if file_uploaded:
returned_data = new_file.as_dict()
result = jsonify({'status': file_uploaded, 'data': returned_data})
return result
def show(id):
selected_trip = TripEvent.get_or_none(TripEvent.id == id)
found_trip = (selected_trip != None)
return_dict = None
if (found_trip):
selected_trip.as_dict()
result = jsonify({'status': found_trip, 'data': return_dict})
return result
def events(trip_id):
selected_events = TripEvent.select().where(
TripEvent.parent_trip_id == trip_id).order_by(
TripEvent.date_time.desc())
event_list = []
for e in selected_events:
event_list.append(e.as_dict())
result = jsonify({'data': event_list})
return result
def notification_check():
now = datetime.now()
events_to_notify = TripEvent.select().where(
(TripEvent.notification_sent == False)
& (now.year - TripEvent.date_time.year == 0)
& (now.month - TripEvent.date_time.month == 0)
& (now.day - TripEvent.date_time.day == 0)
& (now.hour - TripEvent.date_time.hour == 0))
notify_events(events_to_notify)
def create():
data = request.form
new_trip_event = TripEvent.create(
parent_trip=data['parent_trip'],
event_name=data['event_name'],
date_time=data['date_time'],
location_address=data['location_address'],
latitude=data['latitude'],
longitude=data['longitude'],
desc=data['desc'])
result = jsonify({'status': True, 'data': new_trip_event.as_dict()})
return result
def edit(id):
data = request.form
selected_trip_event = TripEvent.get_or_none(TripEvent.id == id)
found_selected_trip = (selected_trip_event != None)
return_dict = None
if (found_selected_trip):
selected_trip_event.event_name = data['event_name']
selected_trip_event.date_time = data['date_time']
selected_trip_event.location_address = data['location_address']
selected_trip_event.latitude = data['latitude']
selected_trip_event.longitude = data['longitude']
selected_trip_event.desc = data['desc']
selected_trip_event.save()
return_dict = selected_trip_event.as_dict()
result = jsonify({'status': found_selected_trip, 'data': return_dict})
return result
'parent_trip': Trip.select().first().id + 1,
'date_time': datetime(2019, 4, 18),
'location': 'California'
}, {
'parent_trip': Trip.select().first().id + 2,
'date_time': datetime(2019, 3, 22),
'location': 'Arizona'
}, {
'parent_trip': Trip.select().first().id + 3,
'date_time': datetime(2019, 4, 2),
'location': 'Florida'
}]
for te in tripevent_list:
TripEvent.create(parent_trip=te['parent_trip'],
date_time=te['date_time'],
location=te['location'])
# File Attachments
from models.file_attachment import FileAttachment
file_list = [{
'parent_event': TripEvent.select().first().id,
'url': 'uploadplace.com/files/test_file1.file'
}, {
'parent_event': TripEvent.select().first().id + 1,
'url': 'uploadplace.com/files/test_file2.file'
}, {
'parent_event': TripEvent.select().first().id + 1,
'url': 'uploadplace.com/files/test_file.txt'
}, {
from models.user import User from models.trip import Trip from models.trip_event import TripEvent from models.file_attachment import FileAttachment from models.photo_attachment import PhotoAttachment from models.payment import Payment from models.subscription import Subscription FileAttachment.delete().execute() PhotoAttachment.delete().execute() Subscription.delete().execute() Payment.delete().execute() User.delete().execute() Trip.delete().execute() TripEvent.delete().execute()
def index():
trip_event_list = [t.as_dict() for t in TripEvent.select()]
result = jsonify({'data': trip_event_list})
return result