Adding Predefined Calendars

Added by Jennifer Bourey, last edited by Jennifer Bourey on Jan 15, 2008  (view change)

Adding a calendar to the database

insert into calendar_store (calendar_id, calendar_listing_type, calendar_name, calendar_class)
   values (hibernate_sequence.nextval, 'PD', 'Academic Calendar', 'edu.yale.its.tp.portlets.calendar.ICalFeed');

insert into calendar_parameter (calendar_id, calendar_parameter_value, calendar_parameter_name)
   values ((select calendar_id from calendar_store where calendar_name='US Holidays'), 'http://ical.mac.com/ical/US32Holidays.ics', 'url');

Setting default roles

insert into calendar_role (calendar_id, role_name) values (
   (select calendar_id from calendar_store where calendar_name='US Holidays'),'student');
insert into calendar_role (calendar_id, role_name) values (
   (select calendar_id from calendar_store where calendar_name='US Holidays'),'staff');
insert into calendar_role (calendar_id, role_name) values (
   (select calendar_id from calendar_store where calendar_name='US Holidays'),'faculty');

Labels

 
(None)