From 9e3c08db40b8916968b9f30096c7be3f00ce9647 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sun, 21 Apr 2024 13:44:51 +0200 Subject: Adding upstream version 1:115.7.0. Signed-off-by: Daniel Baumann --- comm/calendar/test/unit/data/bug1790339.sql | 194 ++++++++++++++++++++++++++++ comm/calendar/test/unit/data/import.ics | 24 ++++ 2 files changed, 218 insertions(+) create mode 100644 comm/calendar/test/unit/data/bug1790339.sql create mode 100644 comm/calendar/test/unit/data/import.ics (limited to 'comm/calendar/test/unit/data') diff --git a/comm/calendar/test/unit/data/bug1790339.sql b/comm/calendar/test/unit/data/bug1790339.sql new file mode 100644 index 0000000000..ad464de995 --- /dev/null +++ b/comm/calendar/test/unit/data/bug1790339.sql @@ -0,0 +1,194 @@ +-- Data for test_bug1790339.js. There's two events here, one saved with folded ICAL strings +-- (as libical would do) and one with unfolded ICAL strings (as ical.js does). +-- +-- This file contains significant white-space and is deliberately saved with Windows line-endings. + +CREATE TABLE cal_calendar_schema_version (version INTEGER); +CREATE TABLE cal_attendees ( + item_id TEXT, + recurrence_id INTEGER, + recurrence_id_tz TEXT, + cal_id TEXT, + icalString TEXT); +CREATE TABLE cal_recurrence (item_id TEXT, cal_id TEXT, icalString TEXT); +CREATE TABLE cal_properties ( + item_id TEXT, + key TEXT, + value BLOB, + recurrence_id INTEGER, + recurrence_id_tz TEXT, + cal_id TEXT); +CREATE TABLE cal_events ( + cal_id TEXT, + id TEXT, + time_created INTEGER, + last_modified INTEGER, + title TEXT, + priority INTEGER, + privacy TEXT, + ical_status TEXT, + flags INTEGER, + event_start INTEGER, + event_end INTEGER, + event_stamp INTEGER, + event_start_tz TEXT, + event_end_tz TEXT, + recurrence_id INTEGER, + recurrence_id_tz TEXT, + alarm_last_ack INTEGER, + offline_journal INTEGER); +CREATE TABLE cal_todos ( + cal_id TEXT, + id TEXT, + time_created INTEGER, + last_modified INTEGER, + title TEXT, + priority INTEGER, + privacy TEXT, + ical_status TEXT, + flags INTEGER, + todo_entry INTEGER, + todo_due INTEGER, + todo_completed INTEGER, + todo_complete INTEGER, + todo_entry_tz TEXT, + todo_due_tz TEXT, + todo_completed_tz TEXT, + recurrence_id INTEGER, + recurrence_id_tz TEXT, + alarm_last_ack INTEGER, + todo_stamp INTEGER, + offline_journal INTEGER); +CREATE TABLE cal_tz_version (version TEXT); +CREATE TABLE cal_metadata (cal_id TEXT, item_id TEXT, value BLOB); +CREATE TABLE cal_alarms ( + cal_id TEXT, + item_id TEXT, + recurrence_id INTEGER, + recurrence_id_tz TEXT, + icalString TEXT); +CREATE TABLE cal_relations ( + cal_id TEXT, + item_id TEXT, + recurrence_id INTEGER, + recurrence_id_tz TEXT, + icalString TEXT); +CREATE TABLE cal_attachments ( + item_id TEXT, + cal_id TEXT, + recurrence_id INTEGER, + recurrence_id_tz TEXT, + icalString TEXT); +CREATE TABLE cal_parameters ( + cal_id TEXT, + item_id TEXT, + recurrence_id INTEGER, + recurrence_id_tz TEXT, + key1 TEXT, + key2 TEXT, + value BLOB); + +INSERT INTO cal_calendar_schema_version VALUES (23); + +INSERT INTO cal_events ( + cal_id, + id, + time_created, + last_modified, + title, + flags, + event_start, + event_end, + event_stamp, + event_start_tz, + event_end_tz +) VALUES ( + '00000000-0000-0000-0000-000000000000', + '00000000-0000-0000-0000-111111111111', + 1663028606000000, + 1663030277000000, + 'test', + 86, + 1663032600000000, + 1663037100000000, + 1663030277000000, + 'Pacific/Auckland', + 'Pacific/Auckland' +), ( + '00000000-0000-0000-0000-000000000000', + '00000000-0000-0000-0000-222222222222', + 1663028606000000, + 1663030277000000, + 'test', + 86, + 1663032600000000, + 1663037100000000, + 1663030277000000, + 'Pacific/Auckland', + 'Pacific/Auckland' +); + +INSERT INTO cal_attachments (cal_id, item_id, icalString) VALUES ( + '00000000-0000-0000-0000-000000000000', + '00000000-0000-0000-0000-111111111111', + 'ATTACH:https://ftp.mozilla.org/pub/thunderbird/nightly/latest-comm-central + /thunderbird-106.0a1.en-US.linux-x86_64.tar.bz2' +), ( + '00000000-0000-0000-0000-000000000000', + '00000000-0000-0000-0000-222222222222', + 'ATTACH:https://ftp.mozilla.org/pub/thunderbird/nightly/latest-comm-central/thunderbird-106.0a1.en-US.linux-x86_64.tar.bz2' +); + +INSERT INTO cal_attendees (cal_id, item_id, icalString) VALUES ( + '00000000-0000-0000-0000-000000000000', + '00000000-0000-0000-0000-111111111111', + 'ATTENDEE;PARTSTAT=NEEDS-ACTION;ROLE=REQ-PARTICIPANT;CN=Test Person:mailto: + test@example.com' +), ( + '00000000-0000-0000-0000-000000000000', + '00000000-0000-0000-0000-222222222222', + 'ATTENDEE;PARTSTAT=NEEDS-ACTION;ROLE=REQ-PARTICIPANT;CN=Test Person:mailto:test@example.com' +); + +INSERT INTO cal_recurrence (cal_id, item_id, icalString) VALUES ( + '00000000-0000-0000-0000-000000000000', + '00000000-0000-0000-0000-111111111111', + 'RRULE:FREQ=WEEKLY;UNTIL=20220913T013000Z;INTERVAL=22;BYDAY=MO,TU,WE,TH,FR, + SA,SU' +), ( + '00000000-0000-0000-0000-000000000000', + '00000000-0000-0000-0000-222222222222', + 'RRULE:FREQ=WEEKLY;UNTIL=20220913T013000Z;INTERVAL=22;BYDAY=MO,TU,WE,TH,FR,SA,SU' +); + +INSERT INTO cal_relations (cal_id, item_id, icalString) VALUES ( + '00000000-0000-0000-0000-000000000000', + '00000000-0000-0000-0000-111111111111', + 'RELATED-TO;RELTYPE=SIBLING:19960401-080045-4000F192713@ + example.com' +), ( + '00000000-0000-0000-0000-000000000000', + '00000000-0000-0000-0000-222222222222', + 'RELATED-TO;RELTYPE=SIBLING:19960401-080045-4000F192713@example.com' +); + +INSERT INTO cal_alarms (cal_id, item_id, icalString) VALUES ( + '00000000-0000-0000-0000-000000000000', + '00000000-0000-0000-0000-111111111111', + 'BEGIN:VALARM +ACTION:DISPLAY +TRIGGER:-PT5M +DESCRIPTION:Make sure you don''t miss this very very important event. It''s + essential that you don''t forget. +END:VALARM +' +), ( + '00000000-0000-0000-0000-000000000000', + '00000000-0000-0000-0000-222222222222', + 'BEGIN:VALARM +ACTION:DISPLAY +TRIGGER:-PT5M +DESCRIPTION:Make sure you don''t miss this very very important event. It''s essential that you don''t forget. +END:VALARM +' +); diff --git a/comm/calendar/test/unit/data/import.ics b/comm/calendar/test/unit/data/import.ics new file mode 100644 index 0000000000..b6e7a965d7 --- /dev/null +++ b/comm/calendar/test/unit/data/import.ics @@ -0,0 +1,24 @@ +BEGIN:VCALENDAR +PRODID:-//Mozilla.org/NONSGML Mozilla Calendar V1.1//EN +VERSION:2.0 +BEGIN:VEVENT +SUMMARY:Event One +DTSTART:20190101T150000 +DTEND:20190101T160000 +END:VEVENT +BEGIN:VEVENT +SUMMARY:Event Four +DTSTART:20190101T180000 +DTEND:20190101T190000 +END:VEVENT +BEGIN:VEVENT +SUMMARY:Event Three +DTSTART:20190101T170000 +DTEND:20190101T180000 +END:VEVENT +BEGIN:VEVENT +SUMMARY:Event Two +DTSTART:20190101T160000 +DTEND:20190101T170000 +END:VEVENT +END:VCALENDAR -- cgit v1.2.3