Patch? UDD wnpp table has source=NULL for multiple-source bugs
наб <[email protected]>
| Newsgroups | gmane.linux.debian.devel.quality-assurance |
|---|---|
| Message-ID | <zrvmmbinnmz4lfadkx3h4sirep3lmt3v67imuzmrxecsikrsge@tarta.nabijaczleweli.xyz> |
On Sat, Nov 23, 2024 at 05:53:45PM +0100, наб wrote: > On Sat, Nov 23, 2024 at 05:34:42PM +0100, наб wrote: > > Here's what select * from wnpp where source is null; gives me rn: > > id | type | source | title > > ---------+------+--------+---------------------------------------------------------------------------------------------------------------- > > 1083234 | RFH | | RFH: libpgjava libscram-java libstringprep-java -- Java database (JDBC) driver for PostgreSQL and dependencies > > > > The first few bugs are obviously wrong > > (other services don't understand them either), > This is not true for #1083234. > Both DDPO and tracker.d.o understand that this is a multi-source-package RFH > and tag each of libpgjava libscram-java libstringprep-java RFH. > > So UDD should parse this as > 1083234 | RFH | libpgjava | RFH: libpgjava libscram-java libstringprep-java -- Java database (JDBC) driver for PostgreSQL and dependencies > 1083234 | RFH | libscram-java | RFH: libpgjava libscram-java libstringprep-java -- Java database (JDBC) driver for PostgreSQL and dependencies > 1083234 | RFH | libstringprep-java | RFH: libpgjava libscram-java libstringprep-java -- Java database (JDBC) driver for PostgreSQL and dependencies > > And now that I look at it again, this is a postgres view. > So idk if this is possible. But then I'm far from a postgres expert. It is: select type, id, unnest(string_to_array(trim(split_part(split_part(title, '--', 1), ':', 2)), ' ')) as source, title from ( ... current wnpp query ... ) wnpp; does this (trimmed diff for bugs I already fixed, full attached): --- /dev/fd/63 2024-11-23 18:54:45.727787265 +0100 +++ /dev/fd/62 2024-11-23 18:54:45.727787265 +0100 @@ -1784 +1785,3 @@ - 1083234 | RFH | | RFH: libpgjava libscram-java libstringprep-java -- Java database (JDBC) driver for PostgreSQL and dependencies + 1083234 | RFH | libpgjava | RFH: libpgjava libscram-java libstringprep-java -- Java database (JDBC) driver for PostgreSQL and dependencies + 1083234 | RFH | libscram-java | RFH: libpgjava libscram-java libstringprep-java -- Java database (JDBC) driver for PostgreSQL and dependencies + 1083234 | RFH | libstringprep-java | RFH: libpgjava libscram-java libstringprep-java -- Java database (JDBC) driver for PostgreSQL and dependencies Is this reasonable to include in the view schema? Best,
diff
(text/plain, 2 KB)
--- /dev/fd/63 2024-11-23 18:54:45.727787265 +0100 +++ /dev/fd/62 2024-11-23 18:54:45.727787265 +0100 @@ -832 +832,2 @@ - 1037180 | RFP | | RFP: fidus Writer -- online collaborative editor for academics + 1037180 | RFP | fidus | RFP: fidus Writer -- online collaborative editor for academics + 1037180 | RFP | Writer | RFP: fidus Writer -- online collaborative editor for academics @@ -1488,2 +1489,2 @@ - 1072197 | O | | O: bglibs-- This package contains a collection of libraries - 1072199 | O | | O: compton-- compositor for X11, based on xcompmgr + 1072197 | O | bglibs | O: bglibs-- This package contains a collection of libraries + 1072199 | O | compton | O: compton-- compositor for X11, based on xcompmgr @@ -1502 +1503 @@ - 1072818 | ITP | | ITP: hatch -- Modern, extensible Python project + 1072818 | ITP | hatch | ITP: hatch -- Modern, extensible Python project @@ -1535 +1536 @@ - 1074465 | RFP | | RFP: nvidia-fabricmanager + 1074465 | RFP | nvidia-fabricmanager | RFP: nvidia-fabricmanager @@ -1784 +1785,3 @@ - 1083234 | RFH | | RFH: libpgjava libscram-java libstringprep-java -- Java database (JDBC) driver for PostgreSQL and dependencies + 1083234 | RFH | libpgjava | RFH: libpgjava libscram-java libstringprep-java -- Java database (JDBC) driver for PostgreSQL and dependencies + 1083234 | RFH | libscram-java | RFH: libpgjava libscram-java libstringprep-java -- Java database (JDBC) driver for PostgreSQL and dependencies + 1083234 | RFH | libstringprep-java | RFH: libpgjava libscram-java libstringprep-java -- Java database (JDBC) driver for PostgreSQL and dependencies @@ -1977 +1979,0 @@ - 1087620 | | | Powerful CLI for creating and managing PrivateBin pastes with ease @@ -2899 +2900,0 @@ -(7284 rows) @@ -2906,0 +2908 @@ +(7287 rows) @@ -6702 +6704,2 @@ - 973700 | RFP | | RFP: nodejs-client (?) -- a client for browser's extensions + 973700 | RFP | nodejs-client | RFP: nodejs-client (?) -- a client for browser's extensions + 973700 | RFP | (?) | RFP: nodejs-client (?) -- a client for browser's extensions
signature.asc
(application/pgp-signature, 833 B)
-----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEfWlHToQCjFzAxEFjvP0LAY0mWPEFAmdCF1EACgkQvP0LAY0m WPGR3A//VOGTwsoX753LGye2mYLbBjMNeKHTpbYkY7631HicOt2YNOufD0JTERyz OgPqYTzUXJdhFMz76Mqnh87nkiJYRv+/PGSSTPmW7dgVAJWYHmDrS04Q+iy73QN4 8Y88wVe6UMd149qbRz20S281Ml6mDQFbERWakoWL8lI/ImjG/Pc+bi6ZbjuUP87C qe44D94XqWoIT2bWVir5guX1TE39fVADNyotOW/GHvthLpkcwqiagXWl/2MzCXY5 shpsBYb3rik1dXJfomS06OTNp2rGw7zG3lYAMgUtXTro0imq68frzrjVT8jRY77P EXSA4U0AM6B0vvRvRqxnuiOBgSAMuxnAsO94nj7Ri+BdyX/3bTXYdPvYnB9BXD9U EbNiY1D4yHnx55fKPMKAdK4J4c8XoCoU1R/ZJJwCPuF2RCGwp3QluvrcScT4KFhI Y8BcfPfmgdrzamsoclpcy3Gr93nrlSEs6Fw5EW7oZw06OEqHuc2EA0BK6wap0hXI 8KM+wyFEj9v1MpWPAYBCTAOn6UZS1PsDnML1OZ480xbdt8HxgZMC3NE4xhGFzKHk t6Qzaxqk0HKCKrk/CTDzsO0Sm6M544m2PP2lC+2QfSYlEpf2rwc11FKFJHkjWHvw LnDA1DQkdAjaUO6OpC36VxXmGkY3cfTiByUUW1ntjkfJE7X1xY0= =ioIJ -----END PGP SIGNATURE-----