Re: [UDD] Any reason to drop view all_sources?

[Davide Prina <Davide.Prina@null.net>]

Lucas Nussbaum wrote:

> I removed that view because...
> ,,,it was a bit painful to update when the sources
> schema changed.
> 
> It was defined as the equivalent of:
> SELECT * FROM sources -- that's Debian's source packages
> UNION SELECT * FROM ubuntu_sources -- that's Ubuntu's
> UNION SELECT * FROM derivatives_sources;

if all these tables have "sources" as final part of their names and there
are not any other tables with this feature, then probably you can make a
dynamic query and execute it on runtime.

open a cursor on

select "select * from " || table_name
from $TableCatalog
where table_name like "%sources"

take each result and add " union all " at the end it this is not the last

execute immediate (or similar command) for executing the query in the
string you have created.

Ciao
Davide

--
La mia privacy non è affar tuo
https://noyb.eu/it
- You do not have my permission to use this email to train an AI -
If you use this to train your AI than you accept to distribute under AGPL
license >= 3.0 all the model trained, all the source you have used to
training your model and all the source of the program that use that model