Cache doesn't invalidate when using insert method about laravel-model-caching HOT 10 CLOSED

@hendra1 this should now be fixed in 0.2.41. Thank you so much for reporting this! The insert and update methods hadn't been accounted for yet. Please let me know how this update works for you.

from laravel-model-caching.

@hendra1 thanks for reporting this. Could you test again using the latest version of this package: 0.2.40? Thanks!

from laravel-model-caching.

Yes I did.. and the result is still same.

from laravel-model-caching.

Thanks, I will try to replicate it.

from laravel-model-caching.

Hi @hendra1,

Regarding your question about having a way to invalidate in the controller: that is not planned. The package should invalidate.

I am unable to recreate the problem with the following test:

    public function testModelCacheDoesInvalidateWhenNoCooldownPeriod()
    {
        $authors = (new Author)
            ->get();

        factory(Author::class, 1)->create();
        $authorsAfterCreate = (new Author)
            ->get();
        $uncachedAuthors = (new UncachedAuthor)
            ->get();

        $this->assertCount(10, $authors);
        $this->assertCount(11, $authorsAfterCreate);
        $this->assertCount(11, $uncachedAuthors);
    }

The test passes. Could you provide the queries you are running, specifically the initial query, the insert query, and the third query that is not getting the updated values?

Thanks!

from laravel-model-caching.

I found an issue, it has to do with insert. (Sorry I didn't test that right away, mia culpa. :) ) This test exposes it:

    public function testInsertInvalidatesCache()
    {
        $authors = (new Author)
            ->get();

        $newAuthor = (new Author)
            ->insert([
                'name' => 'Test Insert',
                'email' => '[email protected]',
            ]);
        $authorsAfterInsert = (new Author)
            ->get();
        $uncachedAuthors = (new UncachedAuthor)
            ->get();

        $this->assertCount(10, $authors);
        $this->assertCount(11, $authorsAfterInsert);
        $this->assertCount(11, $uncachedAuthors);
    }

I will work on fixing this ASAP!

from laravel-model-caching.

Hi Mike

Thanks for the update.. now it's work :)

from laravel-model-caching.

Awesome! That's great to hear. :) please let me know if you run into any other issues .

from laravel-model-caching.

I'm using
DB::insert();
to insert hundreds of records (this provide faster insert than MODEL::insert, any chance I can invalidate the cache?

from laravel-model-caching.

Hi @mrahmadt, could you open a new issue for this? Thanks!

from laravel-model-caching.