S

Order items by atom <published>

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.

id

398

author

Singpolyma

created

21. 8. 2021 2:29

updated

30. 9. 2021 17:30

labels
libervia-web
type
bug
status
closed
priority
normal
milestone
0.7
severity
normal