Populate relation with random entities

Get Help
1

How would I write script to populate a relation column with a number of random entities from another database?

Say I have a Day entity auto created each morning. I want to have a column “Baby Lunch” that is automatically filled with 3 random entities from my “Food” database (even better if I can get 3 from the Food database that have a value of True for the “Baby” column).

I’ve been working on figuring it out the last hour and it should be easier than this!

1 Like
2

Assuming you can write a script - my approach would be this:

  • Get all the BabyFood entities
  • Initialize BabyLunch = []
  • Loop 3 times:
    • Choose a random BabyFood entity that’s not already in BabyLunch, and add it to BabyLunch
  • Update Day.BabyLunch
1 Like
3

I’ve been trying and I don’t know how to write the script :sweat_smile:

1 Like
4

Something like this might work:

const fibery = context.getService('fibery');
// query all Foods
const query = await fibery.graphql('SpaceName', "{findFoods{id}}");
// get the array of food entities
const foods = query['data']['findFoods'];

for (const entity of args.currentEntities) {
    // do three times
    for (let i = 0; i < 3; i++) {
        // generate a random number
        const rand = Math.floor(Math.random() * foods.length);
        // extract a random food
        const food = foods.splice(rand, 1)[0];
        // link the task based on the ID
        await fibery.addCollectionItem(entity.type, entity.id, 'Baby Lunch', food['id']);
    }
}

Note: this assumes that the Baby Lunch field is initially empty. If not, then you would need to add a line of code to clear it before adding in the randomly selected ones.

2 Likes
5

I changed it slightly to this (with chatGPTs help lol):

const fibery = context.getService('fibery');
// query all Foods
const query = await fibery.graphql('Testing', "{findFoods{id}}");
// get the array of food entities
const foods = query['data']['findFoods'];

for (const entity of args.currentEntities) {
    // do three times
    for (let i = 0; i < 3; i++) {
        // generate a random number
        const rand = Math.floor(Math.random() * foods.length);
        // extract a random food
        const food = foods.splice(rand, 1)[0];
        // link the task based on the ID
        await fibery.addCollectionItem(entity.type, entity.id, 'Baby Lunch', food['id']);
    }
}

and IT’S WORKING!!!

I might actually be able to use Fibery seriously now!! Thank you sooooo much :pray:

1 Like
6

Yeah, sorry, I should have made clear that you would need to choose the correct SpaceName for your specific case.
Hope it proves useful.

1 Like
7

Oh actually the part I changed was this:

2 Likes
8

Oh dear, yes, i made a typo. I shall correct the original post.

3 Likes