Skip to main content

SQLAlchemy backup/dump tool for Flask

Project description


Do you use Flask with SQLAlchemy and Flask-Script ? Wow, what a coincidence!

This package let you backup and restore all your data using SQLALchemy dumps() method.

It is an easy way (one singe command, I mean it) to save all the data stored in your database.


First install the package: $ pip install Flask-AlchemyDumps

Then configure it in your Flask application:

from alchemydumps import AlchemyDumps, AlchemyDumpsCommand
from flask import Flask
from flask.ext.script import Manager
from flask.ext.sqlalchemy import SQLAlchemy

# init Flask
app = Flask(__name__)

# init SQLAlchemy and Flask-Script
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///app.db'
db = SQLAlchemy(app)
manager = Manager(app)

# init Alchemy Dumps
alchemydumps = AlchemyDumps(app, db)
manager.add_command('alchemydumps', AlchemyDumpsCommand)

The first line import the methods from the package.

The last two lines instantiate and add AlchemyDumps to the Flask-Script manager).

You might want to add alchemydumps to your .gitignore. It is the folder where AlchemyDumps save the backup files.


Considering you have these models (SQLAlchemy mapped classes):

class User(Model):
    id = Column(Integer, primary_key=True)
    email = Column(String(140), index=True, unique=True)

class Post(Model):
    id = Column(Integer, primary_key=True)
    title = Column(String(140))
    content = Column(UnicodeText)

You can backup all your data

$ python alchemydumps create


==> 3 rows from User post saved as /vagrant/alchemydumps/db-bkp-20141115172107-User.gz
==> 42 rows from Post saved as /vagrant/alchemydumps/db-bkp-20141115172107-Post.gz

You can list the backups you have already created

$ python alchemydumps history


==> ID: 20141114203949 (from Nov 15, 2014 at 17:21:07)

==> ID: 20141115140629 (from Nov 15, 2014 at 14:06:29)

You can restore a backup

$ python alchemydumps restore -d 20141115172107


==> /vagrant/alchemydumps/db-bkp-20141115172107-User.gz totally restored.
==> /vagrant/alchemydumps/db-bkp-20141115172107-Post.gz totally restored.

You can delete an existing backup

$ python alchemydumps remove -d 20141115172107


==> Do you want to delete the following files?'
==> Press "Y" to confirm, or anything else to abort.
    /vagrant/alchemydumps/db-bkp-20141115172107-User.gz deleted.
    /vagrant/alchemydumps/db-bkp-20141115172107-Post.gz deleted.

And you can use the auto-clean command

The autoclean command follows these rules to delete backups:

  • It keeps all the backups from the last 7 days.

  • It keeps the most recent backup from each week of the last month.

  • It keeps the most recent backup from each month of the last year.

  • It keeps the most recent backup from each year of the remaining years.

$ python alchemydumps autoclean


==> 8 backups will be kept:

    ID: 20130703225903 (from Jul 03, 2013 at 22:59:03)

    ID: 20120405013054 (from Apr 05, 2012 at 01:30:54)

    ID: 20101123054342 (from Nov 23, 2010 at 05:43:42)

    ID: 20090708100815 (from Jul 08, 2009 at 10:08:15)

    ID: 20081208191908 (from Dec 08, 2008 at 19:19:08)

    ID: 20070114122922 (from Jan 14, 2007 at 12:29:22)

    ID: 20060911035318 (from Sep 11, 2006 at 03:53:18)

    ID: 20051108082503 (from Nov 08, 2005 at 08:25:03)

==> 11 backups will be deleted:

    ID: 20120123032442 (from Jan 23, 2012 at 03:24:42)

    ID: 20101029100412 (from Oct 29, 2010 at 10:04:12)

    ID: 20100526185156 (from May 26, 2010 at 18:51:56)

    ID: 20100423085529 (from Apr 23, 2010 at 08:55:29)

    ID: 20081006074458 (from Oct 06, 2008 at 07:44:58)

    ID: 20080429210254 (from Apr 29, 2008 at 21:02:54)

    ID: 20080424043716 (from Apr 24, 2008 at 04:37:16)

    ID: 20080405110244 (from Apr 05, 2008 at 11:02:44)

    ID: 20060629054914 (from Jun 29, 2006 at 05:49:14)

    ID: 20060329020048 (from Mar 29, 2006 at 02:00:48)

    ID: 20050324012859 (from Mar 24, 2005 at 01:28:59)

==> Press "Y" to confirm, or anything else to abort.
    /vagrant/alchemydumps/db-bkp-20120123032442-User.gz deleted.
    /vagrant/alchemydumps/db-bkp-20120123032442-Post.gz deleted.
    /vagrant/alchemydumps/db-bkp-20101029100412-User.gz deleted.
    /vagrant/alchemydumps/db-bkp-20101029100412-Post.gz deleted.
    /vagrant/alchemydumps/db-bkp-20100526185156-User.gz deleted.
    /vagrant/alchemydumps/db-bkp-20100526185156-Post.gz deleted.
    /vagrant/alchemydumps/db-bkp-20100423085529-User.gz deleted.
    /vagrant/alchemydumps/db-bkp-20100423085529-Post.gz deleted.
    /vagrant/alchemydumps/db-bkp-20081006074458-User.gz deleted.
    /vagrant/alchemydumps/db-bkp-20081006074458-Post.gz deleted.
    /vagrant/alchemydumps/db-bkp-20080429210254-User.gz deleted.
    /vagrant/alchemydumps/db-bkp-20080429210254-Post.gz deleted.
    /vagrant/alchemydumps/db-bkp-20080424043716-User.gz deleted.
    /vagrant/alchemydumps/db-bkp-20080424043716-Post.gz deleted.
    /vagrant/alchemydumps/db-bkp-20080405110244-User.gz deleted.
    /vagrant/alchemydumps/db-bkp-20080405110244-Post.gz deleted.
    /vagrant/alchemydumps/db-bkp-20060629054914-User.gz deleted.
    /vagrant/alchemydumps/db-bkp-20060629054914-Post.gz deleted.
    /vagrant/alchemydumps/db-bkp-20060329020048-User.gz deleted.
    /vagrant/alchemydumps/db-bkp-20060329020048-Post.gz deleted.
    /vagrant/alchemydumps/db-bkp-20050324012859-User.gz deleted.
    /vagrant/alchemydumps/db-bkp-20050324012859-Post.gz deleted.


As AlchemyDumps was designed to work together with Flask applications that uses SQLAlchemy. And it runs within the Flask-Script manager. Thus, be sure to have these packages installed and in use.

AlchemyDumps also uses Unipath package.

In sum, if your requirements.txt looks something like this, probably you will be fine:


AlchemyDumps is not ready for Python 3 yet – but pull requests are more than welcomed.


If you wanna to run the tests:

$ git clone
$ cd /alchemydumps
$ pip install nose unipath
$ nosetests


Version 0.0.3
  • New command: auto-clean backup folder.

Version 0.0.2
  • New command: delete a single backup.

  • Proper message when ID is not found in restore and delete commands.

  • Avoid breaking the code when get_id() fails.

  • Minor code improvements.


Copyright (c) 2014 Eduardo Cuducos.

Licensed under the MIT License.

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

Flask-AlchemyDumps-0.0.3.tar.gz (6.7 kB view hashes)

Uploaded Source

Supported by

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