2659 Commits

Author SHA1 Message Date
Andrew Dolgov
77e5deb9dd
use RETURNING syntax when creating base filter record during OPML import 2025-05-06 05:06:17 +03:00
Andrew Dolgov
e91c49b747
use RETURNING syntax when creating article record in share anything 2025-05-06 05:04:47 +03:00
Andrew Dolgov
9735ff83cc
use RETURNING syntax when creating base filter record 2025-05-06 05:01:23 +03:00
Andrew Dolgov
ea6f42dc61
switch insert query for base article record to named parameters and add previously missing ts_content stuff 2025-05-05 22:08:01 +03:00
Andrew Dolgov
677cd7453f
drop some pointless queries now that we can use RETURNING for inserts 2025-05-05 21:55:38 +03:00
Andrew Dolgov
070585ac5e
only open PDO transaction while performing CRUD operations on article 2025-05-05 20:45:40 +03:00
Andrew Dolgov
4cc40ddaa4
scheduler - only register built-in purge_orphaned_scheduled_tasks if running as default name 2025-05-04 20:25:29 +03:00
Andrew Dolgov
5263a07f61
record last cron expression (and stub owner_uid) used by scheduled task 2025-05-04 18:06:43 +03:00
Andrew Dolgov
fc059fc0fc
expose scheduled tasks to plugins, switch cache_starred_images plugin to use them instead of housekeeping hook 2025-05-04 17:50:03 +03:00
wn_
3ee0f331cc Move registration of 'purge_orphaned_scheduled_tasks' into Scheduler. 2025-05-04 14:20:17 +00:00
Andrew Dolgov
07eb34529f Merge branch 'feature/purge-orphaned-scheduled-tasks' into 'master'
Periodically purge orphaned scheduled task records

See merge request tt-rss/tt-rss!126
2025-05-04 14:10:56 +00:00
wn_
853864794a Move logging users excluded from updates to a daily scheduled task, exclude disabled or readonly users. 2025-05-04 13:28:09 +00:00
wn_
868385442a Periodically purge orphaned scheduled task records. 2025-05-04 12:57:58 +00:00
Andrew Dolgov
fecab891fc
add a basic prefs panel for scheduled task records 2025-05-04 13:44:08 +03:00
Andrew Dolgov
ec12a514a2
Revert "bring back cleanup of potentially sensitive environment variables but exclude CLI SAPI to prevent updater failures"
Breaks OIDC

This reverts commit 247efe3137fadf5d74ab254cf4c80957624abc90.
2025-05-04 13:30:07 +03:00
Andrew Dolgov
4cda1da5c0
adjust scheduler logging to be somewhat more alike to feed updater 2025-05-03 07:55:45 +03:00
Andrew Dolgov
997c10437e
reorder housekeeping tasks by interval 2025-05-02 23:26:13 +03:00
Andrew Dolgov
d5d15072e1
move scheduled tasks to a separate class, add some try-catches, improve/shorten logging and descriptions 2025-05-02 22:51:07 +03:00
Andrew Dolgov
b30f8c93a0
rename article mark/publish hooks 2025-05-02 21:27:50 +03:00
Andrew Dolgov
dc6ea08ca4
add workaround for due tasks because housekeeping is not run every minute, fix last_run not updated to NOW() in the db 2025-05-02 14:03:45 +03:00
Andrew Dolgov
247efe3137
bring back cleanup of potentially sensitive environment variables but exclude CLI SAPI to prevent updater failures 2025-05-02 13:37:08 +03:00
Andrew Dolgov
aeca30cb0c
drop SIMPLE_UPDATE_MODE, limit housekeeping and updates to background processes 2025-05-02 13:26:58 +03:00
Andrew Dolgov
a51c1d5176
fix tasks_run never incremented 2025-05-02 13:18:48 +03:00
Andrew Dolgov
36f60b51d7
make digest sending a hourly cron job 2025-05-02 13:17:20 +03:00
Andrew Dolgov
44b5b33f3d
remove synchronous usages of _purge_orphans() 2025-05-02 10:28:35 +03:00
Andrew Dolgov
a268f52de6
record task duration in seconds 2025-05-02 10:23:30 +03:00
Andrew Dolgov
6a40940ad6
split housekeeping jobs to separate scheduled tasks on longer cooldown intervals, add table to record task execution timestamps, bump schema 2025-05-02 10:17:13 +03:00
Andrew Dolgov
0520ca2226
deal with published hook in _create_published_article 2025-05-02 08:26:52 +03:00
Andrew Dolgov
5f70e41118
add plugin hooks invoked when articles get un/marked or un/published 2025-05-01 22:36:33 +03:00
wn
4ae17d0f1c Merge branch 'feature/phpstan-updates' into 'master'
PHPStan update and addressing findings

