← Back to branch summary

~launchpad-pqm/launchpad/devel

« back to all changes in this revision

Viewing changes to database/schema/patch-17-27-0.sql

  • Committer: Canonical.com Patch Queue Manager
  • Date: 2005-06-21 15:50:13 UTC
  • mfrom: (unknown (missing))
  • Revision ID: Arch-1:rocketfuel@canonical.com%launchpad--devel--0--patch-1902
Merge in publishing work from soyuz sprint. r=jamesh
Patches applied:

 * daniel.silverstone@canonical.com--desktop/launchpad--publishing--0--patch-29
   star-merge from rocketfuel@canonical.com/launchpad--devel--0

 * daniel.silverstone@canonical.com--desktop/launchpad--publishing--0--patch-30
   Merge from laptop publisher archive

 * daniel.silverstone@canonical.com--desktop/launchpad--publishing--0--patch-31
   Merge db blessing from Stuart

 * daniel.silverstone@canonical.com--desktop/launchpad--publishing--0--patch-32
   star-merge from rocketfuel@canonical.com/launchpad--devel--0

 * daniel.silverstone@canonical.com--desktop/launchpad--publishing--0--patch-33
   star-merge from rocketfuel@canonical.com/launchpad--devel--0

 * daniel.silverstone@canonical.com--desktop/launchpad--publishing--0--patch-34
   replay laptop branch changes in

 * daniel.silverstone@canonical.com--desktop/launchpad--publishing--0--patch-35
   star-merge from rocketfuel@canonical.com/launchpad--devel--0

 * daniel.silverstone@canonical.com--desktop/launchpad--publishing--0--patch-36
   Sync-tree with laptop branch

 * daniel.silverstone@canonical.com--desktop/launchpad--publishing--0--patch-37
   Unpublish death row

 * daniel.silverstone@canonical.com--desktop/launchpad--publishing--0--patch-38
   Final bits from jamesh's review

 * daniel.silverstone@canonical.com--desktop/launchpad--publishing--0--patch-39
   [trivial] Quick fix to the sampledata to match priorities

 * daniel.silverstone@canonical.com--desktop/launchpad--publishing--0--patch-40
   Disable dominator test because it is completely wrong

 * daniel.silverstone@canonical.com--desktop/launchpad--publishing--0--patch-41
   oops, disable the tests cleanly this time

 * daniel.silverstone@canonical.com--laptop/launchpad--publishing--0--patch-13
   Merge from rocketfuel@canonical.com/launchpad--devel--0

 * daniel.silverstone@canonical.com--laptop/launchpad--publishing--0--patch-14
   star-merge from rocketfuel@canonical.com/launchpad--devel--0

 * daniel.silverstone@canonical.com--laptop/launchpad--publishing--0--patch-15
   star-merge from rocketfuel@canonical.com/launchpad--devel--0

 * daniel.silverstone@canonical.com--laptop/launchpad--publishing--0--patch-16
   star-merge from rocketfuel@canonical.com/launchpad--devel--0

 * daniel.silverstone@canonical.com--laptop/launchpad--publishing--0--patch-17
   Dehumanise the archive publisher

 * daniel.silverstone@canonical.com--laptop/launchpad--publishing--0--patch-18
   Add the archtag info for the archive publisher

 * daniel.silverstone@canonical.com--laptop/launchpad--publishing--0--patch-19
   initial publishing implementation

 * daniel.silverstone@canonical.com--laptop/launchpad--publishing--0--patch-20
   star-merge from rocketfuel@canonical.com/launchpad--devel--0

 * daniel.silverstone@canonical.com--laptop/launchpad--publishing--0--patch-21
   star-merge from rocketfuel@canonical.com/launchpad--devel--0

 * daniel.silverstone@canonical.com--laptop/launchpad--publishing--0--patch-22
   Merge stuart's blessing

 * daniel.silverstone@canonical.com--laptop/launchpad--publishing--0--patch-23
   Review response for jamesh

 * daniel.silverstone@canonical.com--laptop/launchpad--publishing--0--patch-24
   Hopefully the last of the dominator fixes

 * daniel.silverstone@canonical.com--laptop/launchpad--publishing--0--patch-25
   dbschema.items is iterable sanely

 * daniel.silverstone@canonical.com--laptop/launchpad--publishing--0--patch-26
   Change patch-17-19 to patch-17-27 as per instructions from stub

 * stuart.bishop@canonical.com/launchpad-kinnison--4--base-0
   tag of daniel.silverstone@canonical.com--laptop/launchpad--publishing--0--patch-19

 * stuart.bishop@canonical.com/launchpad-kinnison--4--patch-1
   format patch, migrate to final home and add indexes

