Duplicate data when seed an excluded model

[thiagogsr]

Hi guys

When I try run a seed to create data to an excluded model, it is created N times in public schema, where N is equals to tenants count.

Anyone has suggestions?

I tried run with bin/rake apartment:seed, but it created N-1 times in public schema. With bin/rake db:seed it created N times in public schema.

[thiagogsr]

I already solve using if Apartment::Tenant.current_tenant == 'public' conditional, but is it the better way?

[bradrobertson]

Seeds are basically your responsibility to maintain data integrity, there's no better way than what you're doing. We essentially do the same thing to make sure seeds are idempotent

[thiagogsr]

Let me show an example for sure that you understood

There are two tentants + public. When I create a seed with these lines:

Foo.create(name: 'bar')

Foo.create(name: 'bar2')

Foo.create(name: 'bar3')

and For is an excluded model, the seed is creating 9 records in "foos" table, 3 for each create, understand? Therefore I written this conditional :)

[bradrobertson]

That's exactly what I would expect. Since Foo is excluded, it's all working on the same (public) schema. If you run a seed, it will run it for every tenant plus public (in your case 3 times). Therefore, with your setup, I'd expect 9 entries in the Foo table. So you conditional makes sense.

[thiagogsr]

Nice :)