schema

sqllocks_spindle.schema

Schema parsing, validation, and dependency resolution.

Classes

SchemaParser

Parse a .spindle.json file into a SpindleSchema.

SchemaValidator

Validate a parsed SpindleSchema.

DependencyResolver

Resolve table generation order via topological sort.

DdlParser

Parse SQL DDL (CREATE TABLE) into a SpindleSchema.

Supports SQL Server / Fabric Warehouse, PostgreSQL, MySQL, and ANSI SQL via regex-based parsing. No external SQL parser dependency required.

Usage::

parser = DdlParser()
schema = parser.parse_file("my_tables.sql")
# or
schema = parser.parse_string("CREATE TABLE ...")

Methods:

parse_file(path)

Parse a .sql file containing CREATE TABLE statements.

parse_string(sql)

Parse SQL DDL string into a SpindleSchema.