Show diffs side-by-side

added added

removed removed

Lines of Context:
database/schema/patch-17-27-0.sql
 
1
/* Add Pocket to views used by publisher */
 
2
 
 
3
SET client_min_messages=ERROR;
 
4
 
 
5
DROP VIEW binarypackagefilepublishing;
 
6
DROP VIEW sourcepackagefilepublishing;
 
7
 
 
8
CREATE VIEW binarypackagefilepublishing AS
 
9
    SELECT (((libraryfilealias.id)::text || '.'::text) || (packagepublishing.id)::text) AS id, distrorelease.distribution,
 
10
    packagepublishing.id AS packagepublishing,
 
11
    component.name AS componentname,
 
12
    libraryfilealias.filename AS libraryfilealiasfilename,
 
13
    sourcepackagename.name AS sourcepackagename,
 
14
    binarypackagefile.libraryfile AS libraryfilealias,
 
15
    distrorelease.name AS distroreleasename,
 
16
    distroarchrelease.architecturetag,
 
17
    packagepublishing.status AS publishingstatus,
 
18
    packagepublishing.pocket AS pocket
 
19
FROM 
 
20
    packagepublishing JOIN binarypackage
 
21
        ON packagepublishing.binarypackage = binarypackage.id
 
22
    JOIN build ON binarypackage.build = build.id
 
23
    JOIN sourcepackagerelease
 
24
        ON build.sourcepackagerelease = sourcepackagerelease.id
 
25
    JOIN sourcepackagename
 
26
        ON sourcepackagerelease.sourcepackagename = sourcepackagename.id
 
27
    JOIN binarypackagefile
 
28
        ON binarypackagefile.binarypackage = binarypackage.id
 
29
    JOIN libraryfilealias
 
30
        ON binarypackagefile.libraryfile = libraryfilealias.id
 
31
    JOIN distroarchrelease
 
32
        ON packagepublishing.distroarchrelease = distroarchrelease.id
 
33
    JOIN distrorelease
 
34
        ON distroarchrelease.distrorelease = distrorelease.id
 
35
    JOIN component ON packagepublishing.component = component.id;
 
36
 
 
37
CREATE INDEX binarypackagefile_libraryfile_idx
 
38
    ON BinaryPackageFile(libraryfile);
 
39
CREATE INDEX sourcepackagerelease_sourcepackagename_idx
 
40
    ON SourcePackageRelease(sourcepackagename);
 
41
CREATE INDEX binarypackagefile_binarypackage_idx
 
42
    ON BinaryPackageFile(binarypackage);
 
43
 
 
44
CREATE VIEW sourcepackagefilepublishing AS
 
45
    SELECT (((libraryfilealias.id)::text || '.'::text) || (sourcepackagepublishing.id)::text) AS id,
 
46
    distrorelease.distribution,
 
47
    sourcepackagepublishing.id AS sourcepackagepublishing,
 
48
    sourcepackagereleasefile.libraryfile AS libraryfilealias,
 
49
    libraryfilealias.filename AS libraryfilealiasfilename,
 
50
    sourcepackagename.name AS sourcepackagename,
 
51
    component.name AS componentname,
 
52
    distrorelease.name AS distroreleasename,
 
53
    sourcepackagepublishing.status AS publishingstatus,
 
54
    sourcepackagepublishing.pocket AS pocket
 
55
FROM 
 
56
    sourcepackagepublishing
 
57
    JOIN sourcepackagerelease ON 
 
58
        sourcepackagepublishing.sourcepackagerelease = sourcepackagerelease.id
 
59
    JOIN sourcepackagename
 
60
        ON sourcepackagerelease.sourcepackagename = sourcepackagename.id
 
61
    JOIN sourcepackagereleasefile
 
62
        ON sourcepackagereleasefile.sourcepackagerelease
 
63
        = sourcepackagerelease.id
 
64
    JOIN libraryfilealias
 
65
        ON libraryfilealias.id = sourcepackagereleasefile.libraryfile
 
66
    JOIN distrorelease
 
67
        ON sourcepackagepublishing.distrorelease = distrorelease.id
 
68
    JOIN component ON sourcepackagepublishing.component = component.id;
 
69
 
 
70
CREATE INDEX sourcepackagereleasefile_sourcepackagerelease_idx
 
71
    ON SourcePackageReleaseFile (SourcePackageRelease);
 
72
CREATE INDEX sourcepackagereleasefile_libraryfile_idx
 
73
    ON SourcePackageReleaseFile (libraryfile);
 
74
 
 
75
INSERT INTO LaunchpadDatabaseRevision VALUES (17, 27, 0);