mardix/active-alchemy

Active-Alchemy is a framework agnostic wrapper for SQLAlchemy that makes it really easy to use by implementing a simple active record like api, while it still uses the db.session underneath. Inspired by Flask-SQLAlchemy

active-alchemy's Issues

How to pass the connect_args to engine?

ActiveAlchemy takes very little args of what SQLAlchemy supports, is there a mechanism to pass the connect_args to engine?

Can't validate argument 'bind_key'

After connecting active-sqlalchemy I got strange warnings:

/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/schema.py:552: SAWarning: Can't validate argument 'bind_key'; can't locate any SQLAlchemy dialect named 'bind'
self._validate_dialect_kwargs(kwargs)

• Running on http://0.0.0.0:5000/ (Press CTRL+C to quit)
• Restarting with stat
  /usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/schema.py:552: SAWarning: Can't validate argument 'bind_key'; can't locate any SQLAlchemy dialect named 'bind'
  self._validate_dialect_kwargs(kwargs)

Delayed definition of database URI

The ActiveAlchemy constructor expects a URI as first argument, but that URI may not be known at the time that it is created. It would be nice if the constructor accepted None as an alternative value, requiring that we initialise the database URI before interacting with the database. Illustrative example:

db = ActiveAlchemy()

class User(db.Model):
  # ...

def main():
  config = load_config()
  db.bind(config.database_uri)
  db.create_all()
  # ...

Querying in a seperate file

I have set up the models in a model.py page which has classes Article and Website, how can i query those in another page without importing from the model page? Is this possible? I need to write a function that is called in model.py that also queries the db and i cant seem to figure out how to do it without from model import article and running into a circular dependency

What is the purposes of this library?

Is this the JQuery JS of SQLAlchemy?

Polimorphism not working

$ cat t.py
from flask import Flask, render_template, request
from active_sqlalchemy import SQLAlchemy

app = Flask(name)
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite://'
db = SQLAlchemy()

class Alert(db.Model):
mapper_args = {'polymorphic_on': 'type'}
tablename = 'alerts'
id = db.Column(db.Integer, primary_key=True)
type = db.Column(db.String(20))

class ComparisonAlert(Alert):
mapper_args = {'polymorphic_identity': "Comparison"}
percent = db.Column(db.Float(), nullable=False, default=10.0)

db.init_app(app)

$ python t.py
Traceback (most recent call last):
File "t.py", line 14, in
class ComparisonAlert(Alert):
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/ext/declarative/api.py", line 55, in init
_as_declarative(cls, classname, cls.dict)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/ext/declarative/base.py", line 254, in _as_declarative
**table_kw)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/schema.py", line 393, in new
"existing Table object." % key)
sqlalchemy.exc.InvalidRequestError: Table 'alerts' is already defined for this MetaData instance. Specify 'extend_existing=True' to redefine options and columns on an existing Table object.

Adding/renaming/deleting columns

So how do I Add a new column to existing db file ?

Also renaming or deleting columns ?

I think sqlacademy cant do it out of the box, but since this is a wrapper maybe its possible ?