Node.js 读取并编辑Firebase Database JSON文件问题求助

Since you mentioned your data comes from Firebase, I’ll use the common nested key-value structure that Firebase Realtime Database exports as an example, along with a typical target array format. I’ll also walk through a working solution and common fixes for code that fails to run.

Example Input (Firebase-style data.json) #

Firebase usually exports data with auto-generated unique IDs as top-level keys for each entry:

{
  "products": {
    "prod_001": {
      "name": "Wireless Headphones",
      "price": 99.99,
      "in_stock": true
    },
    "prod_002": {
      "name": "Bluetooth Speaker",
      "price": 49.99,
      "in_stock": false
    }
  }
}

Example Target Format #

Let’s assume you want to convert this into a flat array with each entry including its original Firebase ID:

[
  {
    "id": "prod_001",
    "name": "Wireless Headphones",
    "price": 99.99,
    "in_stock": true
  },
  {
    "id": "prod_002",
    "name": "Bluetooth Speaker",
    "price": 49.99,
    "in_stock": false
  }
]

Working Python Code #

This script handles the conversion and includes basic error handling to catch common issues:

import json

def convert_firebase_json(input_path, output_path, target_node):
    # Load the original Firebase data
    try:
        with open(input_path, 'r', encoding='utf-8') as f:
            firebase_data = json.load(f)
    except FileNotFoundError:
        print(f"Error: File {input_path} not found.")
        return
    except json.JSONDecodeError:
        print(f"Error: {input_path} is not valid JSON.")
        return

    # Validate the target node exists in the input data
    if target_node not in firebase_data:
        print(f"Error: Target node '{target_node}' not found in the input JSON.")
        return

    # Convert to the target array format
    target_data = []
    for item_id, item_details in firebase_data[target_node].items():
        # Attach the Firebase-generated ID to each entry
        item_details['id'] = item_id
        target_data.append(item_details)

    # Save the converted data to a new file
    with open(output_path, 'w', encoding='utf-8') as f:
        json.dump(target_data, f, indent=2)
    print(f"Conversion done! Saved to {output_path}")

# Run the function - adjust these values to match your actual data
convert_firebase_json(
    input_path='data.json',
    output_path='converted_data.json',
    target_node='products'  # Replace with your actual top-level node name
)

Fixes for Your Non-Working Code #

If your existing code isn’t running, check these common pitfalls:

• Incorrect Node Reference: Double-check that you’re accessing the right top-level key (e.g., products instead of items). Firebase’s exported JSON is often nested under a node matching your database path.
• Missing Error Handling: Add try/except blocks to catch missing files or invalid JSON—this will tell you exactly where things break.
• Data Type Mismatches: If your target format requires specific types (e.g., numbers instead of strings), add type conversion logic like float(item_details['price']) if Firebase stored values as strings.
• Encoding Issues: Always specify encoding='utf-8' when reading/writing JSON to avoid garbled text.

内容的提问来源于stack exchange，提问作者Kern Elliott