Seed Database

Populate DynamoDB tables with sample data for development/testing.

WARNING

This skill modifies database data. ALWAYS verify the environment before proceeding.

Pre-checks

1. Verify environment (NEVER run in production!):

   echo "Current AWS Profile: $AWS_PROFILE"
   aws sts get-caller-identity --profile pitfal
   

2. Confirm with user before proceeding

Seed Commands

Seed All Tables (Recommended Order)

# 1. Seed admin users and settings first
aws dynamodb batch-write-item \
  --request-items file://scripts/seed-admin.json \
  --profile pitfal

# 2. Seed galleries and images
aws dynamodb batch-write-item \
  --request-items file://scripts/seed-galleries.json \
  --profile pitfal

# 3. Seed sample inquiries
aws dynamodb batch-write-item \
  --request-items file://scripts/seed-inquiries.json \
  --profile pitfal

Seed Individual Tables

Admin Users & Settings

aws dynamodb batch-write-item \
  --request-items file://scripts/seed-admin.json \
  --profile pitfal

Galleries & Images

aws dynamodb batch-write-item \
  --request-items file://scripts/seed-galleries.json \
  --profile pitfal

Inquiries

aws dynamodb batch-write-item \
  --request-items file://scripts/seed-inquiries.json \
  --profile pitfal

Verify Seeding

# Count items in galleries table
aws dynamodb scan \
  --table-name pitfal-galleries \
  --select COUNT \
  --profile pitfal

# Count items in inquiries table
aws dynamodb scan \
  --table-name pitfal-inquiries \
  --select COUNT \
  --profile pitfal

# Count items in admin table
aws dynamodb scan \
  --table-name pitfal-admin \
  --select COUNT \
  --profile pitfal

Seed Data Contents

File	Contents
seed-admin.json	Admin user, site settings, services, testimonials, FAQs
seed-galleries.json	Sample galleries (brand, portrait, event) with images
seed-inquiries.json	Sample booking inquiries in various statuses

Default Admin Credentials

• Username: admin
• Password: admin123 (change immediately in production!)
• Note: Password hash in seed file is bcrypt with cost factor 12

Clear Data (Development Only)

To remove all seed data:

# This is destructive - confirm before running
aws dynamodb delete-table --table-name pitfal-galleries --profile pitfal
aws dynamodb delete-table --table-name pitfal-inquiries --profile pitfal
aws dynamodb delete-table --table-name pitfal-admin --profile pitfal
# Then re-run terraform apply to recreate tables