Advanced queries and .populate

Clase 26 de 54 • Full Stack JavaScript with Sails.js

Contenido del curso

Welcome to the course

The essentials

Creating custom made functions

Growth and monetization

Going live

Bonus content

Tomar examen

Comentarios

badr eddine mada

student•

Is there a way to do all this in one request to the database? instead of fetching all friends which can be millions of records :p, and constructing another request from, the ORM should do all that in an optimized way.

Alexandre Assis

student•

This logic is weird - I am basically adding someone to my friends without their consent and just by doing that I can see their items…

Is that really how it was supposed to work? Isn’t it the other way around (I can see the items of people that added me as a friend)??

Noitidart Saab

student•

Mike admits this in the tutorial. It’s a demonstration thing. The further you go though in the tutorial he fixes this logic.

Mike USA

student•

What if in the future, their consent is required in order to be counted as a friend?

Ashfaq Shimer Ahamed

student•

How do you make a case insensitve search?

Rajavanya Subramaniyan

student•

For anyone interested to have a more interesting bootstrap.js/fake data. You can use the npm package called random-alias. You can configure it to auto-generate fun thing names. npm i random-alias

Here is my full bootstrap.js code so I can showoff... erm.. I meant... if anyone is curious

  var users = await User.createEach([
    { emailAddress: 'admin@example.com', fullName: 'Ryan Dahl', isSuperAdmin: true, password: await sails.helpers.passwords.hashPassword('1234!@#$') },
    { emailAddress: 'mike@sailsjs.com', fullName: 'Mike McNeil', isSuperAdmin: true, password: await sails.helpers.passwords.hashPassword('1234!@#$') },
    { emailAddress: 'alex@baker.com', fullName: 'Alex Baker', isSuperAdmin: true, password: await sails.helpers.passwords.hashPassword('1234!@#$') },
  ]).fetch();

  await User.addToCollection(users[0].id, 'friends', users[1].id);
  await User.addToCollection(users[1].id, 'friends', [users[0].id, users[2].id]);
  await User.addToCollection(users[2].id, 'friends', users[0].id);

  const { randomAlias } = require('random-alias');

  const schemaColor = [
    {
      fromList: 'colors',
      minLetters: 1,
      maxLetters: 10,
    },
    {
      fromList: 'nouns',
      minLetters: 1,
      maxLetters: 10,
    },
  ];

  const schemaAdjectives = [
    {
      fromList: 'adjectives',
      minLetters: 1,
      maxLetters: 10,
    },
    {
      fromList: 'nouns',
      minLetters: 1,
      maxLetters: 10,
    },
  ];

  const optionsExample = {
    delimiter: ' ',
    possibilityCount: true
  };

  for(let user of users) {
    for (let i = 0; i < 5; i++) {
      await Thing.create({label:randomAlias(schemaColor, optionsExample).word, owner:user.id});
    }

    for (let i = 0; i < 5; i++) {
      await Thing.create({label:randomAlias(schemaAdjectives, optionsExample).word, owner:user.id});
    }
  }

This would generate names with a random color/adjective as the first word, and a random noun as the second word. Examples - 'flirt endorsement', 'audacious sucker', 'wine coal', 'pink someone' etc.

Michael Montalban

student•

I’m not able to populate the name of another person’s thing…

<small class="owner text-primary" v-else>{{thing.owner.fullName}}</small>

However, if I enter {{thing.owner}}, it does return the id of the other person. Has anyone been able to generate the fullName correctly?

Michael Montalban

student•

This took way longer to figure out that i’d like to admit but here’s how I ended up retrieving the other owners’ names

Update view-available-things w/ another var:

    var things = await Thing.find({
      where: {
        or: [
          {owner: this.req.me.id},
          {owner: {in: friendIDs}}
        ]
      }
    });

    var owners = await User.find({
      and: [
        {id: {in: friendIDs}}
      ]
    });

    // Respond with view.
    return exits.success({things, owners});

Update available-things.ejs to call that new var:

<small class="owner text-primary" v-for="owner in owners">
  <small class="owner text-secondary" v-if="thing.owner === me.id"
    <span class="fa fa-home mr-1"></span>Mine</small>
  <small class="owner text-secondary" v-else>{{owner.fullName}}</small>
