4 Generate changelog entry between two suites
6 @contact: Debian FTP Master <ftpmaster@debian.org>
7 @copyright: 2010 Luca Falavigna <dktrkranz@debian.org>
8 @license: GNU General Public License version 2 or later
11 # This program is free software; you can redistribute it and/or modify
12 # it under the terms of the GNU General Public License as published by
13 # the Free Software Foundation; either version 2 of the License, or
14 # (at your option) any later version.
16 # This program is distributed in the hope that it will be useful,
17 # but WITHOUT ANY WARRANTY; without even the implied warranty of
18 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
19 # GNU General Public License for more details.
21 # You should have received a copy of the GNU General Public License
22 # along with this program; if not, write to the Free Software
23 # Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
25 ################################################################################
27 # <bdefreese> !dinstall
28 # <dak> bdefreese: I guess the next dinstall will be in 0hr 1min 35sec
29 # <bdefreese> Wow I have great timing
30 # <DktrKranz> dating with dinstall, part II
32 # <Ganneff> dating with that monster? do you have good combat armor?
33 # <bdefreese> +5 Plate :)
34 # <Ganneff> not a good one then
35 # <Ganneff> so you wont even manage to bypass the lesser monster in front, unchecked
36 # <DktrKranz> asbesto belt
37 # <Ganneff> helps only a step
38 # <DktrKranz> the Ultimate Weapon: cron_turned_off
40 # <Ganneff> thats debadmin limited
41 # <Ganneff> no option for you
42 # <DktrKranz> bdefreese: it seems ftp-masters want dinstall to sexual harass us, are you good in running?
43 # <Ganneff> you can run but you can not hide
44 # <bdefreese> No, I'm old and fat :)
45 # <Ganneff> you can roll but you can not hide
48 # <DktrKranz> damn dinstall, you racist bastard
50 ################################################################################
54 from daklib.dbconn import *
55 from daklib import utils
57 ################################################################################
59 def usage (exit_code=0):
60 print """Usage: make-changelog -s <suite> -b <base_suite> [OPTION]...
61 Generate changelog between two suites
65 -h, --help show this help and exit
66 -s, --suite suite providing packages to compare
67 -b, --base-suite suite to be taken as reference for comparison
68 -n, --binnmu display binNMUs uploads instead of source ones"""
72 def get_source_uploads(suite, base_suite, session):
74 Returns changelogs for source uploads where version is newer than base.
77 query = """WITH base AS (
78 SELECT source, max(version) AS version
80 WHERE suite_name = :base_suite
82 UNION (SELECT source, CAST(0 AS debversion) AS version
84 WHERE suite_name = :suite
85 EXCEPT SELECT source, CAST(0 AS debversion) AS version
87 WHERE suite_name = :base_suite
90 SELECT source, max(version) AS version
92 WHERE suite_name = :suite
94 SELECT DISTINCT c.source, c.version, c.changelog
96 JOIN base b ON b.source = c.source
97 JOIN cur_suite cs ON cs.source = c.source
98 WHERE c.version > b.version
99 AND c.version <= cs.version
100 AND c.architecture LIKE '%source%'
101 ORDER BY c.source, c.version DESC"""
103 return session.execute(query, {'suite': suite, 'base_suite': base_suite})
105 def get_binary_uploads(suite, base_suite, session):
107 Returns changelogs for binary uploads where version is newer than base.
110 query = """WITH base as (
111 SELECT s.source, max(b.version) AS version, a.arch_string
113 JOIN binaries b ON b.source = s.id
114 JOIN bin_associations ba ON ba.bin = b.id
115 JOIN architecture a ON a.id = b.architecture
119 WHERE suite_name = :base_suite)
120 GROUP BY s.source, a.arch_string),
122 SELECT s.source, max(b.version) AS version, a.arch_string
124 JOIN binaries b ON b.source = s.id
125 JOIN bin_associations ba ON ba.bin = b.id
126 JOIN architecture a ON a.id = b.architecture
130 WHERE suite_name = :suite)
131 GROUP BY s.source, a.arch_string)
132 SELECT DISTINCT c.source, c.version, c.architecture, c.changelog
134 JOIN base b on b.source = c.source
135 JOIN cur_suite cs ON cs.source = c.source
136 WHERE c.version > b.version
137 AND c.version <= cs.version
138 AND c.architecture = b.arch_string
139 AND c.architecture = cs.arch_string
140 ORDER BY c.source, c.version DESC, c.architecture"""
142 return session.execute(query, {'suite': suite, 'base_suite': base_suite})
145 Cnf = utils.get_conf()
146 Arguments = [('h','help','Make-Changelog::Options::Help'),
147 ('s','suite','Make-Changelog::Options::Suite','HasArg'),
148 ('b','base-suite','Make-Changelog::Options::Base-Suite','HasArg'),
149 ('n','binnmu','Make-Changelog::Options::binNMU')]
151 for i in ['help', 'suite', 'base-suite', 'binnmu']:
152 if not Cnf.has_key('Make-Changelog::Options::%s' % (i)):
153 Cnf['Make-Changelog::Options::%s' % (i)] = ''
155 apt_pkg.ParseCommandLine(Cnf, Arguments, sys.argv)
156 Options = Cnf.SubTree('Make-Changelog::Options')
157 suite = Cnf['Make-Changelog::Options::Suite']
158 base_suite = Cnf['Make-Changelog::Options::Base-Suite']
159 binnmu = Cnf['Make-Changelog::Options::binNMU']
161 if Options['help'] or not (suite and base_suite):
164 for s in suite, base_suite:
166 utils.fubar('Invalid suite "%s"' % s)
168 session = DBConn().session()
171 uploads = get_binary_uploads(suite, base_suite, session)
173 for upload in uploads:
174 print upload[3] + "\n"
176 uploads = get_source_uploads(suite, base_suite, session)
178 for upload in uploads:
179 print upload[2] + "\n"
181 if __name__ == '__main__':