Improve `workspace:seed:dev` command to seed all field types

[lucasbordeau]

Scope & Context

When seeding the database in dev mode.

Technical inputs

Right now we use the seeds that were relevant months ago, but now we have multiple new field types like JSON, Address and Links, and we have to create them manually each time we want to test them while developing our features.

What would really help all the community is to seed people and company with all possible field types, and fill all rows with more demo data so our initial tables aren't so empty.

A nice good first issue !

[otutukingsley]

I'm interested in helping! can you assign this issue to me? @lucasbordeau

[Bonapara]

Sure @otutukingsley, thanks for contributing! Regarding the content, we should keep the five companies and five people we have but fill in all the columns.

[prateekj117]

@otutukingsley If you have not taken it up yet or not planning to take it up, I can have a look into this?

@Bonapara I see in the command, we only seed for 2 companies, SEED_APPLE_WORKSPACE_ID, SEED_TWENTY_WORKSPACE_ID, and not 5. Or am I missing something here?

[prateekj117]

Ohh and in the case of all companies and all people, it's 13 companies and 15 people. I think this is what you were talking about. My bad.

[prateekj117]

@Bonapara Can I take this up?

[Bonapara]

@otutukingsley are you still on it? Otherwise I'll assign you @prateekj117!

[lucasbordeau]

@Bonapara I'm assigning @prateekj117 as it would be nice to have it soon.

[lucasbordeau]

@prateekj117, I'll explain more :

• What you talk about SEED_APPLE_WORKSPACE_ID is a workspace not an object
• We already seed companies and people object
• We want to seed more FieldMetadatItem types, but those fields will be custom fields on company and people

Step 1 :

You might want to import the field metadata service in DataSeedWorkspaceCommand and call createOne directly in a new function seedCompanyCustomFields and seedPeopleCustomFields.

Be careful to seed custom field with isCustom: true.

Step 2 :

Once those fields are created in the DB, you can proceed to seed them with demo data in seedCompanies and seedPeople.

[prateekj117]

@lucasbordeau This gave me a good idea of the db structuring haha! Thanks for assigning this to me.