Log of /udd/udd/upload_history_gatherer.py

---

Revision 1536 - (view) (download) (as text) (annotate) - [select for diffs]
Modified Fri Jul 24 11:00:34 2009 UTC (3 years, 10 months ago) by lucas
File length: 4433 byte(s)
Diff to previous 1531

use lists instead of tuples (thanks zack)

---

Revision 1531 - (view) (download) (as text) (annotate) - [selected]
Modified Thu Jul 23 14:05:39 2009 UTC (3 years, 10 months ago) by lucas
File length: 4495 byte(s)
Diff to previous 1529

add ANALYZE at the end of all importers to teach pgsql some stats about the data we just imported

---

Revision 1529 - (view) (download) (as text) (annotate) - [select for diffs]
Modified Thu Jul 23 00:28:12 2009 UTC (3 years, 10 months ago) by lucas
File length: 4294 byte(s)
Diff to previous 1335 , to selected 1531

add _email and _name columns in sources, packages and upload_history. use executemany() in upload-history.

---

Revision 1335 - (view) (download) (as text) (annotate) - [select for diffs]
Modified Wed Oct 22 19:44:01 2008 UTC (4 years, 7 months ago) by lucas
File length: 3191 byte(s)
Diff to previous 1264 , to selected 1531

bug_presence: use reference to @arch array

---

Revision 1264 - (view) (download) (as text) (annotate) - [select for diffs]
Modified Wed Sep 10 22:18:10 2008 UTC (4 years, 8 months ago) by kroeckx
File length: 3007 byte(s)
Diff to previous 1243 , to selected 1531

Make all inserts reference the fields they want to insert into.

---

Revision 1243 - (view) (download) (as text) (annotate) - [select for diffs]
Modified Mon Sep 8 09:18:54 2008 UTC (4 years, 8 months ago) by lucas
File length: 2880 byte(s)
Diff to previous 1238 , to selected 1531

added foreign keys, adapted import scripts to allow to use them. DB udd on udd.debian.net was updated manually.

---

Revision 1238 - (view) (download) (as text) (annotate) - [select for diffs]
Modified Mon Sep 8 07:07:04 2008 UTC (4 years, 8 months ago) by lucas
File length: 2880 byte(s)
Diff to previous 1217 , to selected 1531

dont display anything if no error

---

Revision 1217 - (view) (download) (as text) (annotate) - [select for diffs]
Modified Sun Sep 7 17:28:09 2008 UTC (4 years, 8 months ago) by lucas
File length: 2878 byte(s)
Diff to previous 1106 , to selected 1531

move udd/* up one dir. makes more sense.

---

Revision 1106 - (view) (download) (as text) (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/upload_history_gatherer.py
File length: 2878 byte(s)
Diff to previous 1095 , to selected 1531

Added command 'tables' which returns the tables used by the given source

---

Revision 1095 - (view) (download) (as text) (annotate) - [select for diffs]
Modified Thu Aug 14 12:11:41 2008 UTC (4 years, 9 months ago) by neronus-guest
Original Path: udd/src/udd/upload_history_gatherer.py
File length: 2971 byte(s)
Diff to previous 1087 , to selected 1531

fixed foreign keys

---

Revision 1087 - (view) (download) (as text) (annotate) - [select for diffs]
Modified Tue Aug 12 16:38:58 2008 UTC (4 years, 9 months ago) by neronus-guest
Original Path: udd/src/udd/upload_history_gatherer.py
File length: 2971 byte(s)
Diff to previous 1086 , to selected 1531

Locking is implemented
upload_histories has now an extra cloeses table

---

Revision 1086 - (view) (download) (as text) (annotate) - [select for diffs]
Modified Tue Aug 12 15:13:01 2008 UTC (4 years, 9 months ago) by neronus-guest
Original Path: udd/src/udd/upload_history_gatherer.py
File length: 2543 byte(s)
Diff to previous 1075 , to selected 1531

web/*: Fixed web scripts
TODO: rt_affects_* tristate: won't do
      PREPARE/EXECUTE for bugs: done
      access information on wiki: done
      two new TODOs
orpahend_packages: fixed typo
upload_history: added two new fields

---

Revision 1075 - (view) (download) (as text) (annotate) - [select for diffs]
Modified Mon Aug 11 17:10:30 2008 UTC (4 years, 9 months ago) by neronus-guest
Original Path: udd/src/udd/upload_history_gatherer.py
File length: 1933 byte(s)
Diff to previous 1068 , to selected 1531

Added summary table to packages schema
modified bugs schema to use summary table from packages
use db api qupting for upload history, too

---

Revision 1068 - (view) (download) (as text) (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/upload_history_gatherer.py
File length: 1934 byte(s)
Diff to previous 1037 , to selected 1531

Decentralized setup and drop scheme
bugs_gatherer.pl now has prepared SQL statements
for archived bugs, affects_* is now false

---

Revision 1037 - (view) (download) (as text) (annotate) - [select for diffs]
Modified Sat Aug 9 16:32:42 2008 UTC (4 years, 9 months ago) by neronus-guest
Original Path: udd/src/udd/upload_history_gatherer.py
File length: 1977 byte(s)
Diff to previous 1036 , to selected 1531

Configuration checking is a little less ugly now

---

Revision 1036 - (view) (download) (as text) (annotate) - [select for diffs]
Modified Sat Aug 9 16:23:35 2008 UTC (4 years, 9 months ago) by neronus-guest
Original Path: udd/src/udd/upload_history_gatherer.py
File length: 1977 byte(s)
Diff to previous 943 , to selected 1531

Use tierators to read lines from files instead of reading the whole file at once

---

Revision 943 - (view) (download) (as text) (annotate) - [select for diffs]
Modified Sun Jul 27 11:57:57 2008 UTC (4 years, 9 months ago) by neronus-guest
Original Path: udd/src/udd/upload_history_gatherer.py
File length: 1984 byte(s)
Diff to previous 939 , to selected 1531

Script doesn't exit now, but returns to dispatcher

---

Revision 939 - (view) (download) (as text) (annotate) - [select for diffs]
Added Sat Jul 26 19:21:15 2008 UTC (4 years, 9 months ago) by neronus-guest
Original Path: udd/src/udd/upload_history_gatherer.py
File length: 2001 byte(s)
Diff to selected 1531

Added code to import upload history
Removed print from bugs gatherer