yaqlite(1)
==========

NAME
----
yaqlite - YAML interface for SQLite

SYNOPSIS
--------
'yaqlite' [--help] [--version] <command> [<args>]

DESCRIPTION
-----------
A bridge between YAML and SQLite. Enables inserting YAML records into a
database and selecting records as YAML.

OPTIONS
-------
-h, --help::
	Print usage help.

-V, --version::
	Print the program version.

COMMANDS
--------
*insert*::
	Insert a record from YAML.

*select*::
	Select a record as YAML.

INSERT COMMAND
--------------

Insert Synopsis
~~~~~~~~~~~~~~~
'yaqlite insert' [<options>] <table-name> [<input-file>]

Insert Description
~~~~~~~~~~~~~~~~~~
Insert a YAML-formatted record into <table-name>. The YAML is read from
<input-file> if specified. If <input-file> is "-" or empty, YAML is read from
standard input.

Insert Options
~~~~~~~~~~~~~~
--database::
	The database to insert into.

SELECT COMMAND
--------------

Select Synopsis
~~~~~~~~~~~~~~~
'yaqlite select' [<options>] <table-name> <record-id>

Select Description
~~~~~~~~~~~~~~~~~~
Select a record by <record-id> from <table-name>. The record will output in
YAML format to standard output.

Select Options
~~~~~~~~~~~~~~
--database::
	The database to select from.

--exclude-column::
	Exclude the given column from the YAML output. This option can be given
	multiple times to exclude several columns.

--include-primary-key::
	Include the primary key field in the YAML output. By default, the primary
	key is excluded.

--primary_key::
	Name of the column to that matches <record-id>. Defaults to the table's
	primary key.