wagoe.platform.shell.adapters.database.postgresql.utils — com.wagoe/wagoe-platform 1.0.0-beta-5

PostgreSQL utility functions and DDL helpers.

active-connections clj

(active-connections datasource)

Get information about active PostgreSQL connections.

analyze-table clj

(analyze-table datasource)

(analyze-table datasource table-name)

Update PostgreSQL table statistics for better query planning.

bigserial-primary-key clj

(bigserial-primary-key)

Get PostgreSQL bigserial primary key definition.

boolean-column-type clj

(boolean-column-type)

Get PostgreSQL boolean column type definition.

connection-info clj

(connection-info datasource)

Get PostgreSQL connection and server information.

create-database-url clj

(create-database-url host port database & [options])

Create PostgreSQL JDBC URL from components.

Args: host: Database hostname port: Database port database: Database name options: Optional map of connection parameters

Returns: JDBC URL string

enable-extension clj

(enable-extension datasource extension-name)

Enable PostgreSQL extension.

explain-query clj

(explain-query datasource query-map)

(explain-query datasource query-map options)

Get PostgreSQL query execution plan.

list-extensions clj

(list-extensions datasource)

List installed PostgreSQL extensions.

serial-primary-key clj

(serial-primary-key)

Get PostgreSQL serial primary key definition.

timestamp-column-type clj

(timestamp-column-type)

Get PostgreSQL timestamp column type definition.

uuid-column-type clj

(uuid-column-type)

Get PostgreSQL UUID column type definition.

vacuum-table clj

(vacuum-table datasource table-name)

(vacuum-table datasource table-name options)

Vacuum PostgreSQL table to reclaim space and update statistics.

varchar-uuid-column-type clj

(varchar-uuid-column-type)

Get PostgreSQL varchar UUID column type definition for compatibility.