Download the PHP package mitsuki/mitsuki-db-migrations without Composer
On this page you can find all versions of the php package mitsuki/mitsuki-db-migrations. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download mitsuki/mitsuki-db-migrations
More information about mitsuki/mitsuki-db-migrations
Files in mitsuki/mitsuki-db-migrations
Package mitsuki-db-migrations
Short Description A lightweight, fluent database migration wrapper for the Mitsuki framework, built on top of Phinx.
License MIT
FAQ
Example:
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
- Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
- To use Composer is sometimes complicated. Especially for beginners.
- Composer needs much resources. Sometimes they are not available on a simple webspace.
- If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
- Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Informations about the package mitsuki-db-migrations
Mitsuki Database Migrations
Mitsuki Database Migrations is a lightweight, fluent schema builder for PHP. Built as a powerful wrapper around Phinx, it allows you to define your database structure using a clean, expressive syntax inspired by Laravel's Migration system.
✨ Features
- Fluent API: Define tables and columns using clean method chaining.
- Smart Migrations: Automatically detects if a table exists to choose between
CREATEorALTER. - Standardized Fields: Quick helpers for primary keys (
id()) and tracking (timestamps()). - Relationship Helpers: Intelligent foreign key resolution with
foreignIdFor(). - Phinx Powered: Seamlessly integrates with your existing Phinx environments and commands.
- Fully Tested: High-reliability codebase tested with Pest PHP and Mockery.
🚀 Installation & Setup
1. Install via Composer
2. Initialize Phinx
Ensure your phinx.php is configured to use the Mitsuki template and environment variables.
🛠 Usage
1. Basic Table Creation
Use the Schema facade. It coordinates with the Phinx migration instance to execute your definitions.
2. 🔗 Foreign Keys & Relationships
The foreignIdFor() method simplifies relationship management by automatically guessing column and table names.
💻 Console Commands
Mitsuki leverages the Phinx CLI. Here are the essential commands for your workflow:
Create a New Migration
Generate a new migration file using the Mitsuki stub:
Run Migrations
Execute all pending migrations:
Rollback
Undo the last migration:
Check Status
See the list of migrated and pending files:
⚙️ Configuration (phinx.php)
Mitsuki handles environment switching automatically based on your .env file:
| Env Var | Default | Description |
|---|---|---|
ENVIRONEMENT |
testing |
Switches between testing (SQLite) and development (MySQL). |
DB_CONNECTION |
mysql |
The database driver to use in development. |
DB_DATABASE |
mitsuki_db |
The name of your database or path to SQLite file. |
🧠 Smart Save Logic
Mitsuki is designed to be safe. When you call save(), the library checks the database state:
- If the table doesn't exist: It executes a
CREATE TABLEstatement (withid => falseto let the Blueprint manage the primary key). - If the table exists: It automatically switches to
ALTER TABLEto add your new columns without destroying existing data.
🧪 Testing
We take stability seriously. The library is fully covered by Pest PHP unit tests.
📄 License
The Mitsuki Database Migrations library is open-sourced software licensed under the MIT license.
Developed with ❤️ by [Zgeniuscoders](mailto:[email protected])
