aboutsummaryrefslogtreecommitdiff
path: root/tests
diff options
context:
space:
mode:
Diffstat (limited to 'tests')
-rw-r--r--tests/app/Models/SearchTest.php142
-rw-r--r--tests/lib/LibDateTest.php84
2 files changed, 220 insertions, 6 deletions
diff --git a/tests/app/Models/SearchTest.php b/tests/app/Models/SearchTest.php
index 19279fa65..90aca6a24 100644
--- a/tests/app/Models/SearchTest.php
+++ b/tests/app/Models/SearchTest.php
@@ -167,9 +167,9 @@ final class SearchTest extends \PHPUnit\Framework\TestCase {
*/
public static function provideDateSearch(): array {
return [
- ['date:2007-03-01T13:00:00Z/2008-05-11T15:30:00Z', 1172754000, 1210519800],
- ['date:2007-03-01T13:00:00Z/P1Y2M10DT2H30M', 1172754000, 1210519799],
- ['date:P1Y2M10DT2H30M/2008-05-11T15:30:00Z', 1172754001, 1210519800],
+ ['date:2007-03-01T13:00:00Z/2008-05-11T15:30:00Z', strtotime('2007-03-01T13:00:00Z'), strtotime('2008-05-11T15:30:00Z')],
+ ['date:2007-03-01T13:00:00Z/P1Y2M10DT2H30M', strtotime('2007-03-01T13:00:00Z'), strtotime('2008-05-11T15:29:59Z')],
+ ['date:P1Y2M10DT2H30M/2008-05-11T15:30:00Z', strtotime('2007-03-01T13:00:01Z'), strtotime('2008-05-11T15:30:00Z')],
['date:2007-03-01/2008-05-11', strtotime('2007-03-01'), strtotime('2008-05-12') - 1],
['date:2007-03-01/', strtotime('2007-03-01'), null],
['date:/2008-05-11', null, strtotime('2008-05-12') - 1],
@@ -188,15 +188,32 @@ final class SearchTest extends \PHPUnit\Framework\TestCase {
*/
public static function providePubdateSearch(): array {
return [
- ['pubdate:2007-03-01T13:00:00Z/2008-05-11T15:30:00Z', 1172754000, 1210519800],
- ['pubdate:2007-03-01T13:00:00Z/P1Y2M10DT2H30M', 1172754000, 1210519799],
- ['pubdate:P1Y2M10DT2H30M/2008-05-11T15:30:00Z', 1172754001, 1210519800],
+ ['pubdate:2007-03-01T13:00:00Z/2008-05-11T15:30:00Z', strtotime('2007-03-01T13:00:00Z'), strtotime('2008-05-11T15:30:00Z')],
+ ['pubdate:2007-03-01T13:00:00Z/P1Y2M10DT2H30M', strtotime('2007-03-01T13:00:00Z'), strtotime('2008-05-11T15:29:59Z')],
+ ['pubdate:P1Y2M10DT2H30M/2008-05-11T15:30:00Z', strtotime('2007-03-01T13:00:01Z'), strtotime('2008-05-11T15:30:00Z')],
['pubdate:2007-03-01/2008-05-11', strtotime('2007-03-01'), strtotime('2008-05-12') - 1],
['pubdate:2007-03-01/', strtotime('2007-03-01'), null],
['pubdate:/2008-05-11', null, strtotime('2008-05-12') - 1],
];
}
+ #[DataProvider('provideUserdateSearch')]
+ public static function test__construct_whenInputContainsUserdate(string $input, ?int $min_userdate_value, ?int $max_userdate_value): void {
+ $search = new FreshRSS_Search($input);
+ self::assertSame($min_userdate_value, $search->getMinUserdate());
+ self::assertSame($max_userdate_value, $search->getMaxUserdate());
+ }
+
+ /**
+ * @return list<list<mixed>>
+ */
+ public static function provideUserdateSearch(): array {
+ return [
+ ['userdate:2007-03-01T13:00:00Z/2008-05-11T15:30:00Z', strtotime('2007-03-01T13:00:00Z'), strtotime('2008-05-11T15:30:00Z')],
+ ['userdate:/2008-05-11', null, strtotime('2008-05-12') - 1],
+ ];
+ }
+
/**
* @param array<string>|null $tags_value
* @param array<string>|null $search_value
@@ -584,6 +601,119 @@ final class SearchTest extends \PHPUnit\Framework\TestCase {
}
/**
+ * @param array<string> $values
+ */
+ #[DataProvider('provideDateOperators')]
+ public function test__date_operators(string $input, string $sql, array $values): void {
+ [$filterValues, $filterSearch] = FreshRSS_EntryDAOPGSQL::sqlBooleanSearch('e.', new FreshRSS_BooleanSearch($input));
+ self::assertSame(trim($sql), trim($filterSearch));
+ self::assertSame($values, $filterValues);
+ }
+
+ /** @return list<list<mixed>> */
+ public static function provideDateOperators(): array {
+ return [
+ // Basic date operator tests
+ [
+ 'date:2007-03-01/2008-05-11',
+ '(e.id >= ? AND e.id <= ? )',
+ [strtotime('2007-03-01T00:00:00Z') . '000000', strtotime('2008-05-11T23:59:59Z') . '000000'],
+ ],
+ [
+ 'date:2007-03-01/',
+ '(e.id >= ? )',
+ [strtotime('2007-03-01T00:00:00Z') . '000000'],
+ ],
+ [
+ 'date:/2008-05-11',
+ '(e.id <= ? )',
+ [strtotime('2008-05-11T23:59:59Z') . '000000'],
+ ],
+ // Basic pubdate operator tests
+ [
+ 'pubdate:2007-03-01T13:00:00Z/2008-05-11T15:30:00Z',
+ '(e.date >= ? AND e.date <= ? )',
+ [strtotime('2007-03-01T13:00:00Z'), strtotime('2008-05-11T15:30:00Z')],
+ ],
+ [
+ 'pubdate:2007-03-01/',
+ '(e.date >= ? )',
+ [strtotime('2007-03-01T00:00:00Z')],
+ ],
+ [
+ 'pubdate:/2008-05-11',
+ '(e.date <= ? )',
+ [strtotime('2008-05-11T23:59:59Z')],
+ ],
+ // Basic userdate operator tests
+ [
+ 'userdate:2007-03-01T13:00:00Z/2008-05-11T15:30:00Z',
+ '(e.`lastUserModified` >= ? AND e.`lastUserModified` <= ? )',
+ [strtotime('2007-03-01T13:00:00Z'), strtotime('2008-05-11T15:30:00Z')],
+ ],
+ [
+ 'userdate:2007-03-01/',
+ '(e.`lastUserModified` >= ? )',
+ [strtotime('2007-03-01T00:00:00Z')],
+ ],
+ [
+ 'userdate:/2008-05-11',
+ '(e.`lastUserModified` <= ? )',
+ [strtotime('2008-05-11T23:59:59Z')],
+ ],
+ // Negative date operator tests
+ [
+ '-date:2007-03-01/2008-05-11',
+ '((e.id < ? OR e.id > ?) )',
+ [strtotime('2007-03-01T00:00:00Z') . '000000', strtotime('2008-05-11T23:59:59Z') . '000000'],
+ ],
+ [
+ '!pubdate:2007-03-01T13:00:00Z/2008-05-11T15:30:00Z',
+ '((e.date < ? OR e.date > ?) )',
+ [strtotime('2007-03-01T13:00:00Z'), strtotime('2008-05-11T15:30:00Z')],
+ ],
+ [
+ '!userdate:2007-03-01T13:00:00Z/2008-05-11T15:30:00Z',
+ '((e.`lastUserModified` < ? OR e.`lastUserModified` > ?) )',
+ [strtotime('2007-03-01T13:00:00Z'), strtotime('2008-05-11T15:30:00Z')],
+ ],
+ // Combined date operators
+ [
+ 'date:2007-03-01/ pubdate:/2008-05-11',
+ '(e.id >= ? AND e.date <= ? )',
+ [strtotime('2007-03-01T00:00:00Z') . '000000', strtotime('2008-05-11T23:59:59Z')],
+ ],
+ [
+ 'pubdate:2007-03-01/ userdate:/2008-05-11',
+ '(e.date >= ? AND e.`lastUserModified` <= ? )',
+ [strtotime('2007-03-01T00:00:00Z'), strtotime('2008-05-11T23:59:59Z')],
+ ],
+ [
+ 'date:2007-03-01/ userdate:2007-06-01/',
+ '(e.id >= ? AND e.`lastUserModified` >= ? )',
+ [strtotime('2007-03-01T00:00:00Z') . '000000', strtotime('2007-06-01T00:00:00Z')],
+ ],
+ // Complex combinations with other operators
+ [
+ 'intitle:test date:2007-03-01/ pubdate:/2008-05-11',
+ '(e.id >= ? AND e.date <= ? AND e.title LIKE ? )',
+ [strtotime('2007-03-01T00:00:00Z') . '000000', strtotime('2008-05-11T23:59:59Z'), '%test%'],
+ ],
+ [
+ 'author:john userdate:2007-03-01/2008-05-11',
+ '(e.`lastUserModified` >= ? AND e.`lastUserModified` <= ? AND e.author LIKE ? )',
+ [strtotime('2007-03-01T00:00:00Z'), strtotime('2008-05-11T23:59:59Z'), '%john%'],
+ ],
+ // Mixed positive and negative date operators
+ [
+ 'date:2007-03-01/ !pubdate:2008-01-01/2008-05-11',
+ '(e.id >= ? AND (e.date < ? OR e.date > ?) )',
+ [strtotime('2007-03-01T00:00:00Z') . '000000', strtotime('2008-01-01T00:00:00Z'), strtotime('2008-05-11T23:59:59Z')],
+ ],
+ ];
+ }
+
+ /**
* @dataProvider provideRegexPostreSQL
* @param array<string> $values
*/
diff --git a/tests/lib/LibDateTest.php b/tests/lib/LibDateTest.php
new file mode 100644
index 000000000..0c07696f5
--- /dev/null
+++ b/tests/lib/LibDateTest.php
@@ -0,0 +1,84 @@
+<?php
+declare(strict_types=1);
+
+require_once LIB_PATH . '/lib_date.php';
+
+use PHPUnit\Framework\Attributes\DataProvider;
+
+/**
+ * Tests for lib_date.php functions
+ */
+class LibDateTest extends \PHPUnit\Framework\TestCase {
+
+ /**
+ * Test parseDateInterval function with various ISO 8601 interval formats
+ *
+ * @param string $interval
+ * @param int|null|false $expectedMin
+ * @param int|null|false $expectedMax
+ */
+ #[DataProvider('provideDateIntervals')]
+ public function test_parseDateInterval(string $interval, $expectedMin, $expectedMax): void {
+ $result = parseDateInterval($interval);
+ self::assertIsArray($result);
+ self::assertCount(2, $result);
+ self::assertSame($expectedMin, $result[0], "Min timestamp mismatch for interval: $interval");
+ self::assertSame($expectedMax, $result[1], "Max timestamp mismatch for interval: $interval");
+ }
+
+ /** @return list<array{string,int|null|false,int|null|false}> */
+ public static function provideDateIntervals(): array {
+ return [
+ ['', null, null], // Empty string
+
+ // Year intervals
+ ['2014', strtotime('2014-01-01 00:00:00'), strtotime('2014-12-31 23:59:59')],
+ [' 2015 ', strtotime('2015-01-01 00:00:00'), strtotime('2015-12-31 23:59:59')], // With whitespace to be trimmed
+
+ // Year-month intervals
+ ['2014-03', strtotime('2014-03-01 00:00:00'), strtotime('2014-03-31 23:59:59')],
+ ['2016-02', strtotime('2016-02-01 00:00:00'), strtotime('2016-02-29 23:59:59')], // Leap year
+ ['2014-02', strtotime('2014-02-01 00:00:00'), strtotime('2014-02-28 23:59:59')], // Non-leap year
+ ['201404', strtotime('2014-04-01 00:00:00'), strtotime('2014-04-30 23:59:59')], // Without hyphen
+
+ // Specific dates
+ ['2014-03-30', strtotime('2014-03-30 00:00:00'), strtotime('2014-03-30 23:59:59')],
+ ['2014-05-30T13', strtotime('2014-05-30 13:00:00'), strtotime('2014-05-30 13:59:59')],
+ ['2014-05-30T13:30', strtotime('2014-05-30 13:30:00'), strtotime('2014-05-30 13:30:59')],
+
+ // Date ranges with explicit end dates
+ ['2014-02/2014-04', strtotime('2014-02-01 00:00:00'), strtotime('2014-04-30 23:59:59')],
+ ['2014-02--2014-04', strtotime('2014-02-01 00:00:00'), strtotime('2014-04-30 23:59:59')], // Same with -- separator
+ ['2014-02/04', strtotime('2014-02-01 00:00:00'), strtotime('2014-04-30 23:59:59')],
+ ['2014-02-03/05', strtotime('2014-02-03 00:00:00'), strtotime('2014-02-05 23:59:59')],
+
+ // Time ranges within same day
+ ['2014-02-03T22:00/22:15', strtotime('2014-02-03 22:00:00'), strtotime('2014-02-03 22:15:59')],
+ ['2014-02-03T22:00/15', strtotime('2014-02-03 22:00:00'), strtotime('2014-02-03 22:15:59')],
+
+ // Open intervals
+ ['2014-03/', strtotime('2014-03-01 00:00:00'), null],
+ ['/2014-03', null, strtotime('2014-03-31 23:59:59')],
+
+ // Period-based intervals
+ ['2014-03/P1W', strtotime('2014-03-01 00:00:00'), strtotime('2014-03-07 23:59:59')],
+ ['P1W/2014-05-25T23:59:59', strtotime('2014-05-19 00:00:00'), strtotime('2014-05-25 23:59:59')],
+
+ // Fixed date periods with known anchors
+ ['2014-01-01/P1Y', strtotime('2014-01-01 00:00:00'), strtotime('2014-12-31 23:59:59')],
+ ['2014-06-15/P6M', strtotime('2014-06-15 00:00:00'), strtotime('2014-12-14 23:59:59')],
+ ['2014-03-01/P2W', strtotime('2014-03-01 00:00:00'), strtotime('2014-03-14 23:59:59')],
+ ['2014-12-25/P10D', strtotime('2014-12-25 00:00:00'), strtotime('2015-01-03 23:59:59')],
+ ['2014-01-01T12:00/PT6H', strtotime('2014-01-01 12:00:00'), strtotime('2014-01-01 17:59:59')],
+ ['2014-01-01 12:00/PT6H', strtotime('2014-01-01 12:00:00'), strtotime('2014-01-01 17:59:59')], // Space instead of T
+ ['2014-01-01T12:00/PT6h', strtotime('2014-01-01 12:00:00'), strtotime('2014-01-01 17:59:59')], // Lowercase h
+ ['2014-05-01T10:30/PT90M', strtotime('2014-05-01 10:30:00'), strtotime('2014-05-01 11:59:59')],
+ ['2014-07-04T14:15:30/PT45S', strtotime('2014-07-04 14:15:30'), strtotime('2014-07-04 14:16:14')],
+
+ // Reverse periods
+ ['P1M/2014-02-28', strtotime('2014-01-28 00:00:01'), strtotime('2014-02-28 00:00:00')],
+ ['P3D/2014-01-10T23:59:59', strtotime('2014-01-08 00:00:00'), strtotime('2014-01-10 23:59:59')],
+ ['PT12H/2014-06-01T12:00', strtotime('2014-06-01 00:00:01'), strtotime('2014-06-01 12:00:00')],
+ ];
+ }
+}
generated by cgit v1.2.3 (git 2.39.1) at 2026-02-10 07:07:19 +0000