Alberto Siurob's questions

I'm writing some tests on a game page for a couple of automated tests. I am using puppeteer and typescript. I have a problem in the function login()because the instructions that are defined, when it reaches the login, are not yet defined

(node:16244) UnhandledPromiseRejectionWarning: TypeError: Cannot read property 'waitFor' of undefined

This is my index.ts

import CorePuppeteer from './core/puppeteer.core';
import { Credentials } from './interfaces/interface';

// Parámetros
const url  = 'https://lobby.ogame.gameforge.com/es_ES/';
// Aquí se instancia un objeto, y el constructor se encarga de crear lo necesario para empezar a trabar
const core = new CorePuppeteer( url, false );
const credentials: Credentials = {
    email: '[email protected]',
    password: 'foobar'
};

// Invocación de funciones
( async () => {
    // aquí salta el error
    await core.login( credentials );
})();

This is the code for puppeteer.core.ts

import puppet from 'puppeteer';
import { Credentials } from '../interfaces/interface';
export default class CorePuppeteer {

    // public browser: puppet.Browser;
    // public page: puppet.Page;
    public browser: any;
    public page: any;
    public delay = 100;

    constructor( url: string, headless = true ) {
        ( async () => {
            this.browser = await puppet.launch( { headless } );
            this.page    = await this.browser.newPage();

            await this.page.setViewport({ width: 1366, height: 768});
            await this.page.goto( url, { waitUntil: 'networkidle2' } );
        })();
    }

    
    async login( credentials: Credentials ) {
        const inputEmail = 'input[name="email"]';
        const inputPass  = 'input[name="password"]';
        const button     = 'button[type="submit"]';

        await this.page.waitFor( inputEmail );
        await this.page.type( inputEmail, credentials.email, { delay: this.delay } );
        await this.page.type( inputPass, credentials.password, { delay: this.delay } );

        await this.page.click( button );
    }
}

What can I do to wait for the constructor to finish setting all the variables, before the next login function is called?

I am using sweetalert to make notifications, but there is a peculiarity with a requirement, they want to see the animation and the form of the sweetalert, but without the modal. I have searched everywhere but I think it is not supported or if there is a trick to do it

function fire() {
  Swal.fire({
    icon: 'success',
    title: 'Done',
    text: 'Request done',
  });

}

<script src="https://cdn.jsdelivr.net/npm/sweetalert2@9"></script>

<button onClick="fire()">Lanzar</button>

This is your most natural form of the library, but we want to get this, the animation and the form but without the modal, it should fall into a div, for example.

I am making a model for MongoDB with mongoose. I am leaning with Typescript to define it. I have a problem because when I declare a property and I want to insert a validation function referring to another property, TS throws me an error

Property 'gender' does not exist on type 'SchemaTypeOpts | scheme | SchemaType'. Property 'gender' does not exist on type 'Schema'.ts(2339)

this is my code

import mongo from 'mongoose'

