LIGHTNING-LISTSQLSCHEMAS(7)

NAME

lightning-listsqlschemas -- Command to example lightning-sql schemas

SYNOPSIS

listsqlschemas [table]

DESCRIPTION

This allows you to examine the schemas at runtime; while they are fully documented for the current release in lightning-sql(7), as fields are added or deprecated, you can use this command to determine what fields are present.

If table is given, only that table is in the resulting list, otherwise all tables are listed.

EXAMPLE JSON REQUEST

    {
      "id": 82,
      "method": "listsqlschemas",
      "params": {
        "table": "offers"
      }
    }

EXAMPLE JSON RESPONSE

    {
       "schemas": [
          {
             "tablename": "offers",
             "columns": [
                {
                   "name": "offer_id",
                   "type": "BLOB"
                },
                {
                   "name": "active",
                   "type": "INTEGER"
                },
                {
                   "name": "single_use",
                   "type": "INTEGER"
                },
                {
                   "name": "bolt12",
                   "type": "TEXT"
                },
                {
                   "name": "bolt12_unsigned",
                   "type": "TEXT"
                },
                {
                   "name": "used",
                   "type": "INTEGER"
                },
                {
                   "name": "label",
                   "type": "TEXT"
                }
             ],
             "indices": [
                [
                   "offer_id"
                ]
             ]
          }
       ]
    }

RETURN VALUE

On success, an object containing schemas is returned. It is an array of objects, where each object contains:

•   tablename (string): the name of the table

•   columns (array of objects): the columns, in database order:

    •   name (string): the name of the column

    •   type (string): the SQL type of the column (one of "INTEGER", "BLOB", "TEXT", "REAL")

•   indices (array of arrays, optional): Any index we created to speed lookups:

    •   The columns for this index:

    •   The column name

AUTHOR

Rusty Russell <rusty@rustcorp.com.au> is mainly responsible.

SEE ALSO

lightning-sql(7).

RESOURCES

Main web site: https://github.com/ElementsProject/lightning