def event_exists(event):
temp = db_connect()
mydb = temp[0]
mycursor = temp[1]
events = []
print("checking if event exists")
test_statement = "SELECT id,name,date_start,time_start,date_end,time_end,idlocation FROM event WHERE name LIKE %s"
test_val = ('%' + event.name + '%', )
mycursor.execute(test_statement, test_val)
tuples = mycursor.fetchall()
for i in tuples:
events.append(dbo.tuple_to_event(i))
return events
def find_event_by_location(location):
temp = db_connect()
mydb = temp[0]
mycursor = temp[1]
events = []
event_statement = """SELECT e.id,e.name,e.date_start,e.time_start,e.date_end,e.time_end,e.idlocation
FROM event e
WHERE e.idlocation=%s"""
event_val = (location.id_, )
print("selecting events by location:", location.id_)
mycursor.execute(event_statement, event_val)
tuples = mycursor.fetchall()
for i in tuples:
events.append(dbo.tuple_to_event(i))
return events
def find_events_by_name(name):
temp = db_connect()
mydb = temp[0]
mycursor = temp[1]
events = []
event_statement = """SELECT id,name,date_start,time_start,date_end,time_end,idlocation
FROM event
WHERE name LIKE %s"""
event_val = ('%' + name + '%', )
print("selecting events by name:", name)
mycursor.execute(event_statement, event_val)
tuples = mycursor.fetchall()
for i in tuples:
events.append(dbo.tuple_to_event(i))
return events
def find_event_by_keywords_in_posts(keywords):
temp = db_connect()
mydb = temp[0]
mycursor = temp[1]
events = []
print("selecting events by keywords in posts")
for i in keywords:
event_statement = """SELECT e.id,e.name,e.date_start,e.time_start,e.date_end,e.time_end,e.idlocation
FROM event e, postevent pe, post p
WHERE e.id=pe.idevent AND p.id=pe.idPost AND (post.title LIKE %s OR post.description LIKE %s)"""
event_val = ('%' + i + '%', '%' + i + '%')
print("selecting events by keyword in posts:", i)
mycursor.execute(event_statement, event_val)
tuples = mycursor.fetchall()
for i in tuples:
events.append(dbo.tuple_to_event(i))
return events
def find_event_by_keywords(keywords):
temp = db_connect()
mydb = temp[0]
mycursor = temp[1]
events = []
print("selecting events by keywords")
for i in keywords:
event_statement = """SELECT e.id,e.name,e.date_start,e.time_start,e.date_end,e.time_end,e.idlocation
FROM event e,tag t,tagevent te
WHERE e.id=te.idevent AND t.id=te.idtag AND t.name LIKE %s"""
event_val = ('%' + i + '%', )
print("selecting events by keyword:", i)
mycursor.execute(event_statement, event_val)
tuples = mycursor.fetchall()
for i in tuples:
events.append(dbo.tuple_to_event(i))
return events
def find_events_by_date(start_date, end_date):
temp = db_connect()
mydb = temp[0]
mycursor = temp[1]
events = []
event_statement = """SELECT id,name,date_start,time_start,date_end,time_end,idlocation
FROM event
WHERE date_start BETWEEN %s %s OR date_end BETWEEN %s,%s"""
event_val = (
start_date,
end_date,
start_date,
end_date,
)
print("selecting events by date", start_date, end_date)
mycursor.execute(event_statement, event_val)
tuples = mycursor.fetchall()
for i in tuples:
events.append(dbo.tuple_to_event(i))
return events