-- Import Liturgical Events for St. Gerard's Catholic Church
-- This script populates the events table with Catholic liturgical calendar events

-- Calculate Easter for 2025 (April 20, 2025)
-- Other moveable feasts are calculated based on Easter

-- Fixed date liturgical events
INSERT INTO events (title, description, category, start_datetime, end_datetime, location, location_details, image, recurring)
VALUES 
-- January
('Solemnity of Mary, Mother of God', 'The Solemnity of Mary, Mother of God is a feast day celebrating Mary\'s motherhood of Jesus. It is a Holy Day of Obligation for Catholics, meaning they are obligated to attend Mass on this day.', 'Mass', '2025-01-01 10:00:00', '2025-01-01 11:30:00', 'St. Gerard\'s Catholic Church', 'Main Sanctuary', 'mary_mother_of_god.jpg', TRUE),

('Epiphany of the Lord', 'The Epiphany celebrates the revelation of God incarnate as Jesus Christ to the Gentiles, as represented by the Magi (Wise Men).', 'Mass', '2025-01-05 10:00:00', '2025-01-05 11:30:00', 'St. Gerard\'s Catholic Church', 'Main Sanctuary', 'epiphany.jpg', TRUE),

('Feast of the Baptism of the Lord', 'This feast celebrates Jesus\' baptism by John the Baptist in the Jordan River, marking the beginning of Jesus\' public ministry.', 'Mass', '2025-01-12 10:00:00', '2025-01-12 11:30:00', 'St. Gerard\'s Catholic Church', 'Main Sanctuary', 'baptism_of_lord.jpg', TRUE),

-- February
('Feast of the Presentation of the Lord', 'Also known as Candlemas, this feast commemorates the presentation of Jesus at the Temple and the purification of Mary.', 'Mass', '2025-02-02 10:00:00', '2025-02-02 11:30:00', 'St. Gerard\'s Catholic Church', 'Main Sanctuary', 'presentation.jpg', TRUE),

('Ash Wednesday', 'Ash Wednesday marks the beginning of Lent, a 40-day period of prayer, fasting, and almsgiving that precedes Easter.', 'Mass', '2025-03-05 18:00:00', '2025-03-05 19:30:00', 'St. Gerard\'s Catholic Church', 'Main Sanctuary', 'ash_wednesday.jpg', TRUE),

-- March
('Feast of St. Joseph, Spouse of the Blessed Virgin Mary', 'This feast honors St. Joseph, the husband of Mary and the foster father of Jesus.', 'Mass', '2025-03-19 18:00:00', '2025-03-19 19:30:00', 'St. Gerard\'s Catholic Church', 'Main Sanctuary', 'st_joseph.jpg', TRUE),

('Solemnity of the Annunciation of the Lord', 'This solemnity celebrates the announcement by the angel Gabriel to the Virgin Mary that she would conceive and bear a son through a virgin birth.', 'Mass', '2025-03-25 18:00:00', '2025-03-25 19:30:00', 'St. Gerard\'s Catholic Church', 'Main Sanctuary', 'annunciation.jpg', TRUE),

-- Holy Week
('Palm Sunday', 'Palm Sunday commemorates Jesus\' triumphal entry into Jerusalem, when palm branches were placed in his path.', 'Mass', '2025-04-13 10:00:00', '2025-04-13 11:30:00', 'St. Gerard\'s Catholic Church', 'Main Sanctuary', 'palm_sunday.jpg', TRUE),

('Holy Thursday', 'Holy Thursday commemorates the Last Supper of Jesus Christ with the Apostles and the institution of the Eucharist.', 'Mass', '2025-04-17 19:00:00', '2025-04-17 21:00:00', 'St. Gerard\'s Catholic Church', 'Main Sanctuary', 'holy_thursday.jpg', TRUE),

('Good Friday', 'Good Friday commemorates the crucifixion of Jesus and his death at Calvary.', 'Mass', '2025-04-18 15:00:00', '2025-04-18 17:00:00', 'St. Gerard\'s Catholic Church', 'Main Sanctuary', 'good_friday.jpg', TRUE),

('Holy Saturday Easter Vigil', 'The Easter Vigil is a service held in traditional Christian churches as the first official celebration of the Resurrection of Jesus.', 'Mass', '2025-04-19 20:00:00', '2025-04-19 22:30:00', 'St. Gerard\'s Catholic Church', 'Main Sanctuary', 'easter_vigil.jpg', TRUE),

