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,
--- /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
Description: PGP signature
