From a8c27881f7e6fe7b4cd4d0f6396a4d8c5d43008c Mon Sep 17 00:00:00 2001
From: terminaldweller <thabogre@gmail.com>
Date: Fri, 10 Jun 2022 15:26:17 +0430
Subject: updates

---
 db/mongo/build_db.js        | 35 +++++++++++++++++++++++++++++------
 db/postgres/create_db.pgsql |  2 ++
 2 files changed, 31 insertions(+), 6 deletions(-)
 create mode 100644 db/postgres/create_db.pgsql

(limited to 'db')

diff --git a/db/mongo/build_db.js b/db/mongo/build_db.js
index efabe5a..9711c31 100644
--- a/db/mongo/build_db.js
+++ b/db/mongo/build_db.js
@@ -42,13 +42,36 @@ const mangas = {
   "baki-dou": "https://readmanganato.com/manga-cc980259",
   "everyone's loose screw'": "https://manganato.com/manga-ga983883",
   "kumo desu": "https://readmanganato.com/manga-zd976712",
+  "dungeon sherpa": "https://manganato.com/manga-kt987428",
+  gachiakuta: "https://manganato.com/manga-na990935",
 };
 
 db = connect("192.168.1.109:27117/devi");
-// cursor = db.collection.find();
-// while (cursor.hasNext()) {
-//   printjson(cursor.next());
-// }
 
-db.mangas.insertOne(mangas);
-db.animes.insertOne(animes);
+var mangas_entry = db.mangas.find({});
+Object.keys(mangas_entry).forEach((prop) => {
+  console.log(prop);
+});
+while (mangas_entry.hasNext()) {
+  var mangas_id = mangas_entry.next()._id;
+  console.log(mangas_id);
+}
+db.mangas.updateOne(
+  { _id: mangas_id },
+  {
+    $set: {
+      "dungeon sherpa": "https://manganato.com/manga-kt987428",
+      gachiakuta: "https://manganato.com/manga-na990935",
+    },
+  }
+);
+
+var animes_entry = db.animes.find({});
+Object.keys(animes_entry).forEach((prop) => {
+  console.log(prop);
+});
+while (animes_entry.hasNext()) {
+  var animes_id = animes_entry.next()._id;
+  console.log(animes_id);
+}
+db.animes.updateOne({ _id: animes_id }, { $set: {} });
diff --git a/db/postgres/create_db.pgsql b/db/postgres/create_db.pgsql
new file mode 100644
index 0000000..3c52221
--- /dev/null
+++ b/db/postgres/create_db.pgsql
@@ -0,0 +1,2 @@
+SELECT 'CREATE DATABASE irc'
+WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = 'irc')\gexec
-- 
cgit v1.2.3