Skip to content

fix: refresh presence rows on SQLite with CASE instead of IF() - #623

Merged
josephfusco merged 1 commit into
mainfrom
fix/sqlite-row-refresh
Sep 27, 2026
Merged

josephfusco merged 1 commit into
mainfrom
fix/sqlite-row-refresh

Conversation

@josephfusco

Copy link
Copy Markdown
Collaborator

The SQLite plugin always takes IF()'s false branch, so the test checks the query shape, since CI never runs on SQLite; unchanged writes there still report one affected row and fire wp_presence_admin_room_changed, which this leaves alone.

Fixes #616

Use of AI Tools

AI assistance: Yes
Tool(s): Claude Code
Model(s): Claude Opus 5.5
Used for: Assisting with the fix and tests.

@github-actions

Copy link
Copy Markdown
Contributor

🛝 WordPress Playgrounds

Built from fb22340

25 users 100 users
Single site Launch single site, 25 users Launch single site, 100 users
Multisite Launch multisite, 25 users Launch multisite, 100 users

@codecov

codecov Bot commented Sep 27, 2026 •

Copy link
Copy Markdown

Codecov Report

✅ All modified and coverable lines are covered by tests.
✅ Project coverage is 95.39%. Comparing base (f708b2b) to head (fb22340).
⚠️ Report is 4 commits behind head on main.

Additional details and impacted files
@@            Coverage Diff            @@
##               main     #623   +/-   ##
=========================================
  Coverage     95.39%   95.39%           
  Complexity      191      191           
=========================================
  Files            24       24           
  Lines          3149     3149           
=========================================
  Hits           3004     3004           
  Misses          145      145           
Flag Coverage Δ
multisite 95.39% <100.00%> (ø)
phpunit 70.72% <100.00%> (ø)

Flags with carried forward coverage won't be shown. Click here to find out more.

🚀 New features to boost your workflow:
  • ❄️ Test Analytics: Detect flaky tests, report on failures, and find test suite problems.
  • 📦 JS Bundle Analysis: Save yourself from yourself by tracking and limiting bundle sizes in JS merges.

@josephfusco
josephfusco marked this pull request as ready for review September 27, 2026 19:11
@josephfusco
josephfusco merged commit 825f849 into main Sep 27, 2026
22 checks passed
@josephfusco
josephfusco deleted the fix/sqlite-row-refresh branch September 27, 2026 19:11
@github-actions

Copy link
Copy Markdown
Contributor

The following accounts have interacted with this PR and/or linked issues. I will continue to update these lists as activity occurs. You can also manually ask me to refresh this list by adding the props-bot label.

Core Committers: Use this line as a base for the props when committing in SVN:

Props joefusco.

To understand the WordPress project's expectations around crediting contributors, please review the Contributor Attribution page in the Core Handbook.

@josephfusco josephfusco added the [Area] Database Issues for the wp_presence table and cron cleanup label Sep 27, 2026
@josephfusco josephfusco added this to the 0.10.0 milestone Sep 27, 2026
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

[Area] Database Issues for the wp_presence table and cron cleanup

Projects

None yet

Development

Successfully merging this pull request may close these issues.

Presence rows never refresh on SQLite, so everyone drops out 150 seconds after arriving

1 participant