Satisfacción's questions

I have this function where I have 2 parameters, I use the "field" parameter to access an object but it takes it as an attribute of the object and does not refer to my parameter.

async id(modelo, campo){
    const data = await modelo.all()
    console.log(data)
    
    var idmayor = 0
    for (let i = 0; i < data.rows.length; i++) {
        const id = data.rows[i].campo;
        if(id > idmayor){
            idmayor = id
        }
        console.log(idmayor)
    }
    idmayor + 1
    return idmayor
}

Here it can be shown better that it does not refer to the parameter "field"

Thank you

I want to install @adonisjs/validator in my adonis project, with the command:

adonis install @adonisjs/validator

but I get this error

[1/1] ❌ Installation failed [@adonisjs/validator]

ERROR  Command failed: npm i --save @adonisjs/validator
npm ERR! code ERESOLVE
npm ERR! ERESOLVE unable to resolve dependency tree
npm ERR!
npm ERR! While resolving: [email protected]
npm ERR! Found: @adonisjs/[email protected]
npm ERR! node_modules/@adonisjs/bodyparser
npm ERR!   @adonisjs/bodyparser@"~2.0.9" from the root project
npm ERR!
npm ERR! Could not resolve dependency:
npm ERR! peer @adonisjs/bodyparser@"^7.0.0" from @adonisjs/[email protected]
npm ERR! node_modules/@adonisjs/validator
npm ERR!   @adonisjs/validator@"^11.0.0" from the root project
npm ERR!
npm ERR! Fix the upstream dependency conflict, or retry
npm ERR! this command with --force, or --legacy-peer-deps
npm ERR! to accept an incorrect (and potentially broken) dependency resolution.
npm ERR!
npm ERR! See C:\Users\juanv\AppData\Local\npm-cache\eresolve-report.txt for a full report.

npm ERR! A complete log of this run can be found in:
npm ERR!     C:\Users\juanv\AppData\Local\npm-cache\_logs\2021-04-30T04_38_03_282Z-debug.log

then run this command:

npm i --save @adonisjs/validator

and I get another error

npm ERR! code ERESOLVE
npm ERR! ERESOLVE unable to resolve dependency tree
npm ERR!
npm ERR! While resolving: [email protected]
npm ERR! Found: @adonisjs/[email protected]
npm ERR! node_modules/@adonisjs/bodyparser
npm ERR!   @adonisjs/bodyparser@"~2.0.9" from the root project
npm ERR!
npm ERR! Could not resolve dependency:
npm ERR! peer @adonisjs/bodyparser@"^7.0.0" from @adonisjs/[email protected]
npm ERR! node_modules/@adonisjs/validator
npm ERR!   @adonisjs/validator@"^11.0.0" from the root project
npm ERR!
npm ERR! Fix the upstream dependency conflict, or retry
npm ERR! this command with --force, or --legacy-peer-deps
npm ERR! to accept an incorrect (and potentially broken) dependency resolution.
npm ERR!
npm ERR! See C:\Users\juanv\AppData\Local\npm-cache\eresolve-report.txt for a full report.

npm ERR! A complete log of this run can be found in:
npm ERR!     C:\Users\juanv\AppData\Local\npm-cache\_logs\2021-04-30T04_40_33_919Z-debug.log

try to create a new project and just install @adonisjs/validator, but I get the same error, I already cleared cache with the command:

npm cache clean --force

and delete the node_modules folder and reinstall the dependencies with:

npm install --save

but it keeps giving me the same error, thanks

Hello, I want to upload an Api made in adonisjs to aws but it doesn't work for me, this is what I did, create a normal instance with the Ubuntu OS and perform a git clone, then run a

npm install --save

in the api that I just cloned to install the modules and create the .env file to assign the configuration where the server will start, this is the default configuration of an .env

HOST=127.0.0.1
PORT=3333
NODE_ENV=development
APP_NAME=AdonisJs
APP_URL=http://${HOST}:${PORT}
CACHE_VIEWS=false
APP_KEY=0fL3Ju674VAreZZkNYPe0gtUJcRRUUiX
DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_USER=root
DB_PASSWORD=
DB_DATABASE=adonis
HASH_DRIVER=bcrypt

The server will start and everything is fine, but it will start locally, due to the .env configuration, so I modify this so that it starts on port 3333 and that's it, but it didn't work for me.

It is in the configuration to start on port 3333

HOST=
PORT=3333
NODE_ENV=development
APP_NAME=AdonisJs
APP_URL=:${PORT}

When starting the server I get this in the terminal:

and in the web browser this:

