Cassandra-migrate

Cassandra-migrate is a incremental migration tool for Cassandra.

Version 1.2.0 update

Just added support for more robust Cassandra client configuration, now you can provide a path to a configuration file that can specify a Cassandra client option object directly as javascript. Cassandra client options configuration can found here. A user can override the client options file using either the command line flags, or environment variables

Version 1.1.2 update

the format of the migration table has changed, to facilitate the change over I've included an example migration file (0000000000_updateMigrationTable.js) that should nondestructivly update the migration table to the new format, just copy it into your migrations folder and run it before running any other migrations

Features

• Uses the node cassandra-driver to run incremental migrations on Cassandra database.
• Uses Cassandra keyspace mentioned in commandline to keep track of ran migrations.
• Automatically builds and run UP or DOWN until any migration number.
• Creates a new incremental migration template by a single command.

Installation

Install node.js and cassandra and cassandra-driver. Then:

npm install cassandra-migrate

Overview

Basic Usage

Creates a new migration with a timestamped migration number ( Used for tracking migrations ).

    cassandra-migrate create <title>

Runs all migrations available in current directory.

    cassandra-migrate up -k <keyspace>

Rolls back all migrations in the migrations table.

    cassandra-migrate down -k <keyspace>

Goes back/forward to a particular migration automatically.

    cassandra-migrate <up/down> -k <keyspace> -n <migration-number>

Skips a particular migration (either adds or removes the migration from the table without running any scripts.

    cassandra-migrate <up/down> -k <keyspace> -s <migration-number>

Define host, username, and password. By default connects to [localhost] and default cassandra port [9042].

    cassandra-migrate -H [10.10.10.1] -u username -p password

Cassandra connection details can also be specified in environmental variables

    DBHOST : sets hostname
    DBKEYSPACE : sets keyspace
    DBUSER : sets username
    DBPASSWORD : sets password;

As of 1.2.0 Cassandra connection details can now also be specified in configuration file example you can point to the file's relative path with:

  cassandra-migrate -o <path/to/file.js>

More help.

    cassandra-migrate --help

License

cassandra-migrate is distributed under the MIT license.

Contributions

Feel free to join in and support the project!

Check the Issue tracker