testing_commands.js

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

const uri = "mongodb+srv://phoebe_bear:GoldenDragon1@comp30022-project.yybkyjm.mongodb.net/?retryWrites=true&w=majority"
const client = new MongoClient(uri);

async function create_users() {
  MongoClient.connect(uri, function(err, db) {
    var dbo = db.db("ProjectDatabase");

    if (err) throw err;
    var user_1 = { display_name: "Test User 1", login_email: "test_user1@gmail.com", hashed_password: "thisisapassword" };
    var user_2 = { display_name: "Test User 2", login_email: "test_user3@gmail.com", hashed_password: "thisisapassword" };
    var user_3 = { display_name: "Test User 3", login_email: "test_user3@gmail.com", hashed_password: "thisisapassword" };
    var users = [user_1, user_2, user_3]
    dbo.collection("users").insertMany(users, function(err, res) {
      if (err) throw err;
      console.log(res);
      db.close();
    });
  });
}

async function get_users() {
  var allValues;
  try {
    const database = client.db("ProjectDatabase");
    const users = database.collection("users");

    const cursor = users.find();

    // print a message if no documents were found
    if ((await cursor.countDocuments) == 0) {
      console.log("No documents found!");
    }
    // replace console.dir with your callback to access individual elements
    allValues = await cursor.toArray();
  } finally {
    await client.close();
  }
  return allValues

}

function call_back(input) {
  console.log((input._id).toString())
}

async function main() {
  users = await get_users().catch(console.dir);
  test_owner = users[0]._id.toString()
  console.log(users)
}

async function create_items(item) {
  var result
  try {
    const database = client.db("ProjectDatabase");
    const items = database.collection("items");
    result = await items.insertOne(item);
    console.log(`A document was inserted with the _id: ${result.insertedId}`);
  } finally {
    await client.close();
  }
  return result._id
}

async function create_loan(loan) {
  var result
  try {
    const database = client.db("ProjectDatabase");
    const loans = database.collection("loans");
    result = await loans.insertOne(loan);
    console.log(`A document was inserted with the _id: ${result.insertedId}`);
  } finally {
    await client.close();
  }
  return result._id
}
async function alter_users() {
  
  MongoClient.connect(uri, function(err, db) {
    if (err) throw err;
    const database = db.db("ProjectDatabase");
    var myquery = {}
    var newvalues =  {
      $set: { "item_categories": ["Electronics", "Books", "Stationary", "University Resources", "Cash", "Miscellaneous", "Personal", "Clothing and Apparel", "Toiletries and Beauty"] } }
    
    const result = database.collection("users").updateMany(myquery, newvalues, function (err, res) {
      if (err) throw err;
  });
});
}




async function update_item(item_id) {
  const database = client.db("ProjectDatabase");
  const items = database.collection("items");

  const filter = {_id: new ObjectId(item_id)}
  const updateDocument = {
    $set: {
      being_loaned: true
    },
    $inc: {
      loan_frequency: 1
    }
  }
  const result = await items.updateOne(filter, updateDocument);
  console.log(result)

}



const book = {
  item_name: "Harry Potter",
  category: "Books",
  description: "The Philosopher's Stone.",
  item_owner: new ObjectId("62fd8a9df04410afbc6df31d"),
  being_loaned: false,
  loan_frequency: 0
}

const laptop = {
  item_name: "Macbook Pro",
  category: "Electronics",
  description: "Newest Macbook released by Apple",
  item_owner: new ObjectId("62fd8a9df04410afbc6df31e"),
  being_loaned: false,
  loan_frequency: 0
}

const sunscreen = {
  item_name: "Shiseido Sunscreen",
  category: "Toiletries and Beauty",
  description: "Very nice SPF 50+ sunscreen",
  item_owner: new ObjectId("62fd8a9df04410afbc6df31d"),
  being_loaned: false,
  loan_frequency: 0
}


const loan_sunscreen = {
  loaner_id: new ObjectId("62fd8a9df04410afbc6df31d"),
  loanee_id: new ObjectId("62fd8a9df04410afbc6df31e"),
  item_id: new ObjectId("62fd8d5bfd46ebc631b3bc79"),
  status: "Current",
  loan_start_date: new Date("2022-08-18"),
  intended_return_date: new Date("2022-08-25"),
  actual_return_date: new Date()
}

