- Aur-dev - lists.archlinux.org

Re: [aur-dev] aur-dev Digest, Vol 39, Issue 8
by Connor Behan 22 Feb '11

22 Feb '11

Why would you do this? I find it immensely useful to look at the patches AUR developers use so I can see what they do to packages out of curiosity. Now I will have to download the tarball to see the same thing even if it's a program I don't want to compile and use. Furthermore, I refer to several of my own patches with links to the AUR website. When I'm emailing someone saying "here is a patch you might like" I often provide a link to http://aur.archlinux.org/packages/medit-full/medit-full/bindings2.diff(which still works but for how long) instead of pasting it or attaching it. Just off the top of my head I can think of two websites and two bug reports I've made that I will have to change if these links stop working. Please reconsider. And if I've missed my chance to complain because this was voted on in the mailing lists then I'm sorry for missing it but I highly doubt that was the case. Please note that this release removes all the code for automatic tarball > extraction. From now on, only PKGBUILDs and source tarballs will be > accessible via the AUR web interface. >

2 1

Re: [aur-dev] AUR 1.8.0 released
by Connor Behan 22 Feb '11

22 Feb '11

Oops, wrong subject line in the last post.

1 0

[aur-dev] [PATCH] "logged before" -> "logged in before" in web/lib/pkgfuncs.inc
by Wieland Hoffmann 21 Feb '11

21 Feb '11

This fixes a small message telling people they had to be logged to edit package information into telling them they need to be logged _in_. --- web/lib/pkgfuncs.inc | 4 ++-- 1 files changed, 2 insertions(+), 2 deletions(-)

2 1

[aur-dev] Adding the HE language.
by Netanel Shine 18 Feb '11

18 Feb '11

Hey there, i was working on translating the AUR to my language, Hebrew. I am adding to this message the gzipped patched file. btw. i know his name lame, but i think he will work just fine. THanks! -- Netanel Shine

6 40

[aur-dev] Package blacklist for the AUR
by Lukas Fleischer 10 Feb '11

10 Feb '11