See merge request tt-rss/tt-rss!122
2025-04-30 16:34:52 +00:00
wn_
f097c5ed97 Remove an unnecessary session UID existence check in 'UserHelper::authenticate()'.
PHPStan 'if.alwaysTrue'
2025-04-27 15:13:15 +00:00
wn_
1c9fddd757 Add a PHPStan ignore for a non-issue in 'UrlHelper::fetch()'. 2025-04-27 15:05:28 +00:00
wn_
5c2c95a897 Remove unused 'PluginHost::HOOK_FORMAT_ARTICLE_CDM'.
PHPStan 'method.notFound'.
2025-04-27 14:53:53 +00:00
Andrew Dolgov
75556e2f3d
Merge branch 'master' into rip-mysql 2025-04-17 14:07:26 +03:00
Andrew Dolgov
f7199a47c2
* fix 148 migration for pgsql not setting default value of ttrss_feeds.auth_pass breaking OPML import
* replace no-op migrations for mysql with 'select 1'
2025-04-17 11:51:47 +03:00
Andrew Dolgov
8cf3059951
more type hints 2025-04-14 15:31:06 +03:00
Andrew Dolgov
3c138a71a1
add deprecation notice for sql_random_function() 2025-04-14 15:27:58 +03:00
Andrew Dolgov
54e8ab7e3d
update DB_TYPE deprecation notice 2025-04-14 15:24:34 +03:00
Andrew Dolgov
7e403aae92
further mysql/DB_TYPE related cleanup 2025-04-14 15:21:10 +03:00
Andrew Dolgov
b154bc7a10
initial attempt to remove mysql-related stuff from tt-rss 2025-04-14 12:59:00 +03:00
Andrew Dolgov
f9e8911727
Revert "cleanup environment variables related to global configuration after instantiating config object"
This reverts commit e4f1480453a86401f93ed97878c270628fe4d2b7.
2025-04-08 18:38:10 +03:00
Andrew Dolgov
e4f1480453
cleanup environment variables related to global configuration after instantiating config object 2025-04-08 14:09:15 +03:00
Andrew Dolgov
17b4e98249
spaces to tabs 2025-04-08 13:52:00 +03:00
Andrew Dolgov
f00d9a18f8
if possible, automatically encrypt stored plaintext password for feed on update 2025-04-08 09:43:03 +03:00
Andrew Dolgov
eedc1460e5
support transparent encryption for feed passwords, bump schema to drop length limit of ttrss_feeds.auth_pass 2025-04-08 09:36:04 +03:00
Andrew Dolgov
25d3ce4ee8
drop SESSION-specific stuff and move encrypt/decrypt helpers to a separate class; add a command line flag to generate encryption keys 2025-04-08 08:55:44 +03:00
Andrew Dolgov
58677fc791
rename SODIUM_ENCRYPTION_KEY to SESSION_ENCRYPTION_KEY and move related stuff to Sessions class 2025-04-07 20:28:35 +03:00
Andrew Dolgov
026d68fc2d
add optional encryption for stored session data using Sodium library 2025-04-07 20:09:31 +03:00
Andrew Dolgov
20ba3c67cc
allow setting lifetime to 0 for session cookies 2025-04-07 07:14:01 +03:00
wn_
e1256b06ea Only use valid feed basic info from plugins. 2025-04-04 17:53:47 +00:00