/[collab-qa]/udd/udd/bugs_gatherer.pl
ViewVC logotype

Log of /udd/udd/bugs_gatherer.pl

Parent Directory Parent Directory | Revision Log Revision Log


Sticky Revision:
(Current path doesn't exist after revision 2466)

Revision 1907 - (view) (download) (annotate) - [select for diffs]
Modified Tue Feb 8 22:24:57 2011 UTC (2 years, 3 months ago) by lucas
File length: 13208 byte(s)
Diff to previous 1694 , to selected 946
add affects_oldstable to bugs table

Revision 1694 - (view) (download) (annotate) - [select for diffs]
Modified Sun Feb 21 11:09:22 2010 UTC (3 years, 2 months ago) by lucas
File length: 12741 byte(s)
Diff to previous 1596 , to selected 946
import bugs_blocks/blockedby info

Revision 1596 - (view) (download) (annotate) - [select for diffs]
Modified Wed Oct 7 19:41:33 2009 UTC (3 years, 7 months ago) by lucas
File length: 12202 byte(s)
Diff to previous 1588 , to selected 946
tons of minor UDD stuff

Revision 1588 - (view) (download) (annotate) - [select for diffs]
Modified Thu Sep 24 08:52:59 2009 UTC (3 years, 7 months ago) by lucas
File length: 12191 byte(s)
Diff to previous 1540 , to selected 946
also deal with src:foo in bugs_packages table

Revision 1540 - (view) (download) (annotate) - [select for diffs]
Modified Fri Jul 24 17:49:32 2009 UTC (3 years, 9 months ago) by lucas
File length: 12065 byte(s)
Diff to previous 1539 , to selected 946
handle bugs without submitter

Revision 1539 - (view) (download) (annotate) - [select for diffs]
Modified Fri Jul 24 14:40:23 2009 UTC (3 years, 9 months ago) by lucas
File length: 11970 byte(s)
Diff to previous 1532 , to selected 946
split emails in the bugs and archived_bugs table. based on a patch by Olivier Berger.

Revision 1532 - (view) (download) (annotate) - [select for diffs]
Modified Fri Jul 24 10:30:54 2009 UTC (3 years, 9 months ago) by lucas
File length: 11093 byte(s)
Diff to previous 1531 , to selected 946
analyze before commit in bugs

Revision 1531 - (view) (download) (annotate) - [select for diffs]
Modified Thu Jul 23 14:05:39 2009 UTC (3 years, 9 months ago) by lucas
File length: 11093 byte(s)
Diff to previous 1466 , to selected 946
add ANALYZE at the end of all importers to teach pgsql some stats about the data we just imported

Revision 1466 - (view) (download) (annotate) - [select for diffs]
Modified Sat Jun 6 21:23:12 2009 UTC (3 years, 11 months ago) by lucas
File length: 10768 byte(s)
Diff to previous 1389 , to selected 946
fix paths

Revision 1389 - (view) (download) (annotate) - [select for diffs]
Modified Sun Feb 15 21:46:25 2009 UTC (4 years, 3 months ago) by lucas
File length: 10717 byte(s)
Diff to previous 1351 , to selected 946
added forwarded and done to bugs table

Revision 1351 - (view) (download) (annotate) - [select for diffs]
Modified Fri Dec 19 13:30:01 2008 UTC (4 years, 5 months ago) by lucas
File length: 10659 byte(s)
Diff to previous 1335 , to selected 946
pass the db port when connecting.

Revision 1335 - (view) (download) (annotate) - [select for diffs]
Modified Wed Oct 22 19:44:01 2008 UTC (4 years, 6 months ago) by lucas
File length: 10513 byte(s)
Diff to previous 1331 , to selected 946
bug_presence: use reference to @arch array

Revision 1331 - (view) (download) (annotate) - [select for diffs]
Modified Wed Oct 22 18:10:13 2008 UTC (4 years, 6 months ago) by lucas
File length: 10509 byte(s)
Diff to previous 1305 , to selected 946
added list of arches to bug_presence. doesn't work, but I'll fix it

Revision 1305 - (view) (download) (annotate) - [select for diffs]
Modified Sat Sep 27 16:48:31 2008 UTC (4 years, 7 months ago) by lucas
File length: 10318 byte(s)
Diff to previous 1304 , to selected 946
also delete old bugs

Revision 1304 - (view) (download) (annotate) - [select for diffs]
Modified Sat Sep 27 16:38:23 2008 UTC (4 years, 7 months ago) by lucas
File length: 10308 byte(s)
Diff to previous 1300 , to selected 946
added bugs_packages table

Revision 1300 - (view) (download) (annotate) - [select for diffs]
Modified Sat Sep 27 08:35:35 2008 UTC (4 years, 7 months ago) by lucas
File length: 9954 byte(s)
Diff to previous 1299 , to selected 946
copy the mechanism in pkgreport.cgi to the the bin->src mapping

Revision 1299 - (view) (download) (annotate) - [select for diffs]
Modified Fri Sep 26 22:00:46 2008 UTC (4 years, 7 months ago) by lucas
File length: 10551 byte(s)
Diff to previous 1287 , to selected 946
add some debugging output to compare the result of binarytosource and getpkgsrc

Revision 1287 - (view) (download) (annotate) - [select for diffs]
Modified Mon Sep 22 17:08:03 2008 UTC (4 years, 7 months ago) by kroeckx
File length: 10312 byte(s)
Diff to previous 1264 , to selected 946
Fill in the affects_experimental field in the bugs tables.

Revision 1264 - (view) (download) (annotate) - [select for diffs]
Modified Wed Sep 10 22:18:10 2008 UTC (4 years, 8 months ago) by kroeckx
File length: 9833 byte(s)
Diff to previous 1249 , to selected 946
Make all inserts reference the fields they want to insert into.

Revision 1249 - (view) (download) (annotate) - [select for diffs]
Modified Mon Sep 8 18:58:06 2008 UTC (4 years, 8 months ago) by lucas
File length: 9620 byte(s)
Diff to previous 1243 , to selected 946
bugs import cleanup

Revision 1243 - (view) (download) (annotate) - [select for diffs]
Modified Mon Sep 8 09:18:54 2008 UTC (4 years, 8 months ago) by lucas
File length: 9501 byte(s)
Diff to previous 1220 , to selected 946
added foreign keys, adapted import scripts to allow to use them. DB udd on udd.debian.net was updated manually.

Revision 1220 - (view) (download) (annotate) - [select for diffs]
Modified Sun Sep 7 18:59:22 2008 UTC (4 years, 8 months ago) by lucas
File length: 10025 byte(s)
Diff to previous 1217 , to selected 946
drop schemas, code for drop/setup/schema

Revision 1217 - (view) (download) (annotate) - [select for diffs]
Modified Sun Sep 7 17:28:09 2008 UTC (4 years, 8 months ago) by lucas
File length: 11245 byte(s)
Diff to previous 1118 , to selected 946
move udd/* up one dir. makes more sense.

Revision 1118 - (view) (download) (annotate) - [select for diffs]
Modified Mon Aug 18 14:29:39 2008 UTC (4 years, 9 months ago) by neronus-guest
Original Path: udd/src/udd/bugs_gatherer.pl
File length: 11245 byte(s)
Diff to previous 1106 , to selected 946
We don't need no timing - so we switch it off

Revision 1106 - (view) (download) (annotate) - [select for diffs]
Modified Sun Aug 17 12:24:24 2008 UTC (4 years, 9 months ago) by neronus-guest
Original Path: udd/src/udd/bugs_gatherer.pl
File length: 11265 byte(s)
Diff to previous 1078 , to selected 946
Added command 'tables' which returns the tables used by the given source

Revision 1078 - (view) (download) (annotate) - [select for diffs]
Modified Mon Aug 11 18:14:00 2008 UTC (4 years, 9 months ago) by neronus-guest
Original Path: udd/src/udd/bugs_gatherer.pl
File length: 11038 byte(s)
Diff to previous 1077 , to selected 946
some curlies were missing :)

Revision 1077 - (view) (download) (annotate) - [select for diffs]
Modified Mon Aug 11 18:08:36 2008 UTC (4 years, 9 months ago) by neronus-guest
Original Path: udd/src/udd/bugs_gatherer.pl
File length: 11034 byte(s)
Diff to previous 1071 , to selected 946
Removed double quouting

Revision 1071 - (view) (download) (annotate) - [select for diffs]
Modified Mon Aug 11 13:53:37 2008 UTC (4 years, 9 months ago) by neronus-guest
Original Path: udd/src/udd/bugs_gatherer.pl
File length: 11240 byte(s)
Diff to previous 1070 , to selected 946
s/my/our/ for specific lines

Revision 1070 - (view) (download) (annotate) - [select for diffs]
Modified Mon Aug 11 13:51:32 2008 UTC (4 years, 9 months ago) by neronus-guest
Original Path: udd/src/udd/bugs_gatherer.pl
File length: 11238 byte(s)
Diff to previous 1068 , to selected 946
Added global variable to main()

Revision 1068 - (view) (download) (annotate) - [select for diffs]
Modified Mon Aug 11 13:33:24 2008 UTC (4 years, 9 months ago) by neronus-guest
Original Path: udd/src/udd/bugs_gatherer.pl
File length: 11211 byte(s)
Diff to previous 1059 , to selected 946
Decentralized setup and drop scheme
bugs_gatherer.pl now has prepared SQL statements
for archived bugs, affects_* is now false

Revision 1059 - (view) (download) (annotate) - [select for diffs]
Modified Sun Aug 10 15:02:05 2008 UTC (4 years, 9 months ago) by lucas
Original Path: udd/src/udd/bugs_gatherer.pl
File length: 8231 byte(s)
Diff to previous 1055 , to selected 946
use dbh-do instead of dbh->prepare->execute ; added option to only import some bugs (easier to test)

Revision 1055 - (view) (download) (annotate) - [select for diffs]
Modified Sun Aug 10 13:44:59 2008 UTC (4 years, 9 months ago) by lucas
Original Path: udd/src/udd/bugs_gatherer.pl
File length: 8317 byte(s)
Diff to previous 1053 , to selected 946
bugs_gatherer: improved DELETEs, added timing

Revision 1053 - (view) (download) (annotate) - [select for diffs]
Modified Sun Aug 10 10:28:43 2008 UTC (4 years, 9 months ago) by neronus-guest
Original Path: udd/src/udd/bugs_gatherer.pl
File length: 8467 byte(s)
Diff to previous 1040 , to selected 946
read_usertags was deprecated, using Debbugs::User->new now (which is pretty well hidden)

Revision 1040 - (view) (download) (annotate) - [select for diffs]
Modified Sat Aug 9 18:02:05 2008 UTC (4 years, 9 months ago) by lucas
Original Path: udd/src/udd/bugs_gatherer.pl
File length: 8398 byte(s)
Diff to previous 1029 , to selected 946
rename bugs_unarchived to bugs, bugs to bugs_both

Revision 1029 - (view) (download) (annotate) - [select for diffs]
Modified Sat Aug 9 01:49:53 2008 UTC (4 years, 9 months ago) by lucas
Original Path: udd/src/udd/bugs_gatherer.pl
File length: 8420 byte(s)
Diff to previous 999 , to selected 946
don't insert bugs with source=null. copy the package value.

Revision 999 - (view) (download) (annotate) - [select for diffs]
Modified Fri Aug 8 13:53:23 2008 UTC (4 years, 9 months ago) by neronus-guest
Original Path: udd/src/udd/bugs_gatherer.pl
File length: 8217 byte(s)
Diff to previous 983 , to selected 946
Removed surviving 'next' statement

Revision 983 - (view) (download) (annotate) - [select for diffs]
Modified Sun Aug 3 16:51:14 2008 UTC (4 years, 9 months ago) by neronus-guest
Original Path: udd/src/udd/bugs_gatherer.pl
File length: 8249 byte(s)
Diff to previous 982 , to selected 946
Split bugs table into bugs_archived and bugs_unarchived
Created bugs VIEW as union of bugs_archived and bugs_unarchived

Revision 982 - (view) (download) (annotate) - [select for diffs]
Modified Sun Aug 3 13:10:16 2008 UTC (4 years, 9 months ago) by neronus-guest
Original Path: udd/src/udd/bugs_gatherer.pl
File length: 7979 byte(s)
Diff to previous 973 , to selected 946
Fixed bug regarding bugs.source

Revision 973 - (view) (download) (annotate) - [select for diffs]
Modified Thu Jul 31 15:50:45 2008 UTC (4 years, 9 months ago) by neronus-guest
Original Path: udd/src/udd/bugs_gatherer.pl
File length: 7974 byte(s)
Diff to previous 971 , to selected 946
Removed scanning for mtimes: We need to find a way to check for updated packages first, so that we can recalculate the affects_ columns

Revision 971 - (view) (download) (annotate) - [select for diffs]
Modified Tue Jul 29 14:01:16 2008 UTC (4 years, 9 months ago) by neronus-guest
Original Path: udd/src/udd/bugs_gatherer.pl
File length: 5965 byte(s)
Diff to previous 968 , to selected 946
Now all bugs which are going to be inserted, are deleted prior to that,
	not only bugs which are archived/unarchived

Revision 968 - (view) (download) (annotate) - [select for diffs]
Modified Tue Jul 29 13:06:30 2008 UTC (4 years, 9 months ago) by neronus-guest
Original Path: udd/src/udd/bugs_gatherer.pl
File length: 6273 byte(s)
Diff to previous 946
Added code to import bugs.d.o usertags
Renamed bug_user_tags.bug_user to email

Revision 946 - (view) (download) (annotate) - [selected]
Modified Sun Jul 27 13:26:34 2008 UTC (4 years, 9 months ago) by neronus-guest
Original Path: udd/src/udd/bugs_gatherer.pl
File length: 5238 byte(s)
Diff to previous 945
Added NOTES files, which should contain various notes for UDD
Modified DELETE statments for bugs_gatherer, so that only the correct entries are delted, and not everything

Revision 945 - (view) (download) (annotate) - [select for diffs]
Modified Sun Jul 27 12:53:57 2008 UTC (4 years, 9 months ago) by neronus-guest
Original Path: udd/src/udd/bugs_gatherer.pl
File length: 4831 byte(s)
Diff to previous 942 , to selected 946
Added possibility to import archived bugs
renamed bugs.affects_testings to bugs.affects_testing

Revision 942 - (view) (download) (annotate) - [select for diffs]
Modified Sun Jul 27 11:38:35 2008 UTC (4 years, 9 months ago) by neronus-guest
Original Path: udd/src/udd/bugs_gatherer.pl
File length: 4404 byte(s)
Diff to previous 939 , to selected 946
Added bugs to dispatcher (bugs.debian.org that is)
Moved epoch to timestamp conversion from perl to postgresql

Revision 939 - (view) (download) (annotate) - [select for diffs]
Modified Sat Jul 26 19:21:15 2008 UTC (4 years, 9 months ago) by neronus-guest
Original Path: udd/src/udd/bugs_gatherer.pl
File length: 4215 byte(s)
Diff to previous 936 , to selected 946
Added code to import upload history
Removed print from bugs gatherer

Revision 936 - (view) (download) (annotate) - [select for diffs]
Modified Sat Jul 26 13:06:58 2008 UTC (4 years, 9 months ago) by neronus-guest
Original Path: udd/src/udd/bugs_gatherer.pl
File length: 4063 byte(s)
Diff to previous 930 , to selected 946
* Removed bugs gatherer optimization
* Code cleanups
* comments

Revision 930 - (view) (download) (annotate) - [select for diffs]
Modified Thu Jul 24 19:52:26 2008 UTC (4 years, 9 months ago) by neronus-guest
Original Path: udd/src/udd/bugs_gatherer.pl
File length: 4965 byte(s)
Diff to previous 929 , to selected 946
* Only updated bugs are updated in the DB

Revision 929 - (view) (download) (annotate) - [select for diffs]
Modified Thu Jul 24 16:34:20 2008 UTC (4 years, 9 months ago) by neronus-guest
Original Path: udd/src/udd/bugs_gatherer.pl
File length: 3866 byte(s)
Diff to previous 925 , to selected 946
trivial change in popcon_gatherer.py
added source column to bugs table

Revision 925 - (view) (download) (annotate) - [select for diffs]
Modified Thu Jul 24 12:28:46 2008 UTC (4 years, 9 months ago) by neronus-guest
Original Path: udd/src/udd/bugs_gatherer.pl
File length: 3559 byte(s)
Diff to previous 922 , to selected 946
* added module init file
* moved statement deallocation in sources_gatherer.py
* the pending status of bugs is read now, too

Revision 922 - (view) (download) (annotate) - [select for diffs]
Modified Wed Jul 23 14:32:10 2008 UTC (4 years, 9 months ago) by neronus-guest
Original Path: udd/src/udd/bugs_gatherer.pl
File length: 3465 byte(s)
Diff to previous 921 , to selected 946
Added affects_* to bugs table

Revision 921 - (view) (download) (annotate) - [select for diffs]
Modified Wed Jul 23 12:09:04 2008 UTC (4 years, 9 months ago) by neronus-guest
Original Path: udd/src/udd/bugs_gatherer.pl
File length: 2301 byte(s)
Diff to previous 920 , to selected 946
Added found_in and fixed_in and merged_with

Revision 920 - (view) (download) (annotate) - [select for diffs]
Modified Wed Jul 23 10:33:26 2008 UTC (4 years, 9 months ago) by neronus-guest
Original Path: udd/src/udd/bugs_gatherer.pl
File length: 2070 byte(s)
Diff to previous 919 , to selected 946
Added fixed_in and found_in versions

Revision 919 - (view) (download) (annotate) - [select for diffs]
Added Tue Jul 22 19:03:59 2008 UTC (4 years, 9 months ago) by neronus-guest
Original Path: udd/src/udd/bugs_gatherer.pl
File length: 1404 byte(s)
Diff to selected 946
Added tables for bugs.debian.org
Write script to import data from bugs.debian.org. Still incomplete

This form allows you to request diffs between any two revisions of this file. For each of the two "sides" of the diff, enter a numeric revision.

  Diffs between and
  Type of Diff should be a

  ViewVC Help
Powered by ViewVC 1.1.5