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 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