This project is mirrored from https://:*****@gitlab.archlinux.org/archlinux/aurweb.git. Pull mirroring updated .
  1. 18 Sep, 2012 2 commits
  2. 17 Sep, 2012 2 commits
  3. 23 Aug, 2012 1 commit
  4. 18 Jul, 2012 1 commit
  5. 17 Jul, 2012 1 commit
  6. 15 Jul, 2012 2 commits
  7. 06 Jul, 2012 8 commits
  8. 31 May, 2012 1 commit
  9. 08 Mar, 2012 1 commit
  10. 02 Nov, 2011 1 commit
  11. 25 Oct, 2011 2 commits
  12. 24 Oct, 2011 3 commits
  13. 11 Aug, 2011 5 commits
  14. 25 Jun, 2011 1 commit
    • Dan McGee's avatar
      Use sane ORDER BY clauses in package list queries · 3c110b13
      Dan McGee authored
      
      
      We were doing some silly things here with an "ORDER BY Name, CategoryID"
      clause, due to the fact that Name is unique, and thus any additional
      ordering after Name will have no effect. Of course, the dumb as a box of
      rocks MySQL query optimizer doesn't realize this, leading to full table
      scans every time of ~30000 packages instead of using index scans for the
      ordering and only retrieving the first 50 rows.
      
      The biggest change is noted in the default sort order as it cuts down
      the columns to one, but we can remove the redundant sort from other
      orderings as well, even though those will still not be able to use an
      index-driven query plan.
      
      Signed-off-by: default avatarDan McGee <dan@archlinux.org>
      Signed-off-by: default avatarLukas Fleischer <archlinux@cryptocrack.de>
      3c110b13
  15. 22 Jun, 2011 2 commits
  16. 17 May, 2011 1 commit
  17. 27 Apr, 2011 1 commit
  18. 19 Apr, 2011 1 commit
  19. 06 Apr, 2011 1 commit
  20. 05 Apr, 2011 1 commit
  21. 03 Apr, 2011 2 commits
    • Dan McGee's avatar
      Remove Dummy Package concept · 7c91c592
      Dan McGee authored
      
      
      Instead, we just store dependencies directly in the PackageDepends
      table. Since we don't use this info anywhere besides the package details
      page, there is little value in precalculating what is in the AUR vs.
      what is not.
      
      An upgrade path is provided via several SQL statements in the UPGRADING
      document. There should be no user-visible change from this, but the DB
      schema gets a bit more sane and we no longer have loads of junk packages
      in our tables that are never shown to the end user. This should also
      help the MySQL query planner in several cases as we no longer have to be
      careful to exclude dummy packages on every query.
      
      Signed-off-by: default avatarDan McGee <dan@archlinux.org>
      Signed-off-by: default avatarLukas Fleischer <archlinux@cryptocrack.de>
      7c91c592
    • Dan McGee's avatar
      Always set ModifiedTS including new packages · 1f252eba
      Dan McGee authored
      
      
      Set it equal to the SubmittedTS field, which will be our indication the
      package is new when we show the logo on the front page of the AUR.
      
      This results in the ability to remove the use of the unindexable
      GREATEST() function from the AUR code everywhere we had to use it before
      to handle the 0 timestamp case.
      
      Note that there is no race condition here in calling UNIX_TIMESTAMP()
      twice- it always returns the time at the beginning of statment
      execution:
      
          mysql> select unix_timestamp(), sleep(2), unix_timestamp();
          +------------------+----------+------------------+
          | unix_timestamp() | sleep(2) | unix_timestamp() |
          +------------------+----------+------------------+
          |       1300851746 |        0 |       1300851746 |
          +------------------+----------+------------------+
          1 row in set (2.00 sec)
      
      Signed-off-by: default avatarDan McGee <dan@archlinux.org>
      Signed-off-by: default avatarLukas Fleischer <archlinux@cryptocrack.de>
      1f252eba