def insert():
global user
if request.method == 'POST':
date = request.form['date']
time = request.form['time']
title = request.form['title']
event_content = request.form['event_content']
data_event = Events(date, time, title, event_content)
data_event.author = user
db.session.add(data_event)
db.session.commit()
email_data = {
'subject': title,
'to': user.email,
'body': event_content
}
date_time = date + " " + time
datetime_object = datetime.strptime(date_time, '%Y-%m-%d %H:%M') - timedelta(hours=4)
eta_date = datetime.utcfromtimestamp(datetime_object.timestamp()).strftime('%Y-%m-%d %H:%M:%S')
send_async_email.apply_async(args=[email_data], eta=eta_date)
flash('New event inserted successfully')
return redirect(url_for('Index'))
def post_eevnt(payload):
error = False
response = {}
# get and check the user imput
try:
body = request.get_json()
event_name = body.get('event_name')
event_type = body.get('event_type')
date = body.get('date')
rating = body.get('rating')
provider_id = body.get('provider_id')
customer_id = body.get('customer_id')
# if event_name and event_type and date:
event = Events(id=None,
event_name=event_name,
event_type=event_type,
date=date,
rating=rating,
provider_id=provider_id,
customer_id=customer_id)
# inser event data into db
event.insert()
response['success'] = True
response['id'] = event.id
event.sesion_close()
except BaseException:
abort(400)
# return the response
return jsonify(response)
def get(self):
user = users.get_current_user()
email = self.request.get('email')
template_values = get_generic_template_values(self)
eventsQuery = Events().query()
results = eventsQuery.fetch()
if user:
#self.response.write(json.dumps(results))
# for mobile
# serialized_results = filter_results(results)
# self.response.headers['Content-Type'] = 'application/json'
# self.response.write(json.dumps(serialized_results))
template_values['results'] = results
#template = JINJA_ENVIRONMENT.get_template('/views/viewThemes.html')
#self.response.write(template.render(template_values))
elif email:
serialized_results = filter_results(results)
l = []
for r in serialized_results:
#d = serialized_results[0]
r.pop('theme_id')
r.pop('tag')
r.pop('image_urls')
l.append(r)
self.response.headers['Content-Type'] = 'application/json'
self.response.write(json.dumps(l))
def setUp(self):
self.engine = create_engine('mysql+pymysql://')
self.session = Session(engine)
Base.metadata.create_all(self.engine)
self.characters_instance = Characters(1009610, "Spider-Man")
self.session.add(self.character_instance)
self.comics_instance = Comics(30885, "Age of Heroes (Trade Paperback)")
self.session.add(self.comics_instance)
self.creators_instance = Creators(9799, "David Baldeon")
self.session.add(self.creators_instance)
self.events_instance = Events(116, "Acts of Vengeance!")
self.session.add(self.events_instance)
self.series_instance = Series(10235, "Age of Heroes (2011)")
self.session.add(self.series_instance)
self.stories_instance = Stories(483, "Interior #483")
self.session.add(self.stories_instance)
self.images_instance = Images(
1, 0, "http://i.annihil.us/u/prod/marvel/i/mg/3/40/4c06c8261544e")
self.session.add(self.images_instance)
self.session.commit()
def new_event():
title = request.json.get("title", None)
description = request.json.get("description", None)
event_datetime = request.json.get("start_datetime", None)
event_location = request.json.get("location", None)
image_url = request.json.get("image_url", None)
event_type_id = request.json.get("event_type_id", None)
organizer_id = request.json.get("organizer_id", None)
if not title or not description or not event_datetime \
or not event_location or not event_type_id:
raise BadRequest("Invalid body parameters")
try:
new_event = Events(title=title,
description=description,
start_date_time=event_datetime,
event_location=event_location,
image=image_url,
organizer_id=organizer_id,
event_type_id=event_type_id)
Events.insert(new_event)
return jsonify({"success": True, "data": new_event.serialize})
except Exception as e:
print(e)
db.session.rollback()
raise InternalServerError(f"Something went wrong on server")
def generateevent():
us = extractUser()
print(us)
u = Users(fullname=None,username=None,email=None)
index = random.randint(1,51)
s = session.query(Establishments).filter(Establishments.id == str(index))
ev = Events(dt.datetime.now(), dt.datetime.now(), 'Evennt ' + str(random.randint(1,100000)),random.randint(1,1000),s[0].id)
def post(self):
req_data = request.get_json()
errors = events_schema.validate(req_data)
data = events_schema.load(req_data)
event = Events(data)
event.create()
return {'message': 'Evento ' + event.name + " creado."}, 200
def post(self):
name = self.request.get('name')
desc = self.request.get('desc')
url = self.request.get('url')
token = self.request.get('token')
imageUrl = url + '&token=' + token
correctUrl = imageUrl.replace("images/", "images%2F")
location = self.request.get('place')
tags = self.request.get('tagValues')
themeName = self.request.get('theme')
email = self.request.get('email')
# themeQuery = Theme.query(Theme.name == themeName)
# theme_id = themeQuery.fetch(keys_only=True)
event = Events()
event.name = name
event.description = desc
event.cover_image = correctUrl
event.created_user_email = email
# event.theme_id = theme_id
#event.image_urls = listOfUrls
#event.tag = tags
#event.cover_image = random.choice(listOfUrls)
# coordinates = getCoordinates(location)
# event.place = coordinates[0]
# event.lat = coordinates[1]
# event.long = coordinates[2]
# event.created_user_email = user.email()
key = event.put()
self.response.write('Got post request: ' + name + ' ' + desc + ' ' +
location + ' ' + tags + ' ' + correctUrl + ' ' +
email + ' ' + themeName + " " + key)
def createEvent(e_info):
newEvent = Events(e_info["e_t_id"], e_info["s_id"], e_info["name"],
e_info["location"], e_info["description"])
db.session.add(newEvent)
db.session.commit()
return newEvent.e_id
def post_event(jwt):
try:
event_data = request.get_json()
team_id = event_data.get('team_id')
team_id_two = event_data.get('team_id_two')
venue_id = event_data.get('venue_id')
start_time = event_data.get('start_time')
team_one_score = event_data.get('team_one_score') or 0
team_two_score = event_data.get('team_one_score') or 0
event = Events(
team_id=team_id,
team_id_two=team_id_two,
venue_id=venue_id,
start_time=start_time,
team_one_score=team_one_score,
team_two_score=team_two_score
)
event.insert()
formatted_event = paginated_events(request, [event])
return jsonify({
'success': True,
'event': formatted_event[0]
}), 200
except Exception:
print(sys.exc_info())
abort(400)
def events():
if request.method == "POST":
my_data = json.loads(request.data.decode('utf-8'))
name = my_data['eventDate']
print(name)
event = Events(
event_name=my_data['eventName'],
event_date=my_data['eventDate']
)
try:
db.session.add(event)
# Need to commit event first so I can use the event_id to link two tables
db.session.commit()
attendees = []
for attendee in my_data['attendees']:
attendees.append(Attendance(
meetup_user_id=attendee['userId'],
event_id=event.id,
did_attend=attendee['didAttend'],
did_rsvp=attendee['didRSVP'],
title=attendee['title'],
event_host=attendee['eventHost'],
rsvp_date=attendee['rsvpDate'],
date_joined_group=attendee['dateJoinedGroup']
))
print(attendees)
print(event)
db.session.bulk_save_objects(attendees)
db.session.commit()
except Exception as exception:
print(exception)
return jsonify(my_data)
else:
events = []
for event in Events.query.order_by(Events.event_date.desc()).all():
try:
attendees = Attendance.query.filter(
Attendance.event_id == event.id, Attendance.did_attend == True).all()
rsvps = Attendance.query.filter(Attendance.event_id ==
event.id, Attendance.did_rsvp == True).all()
attendees_who_rsvpd = Attendance.query.filter(Attendance.event_id ==
event.id, Attendance.did_rsvp == True, Attendance.did_attend == True).all()
events.append({
# Needs to be string here beacuse when front end sends event id back to get attendance data
# Database expects getting rows by matching id string, not number
"id": event.id,
"name": event.event_name,
"date": event.event_date,
"attendees": len(attendees),
"rsvps": len(rsvps),
"attendeesWhoRsvpd": len(attendees_who_rsvpd)
})
except Exception as exception:
print(exception)
return "Could not get the event data"
return jsonify(data=events)
def post_event():
print("A post request to newEvent was made")
data = request.json
new_event = Events(data)
db.session.add(new_event)
db.session.commit()
return jsonify(status="success")
def post(self):
tagName = self.request.get('tag')
eventQuery = Events().query(Events.tag == tagName)
events = eventQuery.fetch()
template_values = get_generic_template_values(self)
template_values['events'] = events
template = JINJA_ENVIRONMENT.get_template('/views/search.html')
self.response.write(template.render(template_values))
def insert_events():
event_data = pandas.read_csv('events.csv', quotechar='"')
for i in range(len(event_data)):
event = Events(event_data['title'][i],
event_data['location'][i],
event_data['dateTime'][i],
event_data['description'][i],
event_data['organizer'][i],
event_data['banner'][i])
db.session.add(event)
db.session.commit()
def create():
if request.method == "POST":
new_event = Events(
name=request.form.get('name'),
location=request.form.get('location'),
#date = request.form.get('date'),
secret_code="000000",
society=current_user.name)
db.session.add(new_event)
db.session.commit()
return render_template('newevent.html')
def event(event_id):
event = Events.query.filter_by(id=event_id).one()
# handles POST method (play button to generate 6 digit code)
if request.method == "POST":
pushing_code = Events(secret_code=verify_key())
db.session.add(pushing_code)
db.session.commit()
# returns event specific page
return render_template('event.html', event=event)
def post(self):
event = Events(author=self.request.get('inputAuthor'),
title=self.request.get('inputTitle'),
description=self.request.get('inputDescription'),
type=self.request.get('inputType'),
location=self.request.get('inputLocation'),
image=self.request.get('inputImage'),
date=datetime.strptime(self.request.get('inputDate'),
'%Y-%m-%dT%H:%M'))
event.put()
return webapp2.redirect('/')
def setUp(self):
with app.app_context():
db.create_all()
#event only on single day
e = Events(name="First Test", timeblock=60, dateStart=datetime.date(2019,3,24), dateEnd=datetime.date(2019,3,24), token="easy10curl")
db.session.add(e)
u1 = Users(name="Akira", event=e)
db.session.add(u1)
db.session.add(TimeRanges(user=u1, timeStart = datetime.datetime(2019,3,24,12,0,0), timeEnd = datetime.datetime(2019,3,24,17,0,0)))
u2 = Users(name="Mugen", event=e)
db.session.add(u2)
db.session.add(TimeRanges(user=u2, timeStart = datetime.datetime(2019,3,24,7,0,0), timeEnd = datetime.datetime(2019,3,24,19,0,0)))
u3 = Users(name="Jin", event=e)
db.session.add(u3)
db.session.add(TimeRanges(user=u3, timeStart = datetime.datetime(2019,3,24,11,0,0), timeEnd = datetime.datetime(2019,3,24,13,0,0)))
u4 = Users(name="Fuu", event=e)
db.session.add(u4)
db.session.add(TimeRanges(user=u4, timeStart = datetime.datetime(2019,3,24,1,0,0), timeEnd = datetime.datetime(2019,3,24,23,0,0)))
#event spanning multiple dates
e = Events(name="Dinner With The Wife", timeblock=120, dateStart=datetime.date(2019,3,22), dateEnd=datetime.date(2019,3,24), token="weekendyea")
db.session.add(e)
u1 = Users(name="Jelani", event=e)
db.session.add(u1)
db.session.add(TimeRanges(user=u1, timeStart = datetime.datetime(2019,3,22,12,0,0), timeEnd = datetime.datetime(2019,3,23,19,0,0)))
u2 = Users(name="Ravyn Lenae", event=e)
db.session.add(u2)
db.session.add(TimeRanges(user=u2, timeStart = datetime.datetime(2019,3,23,17,0,0), timeEnd = datetime.datetime(2019,3,24,19,0,0)))
#event with no overlapping times
e = Events(name="Time Vir Can Stop Flexing", timeblock=20, dateStart=datetime.date(2019,4,22), dateEnd=datetime.date(2019,4,22), token="flexoclock")
db.session.add(e)
u1 = Users(name="Vir", event=e)
db.session.add(u1)
db.session.add(TimeRanges(user=u1, timeStart = datetime.datetime(2019,4,22,12,0,0), timeEnd = datetime.datetime(2019,4,22,19,0,0)))
u2 = Users(name="The Haters", event=e)
db.session.add(u2)
db.session.add(TimeRanges(user=u2, timeStart = datetime.datetime(2019,4,22,20,0,0), timeEnd = datetime.datetime(2019,4,22,23,0,0)))
db.session.commit()
def event_insert(request):
variables = {}
print "hello event"
if request.POST:
event = Events()
event.eve_name = request.POST.get('event_name')
event.eve_location = request.POST.get('event_location')
event.eve_date = request.POST.get('event_date')
event.eve_entry_fee = request.POST.get('event_entryfee')
event.eve_discription = request.POST.get('event_discription')
event.eve_isused = 0
event.save()
return render(request, 'clients/new_event.html', variables)
def add_event():
if not current_user.rights.can_edit_events == 1:
return abort(403)
create_form = EventUpdateForm(request.form)
if request.method == "GET":
return render_template('event_create_page.html',
create_form=create_form)
new_event = Events(event_name=request.form.get("event_name"),
event_description=request.form.get("event_description"),
event_date=request.form.get("event_date"))
db_session.add(new_event)
db_session.commit()
return redirect(url_for("events_bp.index"))
def main(session):
killer = GracefulKiller()
while (True):
s_state = getvalue()
if s_state != 3:
event = Events(semaphore_state=s_state)
session.add(event)
session.commit()
print("Evento guardado ")
time.sleep(1)
# print x
if killer.kill_now:
session.close()
break
def create():
form = CreateForm()
if form.validate_on_submit():
eventOwner = Users.query.filter_by(id=int(session['user'])).first()
new_event = Events(sport=form.sport.data,
starttime=form.starttime.data,
endtime=form.endtime.data,
date=form.date.data,
place=form.place.data,
n_ppl=form.n_ppl.data,
eventOwner=eventOwner)
db.session.add(new_event)
db.session.commit()
flash('Event successfully created by ' +
new_event.eventOwner.firstname)
return redirect('/index')
return render_template('create.html', title='Create', form=form)
def add(request):
data = get_data()
name = request.POST.get('name')
date = request.POST.get('date')
city = request.POST.get('cities')
if city:
city = city.capitalize()
if city == 'Other':
city = request.POST.get('city1').capitalize()
info = request.POST['info']
if city not in data["cities"]:
data["cities"].append(city)
manager_instance.update_city(data["cities"])
event_instance = Events(name=name, date=date, city=city, info=info)
event_instance.save()
message = "Event added!"
return HttpResponse(message)
def create_event():
print('in-create')
if request.method=='GET':
return render_template('create.html')
if request.method=='POST':
print('in post')
print(request.form)
event_name=request.form['event_name']
start_date=request.form['start_date']
end_date=request.form['end_date']
#end_date=start_date
timeblock=int(request.form['timeblock_hours'])*60+int(request.form['timeblock_min'])
#10 Digit/Char long Alphanumeric token generated randomly
token= ''.join(random.choices(string.ascii_letters + string.digits, k=10))
e = Events(name=event_name, timeblock=timeblock, dateStart=start_date, dateEnd=end_date, token=token)
db.session.add(e)
db.session.commit()
return render_template('token.html', token=token)
def get(self):
template_values = get_generic_template_values(self)
user = users.get_current_user()
theme = None
events = None
if user:
url_string = self.request.get('val')
key = ndb.Key(urlsafe=url_string)
theme = key.get()
if theme != None:
eventsQuery = Events().query(Events.theme_id == key)
events = eventsQuery.fetch()
template_values['theme'] = theme
template_values['events'] = events
template = JINJA_ENVIRONMENT.get_template('/views/singleTheme.html')
self.response.write(template.render(template_values))
def create_event():
if session.get('email'):
print(session.get('email'))
if request.method == "GET":
eventtype = ['select one', 'Public', 'Private']
return render_template("create_event.html",
title="Create Event",
eventtype=eventtype)
else:
etitle = request.form.get("title")
econtent = request.form.get("content")
ecity = request.form.get("city")
estate = request.form.get("state")
elocation = request.form.get("location")
mailid = session.get('email')
euser_id = db.session.query(
User.id).filter_by(email=mailid).first()
eventtype = request.form.get("etype")
print("EEEEE :: {}".format(eventtype))
print("D::::" + str(datetime.utcnow))
etime = request.form.get("time")
f = "%Y-%m-%dT%H:%M"
formated_time = datetime.strptime(etime, f)
print(euser_id, mailid, etime, formated_time)
try:
event = Events(title=etitle,
content=econtent,
event_type=eventtype,
user_id=euser_id[0],
city=ecity,
state=estate,
location=elocation,
date_posted=formated_time)
print(etitle, econtent, ecity, estate, elocation, euser_id)
db.session.add(event)
db.session.commit()
flash("Created Event Successful")
return redirect(url_for("home"))
except Exception as error:
print(error)
return redirect(url_for("home"))
def post(self):
created_user_id = ""
user = users.get_current_user()
if user:
listOfUrls = []
i = 0
while True:
f = self.request.POST.get("file[{}]".format(i))
if type(f) == type(None):
break
else:
url = writeToGCBucket(f)
listOfUrls.append(url)
i += 1
created_user_id = user.user_id()
themeName = self.request.get('meetupTheme')
meetupName = self.request.get('meetupName')
tags = self.request.get('meetupTags[]', allow_multiple=True)
desc = self.request.get('meetupDescription')
location = self.request.get('location')
coordinates = getCoordinates(location)
themeQuery = Theme.query(Theme.name == themeName)
theme_id = themeQuery.fetch(keys_only=True)
event = Events()
event.name = meetupName
event.description = desc
event.created_user_id = created_user_id
event.theme_id = theme_id
event.image_urls = listOfUrls
event.tag = tags
event.cover_image = random.choice(listOfUrls)
event.place = coordinates[0]
event.lat = coordinates[1]
event.long = coordinates[2]
event.created_user_email = user.email()
key = event.put()
self.redirect('/manageMeetups')
def process_item(self, item, spider):
"""Save events in the database.
This method is called for every item pipeline component.
"""
session = self.Session()
event = Events(**item)
try:
session.add(event)
session.commit()
except:
session.rollback()
#raise
print '[WeixiaoCrawler] - this event already exists ... '
finally:
session.close()
return item
def events(request):
if request.method == 'GET':
print "hello"
Event_title = request.GET.get('Event_title')
print Event_title
Event_desc = request.GET.get('Event_desc')
# Event_date =
Event_date = datetime.strptime(request.GET.get('Event_date'),
'%b %d %Y %I:%M%p')
print Event_date
Event_location = request.GET.get('Event_location')
Event_org = \
Users.objects.get(user_email=request.GET.get('user_email'))
new_event = Events(Event_title=Event_title,
Event_location=Event_location,
Event_date=Event_date,
Event_desc=Event_desc,
Event_org=Event_org)
new_event.save()
return HttpResponse(json.dumps({'success': 'True'}),
content_type='application/json')
def events():
if (request.method == 'GET'):
events = Events.query.all()
events_list = [{'name': e.name, 'date': e.date} for e in events]
return jsonify(events_list)
elif (request.method == 'POST'):
new_event = json.loads(request.data)
event = Events(name=new_event['name'], date=new_event['date'])
event.save()
return jsonify(new_event)
elif (request.method == 'DELETE'):
event_names = json.loads(request.data)
for event_name in event_names:
event = Events.query.filter_by(name=event_name).first()
print(event_name)
event.delete()
return jsonify(event_names)
