How i can made rule for API?

@Sinnbeck technical necessity. Unfortunately, I can't change it, I need to work with it

@aurorame ok. Did you try setting the database like I suggested in the previous post of yours?

You can also try using the query builder

$query = DB::connection($connection)->table($database. '.users')->where(... 

@Sinnbeck how can i use query builder here? return new DataResource(Data::where('Name', $request->input('name'))->firstOrFail()); That code used in DataController, DataResource - resources, Data:: - model

@aurorame use the db facade as you are setting everything dynamically. It might be possible to set the database on the model at runtime, but I would need to dig into the source to find it

Did some digging and perhaps you can do it with ->setTable($db. '.table')

@Sinnbeck with setTable i can`t use model, right?

@aurorame I meant like

$data = new Data;
$data->setTable($db. '.table')->where('Name', $request->input('name'))

It is untested as I'm not near a computer

@Sinnbeck i found 1 way in my solution, just set protected $table = $db . '.table'; in eloquent model, but it just select the database. Now i just need to create something like rules to all eloquent models like this (in order not to copy constantly in all models) and way to set the connection

UPD. find the way to set connection - $protected $connection = ... Now i need just the smth like rule to all other eloquent model to set right connection and db

@aurorame yeah setting connection is easy, but be sure to do it using the method. Otherwise you cannot change it when testing

public function getConnection()
 {
    return 'my_con';
} 

@Sinnbeck how i can make smth like rules for all eloquent model to select correct connection and db`s?

@aurorame I have never had to do this, but if I did I would try with global scopes https://laravel.com/docs/9.x/eloquent#global-scopes