Schedule DB table update in multi tenant application

@aless55 you can switch tenants manually with:

$environment = $this->app->make(\Hyn\Tenancy\Environment::class);

// Retrieve your website

// Now switch the environment to a new tenant.
$environment->tenant($website);

https://tenancy.dev/docs/hyn/5.4/identification#manual-identification

I did something like that before:

 foreach (app(WebsiteRepository::class)->query()->get() as $w) {

            $tenancy = app(Environment::class);

            $tenancy->tenant($w); // switches the tenant and reconfigures the app

	   $xxx = XXX:where(...);

}

The error trace is:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'tenancy.XXX' doesn't exist (SQL: select * from `XXX` where (`danger_status` = 0 and `text` =  and `class` = ok and `1` is null) limit 1)

If I check with app(\Hyn\Tenancy\Environment::class)->tenant() it gives me the tenant connection, but somehow not the right table. Instead of tenancy.XXX there should be thewebsite_ identifier.XXXX

Be wary about switching tenants. It is recommend switching only once during code execution. Use a background job to run mass changes on tenant databases.

@aless55 Do you tried to use background jobs instead?

Do I dind't, I will try them out and will report as soon as I have some results. (probably tomorrow)

Hey @sti3bas I found a solution browsing the web. Here is the link to the solution: https://tenancy.dev/docs/hyn/5.4/laravel-scheduler