deno_sqlite_schema

This is a deno module to extract sqlite’s schema info.

USAGE

import { extract } from "https://deno.land/x/sqlite_schema/mod.ts";

const schema = extract(`
CREATE TABLE IF NOT EXISTS issue (
  id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
  title TEXT NOT NULL,
  description TEXT,
  createdAt TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP
);

CREATE INDEX IF NOT EXISTS issue_createdAt ON issue(createdAt);

CREATE VIEW IF NOT EXISTS describedIssue
AS
  SELECT id, description AS text
  FROM issue
  WHERE description IS NOT NULL
`);
console.log(JSON.stringify(schema, null, 2));

{
  "tables": [
    {
      "name": "issue",
      "columns": [
        {
          "name": "id",
          "typeName": "INTEGER",
          "typeAffinity": "INTEGER",
          "isPrimaryKey": true,
          "isNullable": false,
          "isAutoIncrement": true
        },
        {
          "name": "title",
          "typeName": "TEXT",
          "typeAffinity": "TEXT",
          "isPrimaryKey": false,
          "isNullable": false,
          "isAutoIncrement": false
        },
        {
          "name": "description",
          "typeName": "TEXT",
          "typeAffinity": "TEXT",
          "isPrimaryKey": false,
          "isNullable": true,
          "isAutoIncrement": false
        },
        {
          "name": "createdAt",
          "typeName": "TEXT",
          "typeAffinity": "TEXT",
          "isPrimaryKey": false,
          "isNullable": false,
          "isAutoIncrement": false,
          "defaultExpression": "CURRENT_TIMESTAMP"
        }
      ],
      "indexes": [
        {
          "name": "issue_createdAt",
          "isUnique": false,
          "isPartial": false,
          "columns": [
            {
              "name": "createdAt",
              "isDescending": false,
              "collation": "BINARY"
            }
          ]
        }
      ],
      "isStrict": false,
      "withoutRowId": false
    }
  ],
  "views": [
    {
      "name": "describedIssue",
      "columns": [
        {
          "name": "id",
          "originalName": "id",
          "tableName": "issue"
        },
        {
          "name": "text",
          "originalName": "description",
          "tableName": "issue"
        }
      ]
    }
  ]
}