Papers Mongodb

pepeul1191
1

Express JS + Svelte + Mongodb para almacenar articulos

Express Base

Archivo .env

DB="sqlite:///db/demo.db" ENV="local" MAIL_PORT=465 MAIL_USER="xyz@gmail.com" MAIL_PASS="asdfas" MAIL_HOST="smtp.google.com"

Migraciones

Migraciones con DBMATE - accesos/sqlite3:

$ npm run dbmate:new <<nombre_de_migracion>>
$ npm run dbmate:up
$ npm run dbmate:rollback

Consultas MongoDB

Hacer backup

$ mongodump --db papers

Restaurar backup

$ mongorestore --db papers <ruta_al_archivo_de_volcado>

Listar todos los papers:

db.papers.aggregate([
  {
    $lookup: {
      from: "key_words",
      localField: "key_words",
      foreignField: "_id",
      as: "key_words_data"
    }
  },
  {
    $project: {
      _id: { $toString: "$_id" },
      authors: 1,
      author_abstract: 1,
      my_abstract: 1,
      name: 1,
      year: 1,
      source: 1,
      source_url: 1,
      my_ranking: 1,
      key_words: 1,
      doi: 1,
      file_url: 1,
      created: { $dateToString: { format: "%d/%m/%Y %H:%M:%S", date: "$created", timezone: "-05:00" } },
      updated: { $dateToString: { format: "%d/%m/%Y %H:%M:%S", date: "$updated", timezone: "-05:00" } },
      // Agrega aquí todos los campos necesarios que no deseas cambiar
      key_words: {
        $map: {
          input: "$key_words_data",
          as: "kw",
          in: {
            _id: { $toString: "$$kw._id" },
            name: "$$kw.name",
            // Agrega aquí los campos adicionales de key_words si los hay
          }
        }
      }
    }
  }
]);

Traer un paper por id:

db.papers.aggregate([
  {
    $match: { _id: ObjectId("tu_id_aqui") } // Reemplaza "tu_id_aqui" con el ID específico que deseas buscar
  },
  {
    $lookup: {
      from: "key_words",
      localField: "key_words",
      foreignField: "_id",
      as: "key_words_data"
    }
  },
  {
    $lookup: {
      from: "images",
      localField: "images",
      foreignField: "_id",
      as: "images_data"
    }
  },
  {
    $project: {
      _id: { $toString: "$_id" },
      authors: 1,
      author_abstract: 1,
      my_abstract: 1,
      year: 1,
      source: 1,
      source_url: 1,
      my_ranking: 1,
      key_words: 1,
      doi: 1,
      file_url: 1,
      images: 1,
      name: 1,
      created: { $dateToString: { format: "%d/%m/%Y %H:%M:%S", date: "$created", timezone: "-05:00" } },
      updated: { $dateToString: { format: "%d/%m/%Y %H:%M:%S", date: "$updated", timezone: "-05:00" } },
      // Agrega aquí todos los campos necesarios que no deseas cambiar
      key_words: {
        $map: {
          input: "$key_words_data",
          as: "kw",
          in: {
            _id: { $toString: "$$kw._id" },
            name: "$$kw.name",
            // Agrega aquí los campos adicionales de key_words si los hay
          }
        }
      },
      images: {
        $map: {
          input: "$images_data",
          as: "kw",
          in: {
            _id: { $toString: "$$kw._id" },
            name: "$$kw.name",
            created: { $dateToString: { format: "%d/%m/%Y %H:%M:%S", date: "$$kw.created", timezone: "-05:00" } },
            url: "$$kw.file_surl",
            // Agrega aquí los campos adicionales de key_words si los hay
          }
        }
      }
    }
  }
]);

Fuentes:

Top categories