3 class Sabre_CalDAV_TestUtil {
5 static function getBackend() {
7 $backend = new Sabre_CalDAV_Backend_PDO(self::getSQLiteDB());
12 static function getSQLiteDB() {
14 if (file_exists(SABRE_TEMPDIR . '/testdb.sqlite'))
15 unlink(SABRE_TEMPDIR . '/testdb.sqlite');
17 $pdo = new PDO('sqlite:' . SABRE_TEMPDIR . '/testdb.sqlite');
18 $pdo->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
20 // Yup this is definitely not 'fool proof', but good enough for now.
21 $queries = explode(';', file_get_contents(__DIR__ . '/../../../examples/sql/sqlite.calendars.sql'));
22 foreach($queries as $query) {
25 // Inserting events through a backend class.
26 $backend = new Sabre_CalDAV_Backend_PDO($pdo);
27 $calendarId = $backend->createCalendar(
31 '{DAV:}displayname' => 'user1 calendar',
32 '{urn:ietf:params:xml:ns:caldav}calendar-description' => 'Calendar description',
33 '{http://apple.com/ns/ical/}calendar-order' => '1',
34 '{http://apple.com/ns/ical/}calendar-color' => '#FF0000',
37 $backend->createCalendar(
41 '{DAV:}displayname' => 'user1 calendar2',
42 '{urn:ietf:params:xml:ns:caldav}calendar-description' => 'Calendar description',
43 '{http://apple.com/ns/ical/}calendar-order' => '1',
44 '{http://apple.com/ns/ical/}calendar-color' => '#FF0000',
47 $backend->createCalendarObject($calendarId, 'UUID-2345', self::getTestCalendarData());
52 static function getTestCalendarData($type = 1) {
54 $calendarData = 'BEGIN:VCALENDAR
56 PRODID:-//Apple Inc.//iCal 4.0.1//EN
62 RRULE:FREQ=YEARLY;UNTIL=19880507T150000Z;BYMONTH=5;BYDAY=2SU
63 DTSTART:19870510T000000
69 DTSTART:19881009T000000
75 CREATED:20100225T154229Z
76 UID:39A6B5ED-DD51-4AFE-A683-C35EE3749627
78 SUMMARY:Something here
79 DTSTAMP:20100228T130202Z';
83 $calendarData.="\nDTSTART;TZID=Asia/Seoul:20100223T060000\nDTEND;TZID=Asia/Seoul:20100223T070000\n";
86 $calendarData.="\nDTSTART:20100223T060000\nDTEND:20100223T070000\n";
89 $calendarData.="\nDTSTART;VALUE=DATE:20100223\nDTEND;VALUE=DATE:20100223\n";
92 $calendarData.="\nDTSTART;TZID=Asia/Seoul:20100223T060000\nDURATION:PT1H\n";
95 $calendarData.="\nDTSTART;TZID=Asia/Seoul:20100223T060000\nDURATION:-P5D\n";
98 $calendarData.="\nDTSTART;VALUE=DATE:20100223\n";
101 $calendarData.="\nDTSTART;VALUE=DATETIME:20100223T060000\n";
104 // No DTSTART, so intentionally broken
111 $calendarData.='ATTENDEE;PARTSTAT=NEEDS-ACTION:mailto:lisa@example.com
116 return $calendarData;
120 static function getTestTODO($type = 'due') {
125 $extra = "DUE:20100104T000000Z";
128 $extra = "DUE:20060104T000000Z";
131 $extra = "DUE;VALUE=DATE:20060104";
134 $extra = "DUE;TZID=Asia/Seoul:20060104T000000Z";
137 $extra = "DTSTART:20050223T060000Z\nDUE:20060104T000000Z";
139 case 'due_dtstart2' :
140 $extra = "DTSTART:20090223T060000Z\nDUE:20100104T000000Z";
143 $extra = 'DTSTART:20100223T060000Z';
146 $extra = 'DTSTART:20060223T060000Z';
148 case 'dtstart_date' :
149 $extra = 'DTSTART;VALUE=DATE:20100223';
152 $extra = 'DTSTART;TZID=Asia/Seoul:20100223T060000Z';
154 case 'dtstart_duration' :
155 $extra = "DTSTART:20061023T060000Z\nDURATION:PT1H";
157 case 'dtstart_duration2' :
158 $extra = "DTSTART:20101023T060000Z\nDURATION:PT1H";
161 $extra = 'COMPLETED:20060601T000000Z';
164 $extra = 'COMPLETED:20090601T000000Z';
167 $extra = 'CREATED:20060601T000000Z';
170 $extra = 'CREATED:20090601T000000Z';
172 case 'completedcreated' :
173 $extra = "CREATED:20060601T000000Z\nCOMPLETED:20070101T000000Z";
175 case 'completedcreated2' :
176 $extra = "CREATED:20090601T000000Z\nCOMPLETED:20100101T000000Z";
179 $extra = 'X-FILLER:oh hello';
182 throw new Exception('Unknown type: ' . $type);
186 $todo = 'BEGIN:VCALENDAR
188 PRODID:-//Example Corp.//CalDAV Client//EN
190 DTSTAMP:20060205T235335Z
194 UID:DDDEEB7915FA61233B861457@example.com
197 TRIGGER;RELATED=START:-PT10M