GeneaLabs / laravel-model-caching

class WhereInTest extends IntegrationTestCase

{

    public function testWhereInUsingCollectionQuery()

    {

        $key = sha1("genealabs:laravel-model-caching:testing:{$this->testingSqlitePath}testing.sqlite:books:genealabslaravelmodelcachingtestsfixturesbook-author_id_in_1_2_3_4");

        $tags = [

            "genealabs:laravel-model-caching:testing:{$this->testingSqlitePath}testing.sqlite:genealabslaravelmodelcachingtestsfixturesbook",

        ];

        $authors = (new UncachedAuthor)

            ->where("id", "<", 5)

            ->get(["id"]);

        $books = (new Book)

            ->whereIn("author_id", $authors)

            ->get();

        $cachedResults = $this

            ->cache()

            ->tags($tags)

            ->get($key)['value'];

        $liveResults = (new UncachedBook)

            ->whereIn("author_id", $authors)

            ->get();

        $this->assertEquals($liveResults->pluck("id"), $books->pluck("id"));

        $this->assertEquals($liveResults->pluck("id"), $cachedResults->pluck("id"));

    }

    public function testWhereInWhenSetIsEmpty()

    {

class WhereNotInTest extends IntegrationTestCase

{

    public function testWhereNotInQuery()

    {

        $key = sha1("genealabs:laravel-model-caching:testing:{$this->testingSqlitePath}testing.sqlite:books:genealabslaravelmodelcachingtestsfixturesbook-author_id_notin_1_2_3_4");

        $tags = [

            "genealabs:laravel-model-caching:testing:{$this->testingSqlitePath}testing.sqlite:genealabslaravelmodelcachingtestsfixturesbook",

        ];

        $authors = (new UncachedAuthor)

            ->where("id", "<", 5)

            ->get(["id"]);

        $books = (new Book)

            ->whereNotIn("author_id", $authors)

            ->get();

        $cachedResults = $this

            ->cache()

            ->tags($tags)

            ->get($key)['value'];

        $liveResults = (new UncachedBook)

            ->whereNotIn("author_id", $authors)

            ->get();

        $this->assertEquals($liveResults->pluck("id"), $books->pluck("id"));

        $this->assertEquals($liveResults->pluck("id"), $cachedResults->pluck("id"));

    }

    public function testWhereNotInResults()

    {