Coverage for dak/dakdb/update93.py: 100%

1"""

2update world.files-1 view to handle backports archive on ftp-master

4@contact: Debian FTP Master <ftpmaster@debian.org>

5@copyright: 2012 Ansgar Burchardt <ansgar@debian.org>

6@license: GNU General Public License version 2 or later

7"""

9# This program is free software; you can redistribute it and/or modify

10# it under the terms of the GNU General Public License as published by

11# the Free Software Foundation; either version 2 of the License, or

12# (at your option) any later version.

14# This program is distributed in the hope that it will be useful,

15# but WITHOUT ANY WARRANTY; without even the implied warranty of

16# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

17# GNU General Public License for more details.

19# You should have received a copy of the GNU General Public License

20# along with this program; if not, write to the Free Software

21# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA

23################################################################################

25statements = [

26 """

27 CREATE OR REPLACE VIEW world."files-1" AS

28 SELECT

29 files.id AS id,

30 component.name || '/' || files.filename AS filename,

31 files.size AS size,

32 files.md5sum AS md5sum,

33 files.sha1sum AS sha1sum,

34 files.sha256sum AS sha256sum,

35 files.last_used AS last_used,

36 files.created AS created,

37 files.modified AS modified

38 FROM files

39 JOIN files_archive_map fam ON files.id = fam.file_id

40 JOIN component ON fam.component_id = component.id

41 WHERE fam.archive_id = (SELECT id FROM archive WHERE name IN ('backports', 'ftp-master', 'security') ORDER BY id LIMIT 1)

42 """,