Auto-updating in TCA not working

[morstin]

Hi there,

I put below variable into the State of TCA Feature and tried to following exactly the example in ModernPersistence example. The query is working well - but it is not auto updating when items are added to the db.

• Where should I start debugging / checking to track down the problem?

Kind regards

@FetchOne( Item.select { Stats.Columns( allCount: $0.count() ) } ) var stats = Stats()

[mbrandonw]

Hi @morstin, hard to say without more code. can you share a minimal project that reproduces the problem?

[morstin]

Hi @mbrandonw,

thank you very much for your quick reply. Unfortunately the whole thing is too complex to share and I am not sure I could replicate the issue in a demo. Hence, my question - where to start searching. But as this probably also complicated, I embarked on the following:

As I have still quite some GRDB dependend code mixed in, I think the best is to fully migrate to your libraries and then see if the auto-update not working is still the problem.

Huge thanks for the StructuredQueries and SharingGRDB libraries. You once replied to me, you would not have much to say on SQL triggers - but now you provided this wonderful SQL related series and these libraries 😎

Only thing that comes to mind is adding a SQLite trigger to execute when songs are deleted to then clean up empty albums. But this really isn't going to be the focus of our explorations.
pointfreeco/episode-code-samples#154 (comment)

So looking forward very much to the SQL trigger sessions.