--xdzptu2agsoupy5q
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable
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,
--xdzptu2agsoupy5q
Content-Type: text/plain; charset=us-ascii
Content-Disposition: attachment; filename=diff
Content-Transfer-Encoding: quoted-printable
--- /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
@