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!
========================
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
Release history Release notifications | RSS feed
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)
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
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
fa5879acfcd2a2d8e91b106d5daa69711d5576c1257e81f41f90c8a47ef8452a
|
|
| MD5 |
820dd0048255d6bd9ad6d887a4bdfd39
|
|
| BLAKE2b-256 |
a6d879a7187839bf425347da86eac0de04017b05580db0059cda6d68047cb11f
|