This could be down to my weird use case about laravel-model-caching HOT 9 CLOSED

I’m working on a feature for this. Will try to work on it tomorrow.

from laravel-model-caching.

Duplicate of #34.

from laravel-model-caching.

Hi Matt, just wanted to note that the model cache will respect your entire complex where clause will be processed accordingly and not cause false returns, even with dynamic data.

But I do understand the need to prevent caching of a query and will work on that, just wanted to share that the caching should be able to handle your use case. :)

from laravel-model-caching.

Cool thanks @mikebronner - good to know - I think something else is a play here on my end which is causing odd results :)

from laravel-model-caching.

So I'm definitely seeing some unexpected behaviour here.
The use case is - a list of suggestions filtered on yourself, your already connected / invited users.
When my Profile model is extending CachedModel list of suggestions doesn't decrease when I connect with another user. When Profile model isn't extending CachedModel it behaves as expected.

If I mess around manually with my excluded $excludedIds - when caching is on - the list doesn't change - when caching is off it's as expected. It's 04:30 here so going to get some rest - but I'll put together a use case on fresh install of laravel later today and see if I can replicate the some issue on that with a base use case.

The key being created by the package is:
appprofile_and_profilesuser-id-not-in-and-profilesactive-1-and-profilesuser-id-inselect-user-id-from-user-interests-where-interest-id-in-or-profilesuser-id-inselect-user-id-from-user-locations-where-region-id-in-or-profilesuser-id-inselect-user-id-from-profiles-where-country-id_orderByRaw_rand-limit_10 and I don't see that change too much unless I adjust profile.active = 0 when it becomes: appprofile_and_profilesuser-id-not-in-and-profilesactive-0-and-profilesuser-id-inselect-user-id-from-user-interests-where-interest-id-in-or-profilesuser-id-inselect-user-id-from-user-locations-where-region-id-in-or-profilesuser-id-inselect-user-id-from-profiles-where-country-id_orderByRaw_rand-limit_10

from laravel-model-caching.

I was tired and an idiot 🥇 fool!
I'd messed my bindings up......... sorry!

from laravel-model-caching.

No worries, glad you found the root cause :)

from laravel-model-caching.

@mbuk I just released version 0.2.12 which adds the ability to disable caching on individual queries.

from laravel-model-caching.

Fantastic! I’ll check it out

from laravel-model-caching.