cuducos / alchemydumps Goto Github PK

lets say I have configured the alchemydumps in this manner:
alchemydumps = AlchemyDumps(app, data_base)

is it possible to call the backup directly within the flask app e.g:
alchemydumps.backup()

Hi,

I have a multiple models with abstract model; it not working

Thanks.

Hello,

Not sure what's going on here. I have the following in my __init__.py:

from flask_sqlalchemy import SQLAlchemy
from flask_alchemydumps import AlchemyDumps
from flask_migrate import Migrate

db = SQLAlchemy()
alchemydumps = AlchemyDumps()
migrate = Migrate()

def create_app(config_class=Config):
    app = Flask(__name__)
    app.config.from_object(config_class)

    db.init_app(app)
    migrate.init_app(app, db)
    alchemydumps.init_app(app, db)

The flask_migrate module has successfully registered a new flask db command, but I don't have a flask alchemydumps command, which is what I would expect from the cli.py file contents. I don't have other commands that would match either:

> pipenv run flask --help
Usage: flask [OPTIONS] COMMAND [ARGS]...

  A general utility script for Flask applications.

  Provides commands from Flask, extensions, and the application. Loads the
  application defined in the FLASK_APP environment variable, or from a
  wsgi.py file. Setting the FLASK_ENV environment variable to 'development'
  will enable debug mode.

    $ export FLASK_APP=hello.py
    $ export FLASK_ENV=development
    $ flask run

Options:
  --version  Show the flask version
  --help     Show this message and exit.

Commands:
  db      Perform database migrations.
  routes  Show the routes for the app.
  run     Run a development server.
  shell   Run a shell in the app context.

Any idea what would cause the CLI command not to register?

Thanks,

Clément

Something changes in Travis and tox is not able to find the right Python versions. A fiz is needed here: either by fixing .travis.yml or migrating to another CI.

Their official solution coverallsapp/github-action was failing with No build matching CI build number so I left it out of 889346f

Hi, Can we please assign a license, MIT license or otherwise, to this repository?

Thank you!

Hello,

Python 3 support could be added with one line to setup.py

use_2to3=True

See http://pythonhosted.org/setuptools/python3.html

In case my flask script manager is created using a factory pattern, like this:

manager = script.Manager(app_factory)

How am I supposed to initialize Dumps?

Kind regards and many thanks in advance.

This might make this package more useful in environments such as Heroku.

This is an example that could be useful.

This is in my TODO list, but anyone is free to jump in and make PR.

Hello!

I tried making use of your package some days ago and I noticed this error popping on my console.

It says the import style used for Flask_Script is the deprecated one: flask.ext.script, I see in your codebase you've changed it but I doubt you've published those changes on pypi. Can you rectify please, thanks!

Hello Everyone,
love this project but it is not functioning on my side due to this line in the

__init__.py

file at this line:
from flask.ext.script import Manager

Simply changed to
from flask_script import Manager
after installed the packages locally. This way it works.

A nice feature would be to save the backup files at a file storage as S3.

Example:

In [1]: from sqlalchemy.ext.serializer import loads, dumps
In [2]: from ext.user.table.user import UserTable as User
In [3]: users = User.query.all()
In [4]: s = dumps(users[0])
---------------------------------------------------------------------------
IndexError                                Traceback (most recent call last)
<ipython-input-4-9cf913d7f7a1> in <module>()
----> 1 s = dumps(users[0])
IndexError: list index out of range
In [5]: db = app.extensions['alchemydumps'].db
In [6]: db.session.add(User(email='a@a'))
In [7]: db.session.commit()
In [8]: users = User.query.all()
In [9]: s = dumps(users[0])
In [10]:

If, for example, your database contains an association table for a many-to-many mapping as described here: http://docs.sqlalchemy.org/en/latest/orm/basic_relationships.html#many-to-many, the many-to-many association table doesn't get dumped by alchemy dumps. This seems to be because the base declarative class's subclasses are the only things enumerated when creating dumps, which will result in missing other data. Some other examples of usages that alchemydumps doesn't support can be found here: http://docs.sqlalchemy.org/en/latest/orm/nonstandard_mappings.html

Would it work to enumerate db.Model.metadata.tables and dump the contents that way instead?

Hi,
while using vsftpd as a ftp-server pushing the data to, an issue in the backup/helpers.py occurred. The response code is compared very strict against '250 OK'. With vsftpd a successfull directory-change-response get '250 Directory changed' so the socket-connection get closed in the middle of the transaction and raise an exception.

Changing.

if change_path[0:3] != '250':
ftp.quit()

to

if change_path[0:6] != '250 OK':
ftp.quit()

Would fix the issue. Can you please look at the issue or suggest a ftp-server, with a "250 OK" response?.

Thank you very much.
Marcus

There's some problem in backup.py
Can you make check so that slashes doesn't get added to win path.
Otherwise Backup works well with flask script and py 3.4, haven't tested restore jet.
Thanks for this extension, makes life easier.

something like:
import sys

@staticmethod
def __slashes(string):
    """Adds, if needed, a slash to the beginning and ending of a string"""
    is_winows = sys.platform.startswith('win')
    if not is_winows:
        if string and len(string) > 1:
            if string[0:1] != '/':
                string = '/{}'.format(string)
            if string[-1] != '/':
                string = '{}/'.format(string)
    return string

Hi @cuducos, I would be willing to take over management of this package.

I don't have a forked version of changes I've made to this package, but have modified a majority of the code and placed inside another app of mine (running python 3.6 on an AWS Lambda). If I was given maintership of this package this is the direction I would like to take it in based on my current modifications:

• Make the package python3 only
• Add saving to a S3 bucket in addition to ftp
• Add utilities for working within the AWS cloud (and eventually others)
• Add support for many to many relationships (in progress - i have one issue, not backing up but restoring, with this left and will have it knocked out soon)
• Continued flask integration (possibly rename to flask-alchemydumps?)
• Corresponding documentation

Thanks for the code! This package was really, really, helpful in building my latest application and I'd love the chance to take it in new directions for others to enjoy.

-- les

Can I backup the file in different extensions..?, such as .zip or plaint text..?