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
- Verify environment (NEVER run in production!):
echo "Current AWS Profile: $AWS_PROFILE" aws sts get-caller-identity --profile pitfal - 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 pitfalSeed Individual Tables
Admin Users & Settings
aws dynamodb batch-write-item \
--request-items file://scripts/seed-admin.json \
--profile pitfalGalleries & Images
aws dynamodb batch-write-item \
--request-items file://scripts/seed-galleries.json \
--profile pitfalInquiries
aws dynamodb batch-write-item \
--request-items file://scripts/seed-inquiries.json \
--profile pitfalVerify 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 pitfalSeed 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