GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Man Pages
SQLITE2HTML(1) FreeBSD General Commands Manual SQLITE2HTML(1)

sqlite2html
convert sqlite3 schema to an HTML5 fragment

sqlite2html [-v] [-p prefix] [schema]

The sqlite2html utility converts an sqlite3(1) schema file to an HTML5 fragment. Its options are as follows:
Causes the parser to emit informational messages on stderr.
prefix
Prefix to use for creating HTML ID tags.
schema
An SQLite schema file.

The outputted HTML5 fragment consists of a <dl class="tabs"> list consisting of tables; and then for each table, a <dl class="cols"> list of columns. The <dt> for each list entry consists of the name of the table or column and has its ID attribute set to the transformed name. The <dd> for each list begins with a <div class="comment"> if the table or column is preceeded by comments For columns with a foreign key reference, this will be preceeded by <div class="foreign"> containing an anchor to the key having a text node of the endpoint.

The @ character within a comment is special: the following table name and optional column name will be transformed into an HTML link to the identifier. Thus, @foo.bar will point to the “bar” column in table “foo”. If this identifier is not followed by white-space, you may quote the identifier to prevent subsequent characters from being pulled into the identifier, e.g., @"foo.bar". If you wish to print a standalone @, you may escape it with a backslash (“\”).

The [ character is similar, as it encloses general-purpose links in a manner similar to Markdown. Links are formatted as follows:

You can escape the [ character as well, to prevent this behaviour.

The following sequences are also special:

Print an formatted n-dash.
Print an formatted m-dash.
Print formatted left-double quotes.
Print formatted right-double quotes.

Any of these may be escaped with the backslash to have it print as-is. If you wish to print a backslash, you must escape it, for example, the \\-character---and an \@-sign.

Lastly, a blank (without any white-space but the newline!) one-line comment line is considered to be a paragraph break, for example:

-- Hello, world.
--
-- And after the break...
    

In multi-line comment, this can be affected with a blank line in the comment stream:

/*
 * Hello, world.
 *
 * That was another line break.
 */
    

sqlite2dot(1), sqlite3(1)

The schema language accepted by sqlite2html is currently limited to the table declaration with a subset of the column specification.
June 30, 2016 FreeBSD 13.1-RELEASE

Search for    or go to Top of page |  Section 1 |  Main Index

Powered by GSP Visit the GSP FreeBSD Man Page Interface.
Output converted with ManDoc.