Damaged database?

[Rainer Müller]

On 2013-02-23 20:23, Bradley Giesbrecht wrote:
>> What happens if you query the sqlite registry db directly?
>>
>> $ sqlite3 /opt/local/var/macports/registry/registry.db .schema
>> $ sqlite3 /opt/local/var/macports/registry/registry.db "select load_extension('/opt/local/share/macports/sqlite/macports.sqlext');select t1.id, t1.name from ports t1 where t1.name = 'gst-plugins-base'"
>> $ sqlite3 /opt/local/var/macports/registry/registry.db "select load_extension('/opt/local/share/macports/sqlite/macports.sqlext');select t1.id, t1.name, group_concat(distinct t2.name) as "deps", group_concat(distinct t3.path) as "files" from ports t1 join dependencies t2 on t1.id = t2.id join files t3 on t1.id = t3.id where t1.name = 'gst-plugins-base';"

The macports.sqlext is not installed on a normal end-user installation.
However, it can be built easily from the source code:

  $ svn co
https://svn.macports.org/repository/macports/tags/release_2_1_3/base/src/cregistry/
  $ cd cregistry
  $ make macports.sqlext

Rainer