I am making a connection to mongodb through the mongoose library, and when I start the server and consume a route, this appears:

(node:3500) DeprecationWarning: current URL string parser is deprecated, and will be removed in a future version. To use the new parser, pass option { useNewUrlParser: true } to MongoClient.connect. (Use node --trace-deprecation ...to show where the warning was created) (node:3500) [MONGODB DRIVER] Warning: Current Server Discovery and Monitoring engine is deprecated, and will be removed in a future version. To use the new Server Discover and Monitoring engine, pass option { useUnifiedTopology: true } to the MongoClient constructor.

So I put this option useNewUrlParser: true where mongoose makes the connection, but it didn't work.

MongoseeProvider.js

_registerMongoose () {
    this.app.singleton('Adonis/Addons/Mongoose', function (app) {
      const Config = app.use('Adonis/Src/Config')
      let connectionString = Config.get('database.mongodb.connectionString', null)
      const {
        host = 'localhost',
        port = 27017,
        database = 'test',
        user = null,
        pass = null,
        options = {useNewUrlParser: true}, //Solo modifique esta linea para agregar el useNewUrlParser
        debug = false
      } = Config.get('database.mongodb.connection')

      const auth = user ? `${user}:${pass}@` : ''

      if (!connectionString) {
        connectionString = `mongodb://${auth}${host}:${port}/${database}`
      }

      Mongoose.Promise = global.Promise
      Mongoose.set('useCreateIndex', true)
      Mongoose.connect(connectionString, options)

      if (debug) {
        Mongoose.set('debug', true)
      }

      return Mongoose
    })
    this.app.alias('Adonis/Addons/Mongoose', 'Mongoose')
  }

This is my AuthController, where I try to create a document in my collection:

async register ({ request, response }) {

    const data = await MongoUser.find({})
    const IDlatest = data.length + 1
    const id = IDlatest.toString()

    const rules = {
      nombre: 'required|string',
      apellido: 'required|string',
      password: 'required|string',
      correo: 'required|string',
    }

    const validation = await validate(request.all(), rules)

    if(validation.fails()){
      return validation.messages()
    } else {
      var crypto = require("crypto");
      var pin = crypto.randomBytes(20).toString('hex');

      try{
        const { nombre ,apellido, password, correo } = request.only([
          'nombre',
          'apellido',
          'password',
          'correo'
        ])

        await MongoUser.create({
          id: id,
          nombre: nombre,
          apellido: apellido,
          password: password,
          correo: correo,
          pin: pin
        })
        
        return response.status(201).json({
          message: "User creado correctamente",
        })
        
        
      } catch (e) {
        return response.status(400).send({'Error': e})
      }
    }
  }

User model, here I assign the fields of my document:

'use strict'


/** @type {import('@adonisjs/framework/src/Hash')} */
const Hash = use('Hash')

const BaseModel = use('MongooseModel')

const mongoose = use('Mongoose')

const {Schema} = mongoose

const UserSchema = new Schema(
  {
    id: Number,
    nombre: String,
    apellido: String,
    password: String,
    correo: String,
    pin: String,
  }
)


class User extends BaseModel {
  static boot () {
    super.boot()

    /**
     * A hook to hash the user password before saving
     * it to the database.
     */
    this.addHook('beforeSave', async (userInstance) => {
      if (userInstance.dirty.password) {
        userInstance.password = await Hash.make(userInstance.password)
      }
    })
  }

  /**
   * A relationship on tokens is required for auth to
   * work. Since features like `refreshTokens` or
   * `rememberToken` will be saved inside the
   * tokens table.
   *
   * @method tokens
   *
   * @return {Object}
   */
  tokens () {
    return this.hasMany('App/Models/Token')
  }
}
UserSchema.loadClass(User)

module.exports = mongoose.model('User',UserSchema)

This is the connection configuration to mongodb:

mongodb: {
    connectionString: Env.get('MONGO_CONNECTION_STRING', 'localhost'),
    connection: {
      host: Env.get('MONGO_HOST', 'localhost'),
      port: Env.get('MONGO_PORT', 27017),
      user: Env.get('MONGO_USER', ''),
      pass: Env.get('MONGO_PASSWORD', ''),
      database: Env.get('MONGO_DATABASE', 'adonis'),
      options: {
        // All options can be found at http://mongoosejs.com/docs/connections.html
      },
      debug: false
    }
  },

.env

MONGO_CONNECTION_STRING=mongodb://localhost:27017/adonismongo
MONGO_CONNECTION=mongodb
MONGO_PORT=27017
MONGO_USER=
MONGO_PASSWORD=
MONGO_DATABASE=adonis

