1*6b3a42afSjmmv.\" Copyright 2012 Google Inc. 2*6b3a42afSjmmv.\" All rights reserved. 3*6b3a42afSjmmv.\" 4*6b3a42afSjmmv.\" Redistribution and use in source and binary forms, with or without 5*6b3a42afSjmmv.\" modification, are permitted provided that the following conditions are 6*6b3a42afSjmmv.\" met: 7*6b3a42afSjmmv.\" 8*6b3a42afSjmmv.\" * Redistributions of source code must retain the above copyright 9*6b3a42afSjmmv.\" notice, this list of conditions and the following disclaimer. 10*6b3a42afSjmmv.\" * Redistributions in binary form must reproduce the above copyright 11*6b3a42afSjmmv.\" notice, this list of conditions and the following disclaimer in the 12*6b3a42afSjmmv.\" documentation and/or other materials provided with the distribution. 13*6b3a42afSjmmv.\" * Neither the name of Google Inc. nor the names of its contributors 14*6b3a42afSjmmv.\" may be used to endorse or promote products derived from this software 15*6b3a42afSjmmv.\" without specific prior written permission. 16*6b3a42afSjmmv.\" 17*6b3a42afSjmmv.\" THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS 18*6b3a42afSjmmv.\" "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT 19*6b3a42afSjmmv.\" LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR 20*6b3a42afSjmmv.\" A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT 21*6b3a42afSjmmv.\" OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, 22*6b3a42afSjmmv.\" SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT 23*6b3a42afSjmmv.\" LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, 24*6b3a42afSjmmv.\" DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY 25*6b3a42afSjmmv.\" THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT 26*6b3a42afSjmmv.\" (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE 27*6b3a42afSjmmv.\" OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. 28*6b3a42afSjmmv.Dd September 9, 2012 29*6b3a42afSjmmv.Dt KYUA-DB-EXEC 1 30*6b3a42afSjmmv.Os 31*6b3a42afSjmmv.Sh NAME 32*6b3a42afSjmmv.Nm db-exec 33*6b3a42afSjmmv.Nd Executes a SQL statement in the store database 34*6b3a42afSjmmv.Sh SYNOPSIS 35*6b3a42afSjmmv.Nm 36*6b3a42afSjmmv.Op Fl -no-headers 37*6b3a42afSjmmv.Op Fl -store Ar file 38*6b3a42afSjmmv.Ar statement 39*6b3a42afSjmmv.Sh DESCRIPTION 40*6b3a42afSjmmvThe 41*6b3a42afSjmmv.Nm 42*6b3a42afSjmmvcommand provides a way to execute an arbitrary SQL statement within the 43*6b3a42afSjmmvdatabase. This command is mostly intended to aid in debugging, but can 44*6b3a42afSjmmvalso be used to extract information from the database when the current 45*6b3a42afSjmmvinterfaces do not provide the desired functionality. 46*6b3a42afSjmmv.Pp 47*6b3a42afSjmmvThe 48*6b3a42afSjmmv.Nm 49*6b3a42afSjmmvcommand takes one or more arguments, all of which are concatenated to form 50*6b3a42afSjmmva single SQL statement. Once the staement is executed, 51*6b3a42afSjmmv.Nm 52*6b3a42afSjmmvprints the resulting table on the screen, if any. 53*6b3a42afSjmmv.Pp 54*6b3a42afSjmmvThe following subcommand options are recognized: 55*6b3a42afSjmmv.Bl -tag -width XX 56*6b3a42afSjmmv.It Fl -no-headers 57*6b3a42afSjmmvAvoids printing the headers of the table in the output of the command. 58*6b3a42afSjmmv.It Fl -store Ar path , Fl s Ar path 59*6b3a42afSjmmvSpecifies the database to use. Defaults to 60*6b3a42afSjmmv.Pa ~/.kyua/store.db . 61*6b3a42afSjmmvThe database is created if it does not exist. 62*6b3a42afSjmmv.El 63*6b3a42afSjmmv.Sh EXIT STATUS 64*6b3a42afSjmmvThe 65*6b3a42afSjmmv.Nm 66*6b3a42afSjmmvcommand returns 0 on success or 1 if the SQL statement is invalid or fails 67*6b3a42afSjmmvto run. 68*6b3a42afSjmmv.Pp 69*6b3a42afSjmmvAdditional exit codes may be returned as described in 70*6b3a42afSjmmv.Xr kyua 1 . 71*6b3a42afSjmmv.Sh SEE ALSO 72*6b3a42afSjmmv.Xr kyua 1 , 73*6b3a42afSjmmv.Xr kyua-test 1 74