from sqlmodel.ext.asyncio.session import AsyncSession from app.model.email_template import EmailTemplate, TemplateType from app.repo.email_template import get_all_templates, create_template from typing import List # Default professional email templates DEFAULT_TEMPLATES = [ { "name": "Newsletter - Monthly Digest", "template_type": TemplateType.newsletter, "subject": "Your Monthly Digest - {month}", "body": """
Monthly Digest

Your Monthly Insights.

We've compiled the best updates from this month just for you.

Hello {name},

Here's a look at the top stories and major breakthroughs from our community this month.

Top Stories:

Read Full Digest

Ā© 2026 AeroMail. All rights reserved.

Unsubscribe | Manage Preferences

""", "description": "Professional monthly newsletter digest" }, { "name": "Promotional - Special Offer", "template_type": TemplateType.promotional, "subject": "šŸŽ‰ Exclusive Offer: {discount}% Off!", "body": """

Limited Time Offer!

{discount}% OFF

Don't miss out on this exclusive deal

Hi {name},

We're excited to offer you an exclusive {discount}% discount on your next purchase. This is our way of saying thank you for being a valued member.

Claim Offer Now

Offer valid until {expiry_date}

Ā© 2026 AeroMail. All rights reserved.

""", "description": "Eye-catching promotional offer email" }, { "name": "Announcement - Company Update", "template_type": TemplateType.announcement, "subject": "Important Update: {announcement_title}", "body": """

{announcement_title}

Hello {name},

We have an important update we'd like to share with our community regarding our latest developments.

{announcement_content}

Thank you for your continued support and for being part of our journey.

Best regards,
The AeroMail Team

Ā© 2026 AeroMail. All rights reserved.

""", "description": "Professional company announcement" }, { "name": "Product Launch", "template_type": TemplateType.product, "subject": "Introducing {product_name} - Now Available!", "body": """
New Release

{product_name}

The future of email marketing is here.

Hello {name},

We're thrilled to officially announce the launch of {product_name}. After months of development, it's finally ready for you.

Why you'll love it:

āœ“ Advanced Automation Flows
āœ“ Next-Gen Analytics Dashboard
āœ“ AI-Powered Content Generation
Get Started Now
""", "description": "Product launch announcement" }, { "name": "Event Invitation", "template_type": TemplateType.event, "subject": "You're Invited: {event_name}", "body": """
šŸ“…

You're Invited!

{event_name}

šŸ“ Location: {event_location}
ā° Time: {event_date} at {event_time}

{event_description}

Save My Spot
""", "description": "Event invitation with registration link" }, { "name": "Webinar Invitation", "template_type": TemplateType.webinar, "subject": "Join Our Webinar: {topic}", "body": """

Live Webinar

{topic}

Hello {name},

You're invited to attend our upcoming exclusive guest webinar session.

Topic: {topic}

Speaker: {speaker_name}

When: {webinar_date} at {webinar_time}

Register for Webinar
""", "description": "Webinar invitation" }, { "name": "Onboarding Welcome", "template_type": TemplateType.onboarding, "subject": "Welcome {name}! Let's Get Started", "body": """

Welcome! šŸŽ‰

We're thrilled to have you, {name}.

Your Getting Started Checklist:

Step 1: Complete your profile setup
Step 2: Connect your first email list
Step 3: Launch your first campaign

If you need any help, our team is just a reply away!

""", "description": "Welcome onboarding email for new users" }, { "name": "Feedback Request", "template_type": TemplateType.feedback, "subject": "We'd Love Your Feedback!", "body": """
šŸ’¬

How are we doing?

Hi {name}, your feedback helps us build a better experience for everyone. Would you mind taking 2 minutes to share your thoughts?

Share Feedback
""", "description": "Customer feedback survey request" }, { "name": "Retention - Win Back", "template_type": TemplateType.retention, "subject": "We Miss You! Here's {incentive} Just for You", "body": """

We Miss You!

Come back and enjoy exclusive benefits.

Hi {name}, it's been a while.

We'd love to have you back! To make it easier, here's a special gift: {incentive}.

Claim My Gift

Expires on {expiry_date}

""", "description": "Win-back campaign for inactive users" }, { "name": "Sales - Follow Up", "template_type": TemplateType.sales, "subject": "Quick Question About {product}", "body": """

Hi {name},

I hope you've been doing well! I'm reaching out because I noticed you were interested in {product}.

I'd love to hear if you have any questions or if there's anything I can clarify for you. We've helped many teams similar to yours achieve great results with {product}.

"The best tool we've used for email engagement." - Happy Client

Would you be open to a quick 10-minute chat this week?

Schedule a Call

Best regards,
{sales_rep_name}
AeroMail Team

""", "description": "Sales follow-up email" } ] async def initialize_default_templates(db: AsyncSession) -> int: """Initialize default email templates if they don't exist""" existing_templates = await get_all_templates(db) if existing_templates: print(f"āœ… {len(existing_templates)} templates already exist, skipping initialization") return len(existing_templates) created_count = 0 for template_data in DEFAULT_TEMPLATES: try: await create_template( name=template_data["name"], template_type=template_data["template_type"], subject=template_data["subject"], body=template_data["body"], description=template_data["description"], db=db ) created_count += 1 print(f"āœ… Created template: {template_data['name']}") except Exception as e: print(f"āŒ Error creating template {template_data['name']}: {str(e)}") print(f"\nāœ… Successfully initialized {created_count} email templates") return created_count