from dbconfig import *
import pymysql
from datetime import datetime, date, time

db = get_mysql_param()
cnx = pymysql.connect(user=db['user'], password=db['password'],
                      host=db['host'],
                      database=db['database'])
cursor = cnx.cursor()
query = '''
select distinct m.MeetId, m.Title, v.Name, m.Date,
	e.Title, e.StartTime, e.EndTIme
from Meet m, Venue v, Event e
where m.VenueId = v.VenueId
and m.MeetId = e.MeetId;
'''

cursor.execute(query)
print('Meet report')
print('-----------')

prev_meetId = 0
for (meetId, meet_title, venue, meet_date, event,
		event_start_time, event_end_time) in cursor:
    if (prev_meetId != meetId):
        prev_meetId = meetId
        print('Meet #' + str(meetId) + ' (' + meet_title + ' at '
            + venue + ' on ' + meet_date.strftime('%m/%d/%Y'))
    print('    Event ' + event + ': ('
        + str(event_start_time) + ' to '
        + str(event_end_time) + ')')
cursor.close()
cnx.close()