biboumi/src/database/database.cpp -rw-r--r-- 12.1 KiB
05ba076a — louiz’ 2 years ago
Use return {...} instead of make_tuple
0b51e382 — louiz’ 3 years ago
MaxHistoryLength now has some sensible default value if the user set a negative one
782732ba — louiz’ 4 years ago
Remove a bunch of useless empty lines
458ea53d — louiz’ 4 years ago
Fix a compile error with GCC 5.x

fix #3366
b0168fd4 — louiz’ 4 years ago
mam: Send “fin complete” only when appropriate

Also simplify how we did the whole “limit + 1”
And fix one bad interpretation of the XEP for the case where the query has
no after or before restriction.

fix #3349
1236b8a0 — louiz’ 4 years ago
Only use the ID to order archives

fix #3343
61de6b1d — louiz’ 4 years ago
Revert "Use a different Date data type"

This reverts commit 857c7d3972a03cbeebf730d99b924d3710dee6a0.
a90f196a — louiz’ 4 years ago
Revert "Use the Date to find a next page in RSM, not the id"

This reverts commit 5ef7ba08028065b03d51d1dc70bb35aeb41ae19d.
5ef7ba08 — louiz’ 4 years ago
Use the Date to find a next page in RSM, not the id

This way, it works, whatever the order of insertion in the database was.

fix #3343
4bd7b698 — louiz’ 4 years ago
Refactor that fixes a compilation issue in Release mode

Some template specialization were not found, because they were not declared
at the point they were used.

We moved things around, things are less inter-dependant, and also now it
857c7d39 — louiz’ 4 years ago
Use a different Date data type

PLEASE backup your database before testing this commit, and report any
migration issue.

In postgresql, we use timestamp with timezone.
In sqlite3 we use REAL (the date is expressed as julianday)

This requires a migration of the muclogline_ table:
In postgresql it’s pretty simple, we convert all the integer into timestamps

With sqlite3, we actually rename the table, create the new one with the
correct type, then copy everything to the new table, with a conversion
function for the Date_ column, and then we delete the old table.

fix #3343
9500bfd4 — louiz’ 4 years ago
Reflect message IDs in channel MUCs

fix #3283
5af0a804 — louiz’ 4 years ago
Use a transaction around the DELETE + INSERT of the after_connection_commands

Otherwise we can imagine that two clients changing this value at the same
time would mix things up.

ref #3275
577984fa — louiz’ 4 years ago
Allow the execution of multiple commands after the IRC connection

fix #3275
d3e07eee — louiz’ 4 years ago
Sort archive messages by date (and only then by id)

fix #3337

Because apparently the IDs are not always incrementing. We still use them to
know the order of two messages that were received at the same second (in
this case, the ID will always be incrementing).
4a2a280d — louiz’ 4 years ago
Support the <before/> element in MAM requests
fd7c3652 — louiz’ 4 years ago
Use the same function for both history orders
0280343c — louiz’ 4 years ago
Handle the “after” RSM value to page through results
99389eef — louiz’ 4 years ago
Always return the oldest matching messages from MAM, even if no date is set
2c4016a4 — louiz’ 4 years ago
Merge branch 'postgresql' into 'master'

Add postgresql support

Closes #3237

See merge request louiz/biboumi!18