('Easter Sunday', 'Easter Sunday celebrates the resurrection of Jesus from the dead, described in the New Testament as having occurred on the third day after his burial following his crucifixion.', 'Mass', '2025-04-20 10:00:00', '2025-04-20 11:30:00', 'St. Gerard\'s Catholic Church', 'Main Sanctuary', 'easter_sunday.jpg', TRUE),

('Divine Mercy Sunday', 'Divine Mercy Sunday is celebrated on the Second Sunday of Easter, focusing on the message of Divine Mercy received by St. Faustina.', 'Mass', '2025-04-27 10:00:00', '2025-04-27 11:30:00', 'St. Gerard\'s Catholic Church', 'Main Sanctuary', 'divine_mercy.jpg', TRUE),

-- May
('Ascension of the Lord', 'The Ascension of Jesus marks the departure of Christ from Earth into the presence of God in Heaven.', 'Mass', '2025-05-29 18:00:00', '2025-05-29 19:30:00', 'St. Gerard\'s Catholic Church', 'Main Sanctuary', 'ascension.jpg', TRUE),

-- June
('Pentecost Sunday', 'Pentecost commemorates the descent of the Holy Spirit upon the Apostles and other followers of Jesus.', 'Mass', '2025-06-08 10:00:00', '2025-06-08 11:30:00', 'St. Gerard\'s Catholic Church', 'Main Sanctuary', 'pentecost.jpg', TRUE),

('Trinity Sunday', 'Trinity Sunday celebrates the Christian doctrine of the Trinity, the three Persons of God: the Father, the Son, and the Holy Spirit.', 'Mass', '2025-06-15 10:00:00', '2025-06-15 11:30:00', 'St. Gerard\'s Catholic Church', 'Main Sanctuary', 'trinity_sunday.jpg', TRUE),

('Corpus Christi', 'The Solemnity of the Most Holy Body and Blood of Christ, also known as Corpus Christi, celebrates the Real Presence of Jesus in the Eucharist.', 'Mass', '2025-06-22 10:00:00', '2025-06-22 11:30:00', 'St. Gerard\'s Catholic Church', 'Main Sanctuary', 'corpus_christi.jpg', TRUE),

('Solemnity of the Sacred Heart of Jesus', 'This solemnity honors the Sacred Heart of Jesus as a symbol of divine love.', 'Mass', '2025-06-27 18:00:00', '2025-06-27 19:30:00', 'St. Gerard\'s Catholic Church', 'Main Sanctuary', 'sacred_heart.jpg', TRUE),

-- August
('Solemnity of the Assumption of the Blessed Virgin Mary', 'This solemnity celebrates the bodily taking up of the Virgin Mary into Heaven at the end of her earthly life.', 'Mass', '2025-08-15 18:00:00', '2025-08-15 19:30:00', 'St. Gerard\'s Catholic Church', 'Main Sanctuary', 'assumption.jpg', TRUE),

-- September
('Feast of the Exaltation of the Holy Cross', 'This feast commemorates the recovery of the Holy Cross by Saint Helena.', 'Mass', '2025-09-14 10:00:00', '2025-09-14 11:30:00', 'St. Gerard\'s Catholic Church', 'Main Sanctuary', 'holy_cross.jpg', TRUE),

-- October
('Parish Feast Day - St. Gerard', 'Celebration of our parish patron saint, St. Gerard Majella.', 'Community', '2025-10-16 18:00:00', '2025-10-16 21:00:00', 'St. Gerard\'s Catholic Church', 'Parish Hall and Grounds', 'st_gerard.jpg', TRUE),

-- November
('All Saints Day', 'All Saints\' Day honors all saints, known and unknown, in the Christian tradition.', 'Mass', '2025-11-01 10:00:00', '2025-11-01 11:30:00', 'St. Gerard\'s Catholic Church', 'Main Sanctuary', 'all_saints.jpg', TRUE),

('All Souls Day', 'All Souls\' Day commemorates the faithful departed.', 'Mass', '2025-11-02 10:00:00', '2025-11-02 11:30:00', 'St. Gerard\'s Catholic Church', 'Main Sanctuary', 'all_souls.jpg', TRUE),

('Solemnity of Christ the King', 'This solemnity celebrates Christ\'s kingship and marks the end of the liturgical year.', 'Mass', '2025-11-23 10:00:00', '2025-11-23 11:30:00', 'St. Gerard\'s Catholic Church', 'Main Sanctuary', 'christ_the_king.jpg', TRUE),

-- December
('First Sunday of Advent', 'Advent is a time of preparation for the coming of Christ at Christmas.', 'Mass', '2025-11-30 10:00:00', '2025-11-30 11:30:00', 'St. Gerard\'s Catholic Church', 'Main Sanctuary', 'advent.jpg', TRUE),

