import { SimpleDB } from "https://raw.githubusercontent.com/EntenKoeniq/SimpleDB/master/mod.ts";

const db = new SimpleDB({filePath: "./test.json"}); // or 'new SimpleDB();' to create a database with the default name "db.json"

/* ===== INSERT ===== */
let insert = await db.insert({ username: "EntenKoeniq" });
await db.save();
console.log(insert);

/* ===== FIND ONE ===== */
let findOne = await db.findOne({ username: "EntenKoeniq" });

if (findOne === undefined) console.log("Not found!");
else console.log(findOne);

/* ===== EXISTS ===== */
console.log(await db.exists({ username: "EntenKoeniq" }));

/* ===== EXISTS ===== */
await db.findOneAndUpdate({ username: "EntenKoeniq" }, { username: "KoeniqEnten" });
await db.save();

/* ===== DELETE ===== */
if (await db.delete({ username: "EntenKoeniq" })) {
  await db.save();
  console.log("Succesfully deleted!");
}

await db.insert({ url: "google.de", short: "cj5f39", clicks: 0 }); // return a boolean value

await db.exists({ url: "google.de" }); // return a boolean value

/*
  * Look for a key "URL" with the value "google.de".
  * Return: index with key "url" and value "google.de" not found (undefined).
  * Return: index with key "url" and value "google.de" found (object of index).
*/
await db.findOne({ url: "google.de" });

/* ===== RESULT ===== */
{
  "_id": "n2toa7c4yr2ils1gmdlitu55",
  "url": "google.de",
  "short": "cj5f39",
  "clicks": 0
}

/*
  * Replace value of key "url" from the first index with key "short" and value "cj5f39".
  * Return: index with key "short" and value "cj5f39" not found (undefined).
  * Return: index with key "short" and value "cj5f39" found (object of index).
*/
await db.findOneAndUpdate({ short: "cj5f39" }, { url: "google.com" });

await db.delete({ url: "google.de" }); // Delete the first index with key "url" and value "google.de" (return a boolean value)

await db.save(); // Save all to x.json