Pure.RelationalSchema.Storage.PostgreSQL.Creation 0.1.0-preview.0.1.0

Pure.RelationalSchema.Storage.PostgreSQL.Creation

PostgreSQL schema creation (DDL) for the Pure relational schema ecosystem — CREATE SCHEMA, CREATE TABLE, CREATE INDEX and foreign keys generated from an ISchema and executed via IDbConnection.

Overview

Pure.RelationalSchema.Storage.PostgreSQL.Creation turns the abstract relational model defined in Pure.RelationalSchema into a physical PostgreSQL schema. PostgreSqlCreatedSchema lazily generates and executes CREATE SCHEMA, CREATE TABLE, CREATE INDEX and ALTER TABLE … ADD CONSTRAINT statements derived from an ISchema.

This package covers DDL only. Reading and writing rows is handled by the related packages listed below.

Public API

All SQL statement builders are internal.

Usage

using System.Data;
using Npgsql;
using Pure.RelationalSchema.Abstractions.Schema;
using Pure.RelationalSchema.Abstractions.Table;
using Pure.RelationalSchema.Storage.PostgreSQL.Creation;

// schema is your ISchema; connection is an open IDbConnection
IDbConnection connection = new NpgsqlConnection(connectionString);
connection.Open();

ISchema created = new PostgreSqlCreatedSchema(schema, connection);

// DDL runs lazily, the first time Name, Tables or ForeignKeys is accessed.
// Every statement uses IF NOT EXISTS, so running it again is safe.
IEnumerable<ITable> tables = created.Tables;

Naming convention

Schema, table and column identifiers in PostgreSQL are not the model names. Each one is the first 63 hexadecimal characters of the corresponding hash from Pure.RelationalSchema.HashCodes (SchemaHash, TableHash, ColumnHash), which avoids PostgreSQL's identifier length limit and character restrictions.

The Querying and Insertion packages rely on this convention to address the objects created here, so it is part of the contract between the packages.

Dependencies

• Pure.RelationalSchema — core relational model abstractions: ISchema, ITable, IForeignKey and related types
• Pure.RelationalSchema.HashCodes — hash codes used to derive PostgreSQL object names
• Pure.Primitives.Abstractions — base interfaces for primitive types (IString, IBool, etc.)
• Pure.Primitives — concrete primitive type implementations
• Pure.Primitives.String.Operations — string composition utilities used to build SQL statements
• Pure.Primitives.Choices — choice types
• Pure.Primitives.Switches — switch / pattern matching utilities

Target Frameworks

• .NET 8
• .NET 9
• .NET 10

Installation

dotnet add package Pure.RelationalSchema.Storage.PostgreSQL.Creation

Related packages

• Pure.RelationalSchema.Storage.PostgreSQL.Querying — reading rows from tables created by this package
• Pure.RelationalSchema.Storage.PostgreSQL.Insertion — inserting rows into tables created by this package