okaufmann / laravel-web-money-manager-ex

     *

     * @return $this

     */

    protected function assertSeeIsNotSoftDeletedInDatabase($table, array $data, $connection = null)

    {

        $database = $this->app->make('db');

        $connection = $connection ?: $database->getDefaultConnection();

        $count = $database->connection($connection)

            ->table($table)

            ->where($data)

            ->whereNull('deleted_at')

            ->count();

        $this->assertGreaterThan(0, $count, sprintf(

            'Found unexpected records in database table [%s] that matched attributes [%s].', $table, json_encode($data)

        ));

        return $this;

    }

    /**

     * Assert that a given where condition matches a soft deleted record

     *

     * @return $this

     */

    protected function assertIsSoftDeletedInDatabase($table, array $data, $connection = null)

    {

        $database = $this->app->make('db');

        $connection = $connection ?: $database->getDefaultConnection();

        $count = $database->connection($connection)

            ->table($table)

            ->where($data)

            ->whereNotNull('deleted_at')

            ->count();

        $this->assertGreaterThan(0, $count, sprintf(

            'Found unexpected records in database table [%s] that matched attributes [%s].', $table, json_encode($data)

        ));

        return $this;

    }

    /**

     * Assert that a given where condition exists in the database and return the first occurrence.