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