def initInsertCalendars(client, principal, homeset, calendar_list):
#print(client.hostname, client.auth[0], client.auth[1], homeset.homesetUrl)
result = db_connector.query(
"INSERT INTO account VALUES (%s, %s, %s, %s)",
(client.hostname, client.auth[0], client.auth[1], homeset.homesetUrl))
for calendar in calendar_list:
result2 = db_connector.query(
"INSERT INTO calendar VALUES (%s, %s, %s, %s, %s, %s)",
(client.hostname, client.auth[0], calendar.calendarId,
calendar.calendarUrl, calendar.calendarName, calendar.cTag))
evt_list = calendar.getAllEvent()
req_headers = {"Depth": "1", "Authorization": client.auth[0]}
for evt in evt_list:
if evt.eventId.find(".ics"):
evt_name, evt_start_dt, evt_end_dt, evt_loc = icsParser(
client.hostname, calendar.calendarId, evt.eventId,
req_headers)
result3 = db_connector.query(
"INSERT INTO event "
"(host_name, user_id, calendar_id, event_id, event_url, event_name, start_dt, end_dt, location, e_tag) "
"VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s)",
(client.hostname, client.auth[0], calendar.calendarId,
evt.eventId, evt.eventUrl, evt_name, evt_start_dt,
evt_end_dt, evt_loc, evt.eTag))
def getAllEvent():
result = db_connector.query("select * from event")
rows = util.fetch_all_json(result)
for row in rows:
print(row)
print(type(row))
def updateCalendar(homeset_cal_id, cal_id, add_ics_list, update_ics_list,
delete_ics_list):
# Get auth
res = db_connector.query(
"select user_base64,user_id,host_name from account where host_name=%s",
(homeset_cal_id, ))
rows = util.fetch_all_json(res)
if rows[0]['user_base64'] is None:
return #handle error message
user_id = rows[0]['user_id']
host_name = rows[0]['host_name']
auth = "Basic " + rows[0]['user_base64']
req_headers = {"Depth": "1", "Authorization": auth}
# Add event
if add_ics_list is not None:
addEvent(homeset_cal_id, cal_id, user_id, add_ics_list, req_headers)
# Update event (Overwrite)
if update_ics_list is not None:
updateEvent(homeset_cal_id, cal_id, update_ics_list, req_headers)
# Delete event
if delete_ics_list is not None:
deleteEvent(delete_ics_list)
def deleteEvent(host_name, user_id, calendar_id, event_url):
result = db_connector.query(
"delete from event where host_name=%s and user_id = %s and calendar_id = %s and event_url = %s",
(host_name, user_id, calendar_id, event_url))
def updateEvent(host_name, user_id, calendar_id, event_url, e_tag):
result = db_connector.query(
"update event set e_tag = %s where host_name=%s and user_id = %s and calendar_id = %s and event_url = %s",
(e_tag, host_name, user_id, calendar_id, event_url))
def addEvent(host_name, user_id, calendar_id, event_url, e_tag):
result = db_connector.query(
"insert into event (host_name, user_id, calendar_id, event_id, event_url, e_tag) values (%s, %s, %s, %s, %s, %s)",
(host_name, user_id, calendar_id, util.splitIdfromUrl(event_url),
event_url, e_tag))
def updateCTag(host_name, user_id, calendar_id, c_tag):
result = db_connector.query(
"update calendar set c_tag = %s where host_name=%s and user_id = %s and calendar_id = %s",
(c_tag, host_name, user_id, calendar_id))
def selectEvents(host_name, user_id, calendar_id):
result = db_connector.query(
"select * from event where host_name = %s and user_id = %s and calendar_id= %s",
(host_name, user_id, calendar_id))
rows = util.fetch_all_json(result)
return rows
def selectAllCalendar():
result = db_connector.query("select * from calendar natural join account")
rows = util.fetch_all_json(result)
return rows
def selectAllAccount():
result = db_connector.query("select * from account")
rows = util.fetch_all_json(result)
return rows