</small>

Hope this helps anyone else who ran into this roadblock.

jose manuel ruiz ruiz

student•

you can do this:

const things = await Thing.find({
      or: [
        { owner: this.req.me.id },
        { owner: { in: friendsIds } },
      ]
    }).populate('owner');

and then acces the owner info like thing.owner.fullname

Noitidart Saab

student•

How can we do the opposite of what you did here in the video:

          { // if i think of anyone as a friend, show me their stuff
            owner: {
              in: friendIds
            }
          }

This is not the correct way. Because i can add anyone as friend and view their stuff. What I want is “if owner of item thinks of me as a friend” then show me their stuff. May you please show this query?

Mike USA

student•

As stated above, what if you instead built the piece that authorizes a person to count someone as a friend. For example, in Facebook, in order to add someone as a friend you send them a friend request. It's that person's job to acknowledge as a friend, before you're allowed to view their feed/posts/photos/etc.

So the part that is missing here is the friend request and acceptance, which could come in a later session, or you could give it a go and try to implement it yourself :)

James Severn

student•

I found this code to be helpful for me to “populate the owner”

  var users = await User.createEach([
    { emailAddress: 'admin@example.com', fullName: 'Ryan Dahl', isSuperAdmin: true, password: await sails.helpers.passwords.hashPassword('1234!@#$') },
    { emailAddress: 'mike@sailsjs.com', fullName: 'Mike McNeil', isSuperAdmin: true, password: await sails.helpers.passwords.hashPassword('1234!@#$') },
    { emailAddress: 'alex@baker.com', fullName: 'Alex Baker', isSuperAdmin: true, password: await sails.helpers.passwords.hashPassword('1234!@#$') },
  ]).fetch();

  await User.addToCollection(users[0].id, 'friends', users[1].id);
  await User.addToCollection(users[1].id, 'friends', [users[0].id, users[2].id]);
  await User.addToCollection(users[2].id, 'friends', users[0].id);

  const { randomAlias } = require('random-alias');

  const schemaColor = [
    {
      fromList: 'colors',
      minLetters: 1,
      maxLetters: 10,
    },
    {
      fromList: 'nouns',
      minLetters: 1,
      maxLetters: 10,
    },
  ];

  const schemaAdjectives = [
    {
      fromList: 'adjectives',
      minLetters: 1,
      maxLetters: 10,
    },
    {
      fromList: 'nouns',
      minLetters: 1,
      maxLetters: 10,
    },
  ];

  const optionsExample = {
    delimiter: ' ',
    possibilityCount: true
  };

  for(let user of users) {
    for (let i = 0; i < 5; i++) {
      await Thing.create({label:randomAlias(schemaColor, optionsExample).word, owner:user.id});
    }

    for (let i = 0; i < 5; i++) {
      await Thing.create({label:randomAlias(schemaAdjectives, optionsExample).word, owner:user.id});
    }
  }

    var things = await Thing.find({
      where: {
        or: [
          {owner: this.req.me.id},
          {owner: {in: friendIDs}}
        ]
      }
    });

    var owners = await User.find({
      and: [
        {id: {in: friendIDs}}
      ]
    });

    // Respond with view.
    return exits.success({things, owners});

<small class="owner text-primary" v-for="owner in owners">
  <small class="owner text-secondary" v-if="thing.owner === me.id"
    <span class="fa fa-home mr-1"></span>Mine</small>
  <small class="owner text-secondary" v-else>{{owner.fullName}}</small>
</small>

Advanced queries and .populate

Welcome to the course

Introduction and generalities

The technologies we are going to use

What we will build

Avoiding mistakes in our code

Github for our project

Installing platforms and dependencies

The essentials

Backend architecture

Frontend Architecture

ParasailsJS

Authentication and login

User Subscription

Sessions and Data Base

Password recovery

Email verification

Contact form

Managing payment information

Creating a new page

Making our page interactive

Creating a new model

Automatic testing

Creating a new action

Using Cloud SDK

Creating custom made functions

Personalization

Permissions

Friends with associations