const schema = new mongo.Schema({


   name: {
    type: String,
    match:  [ /^[a-zA-Z]{2,35}$/, 
            'El es requerido y debe tener una longitud de 2-35 caracteres' ]
},

lastName: {
    type: String,
    match:  [ /^[a-zA-Z]{2,50}$/, 
            'El es requerido y debe tener una longitud de 2-50 caracteres' ]
},

email: {
    type: String,
    unique: [ true, 'Ya existe un correo electrónico registrado' ],
    match:  [ /^(([^<>()[\]\\.,;:\s@\"]+(\.[^<>()[\]\\.,;:\s@\"]+)*)|(\".+\"))@((\[[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\])|(([a-zA-Z\-0-9]+\.)+[a-zA-Z]{2,}))$/,
            'El formato del correo es incorrecto'
    ]
},

userName: {
    type: String,
    unique: [ true, 'Ya existe este nombre de usuario'],
    match:  [ /^[a-zA-Z]{5,15}$/, 
            'El es requerido y debe tener una longitud de 5-15 caracteres' ]
},

phoneNumber: {
    type: Number,
    match: [ /^[0-9]{10}$/, 
           'El formato del número telefónico es incorrecto' ]
},

gender: {
    type: String,
    enum: ['H', 'M'],
    default: 'H'
},

department: {
    type: mongo.Schema.Types.ObjectId, ref: 'Department'
},

role: {
    type: mongo.Schema.Types.ObjectId, ref: 'Role'
},

photo: {
    type: String,
    default: function() {
        return this.gender === 'M' ? 'profile_male.png' : 'profile_female.png'
    }
},

sign: {
    type: String,
    required: [ true, 'Fatal: No se creo correctamente la contraseña']
},

status: {
   type: String,
   enum: ['activo', 'inactivo'],
   default: 'activo'
},

createdBy: {
   type: mongo.Schema.Types.ObjectId, ref: 'User'
},

createdDate: {
   type: Date,
   default: Date.now
},

changes: [
   {
       date: { type: Date, default: Date.now },
       user: { type: mongo.Schema.Types.ObjectId, ref: 'User' }
   }
]

}, { collection: 'users' })

export const UserModel = mongo.model( 'User', schema )

I tried to do this example validation in official mongoose documentation

var data = [
    {
      _id: '001',
      name: 'Elon Musk',
      rol: 'Chairman',
      image: 'https://picsum.photos/200/101',
      email: '[email protected]',
      phone: '5544332211',
      active: true,
      exp: 30
    },
    {
      _id: '002',
      name: 'Carlos Hernandez',
      rol: 'Chief Operation Officer',
      image: 'https://picsum.photos/200/102',
      email: '[email protected]',
      phone: '5544332211',
      active: true,
      exp: 15
    },
    {
      _id: '003',
      name: 'Alberto Siurob',
      rol: 'Chief Information Officer',
      image: 'https://picsum.photos/200/103',
      email: '[email protected]',
      phone: '5544332211',
      active: false,
      exp: 5
    },
    {
      _id: '004',
      name: 'Erick Lopez',
      rol: 'Chief Marketing Officer',
      image: 'https://picsum.photos/200/104',
      email: '[email protected]',
      phone: '5544332211',
      active: true,
      exp: 1
    },
  ];
  

function search( value ){
 // Si no esta vacio
 if( value ) {
  
  const keys = ['name', 'email', 'rol'];
  const match = searchKeys( data, keys, value.toLowerCase() );
  console.log( match );
 }
}

function searchKeys( source, keys, word ){
   const arr = [];
   
   // Recorrer llaves de busqueda
  keys.forEach( ( k ) => {
  
    // Recorrer la fuente
    source.forEach( ( s ) => {
    
      // validar si el indice tiene un valor semejante
      if ( s[ k ].toLowerCase().includes( word ) ) {
      
        // validar si ya existe en el arreglo
        if ( arr.indexOf( s._id ) < 0 ) {
          arr.push( s );
        }
      }
    });
  });
  return arr;
}

<input type="text" onkeyup="search( this.value )">

I am making a small browser with the benefits of Javascript. The truth is that it works very well, but I have a problem that if I only put a letter in the input, it triples the returned results.

What will I be doing wrong?

PS: If you have any suggestions to do it in a better way, it is always welcome

I'm making a data pager, but I'm already stuck. I have two problems. I want it to jump from 10 to 10 elements and it does so from 20 to 20, I don't know why. I need to set a limit, that is, it does not bring me all from a given index, but only 10 from that index, or whatever is marked as the size of the page, but it continues to bring me everything.

I'm a bit confused array.sliceso here's an example of what I've done.

const arr = Array.from( Array( 100 ).keys() );
let currentPage = 0;


const pageSize = Number( document.getElementById('pagesize').value ) || 10;

const change = ( num ) => {
  
  currentPage += num;
  if( currentPage < 0 ) {
    currentPage = 0;
    
  } else if ( currentPage > Math.ceil( ( arr.length / pageSize ) ) ) {
    currentPage = Math.ceil( ( arr.length / pageSize ) );
    
  } else {
    currentPage += num;
  }
  
  document.getElementById('result').innerHTML = arr.slice( ( pageSize * currentPage ) );
 
};

<input id="pagesize" value="10">
<button onClick="change(-1)">Menos</button>
<button onClick="change(1)">Más</button>
<div id="result"></div>

I have this code in Python

from pymongo import MongoClient

db       = MongoClient('localhost', 27017)['myDB']['myCol']
params   = { "model": "ILX ACURA" }
asset    = { "newAsset": ["Foo", "Bar", "Poo"] }
document = { "$push": { "models.$[mod].years": asset } }
filters  = { "arrayFilters" : [ { "mod.model": params['model'] } ] }
updated  = db.update( {}, document, False, False, None, filters )

if updated.matched_count > 0:
    print 'DONE!'

When I run the script I get this error

WriteError: No array filter found for identifier 'mod' in path models.$[mod].years

I've been struggling with python for a long time and tried better in MongoDB console

db.myCol.updateOne({}, { $push: { "models.$[mod].years": { "newAsset": ["Foo", "Bar","Poo"] } } }, { arrayFilters: [ { "mod.model": "ILX ACURA" } ] } )

Surprise!

{ "acknowledged" : true, "matchedCount" : 1, "modifiedCount" : 1 }

What will be happening?

I use python 2.7 pymongo 3.8 mongoDB 4.0

I am working with a Mongoose model, this is the model

import { Router, Request, Response } from 'express'
import UserModel from '../../../models/user.model'
import { error500 } from '../../../global/errors'
import AreaModel from '../../../models/area.model'


const UserChangesRoute = Router()


UserChangesRoute.get( '/:id', ( req: Request, res: Response ) => {

    const id: String = req.params.id
    const pop_user  = { path: 'modification.user', select: 'name last_name' }
    UserModel.find( { _id: id }, 'modification' ).sort({ 'modification.date': 1 })
    .populate( pop_user )
    .lean()
    .exec( ( err: any, data: any ) => {
        if( err ) {
            return res.status( 500 ).json( { message: error500, err } )
        }
        // I used to: data = data.toObject()
        for( let i = 0; i < data[0].modification.length; i++ ) {

            if( data[0].modification[ i ][ 'updated' ][ 0 ] === 'area' ) {
                AreaModel.findById( data[0].modification[ i ][ 'updated' ][ 1 ], 'name', ( e: any, area: any ) => {
                    if( !e ) data[0].modification[ i ][ 'updated' ][ 1 ] = area.name
                });

                AreaModel.findById( data[0].modification[ i ][ 'updated' ][ 2 ], 'name', ( e: any, area: any ) => {
                    if( !e ) data[0].modification[ i ][ 'updated' ][ 2 ] = area.name
                });
            }
        }
        res.status( 200 ).json( { data } )
    })
})


export default UserChangesRoute

I'm trying to find and replace parts of the array where it comes data[0].modificationin Here inside stores something like this

[ 'area', '5d144642416ada46385d01b8', '5d144681416ada46385d01b9', 'Área'];

It should be like this in the end

['area', 'Sistemas', 'Recursos Humanos', 'Área'];

Index 1 indicates at the DB structure level that it was moved in the front. The second index is what area (in this case) was removed, the third index is what area was replaced, and the last one is just a tag for the front.

It is a history of changes.

What I'm trying to do is replace those Mongo ids with the name of the area, I tried to do it with a populate, however it's not an array Schemasand since it doesn't have a reference to the Areas model, I reiterate it's a history of changes, not only they save areas, if not roles, names, direct bosses, anyway... everything that is changed in the front, must be stored in that way, and each change is an $pusharrangement ofmodifications

Now, the problem is that Mongoose returns me a MongoDocument, not a JSON(No matter how similar it is) I need to parse that MongoDocumenta JSONto be able to work with it.

This is the User model (Requested by Mauricio Contreras)

import mongos from 'mongoose'
import validator from 'mongoose-unique-validator'


const schema = new mongos.Schema({

    name: { 
        type      : String, 
        required  : [ true, 'El nombre es necesario' ], 
        maxlength : [ 50, 'El nombre no puede exceder los 50 caracteres'],
        minlength : [ 3, 'El nombre debe contener 3 o más caracteres'] 
    },
    last_name:  { 
        type      : String, 
        required  : [ true, 'El apellido es necesario' ], 
        maxlength : [ 100, 'El apellido no puede exceder los 50 caracteres'],
        minlength : [ 3, 'El apellido debe contener 3 o más caracteres'],
    },
    user_name:  { 
        type: String, 
        unique    : [ true, 'El usuario está duplicado' ], 
        required  : [ true, 'El usuario es necesario' ], 
        maxlength : [ 25, 'El usuario no puede exceder los 25 caracteres'] },
    email: { 
        type      : String, 
        unique    : [ true, 'El correo está duplicado'], 
        required  : [ true, 'El correo es necesario' ], 
        maxlength : [ 100, 'El correo no puede exceder los 100 caracteres'],
        match     : [/^(([^<>()[\]\\.,;:\s@\"]+(\.[^<>()[\]\\.,;:\s@\"]+)*)|(\".+\"))@((\[[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\])|(([a-zA-Z\-0-9]+\.)+[a-zA-Z]{2,}))$/,
                    'El correo electrónico no tiene el formato adecuado'] },
    gender        : { type: Number, min: 0, max: 2 },
    photo         : { type: String },
    phone         : { type: String },

    role          : { type: mongos.Schema.Types.ObjectId, ref: 'Role' },
    area          : { type: mongos.Schema.Types.ObjectId, ref: 'Area'  },
    boss          : { type: mongos.Schema.Types.ObjectId, ref: 'User'  },
    permissions: [{
        module    : { type: mongos.Schema.Types.ObjectId, ref: 'Module' },
        chmod     :  { type: String, minlength: 1, maxlength: 5, default: 'r' }
    }],

    password      :   { type: String },
    status        :   { type: String, default: 'active' },
    last_login    :   { type: Date },
    addedBy       :   { type: String },
    addedDate     : { type: Date, default: Date.now },
    modification  : [{
        _id       : false,
        user      : { type: mongos.Types.ObjectId, ref: 'User' },
        date      : { type: Date, default: Date.now },
        updated   : { type: Array }
    }]

}, { collection: 'users' })

schema.plugin( validator, {  message: 'Ya existe el correo o ID {VALUE} en la base de datos' } )

const UserModel = mongos.model('User', schema )

export default UserModel

I tried to use lean() method but it is not working for me.

In the same way I used toObject() But it tells me it is not a function.

How can I replace data from a MongoDocument?

I am doing a guard in Angular 7 to verify if a user is logged in or not. Both the back and the request work correctly, however I can't control it inside the subscribe. This is the code I developed

import { Injectable } from '@angular/core';
import { CanActivate, Router } from '@angular/router';
import { LoginService } from '../login.service';
import { Observable } from 'rxjs';
import { map } from 'rxjs/operators';
import { StorageService } from '../storage.service';

@Injectable({
  providedIn: 'root'
})
export class AuthGuard implements CanActivate {

  constructor( private _login: LoginService,
               private _router: Router,
               private _session: StorageService) {}

  canActivate(): Observable<boolean> | boolean {

    this._login.isLogged()
    .subscribe(
      // Si la respuesta es un código HTTP 204, entonces está autorizado
      () => true,

      // Si la respuesta es un código HTTP 401 entonces NO está autorizado
      () => {
        this._session.deleteData();
        this._router.navigate(['/login']);
        return false;
      });
  }
}

The problem is that returndel .subscribedoesn't return true or false as canActivate(): Observable<boolean> | booleanI don't know how to return that Boolean

I get this error

A function whose declared type is neither 'void' nor 'any' must return a value.

I even tried to assign the value of subscribeto a variable to do returnat the end of canActivate(), however it is an asynchronous function so it finishes executing the code and does not wait for the response, I reiterate, everything works excellent, both the responses from the backend, and the function isLogged()which returns the Observableone I am subscribing to in the guard.

What I can do?

I also tried this function

return this._login.isLogged().pipe( map( (data: any) => {
  if( data.auth ) {
    return true;
  } else {
    this._session.deleteData();
    this._router.navigate(['/login']);
    return false;
  }
})
)

And now it works only if there is an HTTP 200, I can't control the 401 code

I have the following model inmongoose

import mongos from 'mongoose'
import validator from 'mongoose-unique-validator'

const schema = new mongos.Schema({

    name: { 
        type     : String, 
        required : [ true, 'El nombre del rol es necesario' ],
        unique   : [ true, 'Ya existe un rol con ese nombre' ],
        max      : [ 50, 'El nombre no puede exceder los 50 caracteres' ],
        min      : [ 3, 'El rol debe contener 3 o más caracteres' ]
    },
    status       : { type: String, default: 'active' },
    addedBy      : { type: mongos.Types.ObjectId, ref: 'User' },
    addedDate    : { type: Date, default: Date.now },
    modification : {
        user     : { type: mongos.Types.ObjectId, ref: 'User' },
        date     : { type: Date, default: Date.now },
        current  : { type: String },
        updated  : { type: String }
    }
}, { collection: 'roles' } )


schema.plugin( validator, { message: 'Ya existe {VALUE} en la base de datos' } )

const RoleModel = mongos.model( 'Role', schema )

export default RoleModel

When I start the validations:

1. passed therequired
2. passed theunique
3. Did not pass the max(Makes the insertion)
4. Did not pass the min(Makes the insertion)

I don't understand what I'm doing wrong, can you help me?

I am trying to parse a base64 string back to the image as a file, however it is giving me the following error

Uncaught InvalidCharacterError: Failed to execute 'atob' on 'Window': The string to be decoded is not correctly encoded.

It is quite strange since the base64 string was never modified, I need to reassemble the file to send it as FormData()and that in PHP it can be processed as$_FILES

$(() => {
    let img;
    $(document).on('change', 'input', function (e) {
        let file = event.target.files[0];
        if (!file) {
            e.preventDefault();
            return;
        }else{
            let imageType = /image.*/;
            if (!file.type.match(imageType)) {
                e.preventDefault();
                return;
            }else {
                let reader = new FileReader();
                reader.onload = () => {
                    $('img').attr('src', reader.result);
                    img = reader.result;
                }
                reader.readAsDataURL(file);
            }
        }
    });
    
    $(document).on('click', 'button', function(e) {
      e.preventDefault(); e.stopPropagation();
      let rebuild = new FormData('img', atob( img ));
      console.log( rebuild );
    });
})

<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
<input type="file">
<img src=""><hr>
<button>Enviar</button>

I am trying to return the first and last name of the user who created a document, as well as the one who last modified it. I am using populate()to do the JOIN between the two collections but it has not worked for me.

This is the area model

var mongo     = require('mongoose'),
    validator = require('mongoose-unique-validator'),
    Schema    = mongo.Schema


var model = new Schema({
    NAME:       { type: String, required: true, unique: true, max: 50, min: 3 },
    STATUS:     { type: String, default: 'active' },
    ADDED_BY:   { type: Schema.Types.ObjectId, ref: 'users' },
    ADDED_DATE: { type: Date, default: Date.now },
    MODIFY_BACKLOG :[{
        USER:     { type: Schema.Types.ObjectId, ref:'users' },
        DATE:     { type: Date, default: Date.now },
        CURRENT:  { type: String },
        MODIFIED: { type: String }
    }]


}, {collection :'areas'})

model.plugin( validator, { message: 'The {PATH} is not valid or duplicated' } )
module.exports = mongo.model('Area', model )

As you can see the indexes ADDED_BYand MODIFY_BACKLOG.USERthey are referring to the collection users.

This is the users model

var mongo     = require('mongoose'),
    validator = require('mongoose-unique-validator'),
    Schema = mongo.Schema

var userSchema = new Schema({
    PERSONAL_DATA: {
        NAME:            { type: String, required: [ true, 'The name is necessary' ], max: 50 },
        LAST_NAME:       { type: String, required: [ true, 'the lastname is necessary' ], max: 100 },
        PHOTO:           { type: String, max: 100 },
        BIRTHDAY:        { type: Date },
        MARITIAL_STATUS: { type: Schema.Types.ObjectId, ref: 'maritial_statuses' },
        GENDER:          { type: String, max: 1 },
        EMAIL:           { type: String, required: true  },
    },
    COMPANY_DATA: {
        JOB:      { type: Schema.Types.ObjectId, ref: 'jobs' },
        AREA:     { type: Schema.Types.ObjectId, ref: 'areas' },
        ROLE:     { type: Schema.Types.ObjectId, ref: 'roles' },
        BOSS:     { type: Schema.Types.ObjectId, ref: 'users' },
    }
}, { collection: 'users' } )

model.plugin( validator, { message: 'The {PATH} is not valid or duplicated' } )

module.exports = mongo.model('User', userSchema )

As the information is very robust in this model, I decided to separate it into PERSONAL_DATA, COMPANY_DATAand there are two other indices PAYMENT_DATA, ENGINE_DATA, each of these keeps indices that refer to the name of the father, but those do not interest me because they have nothing to do with the question and it is a model of approx. . 300 lines.

Inside COMPANY_DATA.AREAis where the area where the user belongs is included, I don't think it's relevant to this problem, but just in case.

This is the path consumed by the area model

var express = require('express'),
    Areas   = require('../../models/catalogs/areas'),
    app     = express()

app.get('/:from', (req, res) => {

    var from = parseInt( req.params.from )
    var populate = { 
        path: 'users', 
        select: 'NAME LAST_NAME'
    }
    Areas.find()
        .sort('NAME').populate( populate )
        .limit(10).skip(from)
        .exec((error, data) => {
            if (error) {
                return res.status(500).json({
                    success: false,
                    error
                })
            }

            Areas.count({}, ( err, total ) => {
                res.status(200).json({
                    success: true,
                    data,
                    total
                })
            })
            
        })
})

module.exports = app

populate()I am passing a variable with the same name to the method , where I am making the reference to the collection and what data I need from the user. This is where I am stuck because it is not bringing me the information of the user, it only brings me the information of the area and here I have three questions

How can I make the JOIN of the collections respect me?

How can I tell it that the indexes I need are not explicitly at the top level of the document, but inside PERSONAL_DATA? i tried with

var populate = { 
        path: 'users', 
        select: 'PERSONAL_DATA.NAME PERSONAL_DATA.LAST_NAME'
    }

But it's still the same, finally

The index MODIFY_BACKLOGin the area model also has the ObjectId of the user who made the modification, how can I say that the JOIN to users is also done to that index?

I leave an example of the answer

{
    "success": true,
    "data": [{
        "STATUS": "active",
        "_id": "5c547f4adadf433914f72c8c",
        "NAME": "Contabilidad y Finanzas",
        "ADDED_BY": "5c4f562deec6f4defeea759b",
        "ADDED_DATE": "2019-02-01T17:18:02.680Z",
        "__v": 0,
        "MODIFY_BACKLOG": []
    }, {
        "STATUS": "active",
        "_id": "5c645f476491cf093c51c38e",
        "NAME": "Recursos Humanos",
        "ADDED_BY": "5c4f562deec6f4defeea759b",
        "ADDED_DATE": "2019-02-13T18:17:43.036Z",
        "__v": 0,
        "MODIFY_BACKLOG": [{
            "DATE": "2019-02-13T19:43:18.273Z",
            "_id": "5c6473561370462754939107",
            "USER": "5c4f562deec6f4defeea759b",
            "CURRENT": "active",
            "MODIFIED": "{\"STATUS\":\"inactive\"}"
        }, {
            "DATE": "2019-02-13T19:43:24.213Z",
            "_id": "5c64735c1370462754939108",
            "USER": "5c4f562deec6f4defeea759b",
            "CURRENT": "inactive",
            "MODIFIED": "{\"STATUS\":\"active\"}"
        }]
    }],
    "total": 5
}

I have a table with 5 columns, with information, the last column is for actions (Edit, delete, etc). I'm trying to click on an edit icon to enable me to edit the text of all the TDs of the same row except for the last one, since it's a tools cell, but I can't do it. I have tried

 !$(this).is('td:last');
 $(this).not('td:last');
 !$(this).is(':last');
 $(this).not(':last');

I have not succeeded, what could be going wrong? This is the code.

$(document).on('click','.tool',function(){
  var action     = $(this).data('action'),
      row        = $(this).parents('tr'),
      row_cloned = $(this).clone(),
      id         = parseInt(row.data('id'));
  switch ( action ) {
    case 'edit':
      row.find('td').each(function(){
        if( !$(this).is('td:last') ){
            $(this).prop('contenteditable',true);
        }
      });
      row.find('td:first').focus();
    break;
});

I'm building an application on AWS and well, this world is new to me.

I expose the problem

I have experience with Apache/PHP, Apache is the one that helps me to serve the HTTP requests and PHP is the Backend language.

The backend language that I am using in this new project is Python, but my question is what is the technology that helps me to serve the requests?

Can I install Apache/Python, or what would be the perfect duo?

I know that this can have many variants depending on each experience and needs of the project, but honestly I'm lost on what to install and what not.

Thanks for your guidance.

I'm trying to query MongoDB from Python, I'm just getting into these technologies.

I have this code

import pymongo
from pymongo import MongoClient

client = MongoClient()
db = client.crawler.users
res = db.find()

print( res )

It throws me this message:

<pymongo.cursor.Cursor object at 0x7f438d574cd0>
Process exited with code: 0

I expected a response like this since from the Mongo console if you run it:

> db.users.find()
{ "_id" : ObjectId("5b3fd50706dd45b669417454"), "NAME" : "FOO", "LAST_NAME" : "BAR" }
{ "_id" : ObjectId("5b3fdd2e613d0b159da70742"), "NAME" : "POO", "LAST_NAME" : "MAR" }

I appreciate your patience

I have a table called USERS which indexes certain nationalities as a comma delimited string.

ID | NOMBRE | NACIONALIDAD
1  | JUAN   | 1,2,3
2  | PEDRO  | 1,2
3  | JOSE   | 1,3

I have my table of NATIONALITIES

ID | NACION
1  | Ruso
2  | Español
3  | Brasileño

How could I make the INNER JOIN so that it brings me the names? I tried with:

SELECT U.* FROM USERS U INNER JOIN NACIONALIDADES N ON U.NACIONALIDAD IN ( N.ID )

I expect such an output

ID | NOMBRE | NACIONALIDAD
1  | JUAN   | Ruso,Español,Brasileño
2  | PEDRO  | Ruso,Español
3  | JOSE   | Ruso,Brasileño

I am using PHP, I could first get an initial array of nationalities and then compare the indexes, but I would like to know if there is a direct query with the database.

Thank you

I have this code in PHP that repeats the same select 10 times with the same information.

  for ($i=1; $i < 11; $i++)
  {
      $output.='
      <div class="form-group">
        <label>Prioridad '.$i.' de horario</label><br>
        <select class="form-control selectDisable">
          <option selected disabled>Elige una opción</option>
          <option value="1">Horario: 00:00 - 00:00 Break:  00:00 - 00:00 Descanso: Lunes</option>
          <option value="2">Horario: 00:00 - 00:00 Break:  00:00 - 00:00 Descanso: Martes</option>
          <option value="3">Horario: 00:00 - 00:00 Break:  00:00 - 00:00 Descanso: Miércoles</option>
          <option value="4">Horario: 00:00 - 00:00 Break:  00:00 - 00:00 Descanso: Jueves</option>
          <option value="5">Horario: 00:00 - 00:00 Break:  00:00 - 00:00 Descanso: Viernes</option>
          <option value="6">Horario: 00:00 - 00:00 Break:  00:00 - 00:00 Descanso: Sábado</option>
          <option value="7">Horario: 00:00 - 00:00 Break:  00:00 - 00:00 Descanso: Domingo</option>
        </select>
      </div>';
  }

I have this with Jquery that eliminates the selected option in the other select

  $(document).on('change','.selectDisable',function(){
    $(this).siblings().find('option[value="'+$(this).val()+'"]').remove();
  });

The problem is that it doesn't execute it, apparently <div class="form-group">because it doesn't seem to be finding siblings within the same DIV.

I've already asked the question here before:

Remove options from different select

I insist, if I remove the div from the form-group it does it fine, but since I can handle it with that class, I have thought of

$(document).on('change','.selectDisable',function(){
    $(this).closest('.form-group').find('.selectDisable').siblings().find('option[value="'+$(this).val()+'"]').remove();
  });

But it didn't work out for me, any suggestions?

I currently have a corporate intranet working with session variables, and it does it very well. Today I will start with a project for the general public and I decided to load the datastore on the front-side with cookies. I have never used them and I am confused. My question is: can I use a cookie to store certain data of a user that came from the database?

For example:

$_SESSION["NOMBRE"] = 'Juan Pérez';
$_SESSION["ID"] = 12345;

This has helped me a lot to create my intranet, but I don't understand if the cookie stores the same data that I need.

I want to add and take an average of a few hours.

$cadena = '00:09:00,00:09:00,00:09:00,00:09:00,00:09:00';
$arr = explode(",",$cadena);
$total = strtotime('00:00:00');

for($i = 0; $i<count($arr);$i++)
{
  $total = $total + strtotime($arr[$i]);
}

$total = $total / count($arr);
echo date('H:i:s',$total);

This returns me 05:45:00 and I expected 00:09:00. What was the mistake :(

I need to know how the mechanisms of hash() o password_hash()I am making an application and I want to encrypt it so that it is stored in the database and when I want to compare that string entered in a login it does not throw me an error. For example

$pass="pepito";
$hashed_pass = password_hash($pass, PASSWORD_DEFAULT);
insert into tabla (password) values ($hashed_pass);

And when I go to consult, return the value, but decrypt the value that was sent encrypted

For example

$pass="pepito";
select password from tabla where password = $pass;

Obviously it will throw me an error because before I have to pass the password to the hash algorithm, however I did some tests and every time I haveh it, it totally changes the algorithm, that prevents me from comparing the password in the database and bringing me the values

Help, thanks.

I am trying to send information by AJAX to a PHP and when the response returns, another PHP opens in another tab that will process the returned information.

I have this code

function printAdmLetter()
{
    if($("#adm_nomina").val()==""||$("#case_desc").val()==""||$("#boss_actions").val()==""||$('select[name=cause]').val()==null)
    {
        swal("¡Olvidaste algo!", "La información no está completa.", "error");
        return false;
    }

    else
    {
        adm_nomina = document.getElementById("adm_nomina").value;
        auth = document.getElementById("auth").value;
        cause = $('select[name=cause]').val();
        case_desc = document.getElementById("case_desc").value;
        boss_actions = document.getElementById("boss_actions").value;
        $.ajax(
        {

            url:"./phpLibraries/admLetter.php",
            method:"POST",
            data:{adm_nomina:adm_nomina,
                        auth:auth,
                        cause:cause,
                      case_desc:case_desc,
                    boss_actions:boss_actions},
            success:function(data)
            {
                if(data=='X')
                {
                    swal("¡Error!","No se pudo ingresar la información, intentalo nuevamente.","error");
                }

                else
                {
                        window.open('phpLibraries/printAdmLetter.php?id='+data);
                }
            }
     });
    }
}

The problem is that it doesn't do anything, it doesn't open the tab. I did a test with:

window.location.href='phpLibraries/printAdmLetter.php?id='+data;

and that way it works.