bif-sql - run an SQL command against the database
bif sql [STATEMENT...] [OPTIONS...]
bif sql command runs an SQL statement directly against the database of the current bif repository.
bif sql "select id,message from changes"
STATEMENT is not given on the command line it will be read from stdin. If the statement begins with "select", "pragma" or "explain" the results of the statement will be fetched and displayed. Otherwise the return value of the statement (DBI "do" method) will be printed.
By default a read-only handle for the database is used. Note that "pragma" statements would therefore require the
--write flag to succeed, even if they are only returning data.
diagfunction. Useful for debugging database state when running tests.
Mark Lawrence <email@example.com>
Copyright 2013-2017 Mark Lawrence <firstname.lastname@example.org>
This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 3 of the License, or (at your option) any later version.