I am trying to import older items into our libervia. I set the updated and published in atom to a date in 2017, and the web shows this old date properly, but still sorted the item to the top. This patch to sat_pubsub (along with a manual change to the sat_pubsub db to make created timestamp match what is in atom) is a workaround:
diff -r 0b5233981671 sat_pubsub/pgsql_storage.py
--- a/sat_pubsub/pgsql_storage.py Mon Aug 02 21:58:17 2021 +0200
+++ b/sat_pubsub/pgsql_storage.py Sat Aug 21 02:28:43 2021 +0000
@@ -894,7 +897,7 @@
cols_statmnt = []
for key in keys:
if key == 'creation':
- column = 'item_id' # could work with items.created too
+ column = 'created' # could work with items.created too
elif key == 'modification':
column = 'updated'
else:
Also, I'm not sure if this was the case before or not, but our atom.xml is now exactly backwards (oldest on top) as in the display of our node in Movim.