NoSQL 数据库存储促销

{
  "_id": "ObjectId",
  "name": "String",
  "description": "String",
  "startDate": "Date",
  "endDate": "Date",
  "discountPercentage": "Number",
  "applicableProducts": ["ObjectId"], // 关联产品的ID数组
  "isActive": "Boolean"
}

const { MongoClient } = require('mongodb');

async function run() {
  const uri = "your_mongodb_connection_string";
  const client = new MongoClient(uri);

  try {
    await client.connect();
    const database = client.db('your_database_name');
    const promotionsCollection = database.collection('promotions');

    // 插入一条促销信息
    const promotion = {
      name: "Summer Sale",
      description: "Get 20% off on all items.",
      startDate: new Date(),
      endDate: new Date(new Date().getTime() + 7 * 24 * 60 * 60 * 1000),
      discountPercentage: 20,
      applicableProducts: ["product_id_1", "product_id_2"],
      isActive: true
    };

    const result = await promotionsCollection.insertOne(promotion);
    console.log(`Promotion inserted with id: ${result.insertedId}`);
  } finally {
    await client.close();
  }
}

run().catch(console.dir);