@pgpm/verify
Advanced tools
@@ -1,3 +0,2 @@ | ||
| import { getConnections, PgTestClient } from 'pgsql-test'; | ||
| import { snapshot } from 'graphile-test'; | ||
| import { getConnections, PgTestClient, snapshot } from 'pgsql-test'; | ||
@@ -4,0 +3,0 @@ let pg: PgTestClient; |
+1
-1
| The MIT License (MIT) | ||
| Copyright (c) 2025 Dan Lynch <pyramation@gmail.com> | ||
| Copyright (c) 2025 Interweb, Inc. | ||
| Copyright (c) 2025 Constructive | ||
@@ -6,0 +6,0 @@ Permission is hereby granted, free of charge, to any person obtaining a copy |
+8
-8
| { | ||
| "name": "@pgpm/verify", | ||
| "version": "0.13.0", | ||
| "description": "Verification utilities for LaunchQL deploy/verify/revert workflow", | ||
| "version": "0.14.0", | ||
| "description": "Verification utilities for PGPM deploy/verify/revert workflow", | ||
| "author": "Dan Lynch <pyramation@gmail.com>", | ||
| "contributors": [ | ||
| "Interweb <developers@interweb.co>" | ||
| "Constructive <developers@constructive.io>" | ||
| ], | ||
@@ -24,13 +24,13 @@ "keywords": [ | ||
| "devDependencies": { | ||
| "pgpm": "^0.2.0" | ||
| "pgpm": "^1.0.0" | ||
| }, | ||
| "repository": { | ||
| "type": "git", | ||
| "url": "https://github.com/launchql/pgpm-modules" | ||
| "url": "https://github.com/constructive-io/pgpm-modules" | ||
| }, | ||
| "homepage": "https://github.com/launchql/pgpm-modules", | ||
| "homepage": "https://github.com/constructive-io/pgpm-modules", | ||
| "bugs": { | ||
| "url": "https://github.com/launchql/pgpm-modules/issues" | ||
| "url": "https://github.com/constructive-io/pgpm-modules/issues" | ||
| }, | ||
| "gitHead": "e7de11be3a2fd806929adf48acc556d812c75aa6" | ||
| "gitHead": "7369638ab084da95b0cb00ec63ad236637f6ebe5" | ||
| } |
+18
-18
| # @pgpm/verify | ||
| <p align="center" width="100%"> | ||
| <img height="250" src="https://raw.githubusercontent.com/launchql/launchql/refs/heads/main/assets/outline-logo.svg" /> | ||
| <img height="250" src="https://raw.githubusercontent.com/constructive-io/constructive/refs/heads/main/assets/outline-logo.svg" /> | ||
| </p> | ||
| <p align="center" width="100%"> | ||
| <a href="https://github.com/launchql/pgpm-modules/actions/workflows/ci.yml"> | ||
| <img height="20" src="https://github.com/launchql/pgpm-modules/actions/workflows/ci.yml/badge.svg" /> | ||
| <a href="https://github.com/constructive-io/pgpm-modules/actions/workflows/ci.yml"> | ||
| <img height="20" src="https://github.com/constructive-io/pgpm-modules/actions/workflows/ci.yml/badge.svg" /> | ||
| </a> | ||
| <a href="https://github.com/launchql/pgpm-modules/blob/main/LICENSE"><img height="20" src="https://img.shields.io/badge/license-MIT-blue.svg"/></a> | ||
| <a href="https://www.npmjs.com/package/@pgpm/verify"><img height="20" src="https://img.shields.io/github/package-json/v/launchql/pgpm-modules?filename=packages%2Futils%2Fverify%2Fpackage.json"/></a> | ||
| <a href="https://github.com/constructive-io/pgpm-modules/blob/main/LICENSE"><img height="20" src="https://img.shields.io/badge/license-MIT-blue.svg"/></a> | ||
| <a href="https://www.npmjs.com/package/@pgpm/verify"><img height="20" src="https://img.shields.io/github/package-json/v/constructive-io/pgpm-modules?filename=packages%2Futils%2Fverify%2Fpackage.json"/></a> | ||
| </p> | ||
| Verification utilities for PostgreSQL extensions | ||
| Verification utilities for PostgreSQL modules | ||
| ## Overview | ||
| `@pgpm/verify` is the foundational verification package used by all LaunchQL extensions. It provides SQL functions to verify the existence and correctness of database objects during deployment, testing, and migrations. This package is essential for the deploy/verify/revert pattern, ensuring that database changes are applied correctly and can be validated programmatically. | ||
| `@pgpm/verify` is the foundational verification package used by all PGPM modules. It provides SQL functions to verify the existence and correctness of database objects during deployment, testing, and migrations. This package is essential for the deploy/verify/revert pattern, ensuring that database changes are applied correctly and can be validated programmatically. | ||
@@ -24,3 +24,3 @@ ## Features | ||
| - **Comprehensive Verification**: Verify tables, functions, schemas, indexes, triggers, views, domains, and roles | ||
| - **Universal Dependency**: Required by all 22 LaunchQL extension packages | ||
| - **Universal Dependency**: Required by all 22 pgpm packages | ||
| - **Deploy/Verify/Revert Pattern**: Core component of safe database migrations | ||
@@ -69,3 +69,3 @@ - **Testing Support**: Essential for integration and unit tests | ||
| # 1. Create a workspace | ||
| pgpm init --workspace | ||
| pgpm init workspace | ||
@@ -342,5 +342,5 @@ # 2. Create your first module | ||
| ### With All LaunchQL Extensions | ||
| ### With All pgpm modules | ||
| Every LaunchQL extension depends on `@pgpm/verify`: | ||
| Every pgpm module depends on `@pgpm/verify`: | ||
@@ -444,9 +444,9 @@ **package.json:** | ||
| * [pgpm](https://github.com/launchql/launchql/tree/main/packages/pgpm): **🖥️ PostgreSQL Package Manager** for modular Postgres development. Works with database workspaces, scaffolding, migrations, seeding, and installing database packages. | ||
| * [pgsql-test](https://github.com/launchql/launchql/tree/main/packages/pgsql-test): **📊 Isolated testing environments** with per-test transaction rollbacks—ideal for integration tests, complex migrations, and RLS simulation. | ||
| * [supabase-test](https://github.com/launchql/launchql/tree/main/packages/supabase-test): **🧪 Supabase-native test harness** preconfigured for the local Supabase stack—per-test rollbacks, JWT/role context helpers, and CI/GitHub Actions ready. | ||
| * [graphile-test](https://github.com/launchql/launchql/tree/main/packages/graphile-test): **🔐 Authentication mocking** for Graphile-focused test helpers and emulating row-level security contexts. | ||
| * [pgsql-parser](https://github.com/launchql/pgsql-parser): **🔄 SQL conversion engine** that interprets and converts PostgreSQL syntax. | ||
| * [libpg-query-node](https://github.com/launchql/libpg-query-node): **🌉 Node.js bindings** for `libpg_query`, converting SQL into parse trees. | ||
| * [pg-proto-parser](https://github.com/launchql/pg-proto-parser): **📦 Protobuf parser** for parsing PostgreSQL Protocol Buffers definitions to generate TypeScript interfaces, utility functions, and JSON mappings for enums. | ||
| * [pgpm](https://github.com/constructive-io/constructive/tree/main/packages/pgpm): **🖥️ PostgreSQL Package Manager** for modular Postgres development. Works with database workspaces, scaffolding, migrations, seeding, and installing database packages. | ||
| * [pgsql-test](https://github.com/constructive-io/constructive/tree/main/packages/pgsql-test): **📊 Isolated testing environments** with per-test transaction rollbacks—ideal for integration tests, complex migrations, and RLS simulation. | ||
| * [supabase-test](https://github.com/constructive-io/constructive/tree/main/packages/supabase-test): **🧪 Supabase-native test harness** preconfigured for the local Supabase stack—per-test rollbacks, JWT/role context helpers, and CI/GitHub Actions ready. | ||
| * [graphile-test](https://github.com/constructive-io/constructive/tree/main/packages/graphile-test): **🔐 Authentication mocking** for Graphile-focused test helpers and emulating row-level security contexts. | ||
| * [pgsql-parser](https://github.com/constructive-io/pgsql-parser): **🔄 SQL conversion engine** that interprets and converts PostgreSQL syntax. | ||
| * [libpg-query-node](https://github.com/constructive-io/libpg-query-node): **🌉 Node.js bindings** for `libpg_query`, converting SQL into parse trees. | ||
| * [pg-proto-parser](https://github.com/constructive-io/pg-proto-parser): **📦 Protobuf parser** for parsing PostgreSQL Protocol Buffers definitions to generate TypeScript interfaces, utility functions, and JSON mappings for enums. | ||
@@ -453,0 +453,0 @@ ## Disclaimer |
57551
0.1%433
-0.23%