Skip to main content

Sooty: Simple database migrator.

Project description

Sooty: Simple Database Migrator
========================

Sooty is a simple database migration tool for postgres databases. When working with a legacy application, more often than not, the application has no means of migrating the database forward. This is a simple library to bridge that gap.

The name Sooty comes from the bird Sooty Shearwater which can travel over 20,000 miles during it's annual migration. https://en.wikipedia.org/wiki/Sooty_shearwater

Usage
------------

.. code:: sh

sooty create add index on product ids

$ Created directory './migrations'
$ Created migration file './migrations/create_index_on_product_ids_20160218223012.sql

$ cat ./migrations/create_index_on_product_ids_20160218223012.sql

-- Just type some SQL!
-- ALTER TABLE products ADD COLUMN customer_code varchar(11)



To run your migrations just


.. code:: sh

$ sooty run <database_url>


If no database url is provided, sooty will try to use the environment variable DATABASE_URL



That's it!

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

sooty-0.0.3.tar.gz (3.5 kB view details)

Uploaded Source

File details

Details for the file sooty-0.0.3.tar.gz.

File metadata

  • Download URL: sooty-0.0.3.tar.gz
  • Upload date:
  • Size: 3.5 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No

File hashes

Hashes for sooty-0.0.3.tar.gz
Algorithm Hash digest
SHA256 fa5879acfcd2a2d8e91b106d5daa69711d5576c1257e81f41f90c8a47ef8452a
MD5 820dd0048255d6bd9ad6d887a4bdfd39
BLAKE2b-256 a6d879a7187839bf425347da86eac0de04017b05580db0059cda6d68047cb11f

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page