aimeos/upscheme

Features

• Database Schema Migrations - Manages incremental database schema changes across environments using versioned migration files and dependency ordering.
• Database Schema Builders - Defines database schema changes through a chainable object-oriented interface that maps method calls to SQL DDL statements.
• Migration File Generators - Generates migration PHP files by querying live database metadata for tables, columns, indexes, and sequences.
• Database Introspection Generators - Generates migration PHP files by inspecting live database tables, columns, indexes, and sequences.
• Migration Code Generators - Generates migration PHP files automatically by inspecting the current structure of a live database.
• Foreign Key Constraints - Creates foreign key constraints with configurable on-delete and on-update actions to enforce referential integrity.
• Index Management Operations - Adds primary, unique, regular, and spatial indexes on single or multiple columns to speed up queries.
• Index Creation - Adds primary, unique, regular, and spatial indexes on single or multiple columns to speed up database queries.
• Migration File Generation - Inspects live database structures to automatically produce PHP migration files for tables, views, and sequences.
• Database Introspection Generators - Generates migration PHP files by inspecting live database tables, columns, indexes, and sequences.
• Fluent Schema Definitions - Defines database schema structure including tables, columns, indexes, and foreign keys via a fluent builder.
• Programmatic Table and Index Managements - Creates and alters tables, columns, indexes, and foreign keys programmatically via a fluent schema builder.
• Dependency Graph Runners - Orders migration tasks by resolving before/after dependencies into a directed graph that determines execution sequence.
• Custom SQL Execution - Runs raw SQL statements and platform-specific queries that fall outside the abstraction layer's capabilities.
• Column Definitions - Adds columns of various standard types with modifiers like length, nullability, defaults, and indexes using shortcut methods.
• Column Additions and Modifications - Defines new columns or changes existing column properties like type, length, and default value.
• Column Type Shortcuts - Ships shorthand methods for common column types and modifiers that expand into full schema builder calls.
• Multi-Connection Routers - Runs schema operations and migrations across multiple database connections from a single configuration.
• Migration Dependency Ordering - Orders migration tasks by specifying before/after dependencies to control the sequence of schema changes.
• Multi-Database Connection Configuration - Associates schema operations with specific database connections using configuration keys to manage heterogeneous environments.
• Migration Routers - Routes schema changes to multiple database connections simultaneously with configurable execution ordering.
• Multi-Database Connections - Connects to several databases simultaneously and routes schema changes to the correct connection by configuration key.
• Raw SQL Execution - Executes arbitrary SQL statements directly against the database connection without abstraction layer processing.
• Dynamic Method Extensions - Registers custom methods on schema objects at runtime using a macro system that stores closures for later invocation.

Star history