('Solemnity of the Immaculate Conception', 'This solemnity celebrates the Immaculate Conception of the Blessed Virgin Mary.', 'Mass', '2025-12-08 18:00:00', '2025-12-08 19:30:00', 'St. Gerard\'s Catholic Church', 'Main Sanctuary', 'immaculate_conception.jpg', TRUE),

('Feast of Our Lady of Guadalupe', 'This feast commemorates the appearance of the Virgin Mary to Juan Diego in Mexico.', 'Mass', '2025-12-12 18:00:00', '2025-12-12 19:30:00', 'St. Gerard\'s Catholic Church', 'Main Sanctuary', 'guadalupe.jpg', TRUE),

('Christmas Eve', 'Christmas celebrates the birth of Jesus Christ, the Son of God.', 'Mass', '2025-12-24 20:00:00', '2025-12-24 22:00:00', 'St. Gerard\'s Catholic Church', 'Main Sanctuary', 'christmas_eve.jpg', TRUE),

('Christmas Day', 'Christmas celebrates the birth of Jesus Christ, the Son of God.', 'Mass', '2025-12-25 10:00:00', '2025-12-25 11:30:00', 'St. Gerard\'s Catholic Church', 'Main Sanctuary', 'christmas.jpg', TRUE),

('Feast of the Holy Family', 'This feast celebrates the family unit of Jesus, Mary, and Joseph.', 'Mass', '2025-12-28 10:00:00', '2025-12-28 11:30:00', 'St. Gerard\'s Catholic Church', 'Main Sanctuary', 'holy_family.jpg', TRUE);

-- Parish-specific events
INSERT INTO events (title, description, category, start_datetime, end_datetime, location, location_details, registration_required, max_attendees, image)
VALUES 
('Parish Mission', 'Annual parish mission with guest speakers and special services. This year\'s theme: "Walking with Christ in Daily Life"', 'Formation', '2025-04-07 18:00:00', '2025-04-11 21:00:00', 'St. Gerard\'s Catholic Church', 'Main Sanctuary', FALSE, NULL, 'parish_mission.jpg'),

('First Communion', 'First Holy Communion for parish children.', 'Sacrament', '2025-05-04 14:00:00', '2025-05-04 16:00:00', 'St. Gerard\'s Catholic Church', 'Main Sanctuary', TRUE, 50, 'first_communion.jpg'),

('Confirmation', 'Confirmation ceremony with the Bishop.', 'Sacrament', '2025-05-18 14:00:00', '2025-05-18 16:00:00', 'St. Gerard\'s Catholic Church', 'Main Sanctuary', TRUE, 40, 'confirmation.jpg'),

('Parish Picnic', 'Annual parish picnic with food, games, and fellowship.', 'Community', '2025-07-12 12:00:00', '2025-07-12 16:00:00', 'St. Gerard\'s Catholic Church', 'Parish Grounds', FALSE, 200, 'parish_picnic.jpg'),

('Vacation Bible School', 'A week of faith formation and fun for children ages 5-12.', 'Formation', '2025-07-21 09:00:00', '2025-07-25 12:00:00', 'St. Gerard\'s Catholic Church', 'Parish Hall and Classrooms', TRUE, 75, 'vbs.jpg'),

('Parish Retreat', 'A weekend of prayer, reflection, and spiritual renewal.', 'Formation', '2025-09-26 17:00:00', '2025-09-28 14:00:00', 'Retreat Center', 'Full address will be provided upon registration', TRUE, 50, 'parish_retreat.jpg'),

('Advent Wreath Making', 'Families gather to make Advent wreaths and prepare for the season.', 'Community', '2025-11-29 14:00:00', '2025-11-29 16:00:00', 'St. Gerard\'s Catholic Church', 'Parish Hall', TRUE, 40, 'advent_wreath.jpg'),

('Christmas Concert', 'Annual Christmas concert featuring our parish choir and musicians.', 'Community', '2025-12-20 19:00:00', '2025-12-20 21:00:00', 'St. Gerard\'s Catholic Church', 'Main Sanctuary', FALSE, NULL, 'christmas_concert.jpg'),

('New Year\'s Eve Prayer Service', 'A special prayer service to end the year with thanksgiving and begin the new year with blessing.', 'Mass', '2025-12-31 22:30:00', '2026-01-01 00:30:00', 'St. Gerard\'s Catholic Church', 'Main Sanctuary', FALSE, NULL, 'new_years_prayer.jpg');
