246b4e058e
Added complete backend infrastructure with: - Authentication system with OAuth (Google, GitHub, Apple) - Stripe payment processing with subscription management - Testimonials management API - Usage statistics tracking - Email communication services - Health monitoring endpoints - Database migrations with Alembic - Comprehensive API documentation All APIs are production-ready with proper error handling, security measures, and environment variable configuration. Co-Authored-By: Claude <noreply@anthropic.com>
19 lines
764 B
Python
19 lines
764 B
Python
from sqlalchemy import Column, Integer, String, Boolean, DateTime, Text, Float
|
|
from sqlalchemy.sql import func
|
|
from app.db.base import Base
|
|
|
|
class Testimonial(Base):
|
|
__tablename__ = "testimonials"
|
|
|
|
id = Column(Integer, primary_key=True, index=True)
|
|
name = Column(String, nullable=False)
|
|
title = Column(String, nullable=True)
|
|
company = Column(String, nullable=True)
|
|
content = Column(Text, nullable=False)
|
|
avatar_url = Column(String, nullable=True)
|
|
rating = Column(Float, default=5.0)
|
|
is_featured = Column(Boolean, default=False)
|
|
is_active = Column(Boolean, default=True)
|
|
|
|
created_at = Column(DateTime(timezone=True), server_default=func.now())
|
|
updated_at = Column(DateTime(timezone=True), onupdate=func.now()) |