Framework: Switching the Database Connection used by Validator

[WMeldon]

I have multiple databases used by my application and found myself needing to validate against the non-default connection. The problem was that the Validator class doesn't provide a way to switch the connection; it needs to be done in DatabasePresenceVerifier.

The DatabasePresenceVerifier is available through Validator but it is protected so I needed to extend the Validator Class and add this function that would allow passing the name of the connection to the object returned by Validator::make().

    public function setConnection($connection)
    {
        $this->presenceVerifier->setConnection($connection);
    }

This was easy enough because of the built in resolver, but it took me a little while to figure out.

Should this be doable without extending the class? Or did I miss some glaringly obvious way to do this.

[taylorotwell]

Validator::getPresenceVerifier()->setConnection($connection);

[taylorotwell]

Err... should be $validator->getPresenceVerifier()... not a static call like I posted above.

[WMeldon]

Awesome. Thank you.

[dimamarkus]

Where would you put that line in your application?

In the model?

WMeldon. Can you please share how you implemented this?

[WMeldon]

@dmi3000 After Validator::make() but before you run it. I did this in the repositories that wrapped my models but wherever you're doing validation will work.

[jcorry]

How would you do this for form request validation?

[KennedyTedesco]

'email' => 'unique:connection.users,email_address'

See: https://laravel.com/docs/5.1/validation