Thank you.

I get this error when sending a file to an api, It sent the file by POST through the guzzle library, this is the code where I send the file

$client = new Client([
        
        'base_uri' => 'http://192.168.2.10:8000/api/archivos',
        
        'timeout'  => 10.0,
    ]);

    $response = $client->request('POST', 'http://192.168.2.10:8000/api/archivos', [
        'multipart' => [
            [
                'name' => '123.pdf',
                'contents' => fopen('archivos/123.pdf', 'r')
            ],
        ]
    ]);

I am sending the fixed file but the intention is to send it through a request with INSOMNIA. This is the error:

Once the file can be sent, it must have received it in the other api, but I don't know how to respond to the request I make, that is, send the file and then save it in the other api and finally return it. Thank you

I want to remove some special characters from a result of this query, this is the query:

$permiso = DB::table('personal_access_tokens')->select('abilities')->where('tokenable_id',$id)->get();

The result of this query is in json format:

[
  {
    "abilities": "[\"rol:user\"]"
  }
]

And I thought that the str_replace() function might be my solution, to remove everything else and just leave 'role:user', so I applied it.

$resultado = str_replace('{["\"/:abilities','',$permiso);

This was my result:

"[{\"abilities\":\"[\\\"rol:user\\\"]\"}]"

What I want is that it only remains: role: user

Additional Information:

Result of:

$permission = json_decode($permission,true);

$result = var_dump($permission);

   array(1){
  [
    0
  ]=>array(1){
    [
      "abilities"
    ]=>string(12)"["rol: user"]"
  }
}{}

I want to insert a new record in a table of my database and I want to validate each of the fields in the request but it doesn't work for me.

This is my UserController.php

<?php

namespace App\Http\Controllers;


use App\User;
use App\Persona;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Hash;
use Illuminate\Validation\ValidationException;

class UserController extends Controller
{

    
    public function registro(Request $request){

        $request->validate([
            'nombre'=> 'required',
            'apellidos'=> 'required',
            'email'=> 'required|email',
            'edad'=> 'required',
            'genero'=> 'required',
            'password'=> 'required',
        ]);

        $persona = new Persona;

        $persona->nombre = $request->input('nombre'); 
        $persona->apellidos = $request->input('apellidos'); 
        $persona->email = $request->input('email');
        $persona->edad = $request->input('edad');
        $persona->genero = $request->input('genero');
        
        if($persona->save()){

            $user = new User; 
            $user->persona_id = $persona->id;
            $user->name = $persona->nombre;
            $user->email = $persona->email;
            $user->password = Hash::make($request->input('password'));

            if($user->save()){
                return response()->json(["User"=>$user],201); 
            }
        } 

        return abort(400, "Error al registrar"); 
    }

}

and to be use of this, I use my route:

Route::post('/registro', 'UserController@registro');

I use insomnia to do the test, where in the request that I send it is empty and it gives me answers like this:

And it should show me an error because the fields are required but not.

I am making an Api with Laravel, and I wanted to make a route: posts/comments where it would show all the posts with their respective comments in json format, but when showing the posts I wanted there to be a new field where the comments would be shown there , something like that:

"Posts": [
{
  "id": 1,
  "user_id": 7,
  "titulo": "Dr.",
  "contenido": "Adipisci sequi nam distinctio inventore magnam rerum fuga.",
  "created_at": "2020-10-17 17:16:49",
  "updated_at": "2020-10-17 17:16:49"
  "Comentarios": "Aqui se muestran todos los comentarios del post"
},
{
  "id": 2,
  "user_id": 2,
  "titulo": "Dr.",
  "contenido": "Quia dicta sunt mollitia eos tenetur.",
  "created_at": "2020-10-17 17:16:49",
  "updated_at": "2020-10-17 17:16:49"
  "Comentarios": "Aqui se muestran todos los comentarios del post"
},

My question is, how can I make it show me the posts with their respective comments like the previous example?

api.php

Route::get('posts/comments', 'PostController@posts_comments');

PostController.php

    public function posts_comments(){

    return response()->json([
        "Posts" => DB::table('posts')->get(),
        "Comments" => DB::table('comments')->get(), //solo muestra la tabla, no hay relacion con un post
    ],200);
}

Model Post.php

class Post extends Model
{

public function user() {
    return $this->belongsTo('App\User');
}

public function comment(){
    return $this->hasMany('App\Comment');
}
}

Model Comment.php

class Comment extends Model
{
public function post(){
    return $this->belongsTo('App\Post');
}
}