const loan_macbook = {
  "loaner_id": "62fd8a9df04410afbc6df31e",
  "loanee_id": "62fd8a9df04410afbc6df31d",
  "item_id": "62fd8cf7fedbec68c80f5878",
  "status": "Current",
  "loan_start_date": "2022-08-18",
  "intended_return_date": "2022-08-25"
}

<<<<<<< HEAD
loan_command = { collMod: "loans",
validator: {
  $jsonSchema: {
      bsonType: "object",
      required: ["loaner_id", "loanee_id", "item_id", "status", "loan_start_date", "intended_return_date"],
      properties: {
          loaner_id: {
              bsonType: "objectId",
              description: "loaner id."
          },
          loanee_id: {
              bsonType: "objectId",
              description: "loanee id."
          },
          item_id: {
              bsonType: "objectId",
              description: "item owner."
          },
          status: {
              bsonType: "string",
              enum: ["On Loan", "Overdue", "On Time Return", "Late Return", "Early Return"],
              description: "loan status."
          },
          loan_start_date: {
              bsonType: "date",
              description: "Loan start date."
          },
          intended_return_date: {
              bsonType: "date",
              description: "Intended return date."
          },
          actual_return_date: {
            bsonType: "date",
            description: "Actual return date"
          },
          loanee_name: {
            bsonType: "string",
            description: "name"
          },
          item_image: {
            bsonType: "string",
            description: "item_image"
          }

      }
  }
}
}


user_command = { collMod: "users",
validator: {
  $jsonSchema: {
      bsonType: "object",
      required: ["display_name", "login_email", "hashed_password", "item_categories"],
      properties: {
        display_name: {
              bsonType: "string",
              description: "display name"
          },
          login_email: {
              bsonType: "string",
              description: "email"
          },
          hashed_password: {
              bsonType: "string",
              description: "password"
          },
          item_categories: {
            bsonType: "array",
            description: "item categories",
            items: {
              bsonType: "string",
           }       
          }
      }
  }
}
}
item_command = { collMod: "items",
validator: {
  $jsonSchema: {
      bsonType: "object",
      required: ["item_name", "category", "description", "item_owner", "being_loaned", "loan_frequency"],
      properties: {
        item_name: {
              bsonType: "string",
              description: "name"
          },
          category: {
              bsonType: "string",
              description: "category"
          },
          description: {
              bsonType: "string",
              description: "description"
          },
          item_owner: {
              bsonType: "objectId",
              description: "item_owner"
          },
          being_loaned: {
            bsonType: "bool",
            description: "being_loaned"
        },
        loan_frequency: {
          bsonType: "int",
          description: "loan_frequency"
        },
        image_url: {
          bsonType: "string",
          description: "image_url"
        },
        visible: {
          bsonType: "bool",
          description: "visible"
        }
      }
  }
}
}


=======
>>>>>>> develop
async function main(){

  await client.connect();
  MongoClient.connect(uri, function(err, db) {
      if (err) throw err;
<<<<<<< HEAD
      db.db("ProjectDatabaseProduction").command(user_command, function(err, res) {
=======
      db.db("ProjectDatabaseTesting").command( { collMod: "items",
          validator: {
            $jsonSchema: {
                bsonType: "object",
                required: ["item_name", "category","item_owner", "being_loaned", "loan_frequency", "visible"],
                properties: {
                  item_name: {
                        bsonType: "string",
                        description: "item_name"
                    },
                    category: {
                        bsonType: "string",
                        description: "category"
                    },
                    description: {
                        bsonType: "string",
                        description: "description"
                    },
                    item_owner: {
                        bsonType: "objectId",
                        description: "item_owner"
                    },
                    being_loaned: {
                        bsonType: "bool",
                        description: "being_loaned"
                    },
                    loan_frequency: {
                        bsonType: "int",
                        description: "loan_frequency"
                    },
                    visible: {
                      bsonType: "bool",
                      description: "visible"
                    },
                    image_url: {
                      bsonType: "string",
                      description: "image_url"
                    }
                }
            }
        }
      }, function(err, res) {
>>>>>>> develop
      if (err) throw err;
      console.log("Collection created!"); })
      db.db("ProjectDatabaseProduction").command(loan_command, function(err, res) {
        if (err) throw err;
        console.log("Collection created!"); })
      db.db("ProjectDatabaseProduction").command(item_command, function(err, res) {
        if (err) throw err;
        console.log("Collection created!"); })
      return;
  });
}

main()