QueryTest.php

<?php

namespace Laravie\SerializesQuery\Tests\Feature;

use Illuminate\Support\Facades\DB;
use function Laravie\SerializesQuery\serialize;
use Laravie\SerializesQuery\Tests\TestCase;
use function Laravie\SerializesQuery\unserialize;

class QueryTest extends TestCase
{
    /** @test */
    public function it_can_serialize_a_basic_query_builder()
    {
        $builder = DB::table('users');
        $serialized = serialize($builder);

        $unserialize = unserialize($serialized);

        $this->assertSame('select * from "users"', $unserialize->toSql());

        $this->assertSame($builder->toSql(), $unserialize->toSql());
    }

    /** @test */
    public function it_can_serialize_a_basic_query_builder_on_custom_connection()
    {
        $builder = DB::connection('mysql')->table('users');
        $serialized = serialize($builder);

        $unserialize = unserialize($serialized);

        $this->assertSame('select * from `users`', $unserialize->toSql());

        $this->assertSame($builder->toSql(), $unserialize->toSql());
        $this->assertSame('mysql', $unserialize->getConnection()->getName());
    }

    /** @test */
    public function it_can_serialize_a_basic_query_builder_with_wheres()
    {
        $builder = DB::table('users')->where('email', '=', 'crynobone@gmail.com');
        $serialized = serialize($builder);

        $unserialize = unserialize($serialized);

        $this->assertSame('select * from "users" where "email" = ?', $unserialize->toSql());

        $this->assertSame($builder->toSql(), $unserialize->toSql());
    }

    /** @test */
    public function it_can_serialize_a_basic_query_builder_with_unions()
    {
        $builder = DB::table('users')->where('email', '=', 'crynobone@gmail.com');
        $union = DB::table('users')->where('email', '=', 'johndoe@gmail.com')
            ->union($builder);

        $serialized = serialize($union);

        $unserialize = unserialize($serialized);

        $this->assertSame('select * from (select * from "users" where "email" = ?) union select * from (select * from "users" where "email" = ?)', $unserialize->toSql());

        $this->assertSame($union->toSql(), $unserialize->toSql());
    }
}