SQLPageNotebook - AHC HRSN Screening documentation

class SQLPageNotebook

import { SQLPageNotebook } from ".";

Encapsulates SQLPage content. SqlPageNotebook has methods with the name of each SQLPage content that we want in the database. The SQLPageNotebook.create method "reads" the cells in SqlPageNotebook (each method's result) and generates SQL to insert the content of the page in the database in the format and table expected by SQLPage sqlpage_files table.

See: https://github.com/lovasoa/SQLpage/tree/main#hosting-sql-files-directly-inside-the-database

If you want to store customizations (e.g. handlebar templates, etc.) see:

If you want to create JSON APIs: https://sql.ophir.dev/documentation.sql?component=json#component

If you want to execute commands (assuming appropriate security) in SQLPage: https://sql.ophir.dev/functions.sql?function=exec#function

NOTE: we break our PascalCase convention for the name of the class since SQLPage is a proper noun (product name).

Constructors

new


        SQLPageNotebook(govn: ddbo.DuckDbOrchGovernance, registerCTS: (...cc: sp.CustomTemplateSupplier<ddbo.DuckDbOrchEmitContext, Any, Any, Any>[]) => void)

Properties

readonly


        comps

readonly


        customCB

readonly


        imsTables: ReturnType<this.sc.components.infoModelSchemaTables>

readonly


        sc: ReturnType<sp.sqliteContent>

readonly


        sessionEntries: ReturnType<sessionEntries>

Methods


        1115-waiver-screenings.sql()


        assetPagePath(path: string, sessionID?: string)


        index.sql()


        issues.sql()


        schema.sql()


        scripts/shell.js()


        session-diagnostics.sql()


        sessions.sql()


        shell()


        shellStatic()

Static Methods


        create(govn: ddbo.DuckDbOrchGovernance)