On Friday October 28 2016 21:34:32 Vincent Habchi wrote:
Hi,
>> sqlite> WITH i AS (SELECT id FROM files WHERE path LIKE exp GROUP BY id)
>> SELECT name FROM ports, i WHERE ports.id = i.id;
This works great, and as expected *much* faster than any other method one could
think of currently. Ideal
On Friday October 28 2016 21:22:41 Clemens Lang wrote:
Hi,
> Isn't this essentially what 'port provides' does?
Only if you already know the full path to the file, and if you're only
interested in the active port.
What I have in mind is two-fold:
- an alternative to spotlight's `mdfind -name`
> if ‘exp’ is the expression you’re looking for (e.g. ‘%qt4%’ for all files
> containing …qt4…)
>
> sqlite> WITH i AS (SELECT id FROM files WHERE path LIKE exp GROUP BY id)
> SELECT name FROM ports, i WHERE ports.id = i.id;
>
> Assuming you want the name of the ports which provides the files yo
sqlite3 register.db
if ‘exp’ is the expression you’re looking for (e.g. ‘%qt4%’ for all files
containing …qt4…)
sqlite> WITH i AS (SELECT id FROM files WHERE path LIKE exp GROUP BY id) SELECT
name FROM ports, i WHERE ports.id = i.id;
Assuming you want the name of the ports which provides the f
"port provides" actually does some extra work to normalize paths before
querying; I believe René is looking for the underlying database, and
possibly its constraints (e.g. whether it includes inactives --- which I
don't think it does).
On Fri, Oct 28, 2016 at 3:20 PM, Ken Cunningham <
ken.cunningh
On Fri, Oct 28, 2016 at 08:41:58PM +0200, René J.V. Bertin wrote:
> I think the registry keeps track of all installed files, whether they
> belong to active or inactive ports, right?
> If so, is there a way to query the registry with a filename pattern,
> to obtain the full paths of known matching
Rene, do you mean
port provides /path/to/file
or something fancier?
Ken
> On Oct 28, 2016, at 11:41 AM, René J.V. Bertin wrote:
>
> Hi,
>
> I think the registry keeps track of all installed files, whether they belong
> to active or inactive ports, right?
> If so, is there a way to query
Hi,
I think the registry keeps track of all installed files, whether they belong to
active or inactive ports, right?
If so, is there a way to query the registry with a filename pattern, to obtain
the full paths of known matching filesand the port(s) which provide them?
Thanks,
René