AUR web interface

Tasklist

FS#23039 - aurblup: Do a real sync instead of deleting and re-creating all rows

Attached to Project: AUR web interface
Opened by Lukas Fleischer (lfleischer) - Friday, 25 February 2011, 10:02 GMT
Last edited by Lukas Fleischer (lfleischer) - Wednesday, 09 March 2011, 17:12 GMT
Task Type General Gripe
Category Backend
Status Closed
Assigned To Lukas Fleischer (lfleischer)
Architecture All
Severity Medium
Priority Normal
Reported Version 1.8.0
Due in Version 1.8.1
Due Date Undecided
Percent Complete 100%
Votes 1
Private No

Details

We should put some more logic into the aurblup helper to have a real sync instead of a table truncation, followed by a whole bunch of INSERT statements.
This task depends upon

Closed by  Lukas Fleischer (lfleischer)
Wednesday, 09 March 2011, 17:12 GMT
Reason for closing:  Fixed
Additional comments about closing:  Fixed in 1.8.1.
Comment by Dan McGee (toofishes) - Friday, 25 February 2011, 13:36 GMT
If you're using libalpm anyway, use alpm_list_diff() to your advantage. There are examples in the libalpm source, but basically:

* form an alpm_list of all existing blacklist entries (SELECT name from table)
* form an alpm_list of all expected blacklist entries (read from databases)
* existing - expected = DELETE FROM
* expected - existing = INSERT INTO
Comment by Lukas Fleischer (lfleischer) - Saturday, 26 February 2011, 19:44 GMT
  • Field changed: Due in Version (Undecided → 1.9.0)
Fixed [1].

[1] http://projects.archlinux.org/aur.git/commit/?id=e72f02872fc1f81bdd609c061f08e69b34153c7e

Loading...