freealberta/scripts/update-campaigns-with-evidence-emails.js

#!/usr/bin/env node
/**
 * Update campaigns with:
 * - Short, concise descriptions
 * - Evidence-based email content
 *
 * Run with: node scripts/update-campaigns-with-evidence-emails.js
 */

const https = require('https');

// NocoDB Configuration
const NOCODB_API_TOKEN = 'H3z5PEgvrC25LDRuvRpF1wuzsByG9PCem5DHyjPj';
const CAMPAIGNS_TABLE_ID = 'mh98emvhot9gjrg';

// ============================================================================
// CAMPAIGN DATA - Short descriptions + Evidence-based emails
// ============================================================================
const campaignData = {
  // ========================
  // EDUCATION CAMPAIGNS
  // ========================
  'learning-access': {
    description: 'Support accessible education for all Albertans regardless of age, income, or location.',
    email_subject: 'Constituent Request: Restore Education Funding',
    email_body: `Dear [Representative Name],

I am writing as your constituent about the state of education in Alberta.

Our education system is in crisis:
- Post-secondary funding has been cut 31% since 2015
- Class sizes continue to grow beyond manageable levels
- Rural communities have limited access to educational opportunities
- Student debt burdens discourage Albertans from pursuing further education

I urge you to advocate for:
- Restored and increased education funding
- Affordable post-secondary education for all
- Expanded access for rural and remote learners
- Support for adult education and retraining programs

An educated population is an innovative, prosperous population. Please make education investment a priority.

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'higher-learning': {
    description: 'Make post-secondary education accessible and affordable for all Albertans.',
    email_subject: 'Constituent Request: Address Post-Secondary Funding Crisis',
    email_body: `Dear [Representative Name],

I am writing about the crisis in post-secondary education in Alberta.

The facts are alarming:
- Post-secondary funding has dropped 31% since 2015
- Tuition increases are outpacing inflation
- Research funding is declining, threatening Alberta's innovation capacity
- Graduate student supports are insufficient

Alberta's future depends on an educated workforce. I urge you to advocate for:
- Increased funding for colleges and universities
- Tuition caps to keep education affordable
- Enhanced support for research and innovation
- Better financial aid for students

Please champion accessible higher education in the Legislature.

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'higher-education': {
    description: 'Advocate for well-funded, accessible post-secondary institutions.',
    email_subject: 'Constituent Request: Support Our Post-Secondary Institutions',
    email_body: `Dear [Representative Name],

As your constituent, I am concerned about post-secondary education in our province.

Alberta's post-secondary institutions face serious challenges:
- 31% funding cut since 2015 has led to larger class sizes
- Student support services have been reduced
- Many programs face cuts or elimination
- Per-student funding continues to decline

I ask you to support:
- Restored funding for colleges and universities
- Investment in student support services
- Protection of program diversity
- Affordable tuition for Alberta students

Our economic future depends on strong post-secondary education.

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'education-reform': {
    description: 'Reform Alberta education to serve all students, not just standardized test results.',
    email_subject: 'Constituent Request: Meaningful Education Reform',
    email_body: `Dear [Representative Name],

I am writing about the need for education reform in Alberta.

Current challenges include:
- Curriculum changes made without adequate teacher consultation
- Special needs funding insufficient for actual student needs
- Rural schools facing closure threats
- Indigenous education chronically underfunded

I urge you to advocate for:
- Teacher and community involvement in curriculum decisions
- Adequate funding for students with special needs
- Protection of rural schools and communities
- Meaningful investment in Indigenous education

Every Alberta student deserves quality education. Please prioritize true education reform.

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  // ========================
  // HEALTHCARE CAMPAIGNS
  // ========================
  'healthcare-funding': {
    description: 'Demand proper funding for public healthcare in Alberta.',
    email_subject: 'Constituent Request: Address Healthcare Crisis',
    email_body: `Dear [Representative Name],

I am writing about Alberta's healthcare crisis.

The evidence is clear:
- Emergency room wait times average 3 hours 48 minutes - among the worst in Canada
- Alberta doctors have called for a "state of emergency" in healthcare
- The "CorruptCare" scandal revealed political interference in health contracts
- Private surgery costs are 52% higher than public alternatives
- An RCMP investigation into AHS procurement was launched in March 2025

Albertans deserve better. I urge you to advocate for:
- Increased public healthcare funding
- Reduced reliance on expensive private providers
- Transparency and accountability in health system management
- Support for healthcare workers

Please stand up for public healthcare.

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'healthcare-access': {
    description: 'Ensure all Albertans can access timely healthcare services.',
    email_subject: 'Constituent Request: Improve Healthcare Access',
    email_body: `Dear [Representative Name],

I am concerned about healthcare access in Alberta.

Many Albertans struggle to get care:
- Thousands lack access to a family doctor
- Rural communities are losing local healthcare services
- Hospital beds close due to staffing shortages
- Wait times for specialists extend for months

I urge you to advocate for:
- More family doctors and walk-in clinics
- Protection of rural healthcare services
- Better staffing and support for hospitals
- Reduced specialist wait times

Healthcare should be accessible to all, not just those in major cities.

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'health-reform': {
    description: 'Reform Alberta health to prioritize patients over private profits.',
    email_subject: 'Constituent Request: Healthcare System Reform',
    email_body: `Dear [Representative Name],

Alberta's healthcare system requires fundamental reform.

The problems are documented:
- Median ER wait time: 3 hours 48 minutes
- AHS CEO lawsuit alleges political pressure on contracts
- RCMP is investigating procurement irregularities (March 2025)
- Private surgery costs 52% higher than public alternatives

I urge you to advocate for:
- A return to publicly delivered healthcare
- Independent oversight of health system management
- A public inquiry into the AHS scandal
- Investment in public capacity, not private profits

Please champion meaningful healthcare reform.

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  // ========================
  // MENTAL HEALTH CAMPAIGNS
  // ========================
  'mental-health': {
    description: 'Expand mental health services and reduce wait times for all Albertans.',
    email_subject: 'Constituent Request: Address Mental Health Crisis',
    email_body: `Dear [Representative Name],

Alberta faces a mental health crisis that demands action.

The statistics are alarming:
- Alberta has only 10.6 psychiatrists per 100,000 people (national average: 13)
- Wait times to see a psychiatrist range from 6 months to 1.5 years
- Alberta's suicide rate of 14.3 per 100,000 is above the national average
- Mental health receives only 6.3% of the healthcare budget
- Rural communities have even less access to mental health services

I urge you to advocate for:
- Significantly increased mental health funding
- More psychiatrists and mental health professionals
- Reduced wait times for mental health services
- Better access in rural and remote communities

Mental health is health. Please make this a priority.

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'mental-health-rest': {
    description: 'Support adequate rest and mental health resources for all Albertans.',
    email_subject: 'Constituent Request: Mental Health and Wellness Support',
    email_body: `Dear [Representative Name],

I am writing about the interconnected needs of mental health and adequate rest.

Alberta faces a crisis:
- Only 10.6 psychiatrists per 100,000 people (national average: 13)
- Wait times for psychiatric care: 6 months to 1.5 years
- Alberta suicide rate: 14.3 per 100,000 (above national average)
- Burnout and chronic stress are increasing across the workforce

Please advocate for:
- Expanded mental health services
- Workplace wellness protections
- Support for work-life balance
- Investment in preventive mental health care

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'rest-nixon': {
    description: 'Advocate for mental health services and work-life balance supports.',
    email_subject: 'Mental Health Services Under Your Ministry',
    email_body: `Dear Minister Nixon,

I am writing regarding mental health services under your ministry.

Albertans are struggling:
- Mental health wait times: 6 months to 1.5 years
- Only 10.6 psychiatrists per 100,000 people
- Suicide rate above national average at 14.3 per 100,000
- Mental health receives only 6.3% of healthcare budget

I urge you to prioritize:
- Significant increases in mental health funding
- Recruitment of mental health professionals
- Reduced barriers to accessing care
- Better support for rural communities

Mental health is health. Please act now.

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  // ========================
  // HOUSING CAMPAIGNS
  // ========================
  'housing-affordability': {
    description: 'Make housing affordable for all Albertans.',
    email_subject: 'Constituent Request: Address Housing Affordability Crisis',
    email_body: `Dear [Representative Name],

Alberta's housing affordability crisis demands action.

The evidence:
- Rent increased 17.5% year-over-year in 2024
- Vacancy rates are near historic lows
- Homelessness is increasing across all demographics
- New construction focuses on luxury, not affordable housing
- Average rent is unaffordable for minimum wage workers

I urge you to advocate for:
- Rent stabilization measures to protect tenants
- Incentives for affordable housing construction
- Increased funding for social and supportive housing
- Protection for renters from renovictions

Housing is a human right. Please act.

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'housing-rights': {
    description: 'Protect tenants and ensure housing as a human right.',
    email_subject: 'Constituent Request: Protect Housing Rights',
    email_body: `Dear [Representative Name],

Housing should be a right, not a privilege.

Albertans face serious housing challenges:
- No rent control allows unlimited rent increases
- Renovictions displace long-term, vulnerable tenants
- Mobile home owners face unlimited lot rent increases
- Discrimination against low-income renters is widespread
- Waitlists for subsidized housing are years long

Please advocate for:
- Rent stabilization to protect tenants
- Anti-renoviction protections
- Expanded social housing
- Stronger anti-discrimination enforcement

Everyone deserves a safe, affordable home.

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'seniors-housing': {
    description: 'Ensure dignified, affordable housing and care for Alberta seniors.',
    email_subject: 'Constituent Request: Protect Seniors in Care',
    email_body: `Dear [Representative Name],

Seniors housing and care in Alberta is in crisis.

The evidence is disturbing:
- 64% of COVID deaths occurred in continuing care facilities
- For-profit facilities had significantly worse COVID outcomes (Auditor General)
- The new Continuing Care Act removed minimum care hour requirements
- Monthly costs of $2,073-$3,324 are unaffordable for many on fixed incomes
- 78% of Albertans support mandatory minimum care standards

Please advocate for:
- Mandatory minimum care hour standards
- Stronger oversight of for-profit facilities
- Affordable rates for seniors
- Return of an independent Seniors' Advocate

Our elders deserve dignity and quality care.

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'family-housing': {
    description: 'Support affordable housing options for Alberta families.',
    email_subject: 'Constituent Request: Family Housing Affordability',
    email_body: `Dear [Representative Name],

Alberta families are struggling with housing costs.

The facts:
- Rent increased 17.5% year-over-year (2024)
- Childcare waitlists exceed 400 children in some communities
- New construction focuses on luxury housing
- Average rent is unaffordable on minimum wage

Families face impossible choices between housing, childcare, and basic needs.

Please advocate for:
- Family-sized affordable housing
- Integrated childcare and housing supports
- Rent stabilization measures
- Incentives for affordable family housing construction

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  // ========================
  // FOOD SECURITY CAMPAIGNS
  // ========================
  'food-security': {
    description: 'End food insecurity and support community food systems.',
    email_subject: 'Constituent Request: Address Food Insecurity Crisis',
    email_body: `Dear [Representative Name],

Food insecurity in Alberta has reached alarming levels.

The evidence:
- Food bank usage increased 21.8% in 2025 alone
- In 2023, Alberta was ranked the most food insecure province in Canada
- Working families increasingly rely on food banks
- Food costs are rising faster than wages
- Rural food deserts leave communities without affordable groceries

I urge you to advocate for:
- Income supports that keep pace with food costs
- Investment in community food systems
- Support for local food production
- School nutrition programs for all children

No Albertan should go hungry. Please act.

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'food-access': {
    description: 'Ensure all Albertans have access to healthy, affordable food.',
    email_subject: 'Constituent Request: Food Access for All',
    email_body: `Dear [Representative Name],

Food access in Alberta is becoming a crisis.

The statistics are troubling:
- Food bank usage up 21.8% in 2025
- Alberta ranked most food insecure province (2023)
- Working families now represent major food bank users
- Food costs rising faster than wages

Please advocate for:
- Living wages that allow families to afford food
- Investment in food banks and community food programs
- Support for local farmers and food systems
- Universal school nutrition programs

Food security is fundamental to human dignity.

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'food-sovereignty': {
    description: 'Support local food systems and community food sovereignty.',
    email_subject: 'Constituent Request: Support Local Food Systems',
    email_body: `Dear [Representative Name],

Albertans deserve food sovereignty - control over how our food is produced and distributed.

Current challenges:
- Grocery chains posted record profits while prices increased
- Small farms are being squeezed out by industrial agriculture
- Local food systems remain underdeveloped
- Food processing capacity is leaving Alberta

Please advocate for:
- Support for local farmers and food producers
- Investment in local food processing
- Regulations to address grocery monopoly power
- Community food security programs

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  // ========================
  // WATER CAMPAIGNS
  // ========================
  'water-protection': {
    description: 'Protect Alberta waters from industrial contamination.',
    email_subject: 'Constituent Request: Protect Our Water',
    email_body: `Dear [Representative Name],

Alberta's water faces serious threats from industrial contamination.

The evidence is alarming:
- Oil sands tailings ponds now hold 1.5 trillion litres of toxic waste - larger than Vancouver
- The 2023 Kearl mine spill leaked 5.3 million litres of contaminated water
- A second Kearl tailings pond leaked for 9+ months before discovery
- Athabasca Chipewyan First Nation is suing over regulatory failures
- Elevated cancer rates have been documented in downstream Indigenous communities
- Over 6,000 tonnes of toxic naphthenic acids are added to tailings yearly

I urge you to advocate for:
- Stronger regulations on tailings pond management
- Independent monitoring of water quality
- Corporate accountability for contamination
- Protection of drinking water sources

Clean water is life. Please protect it.

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'water-rights': {
    description: 'Ensure clean water as a right for all Alberta communities.',
    email_subject: 'Constituent Request: Water Rights for All',
    email_body: `Dear [Representative Name],

Clean water is a human right, yet many Albertans lack safe drinking water.

The reality:
- Multiple First Nations communities remain under boil water advisories
- Industrial users get water allocations ahead of communities
- Groundwater is contaminated by oil and gas operations
- There is no comprehensive strategy for water sustainability

Please advocate for:
- Safe drinking water for all communities
- Community needs prioritized over industrial use
- Groundwater protection from industrial contamination
- A sustainable water strategy for Alberta's future

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'water-access': {
    description: 'Ensure all communities have access to clean, safe water.',
    email_subject: 'Constituent Request: Clean Water Access',
    email_body: `Dear [Representative Name],

Access to clean water should be a right, not a privilege.

Yet in Alberta:
- Multiple First Nations remain under boil water advisories
- Industrial users are allocated water ahead of communities
- Groundwater contamination from oil and gas affects communities
- There is no comprehensive water sustainability strategy

Please advocate for:
- Immediate action on boil water advisories
- Community water needs prioritized
- Protection of groundwater resources
- A long-term water sustainability plan

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  // ========================
  // AIR QUALITY CAMPAIGNS
  // ========================
  'air-quality': {
    description: 'Protect air quality and hold industrial polluters accountable.',
    email_subject: 'Constituent Request: Protect Our Air Quality',
    email_body: `Dear [Representative Name],

Alberta's air quality is deteriorating and threatens public health.

The evidence:
- The 2023 wildfire season was the smokiest on record
- Air quality exceedances: 2,125 in 2023 vs just 194 in 2022 (10x increase)
- Industrial emissions from oil sands affect communities for hundreds of kilometers
- Climate change is making wildfires more frequent and severe
- Children, elderly, and those with respiratory conditions are most at risk

I urge you to advocate for:
- Stronger industrial emissions regulations
- Investment in wildfire prevention and preparedness
- Health system preparedness for air quality emergencies
- Climate action to reduce wildfire risk

Please protect the air we breathe.

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'air-quality-protection': {
    description: 'Demand action on industrial emissions and wildfire smoke.',
    email_subject: 'Constituent Request: Air Quality Protection',
    email_body: `Dear [Representative Name],

Air quality protection in Alberta is inadequate.

The data:
- Air quality exceedances: 2,125 in 2023 vs 194 in 2022 (10x increase)
- 2023 was the smokiest summer on record
- Industrial emissions impact regional air quality
- Climate change is increasing wildfire frequency

Please advocate for:
- Stronger industrial emissions standards
- Better wildfire prevention and response
- Public health protections during air quality emergencies
- Climate action to address root causes

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'air-quality-health': {
    description: 'Address health impacts of poor air quality in Alberta.',
    email_subject: 'Constituent Request: Air Quality and Health',
    email_body: `Dear [Representative Name],

Poor air quality has serious health consequences for Albertans.

Recent evidence:
- 2023 was the smokiest summer on record
- 10x increase in air quality exceedances
- Respiratory health impacts were widespread
- Our health system is not prepared for climate-related health crises

Please advocate for:
- Health system preparedness for air quality emergencies
- Public warning systems and protection programs
- Support for vulnerable populations during smoke events
- Climate action to reduce wildfire risk

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  // ========================
  // INDIGENOUS RIGHTS CAMPAIGNS
  // ========================
  'indigenous-rights': {
    description: 'Uphold Indigenous rights and honor treaty obligations.',
    email_subject: 'Constituent Request: Honor Indigenous Rights',
    email_body: `Dear [Representative Name],

Indigenous rights in Alberta are under threat and must be upheld.

The evidence:
- The murder rate for Indigenous women is 6.79 per 100,000 - drastically higher than non-Indigenous women
- Multiple First Nations are suing the Alberta government over treaty violations
- Treaty 8 Nations have launched a court challenge over Crown land sales
- Beaver Lake Cree Nation's treaty infringement case went to trial in 2024
- In December 2025, a court ruled that separation plans violate treaty rights

I urge you to advocate for:
- Meaningful consultation with Indigenous peoples on all decisions affecting their rights
- Full implementation of the UN Declaration on the Rights of Indigenous Peoples
- A public inquiry into violence against Indigenous women
- Respect for treaty obligations

Please honor the treaties that form Alberta's legal foundation.

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'indigenous-relations': {
    description: 'Transform Alberta-Indigenous relations based on respect and reconciliation.',
    email_subject: 'Constituent Request: Meaningful Indigenous Relations',
    email_body: `Dear [Representative Name],

Alberta's relationship with Indigenous peoples requires fundamental change.

The record shows:
- Indigenous women murder rate: 6.79 per 100,000 (far above non-Indigenous rate)
- Multiple First Nations suing over treaty violations
- Treaty 8 Nations court challenge over Crown land sales
- Lack of meaningful consultation on resource development
- Court ruled separation violates treaty rights (December 2025)

Please advocate for:
- True nation-to-nation relationships
- Meaningful consultation, not token gestures
- Implementation of UNDRIP
- Respect for treaty rights in all government decisions

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'indigenous-consultation': {
    description: 'Demand meaningful consultation with Indigenous peoples.',
    email_subject: 'Constituent Request: True Indigenous Consultation',
    email_body: `Dear [Representative Name],

Meaningful consultation with Indigenous peoples is required by treaty and law.

Yet Alberta consistently fails:
- Court ruled provincial separation violates treaty rights (December 2025)
- Treaty 6 Nations expressed disappointment over lack of consultation (November 2025)
- Onion Lake Cree Nation is suing over the Alberta Sovereignty Act
- Siksika is pursuing legal action over Ghost Dam relocation
- There is no legislative acknowledgment of treaty rights in Alberta

Please advocate for:
- Meaningful consultation before decisions are made
- Free, prior, and informed consent for projects affecting Indigenous lands
- Legislative recognition of treaty rights
- Respect for court decisions upholding Indigenous rights

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  // ========================
  // LAND BACK CAMPAIGNS
  // ========================
  'land-back': {
    description: 'Support Land Back and the return of Indigenous land stewardship.',
    email_subject: 'Constituent Request: Honor Land Back',
    email_body: `Dear [Representative Name],

Land Back is about honoring the treaty obligations that form Alberta's legal foundation.

The facts:
- All of Alberta is covered by Treaties 6, 7, and 8
- 45 First Nations and 140 reserves exist in Alberta
- Courts have ruled that separation without Indigenous consent violates treaties
- Treaty promises regarding land, hunting, and resources remain unfulfilled
- There is growing legal recognition of Indigenous sovereignty

I urge you to advocate for:
- Honoring treaty land obligations
- Returning lands to Indigenous stewardship where possible
- Supporting Indigenous-led conservation
- Respecting Indigenous jurisdiction over traditional territories

The treaties are the foundation of Alberta. Please honor them.

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'landback': {
    description: 'Honor treaties and support Indigenous land sovereignty.',
    email_subject: 'Constituent Request: Support Land Back',
    email_body: `Dear [Representative Name],

Land Back is about honoring treaty obligations that form Alberta's legal foundation.

Key facts:
- All of Alberta covered by Treaties 6, 7, and 8
- 45 First Nations, 140 reserves in Alberta
- Court ruled separation without consent violates treaties
- Treaty promises regarding land remain unfulfilled
- Growing legal recognition of Indigenous sovereignty

Please advocate for:
- Honoring treaty land provisions
- Supporting Indigenous land stewardship
- Implementing UNDRIP land provisions
- Respecting Indigenous jurisdiction

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'land-rights': {
    description: 'Protect land rights and honor treaty obligations.',
    email_subject: 'Constituent Request: Respect Land Rights',
    email_body: `Dear [Representative Name],

Land rights in Alberta must be understood in the context of treaties.

Current violations:
- Treaty 8 Nations challenging Crown land sales
- Resource development without meaningful consultation
- Beaver Lake Cree treaty infringement case (2024)
- Indigenous rights over traditional territories upheld by courts

Please advocate for:
- Consultation before Crown land decisions
- Respect for treaty rights in resource development
- Support for Indigenous land claims
- Implementation of court decisions

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'land-use': {
    description: 'Ensure land use decisions respect treaties and communities.',
    email_subject: 'Constituent Request: Responsible Land Use',
    email_body: `Dear [Representative Name],

Land use decisions in Alberta consistently ignore Indigenous rights and community needs.

The pattern:
- Resource development without Indigenous consultation
- Agricultural land lost to industrial development
- No legislative acknowledgment of treaty rights
- Environmental impacts of land use ignored

Please advocate for:
- Treaty rights in land use decisions
- Protection of agricultural land
- Community input in development decisions
- Environmental impact consideration

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  // ========================
  // LGBTQ+ RIGHTS CAMPAIGNS
  // ========================
  'lgbtq-rights': {
    description: 'Protect LGBTQ+ Albertans from discrimination and harmful legislation.',
    email_subject: 'Constituent Request: Protect LGBTQ+ Rights',
    email_body: `Dear [Representative Name],

LGBTQ+ rights in Alberta face unprecedented attacks.

Recent developments:
- In December 2024, the government passed Bills 26, 27, and 29
- Bill 26 bans gender-affirming care for youth under 18
- Bill 27 requires parental permission for pronoun changes (under 16)
- Bill 29 bans trans women from sports teams (age 12+)
- A court injunction blocked the care ban (June 2025)
- In December 2025, the government invoked the notwithstanding clause to override Charter protections
- The Alberta Medical Association and Pediatric Society opposed these bills
- PM Trudeau called these "most anti-LGBT of anywhere in the country"

I urge you to stand up for:
- Repeal of Bills 26, 27, and 29
- Respect for Charter rights
- Access to evidence-based healthcare
- Protection for LGBTQ+ youth

Please stand with LGBTQ+ Albertans.

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'love-smith': {
    description: 'Oppose anti-LGBTQ+ legislation from the Premier.',
    email_subject: 'Constituent Opposition to Anti-LGBTQ+ Policies',
    email_body: `Dear Premier Smith,

I am writing to express my opposition to your government's anti-LGBTQ+ policies.

Your government has enacted the most restrictive LGBTQ+ policies in Canada:
- Bill 26: Bans gender-affirming care for youth under 18
- Bill 27: Requires parental permission for pronouns (under 16)
- Bill 29: Bans trans women from sports teams (age 12+)
- You invoked the notwithstanding clause to override Charter protections (December 2025)
- PM Trudeau called these "most anti-LGBT of anywhere in the country"

I urge you to:
- Repeal Bills 26, 27, and 29
- Respect the Charter of Rights and Freedoms
- Listen to medical experts who oppose these policies
- Protect vulnerable LGBTQ+ youth

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'love-ellis': {
    description: 'Support LGBTQ+ equality and oppose discriminatory legislation.',
    email_subject: 'Support LGBTQ+ Equality in Alberta',
    email_body: `Dear Minister Ellis,

I am writing about LGBTQ+ rights in Alberta.

Recent developments are alarming:
- Three anti-trans bills passed (December 2024)
- Court injunction blocked care ban (June 2025)
- Government used notwithstanding clause to override (December 2025)
- Medical associations opposed the legislation
- Mental health experts warn of increased suicide risk

Please advocate for:
- Repeal of discriminatory legislation
- Respect for Charter rights
- Evidence-based healthcare policy
- Protection for vulnerable youth

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'love-turton': {
    description: 'Protect LGBTQ+ students in Alberta schools.',
    email_subject: 'Protect LGBTQ+ Students in Our Schools',
    email_body: `Dear Minister Turton,

I am deeply concerned about LGBTQ+ students in Alberta schools.

Bill 27 puts students at risk:
- Schools must notify parents when students under 16 request different pronouns
- Teachers cannot use affirmed names/pronouns without parental consent
- LGBTQ+ students may be outed to unsupportive families
- The Alberta Teachers' Association opposed this legislation
- Mental health experts warn these policies increase suicide risk

Please advocate for:
- Repeal of Bill 27's harmful provisions
- Safe schools for all students
- Teacher discretion to support vulnerable students
- GSA protections

LGBTQ+ students deserve support, not policies that endanger them.

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'love-williams': {
    description: 'Support mental health services for LGBTQ+ Albertans.',
    email_subject: 'Mental Health Support for LGBTQ+ Albertans',
    email_body: `Dear Minister Williams,

LGBTQ+ Albertans desperately need mental health support.

The situation is critical:
- LGBTQ+ youth face higher mental health risks
- Wait times for psychiatric care: 6 months to 1.5 years
- Anti-LGBTQ+ policies increase mental health burden
- Limited LGBTQ+-affirming mental health services available

Please advocate for:
- LGBTQ+-affirming mental health services
- Reduced barriers to care
- Crisis support for LGBTQ+ youth
- Opposition to policies that harm mental health

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'gender-equity': {
    description: 'Advance gender equity and oppose gender-based discrimination.',
    email_subject: 'Constituent Request: Support Gender Equity',
    email_body: `Dear [Representative Name],

Gender equity in Alberta faces ongoing challenges.

Current issues:
- Gender pay gap persists across industries
- Bills 26, 27, 29 discriminate against trans Albertans
- Violence against women remains a significant concern
- Limited support for gender-diverse Albertans

Please advocate for:
- Pay equity legislation
- Repeal of discriminatory bills
- Action on gender-based violence
- Support for all gender identities

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'gsa-protection': {
    description: 'Protect Gay-Straight Alliances in Alberta schools.',
    email_subject: 'Constituent Request: Protect GSAs',
    email_body: `Dear [Representative Name],

Gay-Straight Alliances (GSAs) in Alberta schools are under threat.

Bill 27's impact:
- Schools must notify parents when students under 16 request different pronouns
- Teachers cannot use affirmed names without parental consent
- LGBTQ+ students may be outed to unsupportive families
- Alberta Teachers' Association opposed this legislation
- Mental health experts warn policies increase suicide risk

Please advocate for:
- Protection of GSAs
- Student privacy rights
- Teacher discretion to support students
- Repeal of harmful Bill 27 provisions

LGBTQ+ students need safe spaces.

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  // ========================
  // POLICE ACCOUNTABILITY CAMPAIGNS
  // ========================
  'police-accountability': {
    description: 'Demand independent oversight and accountability for police.',
    email_subject: 'Constituent Request: Police Accountability',
    email_body: `Dear [Representative Name],

Police accountability in Alberta requires strengthening.

Current situation:
- ASIRT is now part of a new Police Review Commission
- The Alberta Police Misconduct Database documents concerning patterns
- Civilian oversight remains limited
- Indigenous people are disproportionately affected by policing practices

I urge you to advocate for:
- Truly independent civilian oversight
- Transparent investigation processes
- Accountability when misconduct is found
- Alternative responses to mental health calls

Public trust in policing depends on accountability.

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'police-reform': {
    description: 'Support community-based alternatives to traditional policing.',
    email_subject: 'Constituent Request: Police Reform',
    email_body: `Dear [Representative Name],

Alberta's policing system needs reform.

Evidence shows:
- Indigenous people are overrepresented in police encounters and incarceration
- Mental health calls are handled by armed officers instead of crisis workers
- Community-based safety alternatives remain underfunded
- Rural RCMP coverage gaps leave communities underserved

Please advocate for:
- Investment in community safety alternatives
- Mental health crisis response teams
- Addressing Indigenous overrepresentation
- Reallocation of resources to prevention

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'asirt-investigation': {
    description: 'Support independent investigations of police incidents.',
    email_subject: 'Support for Independent Police Investigations',
    email_body: `Dear ASIRT,

I am writing about the importance of independent police investigations.

Current context:
- ASIRT is now part of the Police Review Commission (2024)
- The Alberta Police Misconduct Database tracks concerning issues
- Civilian oversight of police remains limited
- Indigenous people are disproportionately affected by policing

I support:
- Thorough and independent investigations
- Transparency in investigation processes
- Accountability when misconduct is found
- Support for families affected by serious incidents

Independent oversight is essential for justice.

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  // ========================
  // GOVERNMENT ACCOUNTABILITY CAMPAIGNS
  // ========================
  'government-accountability': {
    description: 'Demand transparency and accountability from government.',
    email_subject: 'Constituent Request: Government Accountability',
    email_body: `Dear [Representative Name],

Government accountability in Alberta has deteriorated significantly.

Evidence:
- A 2025 investigation found 27 government bodies non-compliant with freedom of information rules
- The "CorruptCare" scandal led to an RCMP investigation
- Fiscal transparency has declined with changes to reporting requirements
- Investigation reports have been delayed by 4+ months

I urge you to advocate for:
- Full compliance with freedom of information laws
- A public inquiry into the AHS scandal
- Restored fiscal transparency
- Independent oversight of government operations

Albertans deserve accountable government.

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'government-reform': {
    description: 'Reform government for transparency and accountability.',
    email_subject: 'Constituent Request: Government Reform',
    email_body: `Dear [Representative Name],

Government accountability in Alberta has deteriorated.

The evidence:
- 27 government bodies non-compliant with FOI rules
- RCMP investigating AHS procurement
- Changes to fiscal framework reduce transparency
- Investigation reports delayed by 4+ months

Please advocate for:
- Strong FOI enforcement
- Independent oversight
- Fiscal transparency
- Timely public reporting

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'corruption': {
    description: 'Fight corruption and demand transparency in government.',
    email_subject: 'Constituent Request: Address Corruption Concerns',
    email_body: `Dear [Representative Name],

Corruption concerns in Alberta have grown significantly.

Recent developments:
- The AHS scandal involved allegations of political pressure on health contracts
- Private surgery costs were 52% higher than public alternatives
- The RCMP launched an investigation (March 2025)
- Government rejected calls for a public inquiry
- Former AHS CEO filed wrongful dismissal lawsuit (February 2025)

I urge you to advocate for:
- A public inquiry into the AHS scandal
- Independent oversight of government contracting
- Transparency in all government operations
- Accountability for those involved in corruption

Albertans deserve honest government.

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'anti-corruption': {
    description: 'Demand action on government corruption.',
    email_subject: 'Constituent Request: Anti-Corruption Action',
    email_body: `Dear [Representative Name],

Corruption concerns in Alberta have grown significantly.

Evidence:
- AHS CEO lawsuit alleges political pressure on contracts
- Private surgery costs 52% higher than public alternatives
- RCMP investigation launched (March 2025)
- Government rejected calls for public inquiry
- Former judge appointed to lead third-party investigation

Please advocate for:
- Full public inquiry
- Independent oversight
- Transparency in contracting
- Accountability for misconduct

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'legal-accountability': {
    description: 'Ensure legal accountability for government misconduct.',
    email_subject: 'Constituent Request: Legal Accountability',
    email_body: `Dear [Representative Name],

Legal accountability in Alberta has weakened.

Recent evidence:
- AHS scandal led to RCMP investigation
- Minister resigned amid scandal
- Government resisted public inquiry calls
- Freedom of information rules violated

Please advocate for:
- Consequences for misconduct
- Full public inquiry
- FOI compliance enforcement
- Independent oversight

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'justice-reform': {
    description: 'Reform Alberta justice system for fairness and access.',
    email_subject: 'Constituent Request: Justice System Reform',
    email_body: `Dear [Representative Name],

Alberta's justice system requires reform.

Key issues:
- Indigenous overrepresentation in corrections
- Court backlogs causing Charter violations
- Legal aid funding inadequate
- Access to justice limited for low-income Albertans

Please advocate for:
- Addressing Indigenous overrepresentation
- Court capacity to reduce delays
- Adequate legal aid funding
- Accessible justice for all

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'ombudsman-investigation': {
    description: 'Support the Ombudsman in investigating government accountability.',
    email_subject: 'Request for Ombudsman Investigation',
    email_body: `Dear Alberta Ombudsman,

I am writing to request your office investigate matters of government accountability.

Context for concern:
- 27 government bodies non-compliant with FOI rules
- RCMP investigating AHS procurement (March 2025)
- Government transparency declining
- Independent oversight increasingly important

Your office plays a vital role in protecting Albertans from government unfairness. I respectfully request that you consider investigating these concerns.

Thank you for your service.

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  // ========================
  // CORPORATE ACCOUNTABILITY CAMPAIGNS
  // ========================
  'corporate-accountability': {
    description: 'Hold corporations accountable for impacts on workers and communities.',
    email_subject: 'Constituent Request: Corporate Accountability',
    email_body: `Dear [Representative Name],

Corporate power in Alberta operates with insufficient accountability.

Evidence:
- Oil companies hold $1.5 trillion in toxic tailings liabilities
- Grocery chains posted record profits during food inflation
- Bill 32 restricts union organizing while corporations face few constraints
- Orphan well cleanup costs are downloaded to taxpayers

I urge you to advocate for:
- Corporate responsibility for environmental cleanup
- Action on grocery profiteering
- Worker rights and union protections
- Fair corporate taxation

Corporations should serve communities, not exploit them.

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'corporate-oversight': {
    description: 'Strengthen oversight of corporate activities in Alberta.',
    email_subject: 'Constituent Request: Corporate Oversight',
    email_body: `Dear [Representative Name],

Corporate oversight in Alberta is inadequate.

The evidence:
- Oil companies hold $1.5 trillion in toxic tailings
- Grocery chains recorded record profits during food inflation
- Corporate tax cuts despite public service cuts
- Environmental regulation weakened

Please advocate for:
- Stronger environmental regulations
- Corporate cleanup responsibility
- Fair taxation
- Consumer protection

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'economic-reform': {
    description: 'Reform Alberta economy to work for workers and communities.',
    email_subject: 'Constituent Request: Economic Reform',
    email_body: `Dear [Representative Name],

Alberta's economy is structured to benefit corporations over workers.

Evidence:
- $1.5 trillion in toxic tailings with limited corporate liability
- Bill 32 restricts union organizing
- Corporate tax cuts while services face cuts
- Orphan well cleanup costs downloaded to taxpayers

Please advocate for:
- Fair corporate taxation
- Worker protections
- Corporate cleanup responsibility
- Investment in public services

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  // ========================
  // ENERGY CAMPAIGNS
  // ========================
  'energy-affordability': {
    description: 'Make energy affordable for all Albertans.',
    email_subject: 'Constituent Request: Energy Affordability',
    email_body: `Dear [Representative Name],

Energy costs in Alberta remain volatile and high despite our resource wealth.

Evidence:
- Electricity prices hit record highs in 2023
- Energy deregulation has led to price volatility
- A new "rate of last resort" program was introduced in 2025
- Low-income households are disproportionately affected
- Energy poverty is growing in an energy-rich province

I urge you to advocate for:
- Rate stability for consumers
- Support for low-income energy users
- Review of deregulation impacts
- Affordable energy as a right

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'energy-transition': {
    description: 'Support clean energy transition for Alberta jobs and environment.',
    email_subject: 'Constituent Request: Clean Energy Future',
    email_body: `Dear [Representative Name],

Alberta's clean energy transition has been deliberately stalled.

The facts:
- A 7-month renewable energy moratorium (2023-2024) halted 118 projects
- An estimated 24,000 jobs were stalled
- Since the freeze lifted, 11 gigawatts of projects have been cancelled
- New restrictions could rule out 40% of the province for renewables
- 45% of proposed renewable projects are failing to proceed

I urge you to advocate for:
- Removal of barriers to renewable energy
- Support for clean energy jobs
- A transition plan that supports workers
- Alberta leadership in clean energy

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'clean-energy': {
    description: 'Remove barriers to clean energy development in Alberta.',
    email_subject: 'Constituent Request: Support Clean Energy',
    email_body: `Dear [Representative Name],

Alberta's clean energy transition has been deliberately blocked.

Evidence:
- 7-month renewable energy moratorium (2023-2024)
- 118 projects and 24,000 potential jobs stalled
- 11 gigawatts of projects cancelled post-moratorium
- New rules could exclude 40% of province from renewables
- 45% of proposed renewable projects failing to proceed

Please advocate for:
- Removal of renewable energy barriers
- Support for clean energy jobs
- Fair treatment for renewable projects
- Alberta clean energy leadership

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'energy-reform': {
    description: 'Reform Alberta energy system for fairness and sustainability.',
    email_subject: 'Constituent Request: Energy System Reform',
    email_body: `Dear [Representative Name],

Alberta's energy system needs reform.

Evidence:
- Electricity prices hit record highs in 2023
- 7-month renewable energy moratorium
- 11 gigawatts of renewable projects cancelled
- Energy poverty growing in energy-rich province

Please advocate for:
- Rate stability for consumers
- Fair treatment for renewables
- Support for energy transition
- Affordable energy for all

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'utilities-reform': {
    description: 'Reform utility pricing for affordability and fairness.',
    email_subject: 'Constituent Request: Utility Reform',
    email_body: `Dear [Representative Name],

Utility costs in Alberta have become unaffordable for many.

Evidence:
- Electricity prices hit record highs in 2023
- "Rate of last resort" introduced (2025)
- Energy deregulation increased price volatility
- Low-income households disproportionately affected

Please advocate for:
- Rate stability measures
- Low-income utility supports
- Review of deregulation
- Affordable utilities for all

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  // ========================
  // COMMUNICATIONS CAMPAIGNS
  // ========================
  'internet-access': {
    description: 'Ensure high-speed internet for all Alberta communities.',
    email_subject: 'Constituent Request: Rural Internet Access',
    email_body: `Dear [Representative Name],

Alberta ranks last among provinces for rural broadband access.

The evidence:
- Only 42% of rural households have internet at target speeds
- 67% of rural Albertans lack reliable high-speed internet
- 80% of Indigenous communities lack reliable high-speed internet
- Major telecom companies refuse to serve rural areas without subsidies
- Rural municipalities are forced to build their own infrastructure

I urge you to advocate for:
- Accelerated rural broadband investment
- Pressure on telecoms to serve rural areas
- Support for community-owned internet
- Indigenous community connectivity

Every Albertan deserves access to the digital economy.

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'tech-innovation': {
    description: 'Bridge the digital divide in Alberta communities.',
    email_subject: 'Constituent Request: Bridge the Digital Divide',
    email_body: `Dear [Representative Name],

Technology access in Alberta remains inequitable.

Evidence:
- Alberta ranks LAST for rural broadband availability
- Only 42% of rural households have target-speed internet
- 67% of rural Albertans lack reliable high-speed internet
- 80% of Indigenous communities lack reliable internet

Please advocate for:
- Rural broadband investment
- Indigenous community connectivity
- Digital literacy programs
- Fair telecom regulation

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'telecom-reform': {
    description: 'Reform telecommunications for rural and remote access.',
    email_subject: 'Constituent Request: Telecom Reform',
    email_body: `Dear [Representative Name],

Telecommunications in Alberta fails rural communities.

Evidence:
- Alberta ranks last for rural broadband
- Major telecoms won't expand rural service without subsidies
- Rural municipalities forced to build own infrastructure
- 80% of Indigenous communities lack reliable internet

Please advocate for:
- Telecom obligations to serve rural areas
- Support for community broadband
- Fair pricing for rural services
- Indigenous community connectivity

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  // ========================
  // RECREATION CAMPAIGNS
  // ========================
  'recreation-access': {
    description: 'Ensure all Albertans can access parks and recreation.',
    email_subject: 'Constituent Request: Accessible Recreation',
    email_body: `Dear [Representative Name],

Access to Alberta's natural spaces has been commodified.

Evidence:
- The Kananaskis Conservation Pass costs $90 annually or $15 daily
- In 2020, the government attempted to close 20 campgrounds and privatize 164 more
- Public outcry forced reversal of privatization plans
- Park fees create barriers for low-income families

I urge you to advocate for:
- Removal or reduction of park user fees
- Protection of public parks from privatization
- Accessible recreation for all income levels
- Investment in park infrastructure

Nature should be accessible to all Albertans.

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'recreation-parks': {
    description: 'Protect Alberta parks from privatization and fee barriers.',
    email_subject: 'Constituent Request: Protect Our Parks',
    email_body: `Dear [Representative Name],

Alberta's parks system faces ongoing threats.

Evidence:
- 2020: Attempted delisting of 184 provincial parks
- Kananaskis Conservation Pass: $90/year
- Recreation areas being delisted
- Budget cuts affecting trail maintenance

Please advocate for:
- Protection of provincial parks
- Affordable or free access
- Adequate park funding
- No privatization

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'recreation-tourism': {
    description: 'Support accessible tourism and recreation for Albertans.',
    email_subject: 'Constituent Request: Accessible Recreation',
    email_body: `Dear [Representative Name],

Access to nature should be a right, not a privilege.

Current issues:
- Park user fees create barriers for low-income Albertans
- Tourism revenue concentrated in private hands
- Community-based tourism underdeveloped
- Health benefits of nature access well-documented

Please advocate for:
- Affordable park access
- Community tourism development
- Public investment in recreation
- Health-promoting outdoor access

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'protected-areas': {
    description: 'Protect natural areas from development and privatization.',
    email_subject: 'Constituent Request: Protect Natural Areas',
    email_body: `Dear [Representative Name],

Protected areas in Alberta face ongoing threats.

Evidence:
- 2020: Attempted delisting of 184 provincial parks
- Kananaskis Conservation Pass: $90/year
- Recreation areas being delisted
- Budget cuts affecting trail maintenance

Please advocate for:
- Expanded protected areas
- No delisting of parks
- Affordable public access
- Conservation funding

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  // ========================
  // TRANSPORTATION CAMPAIGNS
  // ========================
  'transportation-access': {
    description: 'Improve public transit and transportation options.',
    email_subject: 'Constituent Request: Transportation Access',
    email_body: `Dear [Representative Name],

Public transit in Alberta faces funding challenges.

Evidence:
- In 2024, provincial funding for low-income transit passes was cut, then reversed after outcry
- Calgary's low-income transit program serves 119,000+ qualified users
- Edmonton's program has 25,000+ monthly users
- Rural communities have virtually no public transit options

I urge you to advocate for:
- Stable funding for low-income transit
- Expansion of public transit services
- Rural transportation options
- Affordable fares for all

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'transport-reform': {
    description: 'Reform transportation for accessibility and sustainability.',
    email_subject: 'Constituent Request: Transportation Reform',
    email_body: `Dear [Representative Name],

Transportation in Alberta requires reform.

Evidence:
- Low-income transit pass funding cut, then reversed (2024)
- Rural communities have virtually no public transit
- Transit fares increasing while service stagnates
- Highway investment prioritized over public transit

Please advocate for:
- Stable transit funding
- Rural transportation options
- Affordable public transit
- Sustainable transportation investment

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'municipal-transit': {
    description: 'Support municipal transit systems and low-income access.',
    email_subject: 'Constituent Request: Support Municipal Transit',
    email_body: `Dear [Representative Name],

Municipal transit in Alberta faces funding challenges.

Evidence:
- Calgary low-income transit: 119,000+ qualified users
- Edmonton low-income transit: 25,000+ monthly users
- Provincial funding cut, then reversed after outcry (2024)
- Transit fares increasing for 2025-2026

Please advocate for:
- Stable provincial transit funding
- Protection of low-income programs
- Transit service expansion
- Affordable fares

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  // ========================
  // ENVIRONMENT CAMPAIGNS
  // ========================
  'environment-protection': {
    description: 'Protect Alberta environment from industrial damage.',
    email_subject: 'Constituent Request: Environmental Protection',
    email_body: `Dear [Representative Name],

Environmental protection in Alberta faces significant challenges.

Evidence:
- Tailings ponds hold 1.5 trillion litres of toxic waste
- 2023: Smokiest summer on record
- Air quality exceedances: 2,125 in 2023 vs 194 in 2022
- 7-month renewable energy moratorium (2023-2024)

Please advocate for:
- Strong environmental regulations
- Corporate cleanup responsibility
- Climate action
- Renewable energy support

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  // ========================
  // WORKER RIGHTS CAMPAIGNS
  // ========================
  'worker-rights': {
    description: 'Protect worker rights and support fair workplaces.',
    email_subject: 'Constituent Request: Protect Worker Rights',
    email_body: `Dear [Representative Name],

Worker rights in Alberta have been significantly weakened.

Evidence:
- Bill 32 introduced U.S.-style restrictions on union organizing
- Alberta is the only province requiring workers to opt-in for union political activity funding
- The bill eliminates timelines for certification votes, favoring employers
- It allows overtime averaging over 52 weeks
- Legal challenges have been filed on Charter grounds

I urge you to advocate for:
- Repeal of anti-worker provisions in Bill 32
- Protection of the right to organize
- Fair overtime rules
- Worker safety protections

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'work-life': {
    description: 'Support work-life balance for Alberta workers.',
    email_subject: 'Constituent Request: Work-Life Balance',
    email_body: `Dear [Representative Name],

Work-life balance in Alberta has deteriorated.

Evidence:
- Bill 32 allows overtime averaging over 52 weeks
- Alberta workers face high burnout rates
- Mental health supports in workplaces inadequate
- Work-related stress contributing to health crisis

Please advocate for:
- Fair overtime rules
- Workplace mental health supports
- Work-life balance protections
- Worker wellness programs

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'association-rights-jobs': {
    description: 'Protect the right to organize and join unions.',
    email_subject: 'Constituent Request: Association Rights at Work',
    email_body: `Dear [Representative Name],

Worker association rights in Alberta have been severely restricted.

Evidence:
- Bill 32: Most anti-union legislation in Canada
- Only province requiring opt-in for union political activity
- Eliminates timelines for certification votes
- Allows overtime averaging over 52 weeks
- Similar to U.S. "right-to-work" laws that suppress wages

Please advocate for:
- Repeal of Bill 32's anti-union provisions
- Protection of organizing rights
- Fair certification processes
- Worker voice in workplaces

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  // ========================
  // SURVEILLANCE CAMPAIGNS
  // ========================
  'surveillance': {
    description: 'Protect Albertans from mass surveillance.',
    email_subject: 'Constituent Request: Protect Privacy Rights',
    email_body: `Dear [Representative Name],

Mass surveillance threatens privacy rights in Alberta.

Concerns include:
- Automated License Plate Recognition systems track movements without warrants
- Facial recognition technology deployment lacks adequate regulation
- Data retention practices lack consistent oversight
- Charter section 8 protections may be violated

I urge you to advocate for:
- Regulation of surveillance technologies
- Warrant requirements for tracking
- Data retention limits
- Privacy impact assessments

Privacy is a fundamental right. Please protect it.

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'privacy-rights': {
    description: 'Protect privacy from government and corporate surveillance.',
    email_subject: 'Constituent Request: Privacy Protection',
    email_body: `Dear [Representative Name],

Privacy rights in Alberta face threats from surveillance.

Evidence:
- ALPR systems deployed without adequate oversight
- No consistent data retention regulations
- Corporate data collection unregulated
- Charter section 8 protections may be violated

Please advocate for:
- Surveillance technology regulation
- Data retention limits
- Corporate privacy rules
- Charter compliance

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'tech-privacy': {
    description: 'Regulate technology companies to protect privacy.',
    email_subject: 'Constituent Request: Tech Privacy Protection',
    email_body: `Dear [Representative Name],

Technology privacy protections have not kept pace with surveillance capabilities.

Evidence:
- Mass surveillance technologies expanding
- Facial recognition lacks regulation
- Data broker industry unregulated
- Privacy legislation outdated for digital age

Please advocate for:
- Modern privacy legislation
- Facial recognition regulation
- Data broker oversight
- Digital rights protection

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  // ========================
  // HUMAN RIGHTS CAMPAIGNS
  // ========================
  'human-rights': {
    description: 'Protect and expand human rights for all Albertans.',
    email_subject: 'Constituent Request: Protect Human Rights',
    email_body: `Dear Alberta Human Rights Commission,

I am writing regarding human rights protection in Alberta.

Current concerns:
- Anti-LGBTQ+ Bills 26, 27, 29 passed (December 2024)
- Indigenous treaty rights consistently violated
- Human Rights Commission faces backlogs
- Discrimination remains prevalent in employment and housing

I urge the Commission to:
- Advocate for repeal of discriminatory legislation
- Support Indigenous rights enforcement
- Address complaint backlogs
- Strengthen anti-discrimination enforcement

Human rights must be protected for all Albertans.

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  // ========================
  // PUBLIC SPACES CAMPAIGNS
  // ========================
  'community-spaces': {
    description: 'Protect and expand community gathering spaces.',
    email_subject: 'Constituent Request: Community Spaces',
    email_body: `Dear [Representative Name],

Community spaces are essential for healthy societies.

Current challenges:
- Kananaskis Pass costs $90/year or $15/day
- 2020: Attempted closure of 20 campgrounds
- Recreation funding reduced across municipalities
- Community centers facing cuts

Please advocate for:
- Free or affordable public spaces
- Community center funding
- Park access for all
- No privatization of public spaces

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'public-spaces': {
    description: 'Keep public spaces accessible to all Albertans.',
    email_subject: 'Constituent Request: Public Space Access',
    email_body: `Dear [Representative Name],

Public spaces belong to all Albertans.

Current issues:
- Parks charging entry fees (Kananaskis: $90/year)
- Public spaces being privatized
- Community center funding reduced
- Low-income families priced out of public recreation

Please advocate for:
- Free public space access
- No privatization
- Community facility funding
- Inclusive recreation

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'gathering-spaces-municipal': {
    description: 'Support municipal gathering spaces for communities.',
    email_subject: 'Constituent Request: Municipal Gathering Spaces',
    email_body: `Dear [Representative Name],

Municipal gathering spaces are essential for community building.

Current challenges:
- Municipal recreation funding pressures
- User fees creating access barriers
- Community infrastructure aging without renewal
- Rural communities losing gathering spaces

Please advocate for:
- Municipal recreation funding
- Free community space access
- Infrastructure renewal
- Rural community support

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'assembly-rights': {
    description: 'Protect the right to assemble and protest peacefully.',
    email_subject: 'Constituent Request: Assembly Rights',
    email_body: `Dear [Representative Name],

The right to assemble is fundamental to democracy.

Concerns:
- Restrictions on protest activities
- Limited public gathering spaces
- Costs for permits and public space usage
- Critical Infrastructure Defence Act limits protests

Please advocate for:
- Protected protest rights
- Accessible public gathering spaces
- Reasonable permit processes
- Review of protest restrictions

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  // ========================
  // PUBLIC SERVICES CAMPAIGNS
  // ========================
  'public-services-reform': {
    description: 'Reform public services for accessibility and affordability.',
    email_subject: 'Constituent Request: Public Services Reform',
    email_body: `Dear [Representative Name],

Public services in Alberta face ongoing challenges.

Issues:
- Registry services privatized with inconsistent quality
- Administrative fees increase cost of basic services
- Digital services could reduce costs but not prioritized
- Low-income Albertans disproportionately affected by fees

Please advocate for:
- Affordable public services
- Quality service standards
- Digital service investment
- Fee reduction for low-income Albertans

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'public-services-vision': {
    description: 'Build a vision for excellent public services.',
    email_subject: 'Constituent Request: Public Services Vision',
    email_body: `Dear [Representative Name],

Public services should serve all Albertans well.

Please advocate for:
- Accessible services for all
- Quality service standards
- Fair pricing
- Investment in public service capacity

Good public services benefit everyone.

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  // ========================
  // SUPPORT CAMPAIGNS
  // ========================
  'social-support': {
    description: 'Strengthen social supports for Albertans in need.',
    email_subject: 'Constituent Request: Social Support Systems',
    email_body: `Dear [Representative Name],

Social support systems in Alberta are inadequate.

Evidence:
- Income support rates below poverty line
- Mental health wait times exceed 6 months
- Housing waitlists years long
- Food bank usage up 21.8% in 2025

Please advocate for:
- Income supports at living wage levels
- Mental health access
- Housing support expansion
- Food security programs

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'starting-over-support': {
    description: 'Support Albertans rebuilding their lives.',
    email_subject: 'Constituent Request: Starting Over Support',
    email_body: `Dear [Representative Name],

Starting over requires support systems that Alberta has underfunded.

Evidence:
- Mental health wait times: 6 months to 1.5 years
- Housing affordability crisis (17.5% rent increase in 2024)
- Social assistance rates below poverty line
- Employment support programs underfunded

Please advocate for:
- Mental health access
- Affordable housing
- Adequate income support
- Employment transition programs

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'career-transition': {
    description: 'Support workers transitioning to new careers.',
    email_subject: 'Constituent Request: Career Transition Support',
    email_body: `Dear [Representative Name],

Career transitions are increasingly necessary in Alberta's changing economy.

Evidence:
- Post-secondary funding cut 31% since 2015
- Limited retraining programs for displaced workers
- Adult education programs underfunded
- Career transition supports inadequate

Please advocate for:
- Retraining program investment
- Adult education support
- Career counseling services
- Transition income support

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'immigration-rights': {
    description: 'Support immigrant rights and integration.',
    email_subject: 'Constituent Request: Immigrant Support',
    email_body: `Dear [Representative Name],

Immigrants to Alberta deserve full rights and support.

Challenges:
- Foreign credential recognition slow and bureaucratic
- Language training programs underfunded
- Housing affordability crisis affects newcomers acutely
- Employment discrimination based on national origin

Please advocate for:
- Faster credential recognition
- Language training investment
- Housing support for newcomers
- Anti-discrimination enforcement

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  // ========================
  // ARTS CAMPAIGNS
  // ========================
  'arts-support': {
    description: 'Support arts and culture in Alberta communities.',
    email_subject: 'Constituent Request: Arts and Culture Support',
    email_body: `Dear [Representative Name],

Arts funding in Alberta needs continued investment.

Recent developments:
- AFA funding increased by $4.5 million (2024-25)
- 726 grants totaling $21.2 million awarded (2024)
- 40% increase in number of grants from previous year
- New funding programs being developed for 2025-26

Please continue to advocate for:
- Sustained arts funding increases
- Support for rural arts organizations
- Artist livelihood programs
- Cultural programming investment

Arts enrich all Alberta communities.

Sincerely,
[Your Name]
[Your Postal Code]`
  },

  'cultural-association-rights': {
    description: 'Protect rights to cultural expression and association.',
    email_subject: 'Constituent Request: Cultural Rights',
    email_body: `Dear [Representative Name],

The right to cultural association is fundamental.

Concerns:
- Treaty cultural rights not honored
- LGBTQ+ communities face Bills 26, 27, 29
- Immigrant communities face credential recognition barriers
- Cultural programming underfunded

Please advocate for:
- Treaty cultural rights
- LGBTQ+ cultural inclusion
- Immigrant cultural support
- Cultural program funding

Sincerely,
[Your Name]
[Your Postal Code]`
  }
};

// ============================================================================
// API HELPERS
// ============================================================================
async function makeRequest(method, path, data = null) {
  return new Promise((resolve, reject) => {
    const options = {
      hostname: 'db.freealberta.org',
      port: 443,
      path: path,
      method: method,
      headers: {
        'xc-token': NOCODB_API_TOKEN,
        'Content-Type': 'application/json'
      }
    };

    const req = https.request(options, (res) => {
      let body = '';
      res.on('data', chunk => body += chunk);
      res.on('end', () => {
        try {
          const parsed = body ? JSON.parse(body) : {};
          if (res.statusCode >= 200 && res.statusCode < 300) {
            resolve(parsed);
          } else {
            reject(new Error(`HTTP ${res.statusCode}: ${body}`));
          }
        } catch (e) {
          resolve(body);
        }
      });
    });

    req.on('error', reject);
    if (data) req.write(JSON.stringify(data));
    req.end();
  });
}

async function getAllCampaigns() {
  const campaigns = [];
  let offset = 0;
  const limit = 100;

  while (true) {
    const path = `/api/v2/tables/${CAMPAIGNS_TABLE_ID}/records?offset=${offset}&limit=${limit}`;
    const response = await makeRequest('GET', path);

    if (response.list && response.list.length > 0) {
      campaigns.push(...response.list);
      offset += response.list.length;
      if (response.list.length < limit) break;
    } else {
      break;
    }
  }

  return campaigns;
}

async function updateCampaign(campaignId, data) {
  const path = `/api/v2/tables/${CAMPAIGNS_TABLE_ID}/records`;
  const updateData = {
    ID: campaignId,
    ...data
  };
  return makeRequest('PATCH', path, updateData);
}

// ============================================================================
// MAIN EXECUTION
// ============================================================================
async function main() {
  console.log('='.repeat(60));
  console.log('Updating Campaigns: Short Descriptions + Evidence Emails');
  console.log('='.repeat(60));

  try {
    console.log('\nFetching all campaigns...');
    const campaigns = await getAllCampaigns();
    console.log(`Found ${campaigns.length} campaigns`);

    let updated = 0;
    let skipped = 0;

    for (const campaign of campaigns) {
      const slug = campaign['Campaign Slug'];
      const data = campaignData[slug];

      if (data) {
        console.log(`\nUpdating: ${slug}`);
        try {
          await updateCampaign(campaign.ID, {
            Description: data.description,
            'Email Subject': data.email_subject,
            'Email Body': data.email_body
          });
          console.log(`  ✓ Updated description and email content`);
          updated++;
        } catch (error) {
          console.error(`  ✗ Error: ${error.message}`);
        }
        // Rate limiting
        await new Promise(resolve => setTimeout(resolve, 200));
      } else {
        console.log(`\nSkipping (no data): ${slug}`);
        skipped++;
      }
    }

    console.log('\n' + '='.repeat(60));
    console.log('Summary');
    console.log('='.repeat(60));
    console.log(`Updated: ${updated}`);
    console.log(`Skipped: ${skipped}`);
    console.log(`Total: ${campaigns.length}`);

    // List campaigns without data
    const missingData = campaigns
      .filter(c => !campaignData[c['Campaign Slug']])
      .map(c => c['Campaign Slug']);

    if (missingData.length > 0) {
      console.log('\nCampaigns without data defined:');
      missingData.forEach(slug => console.log(`  - ${slug}`));
    }

  } catch (error) {
    console.error('Fatal error:', error);
    process.exit(1);
  }
}

main();