Hi! I recently started working on a package blacklist for the official AUR which can e.g. be used to prevent people from uploading packages in the official repos to [unsupported] (cf. FS#12902 [1]). Patches can be found in the "pkg-blacklist" branch of my working tree [2]. They currently include some code that adds a "PackageBlacklist" table and a hacky helper utility that can be used to update that table by sync'ing it with some binary repos. Constructive criticism and suggestions welcome! [1] https://bugs.archlinux.org/task/12902 [2] http://git.cryptocrack.de/aur.git/log/?h=pkg-blacklist

5 9

[aur-dev] aur live-search
by elij 10 Feb '11

10 Feb '11

I was messing around and created a live-search-like query interface (which utilizes the aur-rpc). forum post: https://bbs.archlinux.org/viewtopic.php?id=112878 example site: http://aurlivesearch.awesometrousers.net/ code: https://github.com/cactus/aurlivesearch

2 2

[aur-dev] Old, unapplied patches
by PyroPeter 09 Feb '11

09 Feb '11

Hello AUR developers, there is a great backlog of patches that work well, but are not applied. Among them are: * The right-to-left fixes for the hebrew translation * Making links in comments clickable * Deletion through the web interface It would be great if you could take some time to review and apply them. Regards, PyroPeter -- freenode/pyropeter ETAOIN SHRDLU

3 5

[aur-dev] [PATCH] Remove fulltext index from "Packages".
by Lukas Fleischer 09 Feb '11

09 Feb '11

Drop unused fulltext indexes from "Packages" table (all search routines use "LIKE" patterns) which prevent the use of InnoDB. Signed-off-by: Lukas Fleischer <archlinux(a)cryptocrack.de> --- As far as I can see, this is the only thing that prevents us from using InnoDB as the storage engine for all tables. Correct me if I missed something. UPGRADING | 10 +++++++++- support/schema/aur-schema.sql | 1 - 2 files changed, 9 insertions(+), 2 deletions(-) diff --git a/UPGRADING b/UPGRADING index 661a6c3..c649985 100644 --- a/UPGRADING +++ b/UPGRADING @@ -29,7 +29,15 @@ ALTER TABLE TU_VoteInfo MODIFY User VARCHAR(32) collate latin1_general_ci NOT NULL; ---- -2. You will need to update all packages which are stored in the incoming dir as +2. Drop all fulltext indexes from the "Packages" table: + +Please do this with care. `ALTER TABLE Packages DROP INDEX Name;` will work in +most cases but might remove the wrong index if your indexes have been created +in a non-standard order (e.g. during some update process). You'd better run +`SHOW INDEX FROM Packages;` before to ensure that your setup doesn't use a +different naming. + +3. You will need to update all packages which are stored in the incoming dir as in 1.8.0, source tarballs are no longer extracted automatically and PKGBUILDs are from now on located in the same subdirectories as the tarballs themselves. The following script will do the conversion automatically when being run inside diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql index cddf00e..d37e1b2 100644 --- a/support/schema/aur-schema.sql +++ b/support/schema/aur-schema.sql @@ -106,7 +106,6 @@ CREATE TABLE Packages ( ModifiedTS BIGINT UNSIGNED NOT NULL, SubmitterUID INTEGER UNSIGNED NOT NULL DEFAULT 0, -- who submitted it? MaintainerUID INTEGER UNSIGNED NOT NULL DEFAULT 0, -- User - FULLTEXT (Name,Description), PRIMARY KEY (ID), UNIQUE (Name), INDEX (CategoryID), -- 1.7.4

1 0

[aur-dev] [PATCH] Use VARCHAR instead of CHAR where appropriate.
by Lukas Fleischer 09 Feb '11

09 Feb '11

Signed-off-by: Lukas Fleischer <archlinux(a)cryptocrack.de> --- UPGRADING | 16 ++++++++++++++++ support/schema/aur-schema.sql | 28 ++++++++++++++-------------- 2 files changed, 30 insertions(+), 14 deletions(-) diff --git a/UPGRADING b/UPGRADING index c067af5..661a6c3 100644 --- a/UPGRADING +++ b/UPGRADING @@ -11,6 +11,22 @@ ALTER TABLE Packages ADD OutOfDateTS BIGINT UNSIGNED NULL DEFAULT NULL; UPDATE Packages SET OutOfDateTS = UNIX_TIMESTAMP() WHERE OutOfDate = 1; ALTER TABLE Packages DROP OutOfDate, DROP FSPath, DROP URLPath, DROP LocationID; DROP TABLE PackageLocations, PackageContents; +ALTER TABLE AccountTypes MODIFY AccountType VARCHAR(32) NOT NULL DEFAULT ''; +ALTER TABLE Users MODIFY Username VARCHAR(32) NOT NULL, + MODIFY Email VARCHAR(64) NOT NULL, + MODIFY RealName VARCHAR(64) NOT NULL DEFAULT '', + MODIFY LangPreference VARCHAR(5) NOT NULL DEFAULT 'en', + MODIFY IRCNick VARCHAR(32) NOT NULL DEFAULT ''; +ALTER TABLE PackageCategories MODIFY Category VARCHAR(32) NOT NULL; +ALTER TABLE Packages MODIFY Name VARCHAR(64) NOT NULL, + MODIFY Version VARCHAR(32) NOT NULL DEFAULT '', + MODIFY Description VARCHAR(255) NOT NULL DEFAULT "An Arch Package", + MODIFY URL VARCHAR(255) NOT NULL DEFAULT "http://www.archlinux.org", + MODIFY License VARCHAR(40) NOT NULL DEFAULT ''; +ALTER TABLE PackageSources + MODIFY Source VARCHAR(255) NOT NULL DEFAULT "/dev/null"; +ALTER TABLE TU_VoteInfo + MODIFY User VARCHAR(32) collate latin1_general_ci NOT NULL; ---- 2. You will need to update all packages which are stored in the incoming dir as diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql index cb5ea42..cddf00e 100644 --- a/support/schema/aur-schema.sql +++ b/support/schema/aur-schema.sql @@ -9,7 +9,7 @@ USE AUR; -- CREATE TABLE AccountTypes ( ID TINYINT UNSIGNED NOT NULL AUTO_INCREMENT, - AccountType char(32) NOT NULL DEFAULT '', + AccountType VARCHAR(32) NOT NULL DEFAULT '', PRIMARY KEY (ID) ); INSERT INTO AccountTypes (ID, AccountType) VALUES (1, 'User'); @@ -23,14 +23,14 @@ CREATE TABLE Users ( ID INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, AccountTypeID TINYINT UNSIGNED NOT NULL DEFAULT 1, Suspended TINYINT UNSIGNED NOT NULL DEFAULT 0, - Username CHAR(32) NOT NULL, - Email CHAR(64) NOT NULL, + Username VARCHAR(32) NOT NULL, + Email VARCHAR(64) NOT NULL, Passwd CHAR(32) NOT NULL, Salt CHAR(32) NOT NULL DEFAULT '', ResetKey CHAR(32) NOT NULL DEFAULT '', - RealName CHAR(64) NOT NULL DEFAULT '', - LangPreference CHAR(5) NOT NULL DEFAULT 'en', - IRCNick CHAR(32) NOT NULL DEFAULT '', + RealName VARCHAR(64) NOT NULL DEFAULT '', + LangPreference VARCHAR(5) NOT NULL DEFAULT 'en', + IRCNick VARCHAR(32) NOT NULL DEFAULT '', LastVoted BIGINT UNSIGNED NOT NULL DEFAULT 0, NewPkgNotify TINYINT UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (ID), @@ -66,7 +66,7 @@ CREATE TABLE Sessions ( -- CREATE TABLE PackageCategories ( ID TINYINT UNSIGNED NOT NULL AUTO_INCREMENT, - Category CHAR(32) NOT NULL, + Category VARCHAR(32) NOT NULL, PRIMARY KEY (ID) ); INSERT INTO PackageCategories (Category) VALUES ('none'); @@ -93,13 +93,13 @@ INSERT INTO PackageCategories (Category) VALUES ('xfce'); -- CREATE TABLE Packages ( ID INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, - Name CHAR(64) NOT NULL, - Version CHAR(32) NOT NULL DEFAULT '', + Name VARCHAR(64) NOT NULL, + Version VARCHAR(32) NOT NULL DEFAULT '', CategoryID TINYINT UNSIGNED NOT NULL DEFAULT 1, - Description CHAR(255) NOT NULL DEFAULT "An Arch Package", - URL CHAR(255) NOT NULL DEFAULT "http://www.archlinux.org", + Description VARCHAR(255) NOT NULL DEFAULT "An Arch Package", + URL VARCHAR(255) NOT NULL DEFAULT "http://www.archlinux.org", DummyPkg TINYINT UNSIGNED NOT NULL DEFAULT 0, -- 1=>dummy - License CHAR(40) NOT NULL DEFAULT '', + License VARCHAR(40) NOT NULL DEFAULT '', NumVotes INTEGER UNSIGNED NOT NULL DEFAULT 0, OutOfDateTS BIGINT UNSIGNED NULL DEFAULT NULL, SubmittedTS BIGINT UNSIGNED NOT NULL, @@ -134,7 +134,7 @@ CREATE TABLE PackageDepends ( -- CREATE TABLE PackageSources ( PackageID INTEGER UNSIGNED NOT NULL, - Source CHAR(255) NOT NULL DEFAULT "/dev/null", + Source VARCHAR(255) NOT NULL DEFAULT "/dev/null", INDEX (PackageID) ); @@ -183,7 +183,7 @@ CREATE UNIQUE INDEX NotifyUserIDPkgID ON CommentNotify (UserID, PkgID); CREATE TABLE IF NOT EXISTS TU_VoteInfo ( ID int(10) unsigned NOT NULL auto_increment, Agenda text collate latin1_general_ci NOT NULL, - User char(32) collate latin1_general_ci NOT NULL, + User VARCHAR(32) collate latin1_general_ci NOT NULL, Submitted bigint(20) unsigned NOT NULL, End bigint(20) unsigned NOT NULL, SubmitterID int(10) unsigned NOT NULL, -- 1.7.4

3 3

[aur-dev] Question about sanitized data dumps
by elij 09 Feb '11

09 Feb '11

I have been [fooling around][1] with an aur-rpc reimplementation in ruby+redis with sphinx as the search engine. Loui [mentioned][2] he had been thinking about providing a dump of the existing database or something, to users who are interested in developing features and/or replacements. If so, and assuming the dump is sanitized in some way (remove real user email addresses, etc), I would certainly be interested. It would be nice to get some real data to play with. Is there any more information currently available on this? Thanks. [1]: https://github.com/cactus/spew-ruby [2]: http://mailman.archlinux.org/pipermail/aur-general/2011-January/013323.html

2 3