db("users").create({ name: "kenza", email: "[email protected]" });
db("users").read({ name: "kenza" });
db("users").update({ name: "kenza" }, { email: "[email protected]" });
db("users").delete({ name: "kenza" });

// Require library
const $0db = require("0db");

// Initialize database
// 💡 By default, A "db.json" file will be created in root directory
const db = await $0db();

// Create a new item within a collection named "users"
// 💡 If the collection doesn't exist it will be created automatically
// 💡 With the utility option "encrypt", the "password" field
//    will be saved as an encrypted hash string instead of the original
const createdUser = await db("users").create(
  {
    name: "kenza",
    email: "[email protected]",
    password: "secret123",
  },
  {
    encrypt: "password",
  }
);

// Read all items from "users" collection where "name" is "kenza"
// 💡 The "omit" option hides the "password" and "email"
//    fields in the returned results
const users = await db("users").read(
  { name: "kenza" },
  {
    omit: ["password", "email"],
  }
);

// Update all "users" items where "name" is "kenza"
// with new values for "email" and "password"
const updatedUser = await db("users").update(
  { name: "kenza" },
  {
    email: "[email protected]",
    password: "NEW_SECRET_123456789",
  }
);

// Delete all "users" items where "email" is "[email protected]"
const deletedUser = await db("users").update({ email: "[email protected]" });

// Initialize with a "db.json" file in the root directory
const db = await fsdb();

// Initialize with a custom named JSON file in the root directory
const db = await fsdb("my-database-file.json");

// Initialize with a custom named JSON file in the current directory
const db = await fsdb(__dirname + "/my-database-file");

const queryObj = {
  firstName: "kenza",
  age: 20,
  rating: 5
};

const users = await db("users").read(queryObj);

const queryFn = (user) => {
  return user.name.startsWith("k") && user.age >= 20 && rating >= 5;
};

const users = await db("users").read(queryFn);

const options = {
  unique: ["name", "email"],
  encrypt: "password",
  omit: ["email", "password"],
  nocase: true
};

const user = {
  name: "moulay-elhassan",
  email: "[email protected]",
  password: "secret#hasson?1980"
}

const createdUser = await db("users").create(user, options);

await db(collectionName).create(item?, options?);

// Create an item within a collection named "players" (automatically created)
// The created item is returned
const createdPlayer = await db("players").create({
  name: "ambratolm",
  level: 99,
  inventory: ["sword", "shield", "potion"],
});

// Create an item within a collection named "players" with some options
const createdPlayer = await db("players").create(
  {
    name: "ambratolm",
    level: 99,
    inventory: ["sword", "shield", "potion"],
    password: "this_is_a_secret",
  },
  {
    // Options
    unique: "name", // Make "name" field unique
    encrypt: "password", // Encrypt "password" field
    omit: ["password", "level"], // Omit fields in the returned item object
    nocase: true, // Ignore case when comparing strings
  }
);

await db(collectionName).read(query?, options?);

// Read all items in "players" collection
const players = await db("players").read();

// Read items matching a query object
const somePlayers = await db("players").read({ name: "ambratolm" });

// Read items matching a query function
const someOtherPlayers = await db("players").read(
  (player) => player.level >= 90
);

// Read items matching a query with some options
const player = await db("players").read(
  { name: "AmBrAtOlM" },
  {
    // Options
    nocase: true, // Ignore case when comparing strings
    one: true, // return only one result (an object instead of array)
  }
);

await db(collectionName).update(query?, changes?, options?);

// Update item(s)
// The updated item is returned
const updatedPlayer = await db("players").update(
  { name: "ambratolm" }, // Query can also be a function
  { name: "new name", level: 0 } // Changes to apply
);

// Update item(s) with some options
const updatedPlayer = await db("players").update(
  { name: "ambratolm" }, // Query can also be a function
  { name: "new name", level: 0 }, // Changes to apply
  {
    // Options
  }
);

await db(collectionName).delete(query?, options?);

// Delete item(s)
// The deleted item is returned
const deletedPlayer = await db("players").delete(
  { name: "ambratolm" } // Query can also be a function
);

// Delete item(s) with some options
const deletedPlayer = await db("players").delete(
  { name: "ambratolm" }, // Query can also be a function
  {
    // Options
  }
);

// Remove all collections
await db.drop();

// Remove a collection named "players"
await db("players").drop();

// Remove all items in a collection named "players" and keep it
await db("players").clear();