mongoexport: 컬렉션을 파일로 내보내기

# Export the 'products' collection to JSONL
mongoimport \
  --uri 'mongodb://localhost:27017/myapp' \
  --collection products \
  --out products_export.json

# Each line in the output file is one document:
# {"_id":{"$oid":"..."},"name":"Widget","price":9.99}
# {"_id":{"$oid":"..."},"name":"Gadget","price":19.99}

# Export selected fields as CSV
mongoimport \
  --uri 'mongodb://localhost:27017/myapp' \
  --collection products \
  --type csv \
  --fields 'name,price,category,rating' \
  --out products_export.csv

# Output:
# name,price,category,rating
# Widget,9.99,tools,4.5
# Gadget,19.99,electronics,4.2

# Export only shipped orders from January 2024
mongoimport \
  --uri 'mongodb://localhost:27017/myapp' \
  --collection orders \
  --query '{"status":"shipped","createdAt":{"$gte":{"$date":"2024-01-01T00:00:00Z"},"$lt":{"$date":"2024-02-01T00:00:00Z"}}}' \
  --out january_orders.json

# Export only name, email, and createdAt for active users
mongoimport \
  --uri 'mongodb://localhost:27017/myapp' \
  --collection users \
  --query '{"isActive":true}' \
  --fields 'name,email,createdAt' \
  --out active_users.json

# Sensitive fields like passwordHash are automatically excluded

# Export events in chronological order
mongoimport \
  --uri 'mongodb://localhost:27017/myapp' \
  --collection events \
  --sort '{"timestamp":1}' \
  --out events_sorted.json

# Export the 100 most recently created products (sample for testing)
mongoimport \
  --uri 'mongodb://localhost:27017/myapp' \
  --collection products \
  --sort '{"createdAt":-1}' \
  --limit 100 \
  --out products_sample.json

# Default (Canonical Extended JSON)
# {"_id":{"$oid":"65a..."},"price":{"$numberDecimal":"9.99"}}

# Relaxed Extended JSON — more human-readable
mongoimport \
  --uri 'mongodb://localhost:27017/myapp' \
  --collection products \
  --relaxed \
  --out products_relaxed.json
# {"_id":"65a...","price":9.99}

# Export from Atlas cluster
MONGO_URI='mongodb+srv://user:password@cluster0.abc.mongodb.net/myapp'

mongoimport \
  --uri "$MONGO_URI" \
  --collection orders \
  --query '{"status":"completed"}' \
  --out completed_orders.json

# Count documents exported
mongoimport --uri '...' --collection products | wc -l

# Pipe to jq to extract just product names
mongoimport --uri '...' --collection products | jq -r '.name'

# Compress while exporting
mongoimport --uri '...' --collection products | gzip > products.json.gz