http/db_routes.ts

API route specs for database administration.
Generic PostgreSQL table browser using information_schema.
Provides: list tables, view columns/rows (paginated), delete rows by PK, health check.

Declarations
#

8 declarations

view source

ColumnInfo
#

http/db_routes.ts view source

ColumnInfo

Column metadata from information_schema.

`column_name`

type string

`data_type`

type string

`is_nullable`

type string

create_db_route_specs
#

http/db_routes.ts view source

(options: DbRouteOptions): RouteSpec[]

Create the db API route specs.

`options`

type DbRouteOptions

returns

RouteSpec[]

DB_TABLE_ROWS_DEFAULT_LIMIT
#

http/db_routes.ts view source

100

Default page size for GET /tables/:name rows.

DB_TABLE_ROWS_LIMIT_MAX
#

http/db_routes.ts view source

1000

Maximum page size for GET /tables/:name rows.

DbRouteOptions
#

http/db_routes.ts view source

DbRouteOptions

Per-factory configuration for db routes.

`db_type`

type DbType

`db_name`

type string

`extra_stats`

Optional callback to provide app-specific stats in the health response.

type (db: Db) => Promise<Record<string, unknown>>

`log`

Optional logger for server-side diagnostics (e.g. FK violation details).

type Logger

PrimaryKeyInfo
#

http/db_routes.ts view source

PrimaryKeyInfo

Primary key constraint info.

`column_name`

type string

TableInfo
#

http/db_routes.ts view source

TableInfo

Table metadata from information_schema.

`table_name`

type string

TableWithCount
#

http/db_routes.ts view source

TableWithCount

Table info with row count.

`name`

type string

`row_count`

type number