Laravel Passport and different database for testing.

Published 1 week ago by vladistick

Hello guys, I'm having terrible luck finding an anwser to my question anywhere so I thought I will ask on this forum. I'm trying to make some unit tests for API. I'm using Laravel Passport. I'm using different database for testing, the whole testing environment is located in .env.testing file, however, whenever I try to run any controllers functions related to creating a tokens in database, they use a database from .env files.

Here is what I mean by that Function to login an user:

public function login($email, $password)
    {
        if (Auth::attempt(['email' => $email, 'password' => $password])) {
            $http = new GuzzleHttp\Client;

            $response = $http->post(url('oauth/token'), [
                'form_params' => [
                    'grant_type' => 'password',
                    'client_id' => '2',
                    'client_secret' => $this->secret,
                    'username' => $email,
                    'password' => $password,
                    'scope' => '',
                ],
            ]);
            return response(['data' => json_decode((string)$response->getBody(), true)]);
        }
        else {
            return response()->json(['error' => 'Unauthorised'], 401);
        }

    }

Function to test if user logs in:

 public function testUserLoginsSuccessfully()
    {
       $response=$this->userService->
       login('[email protected]', 'secret');

    }

When I use phpunit, I get the error "GuzzleHttp\Exception\ClientException: Client error: POST http://127.0.0.1:8000/oauth/token resulted in a 401 Unauthorized response: {"error":"invalid_credentials","message":"The user credentials were incorrect."}"

When I change the .env.testing database to the one in .env everything works fine. Any ideas how to solve this?

Cronix
Cronix
1 week ago (566,300 XP)

Check in your phpunit.xml file in the root dir. Check the <php> section and set your testing .env values

<php>
        <env name="APP_ENV" value="testing"/>
        <env name="CACHE_DRIVER" value="array"/>
        <env name="SESSION_DRIVER" value="array"/>
        <env name="QUEUE_DRIVER" value="sync"/>
        <env name="DB_CONNECTION" value="testing"/>
</php>
vladistick

Doesn't work. Let me be a bit more clear. For example, testing this code, creates new user in testing database, using .env.testing, but post post(url('oauth/token') is trying to access database in regular .env file

 public function register($name, $email, $password, $c_password)
    {

        $validator = Validator::make([
            'name' => $name,
            'email' => $email,
            'password' => $password,
            'c_password' => $c_password
        ], [
            'name' => 'required',
            'email' => 'required|email',
            'password' => 'required',
            'c_password' => 'required|same:password',
        ]);

        if ($validator->fails())
        {
            return response()->json(['error' => $validator->errors()], 401);
        }

        $input = ['name' => $name, 'email' => $email, 'password' => $password, 'c_password' => $c_password];
        $input['password'] = bcrypt($input['password']);
        User::create($input);
        $http = new GuzzleHttp\Client;

        $response = $http->post(url('oauth/token'), [
            'form_params' => [
                'grant_type' => 'password',
                'client_id' => '2',
                'client_secret' => $this->secret,
                'username' => $email,
                'password' => $password,
                'scope' => '',
            ],
        ]);
        return response(['data' => json_decode((string)$response->getBody(), true)]);

    }

Please sign in or create an account to participate in this conversation.