J. King
0d6f8d2921
Avoid most deprecation warnings
The Feed class sets dynamic properties on Picofeed classes; this will
need to be completely rewritten. Version 1.2 of the Laminas XML class
also uses a deprecated function, but upgrading it to 1.3 will require
PHP 7.3.
1 year ago
J. King
0f2da754c5
Fix remaining test problems
2 years ago
J. King
c40f39e34e
Work around MySQL absurdities
2 years ago
J. King
2822864a85
Fix most test failures
MySQL is still being stubborn. It may be a type-conversion issue.
2 years ago
J. King
9ac615e4a4
Apply more PSR-12 style rules
2 years ago
J. King
d1da6fbe5e
Use cases rather than casting bools to int in SQL
2 years ago
J. King
e65069885b
Clean up obsolete FIXMEs
2 years ago
J. King
e6505a5fda
Work around possible MySQL bug
2 years ago
J. King
2489743d0f
Further simplifications
2 years ago
J. King
b5579d6e43
Support PHP 8.1
2 years ago
J. King
fc2abc1203
Use D modifier for all patterns with $ anchors
3 years ago
J. King
19ab9df063
Fix more bugs
3 years ago
J. King
4080b2d09d
Apply new rules
3 years ago
J. King
6b7257a6c4
Work around more MySQL stupidity
3 years ago
J. King
5cfa01f4d5
Work around MySQL stupidity
3 years ago
J. King
f7b3a473a9
Clarify ordering syntax rationale
3 years ago
J. King
ed27e0aaaa
Sort nulls consistently
PostgreSQL normally sorts nulls after everything else in ascending order
and vice versa; we reverse this, to match SQLIte and MySQL
3 years ago
J. King
461e256052
Work around MySQL syntax weirdness
Also improve test for token translation to actually test that the
translated tokens are accepted by the database system
3 years ago
J. King
ce68566fcb
Hopefully fix MySQL
4 years ago
J. King
a431243421
Fixes for MySQL and PostgreSQL
4 years ago
J. King
e16df90bae
Style fixes
4 years ago
J. King
576d7e16a8
Fix handling of bytea-typed nulls
4 years ago
J. King
41bcffd6fb
Correctly query PostgreSQL byte arrays
This required different workarouynd for the native and PDO interfaces
4 years ago
J. King
c21ae3eca9
Correctly send binary data to PostgreSQL
This finally brings PostgreSQL to parity with SQLite and MySQL.
Two tests casting binary data to text were removed since behaviour here
should in fact be undefined
Accountinf for any encoding when retrieving data will be addressed by
a later commit
4 years ago
J. King
e60f7ea03f
Add class constant visibility
4 years ago
J. King
bc53a2d24a
Style fixes
4 years ago
J. King
bbace7a0ac
Use void and nullable return types where practical
4 years ago
J. King
15de8c2320
Fix PostgreSQL connection error message
5 years ago
J. King
c59cdfef76
Whitespace fixes
5 years ago
J. King
7ac4fb4715
Clarify PDO workaround for SQLite
5 years ago
J. King
c706a76057
Simplify array flattening
5 years ago
J. King
fb6e2babb9
Change some conditions to asserts
5 years ago
J. King
53aa7a4d0d
Style fixes
5 years ago
J. King
29667464a1
Remove unnecessary namespace imports
5 years ago
J. King
f7240301e4
Basic database maintenance
Closes #169
5 years ago
J. King
6ef13d0880
Style fixes
5 years ago
J. King
e3d2215920
Style fixes
5 years ago
J. King
38bdde1167
Add access tokens to the db, with relevant code
Tokens are similar to sessions in that they stand in for users, but the
protocol handlers will manage them; Fever login hashes are the
originating use case for them. These must never expire, for example,
and we need to specify their values.
This commit also performs a bit of database clean-up
5 years ago
J. King
ff0c9a3a55
Add functionality for interacting with subscription tags
5 years ago
J. King
6000d80b7b
Work around various SQLite-related problems
- WAL mode was not getting set properly
- Queries using the PDO driver could fail because PDO sucks
5 years ago
J. King
ed22090e49
Work around various SQLite-related problems
- WAL mode was not getting set properly
- Queries using the PDO driver could fail because PDO sucks
5 years ago
J. King
21fdd66d37
Work around limit to SQL parameter placeholders for IN() clauses
Improves #150
LIKE-based matches also need to be similarly conservative
5 years ago
J. King
837f3c6dd6
Simplify SQL type handling
This is done in anticipation of dealing with SQL types in
places other than statements
5 years ago
J. King
570a9b171c
Revert fulltext detection in driver
5 years ago
J. King
ad8057a40b
Driver changes to support basic text searching
5 years ago
J. King
908e1fa310
API documentation for database driver interface
5 years ago
J. King
b55d0b374f
API documentation for database driver interface
5 years ago
J. King
f5c5d49d97
Document SQL timeout changes
5 years ago
J. King
500851f161
Style fixes
5 years ago
J. King
8ea1df920a
Unify SQL timeouts
- Exec and lock timeouts now apply to MySQL
- Lock timeout now applies to PostgreSQL
- SQLite now uses a generic lock timeout setting which applies to all
5 years ago