From owner-freebsd-pkg@freebsd.org  Tue Aug 18 23:58:19 2015
Return-Path: <owner-freebsd-pkg@freebsd.org>
Delivered-To: freebsd-pkg@mailman.ysv.freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org
 [IPv6:2001:1900:2254:206a::19:1])
 by mailman.ysv.freebsd.org (Postfix) with ESMTP id 95CB49BC275
 for <freebsd-pkg@mailman.ysv.freebsd.org>;
 Tue, 18 Aug 2015 23:58:19 +0000 (UTC)
 (envelope-from marquis@roble.com)
Received: from mx5.roble.com (mx5.roble.com [206.40.34.5])
 (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits))
 (Client CN "mx5.roble.com", Issuer "mx5.roble.com" (not verified))
 by mx1.freebsd.org (Postfix) with ESMTPS id 899371BAE
 for <freebsd-pkg@freebsd.org>; Tue, 18 Aug 2015 23:58:19 +0000 (UTC)
 (envelope-from marquis@roble.com)
Received: from secure.postconf.com (mx5.roble.com [206.40.34.5])
 by mx5.roble.com (Postfix) with ESMTP id CDC6B6783C
 for <freebsd-pkg@freebsd.org>; Tue, 18 Aug 2015 16:58:18 -0700 (PDT)
Date: Tue, 18 Aug 2015 16:58:18 -0700
Subject: Manually adding packages to local.sqlite
From: "Roger Marquis" <marquis@roble.com>
To: freebsd-pkg@freebsd.org
Reply-To: marquis@roble.com
MIME-Version: 1.0
Content-Type: text/plain;charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Priority: 3 (Normal)
Importance: Normal
X-BeenThere: freebsd-pkg@freebsd.org
X-Mailman-Version: 2.1.20
Precedence: list
List-Id: Binary package management and package tools discussion
 <freebsd-pkg.freebsd.org>
List-Unsubscribe: <https://lists.freebsd.org/mailman/options/freebsd-pkg>,
 <mailto:freebsd-pkg-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-pkg/>
List-Post: <mailto:freebsd-pkg@freebsd.org>
List-Help: <mailto:freebsd-pkg-request@freebsd.org?subject=help>
List-Subscribe: <https://lists.freebsd.org/mailman/listinfo/freebsd-pkg>,
 <mailto:freebsd-pkg-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Tue, 18 Aug 2015 23:58:19 -0000

I need to run a sort of ad hoc 'pkg audit' for various scenarios without
actually installing packages (some of which are no longer available).
Has anyone done this and, if so, how?  Did you populate local.sqlite's packages
table manually?  What did the sql command look like?

Is there a better way to do this?

Roger