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