Merge lp:~cprov/launchpad/db-cve-2014 into lp:launchpad/db-devel

[Celso Providelo]

Update DB CVE sequence validator to cope with recent (2014) format changes.

[William Grant (wgrant)]

review: Approve (db)

=== added file 'database/schema/patch-2209-55-0.sql'
--- database/schema/patch-2209-55-0.sql	1970-01-01 00:00:00 +0000
+++ database/schema/patch-2209-55-0.sql	2014-03-03 23:43:27 +0000
@@ -0,0 +1,17 @@
+-- Copyright 2014 Canonical Ltd.  This software is licensed under the
+-- GNU Affero General Public License version 3 (see the file LICENSE).
+
+SET client_min_messages=ERROR;
+
+CREATE OR REPLACE FUNCTION valid_cve(text) RETURNS boolean
+    LANGUAGE plpythonu IMMUTABLE STRICT
+    AS $_$
+    import re
+    name = args[0]
+    pat = r"^(19|20)\d{2}-\d{4,}$"
+    if re.match(pat, name):
+        return 1
+    return 0
+$_$;
+
+INSERT INTO LaunchpadDatabaseRevision VALUES (2209, 55, 0);