JustyBase.Netezza 0.4.0

JustyBase.Netezza

Integration layer between Netezza metadata, JustyBase.NetezzaSqlParser (SQL parsing, completion, linting), and JustyBase.NetezzaDdl (DDL generation).

This package lives in the JustyBase.NetezzaSql repository alongside the parser, DDL, and catalog libraries.

Use this package when you need to:

• Represent a Netezza database schema (tables, views, columns, procedures) as immutable C# models
• Feed that schema into the parser's completion engine via InMemorySchemaProvider
• Convert schema metadata into DDL input models for CREATE TABLE / VIEW / PROCEDURE generation
• Apply an engine-first fallback strategy for SQL completion

The package has no I/O, no UI dependency, and no database driver reference — it is pure data transformation.

Dependencies

Target framework

• .NET 10
• Native AOT compatible (IsAotCompatible = true)

Public contract

End-to-end example

using JustyBase.Netezza.DependencyInjection;
using JustyBase.Netezza.Ddl;
using JustyBase.Netezza.Models;
using JustyBase.Netezza.Schema;
using JustyBase.NetezzaSqlParser.Visitor;
using JustyBase.NetezzaDdl;

// 1. Build a schema snapshot (typically from a database query)
var snapshot = new NetezzaSchemaSnapshot([
    new NetezzaSchemaTable(
        "EMPLOYEES", Schema: "PUBLIC", Database: "HR",
        Columns: [
            new NetezzaSchemaColumn("ID", "INTEGER", Nullable: false),
            new NetezzaSchemaColumn("NAME", "VARCHAR(100)"),
            new NetezzaSchemaColumn("SALARY", "DECIMAL(10,2)")
        ],
        Description: "Employee master table")
]);

// 2. Load into parser schema provider (enables semantic completion/linting)
var provider = new InMemorySchemaProvider();
NetezzaSchemaProviderAdapter.Apply(provider, snapshot);

// 3. Build DDL input and generate CREATE TABLE script
var ddlInput = NetezzaDdlInputFactory.BuildTable(
    snapshot.Tables[0],
    distributeColumns: ["ID"]);
var ddlBuilder = new NetezzaDdlTextBuilder();
var sql = new StringBuilder();
ddlBuilder.AppendCreateTable(sql, ddlInput);
Console.WriteLine(sql.ToString());
// Output: CREATE TABLE "HR"."PUBLIC"."EMPLOYEES" ( ... ) DISTRIBUTE ON ("ID");

DI registration

services.AddJustyBaseNetezza();
// Registers: ISqlCompletionMergePolicy, INetezzaSchemaProviderAdapter, INetezzaDdlInputFactory

Build and test

dotnet restore .\JustyBase.NetezzaSql.sln
dotnet build .\JustyBase.NetezzaSql.sln -c Release
dotnet test .\tests\JustyBase.Netezza.Tests\JustyBase.Netezza.Tests.csproj -c Release

See the repository release guide for publishing.