"""cms_pages: seed 7 original marketing pages

Revision ID: 0031
Revises: 0030
Create Date: 2026-06-29
"""
from alembic import op

revision = "0031"
down_revision = "0030"
branch_labels = None
depends_on = None


def upgrade() -> None:
    op.execute("""
        INSERT INTO cms_pages (id, name, path, headline, subhead, status, created_at, updated_at)
        VALUES
          (gen_random_uuid(), 'Home', 'home',
           'Honor every life. Run the cemetery beautifully.',
           'INDELIS brings every plot, record, contract, and memorial into one calm place — with helpful AI that handles the busywork.',
           'Published', now(), now()),
          (gen_random_uuid(), 'Features', 'features',
           'Everything your team needs in one easy place',
           'From the first phone call about a plot to a finished memorial page families can visit online — these are the tools your team uses every day, all in one place.',
           'Published', now(), now()),
          (gen_random_uuid(), 'Solutions', 'solutions',
           'From paper ledgers to a modern cemetery, without losing what makes yours yours',
           'Most cemeteries we work with are dealing with the same things — boxes of paper, old spreadsheets, families who can''t find a grave, and a sales team juggling phone notes. INDELIS pulls all of it into one tidy place.',
           'Published', now(), now()),
          (gen_random_uuid(), 'Who We Serve', 'who-we-serve',
           'Whatever kind of cemetery you run, INDELIS shapes itself to your team',
           'Every cemetery has its own history, its own rules, and its own people. INDELIS works for one small municipal site or a network of religious cemeteries — and adapts to the way you do things.',
           'Published', now(), now()),
          (gen_random_uuid(), 'Pricing', 'pricing',
           'Simple monthly pricing that scales with your cemetery',
           'Pick a plan, start a free trial, and pay monthly. No setup fees and no long-term contract — upgrade or cancel anytime. All prices in CAD.',
           'Published', now(), now()),
          (gen_random_uuid(), 'About', 'about',
           'We make cemetery software the way it should be made',
           'We''re a small team building one thing: software that respects the work cemetery teams do every day, and the families they serve.',
           'Published', now(), now()),
          (gen_random_uuid(), 'Contact', 'contact',
           'Book a walkthrough, ask a question, or just say hello',
           'Tell us a little about your cemetery and we''ll get back to you within one business day. Already a customer? Our support team is here for you any time.',
           'Published', now(), now())
        ON CONFLICT (path) DO NOTHING
    """)


def downgrade() -> None:
    op.execute("""
        DELETE FROM cms_pages
        WHERE path IN ('home', 'features', 'solutions', 'who-we-serve', 'pricing', 'about', 'contact')
    """)