updates

2 files changed, 31 insertions, 6 deletions

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