manojmbharadwaj/laghu

PHP DB Migration Tool

Maintainers

Details

github.com/manojmbharadwaj/laghu

Homepage

Source

Issues

Installs: 0

Dependents: 0

Suggesters: 0

Security: 0

Stars: 0

Watchers: 1

Forks: 0

Open Issues: 0

dev-master 2019-11-16 16:28 UTC

MIT 2092d0447bc6d22ebc51a5f079c391a74f2c10e9

  • Manoj M Bharadwaj <ibeingmj.woop@gmail.com>

migrationphp-migrationsmall-migration

This package is auto-updated.

Last update: 2024-09-17 03:22:19 UTC

README

Project Intro

Laghu(Small in Kannada) Migration Tool!

Intro

Laghu is small migration tool. The flow is simple. First we will create a migration file. Add SQL to the created file. Run the migration!. When we run the migration, the tool check weather the file is all-ready migrated or not. If it is being migrated it won't run the SQL.
The tool will create Migration directory, migration table(laghu_migrations) when you run the script. DO NOT CHANGE DIRECTORY NAME and TABLE NAME unlsess you change the laghu.php script as well.
In small projects I found it is easier to have a migration based on raw SQL scripts than using a framework for it.

Config

Update config.php with database credentials

Commands

  1. Create Migration:
    php laghu.php create [file_suffix]
    php laghu.php create ct-user_detail -> this will create the file [timestamp]ct-user_detail in migration directory.
    Naming conventions (optional. Suggested for readiblity):
    ct -> create table
    mt -> modify table
    dt -> SQL contains Data
  2. Run migration
    php laghu.php migrate
    The command will run the migration outputs no. of files migrated successfully.