Traceback (most recent call last):
File "<console>", line 1, in <module>
File
"/Users/hugo/Dropbox/lahey/api/.venv/lib/python3.6/site-packages/sqlalchemy/orm/scoping.py",
line 157, in do
return getattr(self.registry(), name)(*args, **kwargs)
File
"/Users/hugo/Dropbox/lahey/api/.venv/lib/python3.6/site-packages/sqlalchemy/orm/session.py",
line 921, in commit
self.transaction.commit()
File
"/Users/hugo/Dropbox/lahey/api/.venv/lib/python3.6/site-packages/sqlalchemy/orm/session.py",
line 461, in commit
self._prepare_impl()
File
"/Users/hugo/Dropbox/lahey/api/.venv/lib/python3.6/site-packages/sqlalchemy/orm/session.py",
line 441, in _prepare_impl
self.session.flush()
File
"/Users/hugo/Dropbox/lahey/api/.venv/lib/python3.6/site-packages/sqlalchemy/orm/session.py",
line 2192, in flush
self._flush(objects)
File
"/Users/hugo/Dropbox/lahey/api/.venv/lib/python3.6/site-packages/sqlalchemy/orm/session.py",
line 2312, in _flush
transaction.rollback(_capture_exception=True)
File
"/Users/hugo/Dropbox/lahey/api/.venv/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py",
line 66, in __exit__
compat.reraise(exc_type, exc_value, exc_tb)
File
"/Users/hugo/Dropbox/lahey/api/.venv/lib/python3.6/site-packages/sqlalchemy/util/compat.py",
line 187, in reraise
raise value
File
"/Users/hugo/Dropbox/lahey/api/.venv/lib/python3.6/site-packages/sqlalchemy/orm/session.py",
line 2276, in _flush
flush_context.execute()
File
"/Users/hugo/Dropbox/lahey/api/.venv/lib/python3.6/site-packages/sqlalchemy/orm/unitofwork.py",
line 368, in execute
postsort_actions = self._generate_actions()
File
"/Users/hugo/Dropbox/lahey/api/.venv/lib/python3.6/site-packages/sqlalchemy/orm/unitofwork.py",
line 327, in _generate_actions
if action.execute(self):
File
"/Users/hugo/Dropbox/lahey/api/.venv/lib/python3.6/site-packages/sqlalchemy/orm/unitofwork.py",
line 447, in execute
self.dependency_processor.presort_deletes(uow, delete_states)
File
"/Users/hugo/Dropbox/lahey/api/.venv/lib/python3.6/site-packages/sqlalchemy/orm/dependency.py",
line 430, in presort_deletes
self._passive_delete_flag)
File
"/Users/hugo/Dropbox/lahey/api/.venv/lib/python3.6/site-packages/sqlalchemy/orm/unitofwork.py",
line 223, in get_attribute_history
attributes.LOAD_AGAINST_COMMITTED)
File
"/Users/hugo/Dropbox/lahey/api/.venv/lib/python3.6/site-packages/sqlalchemy/orm/attributes.py",
line 909, in get_history
current = self.get(state, dict_, passive=passive)
File
"/Users/hugo/Dropbox/lahey/api/.venv/lib/python3.6/site-packages/sqlalchemy/orm/attributes.py",
line 584, in get
value = self.callable_(state, passive)
File
"/Users/hugo/Dropbox/lahey/api/.venv/lib/python3.6/site-packages/sqlalchemy/orm/strategies.py",
line 557, in _load_for_state
return self._emit_lazyload(session, state, ident_key, passive)
File "<string>", line 1, in <lambda>
File
"/Users/hugo/Dropbox/lahey/api/.venv/lib/python3.6/site-packages/sqlalchemy/orm/strategies.py",
line 615, in _emit_lazyload
strategy_options.Load.for_existing_path(
File
"/Users/hugo/Dropbox/lahey/api/.venv/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py",
line 977, in __getattr__
attr = getattr(self.module, key)
File
"/Users/hugo/Dropbox/lahey/api/.venv/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py",
line 767, in __get__
obj.__dict__[self.__name__] = result = self.fget(obj)
File
"/Users/hugo/Dropbox/lahey/api/.venv/lib/python3.6/site-packages/sqlalchemy/util/langhelpers.py",
line 962, in module
% (self._il_path, self._il_addtl))
ImportError: importlater.resolve_all() hasn't been called (this is
sqlalchemy.orm strategy_options)
On Tue, Nov 7, 2017 at 5:26 PM, Mike Bayer <[email protected]> wrote:
> Can you show me the stack trace you get with 1.1.15? Thanks
>
> On Nov 7, 2017 8:30 AM, "Hugo Heyman" <[email protected]> wrote:
>
>> Unfortunately it didn't help. I tried adding those imports both in the
>> models file and run them first in shell.
>>
>> On Tue, Nov 7, 2017 at 2:18 PM, Mike Bayer <[email protected]>
>> wrote:
>>
>>> Ok, see if for the moment some imports at the top help:
>>>
>>>
>>> import sqlalchemy
>>> import sqlalchemy.orm
>>>
>>> Make sure those run first.
>>>
>>> On Nov 7, 2017 8:12 AM, "Hugo Heyman" <[email protected]> wrote:
>>>
>>>> 1.2.0b3 but I also tried 1.1.15 now with the same result.
>>>>
>>>> /Hugo
>>>>
>>>> On Tue, Nov 7, 2017 at 1:26 PM, Mike Bayer <[email protected]>
>>>> wrote:
>>>>
>>>>> That's probably our fault, what is the exact version of SQLAlchemy in
>>>>> use ? Did you try upgrading to the latest release ?
>>>>>
>>>>> On Nov 7, 2017 4:32 AM, "Hugo Heyman" <[email protected]> wrote:
>>>>>
>>>>>> Hello,
>>>>>>
>>>>>>
>>>>>> I get an error I don't really understand. When I do session commit
>>>>>> after a deletion like this:
>>>>>>
>>>>>> App: app.bootstrap_new [debug]
>>>>>> Instance: /Users/hugo/Dropbox/lahey/api/instance
>>>>>> >>> from app.extensions import db
>>>>>> >>> from app.models.user import User
>>>>>> >>> user = User.query.all()[0]
>>>>>> >>> db.session.delete(user)
>>>>>> >>> db.session.commit()
>>>>>> (this is in a shell with flask app context but I get the same error
>>>>>> when trying to delete in app that is being served)
>>>>>>
>>>>>>
>>>>>>> Traceback (most recent call last):
>>>>>>> File "<console>", line 1, in <module>
>>>>>>> File "/Users/hugo/Dropbox/lahey/api/.venv/lib/python3.6/site-pack
>>>>>>> ages/sqlalchemy/orm/scoping.py", line 153, in do
>>>>>>> return getattr(self.registry(), name)(*args, **kwargs)
>>>>>>> File "/Users/hugo/Dropbox/lahey/api/.venv/lib/python3.6/site-pack
>>>>>>> ages/sqlalchemy/orm/session.py", line 937, in commit
>>>>>>> self.transaction.commit()
>>>>>>> File "/Users/hugo/Dropbox/lahey/api/.venv/lib/python3.6/site-pack
>>>>>>> ages/sqlalchemy/orm/session.py", line 461, in commit
>>>>>>> self._prepare_impl()
>>>>>>> File "/Users/hugo/Dropbox/lahey/api/.venv/lib/python3.6/site-pack
>>>>>>> ages/sqlalchemy/orm/session.py", line 441, in _prepare_impl
>>>>>>> self.session.flush()
>>>>>>> File "/Users/hugo/Dropbox/lahey/api/.venv/lib/python3.6/site-pack
>>>>>>> ages/sqlalchemy/orm/session.py", line 2237, in flush
>>>>>>> self._flush(objects)
>>>>>>> File "/Users/hugo/Dropbox/lahey/api/.venv/lib/python3.6/site-pack
>>>>>>> ages/sqlalchemy/orm/session.py", line 2363, in _flush
>>>>>>> transaction.rollback(_capture_exception=True)
>>>>>>> File "/Users/hugo/Dropbox/lahey/api/.venv/lib/python3.6/site-pack
>>>>>>> ages/sqlalchemy/util/langhelpers.py", line 66, in __exit__
>>>>>>> compat.reraise(exc_type, exc_value, exc_tb)
>>>>>>> File "/Users/hugo/Dropbox/lahey/api/.venv/lib/python3.6/site-pack
>>>>>>> ages/sqlalchemy/util/compat.py", line 187, in reraise
>>>>>>> raise value
>>>>>>> File "/Users/hugo/Dropbox/lahey/api/.venv/lib/python3.6/site-pack
>>>>>>> ages/sqlalchemy/orm/session.py", line 2327, in _flush
>>>>>>> flush_context.execute()
>>>>>>> File "/Users/hugo/Dropbox/lahey/api/.venv/lib/python3.6/site-pack
>>>>>>> ages/sqlalchemy/orm/unitofwork.py", line 370, in execute
>>>>>>> postsort_actions = self._generate_actions()
>>>>>>> File "/Users/hugo/Dropbox/lahey/api/.venv/lib/python3.6/site-pack
>>>>>>> ages/sqlalchemy/orm/unitofwork.py", line 329, in _generate_actions
>>>>>>> if action.execute(self):
>>>>>>> File "/Users/hugo/Dropbox/lahey/api/.venv/lib/python3.6/site-pack
>>>>>>> ages/sqlalchemy/orm/unitofwork.py", line 454, in execute
>>>>>>> self.dependency_processor.presort_deletes(uow, delete_states)
>>>>>>> File "/Users/hugo/Dropbox/lahey/api/.venv/lib/python3.6/site-pack
>>>>>>> ages/sqlalchemy/orm/dependency.py", line 419, in presort_deletes
>>>>>>> self._passive_delete_flag)
>>>>>>> File "/Users/hugo/Dropbox/lahey/api/.venv/lib/python3.6/site-pack
>>>>>>> ages/sqlalchemy/orm/unitofwork.py", line 225, in
>>>>>>> get_attribute_history
>>>>>>> attributes.LOAD_AGAINST_COMMITTED)
>>>>>>> File "/Users/hugo/Dropbox/lahey/api/.venv/lib/python3.6/site-pack
>>>>>>> ages/sqlalchemy/orm/attributes.py", line 928, in get_history
>>>>>>> current = self.get(state, dict_, passive=passive)
>>>>>>> File "/Users/hugo/Dropbox/lahey/api/.venv/lib/python3.6/site-pack
>>>>>>> ages/sqlalchemy/orm/attributes.py", line 603, in get
>>>>>>> value = self.callable_(state, passive)
>>>>>>> File "/Users/hugo/Dropbox/lahey/api/.venv/lib/python3.6/site-pack
>>>>>>> ages/sqlalchemy/orm/strategies.py", line 623, in _load_for_state
>>>>>>> return self._emit_lazyload(session, state, ident_key, passive)
>>>>>>> File "<string>", line 1, in <lambda>
>>>>>>> File "/Users/hugo/Dropbox/lahey/api/.venv/lib/python3.6/site-pack
>>>>>>> ages/sqlalchemy/orm/strategies.py", line 747, in _emit_lazyload
>>>>>>> result = q(session).params(**params).all()
>>>>>>> File
>>>>>>> "/Users/hugo/Dropbox/lahey/api/.venv/lib/python3.6/site-packages/sqlalchemy/ext/baked.py",
>>>>>>> line 399, in all
>>>>>>> return list(self)
>>>>>>> File
>>>>>>> "/Users/hugo/Dropbox/lahey/api/.venv/lib/python3.6/site-packages/sqlalchemy/ext/baked.py",
>>>>>>> line 296, in __iter__
>>>>>>> baked_context = bq._bake(self.session)
>>>>>>> File
>>>>>>> "/Users/hugo/Dropbox/lahey/api/.venv/lib/python3.6/site-packages/sqlalchemy/ext/baked.py",
>>>>>>> line 198, in _bake
>>>>>>> query = self._as_query(session)
>>>>>>> File
>>>>>>> "/Users/hugo/Dropbox/lahey/api/.venv/lib/python3.6/site-packages/sqlalchemy/ext/baked.py",
>>>>>>> line 221, in _as_query
>>>>>>> query = step(query)
>>>>>>> File "/Users/hugo/Dropbox/lahey/api/.venv/lib/python3.6/site-pack
>>>>>>> ages/sqlalchemy/orm/strategies.py", line 727, in <lambda>
>>>>>>> strategy_options.Load.for_existing_path(
>>>>>>> File "/Users/hugo/Dropbox/lahey/api/.venv/lib/python3.6/site-pack
>>>>>>> ages/sqlalchemy/util/langhelpers.py", line 977, in __getattr__
>>>>>>> attr = getattr(self.module, key)
>>>>>>> File "/Users/hugo/Dropbox/lahey/api/.venv/lib/python3.6/site-pack
>>>>>>> ages/sqlalchemy/util/langhelpers.py", line 767, in __get__
>>>>>>> obj.__dict__[self.__name__] = result = self.fget(obj)
>>>>>>> File "/Users/hugo/Dropbox/lahey/api/.venv/lib/python3.6/site-pack
>>>>>>> ages/sqlalchemy/util/langhelpers.py", line 962, in module
>>>>>>> % (self._il_path, self._il_addtl))
>>>>>>> ImportError: importlater.resolve_all() hasn't been called (this is
>>>>>>> sqlalchemy.orm strategy_options)
>>>>>>
>>>>>>
>>>>>>
>>>>>> My model declaration for this object looks like this:
>>>>>> import datetime
>>>>>> from sqlalchemy_utils.types.password import PasswordType
>>>>>> from sqlalchemy_utils import force_auto_coercion
>>>>>>
>>>>>> from app.extensions import db
>>>>>>
>>>>>> # Setup coercion of passwords
>>>>>> force_auto_coercion()
>>>>>>
>>>>>>
>>>>>> class User(db.Model):
>>>>>> id = db.Column(db.Integer, primary_key=True)
>>>>>> email = db.Column(db.String(120), unique=True, nullable=False)
>>>>>> password = db.Column(PasswordType(schemes=['pbkdf2_sha512']),
>>>>>> nullable=False)
>>>>>> name = db.Column(db.String(256))
>>>>>> created_at = db.Column(db.DateTime, default=datetime.datetime.now)
>>>>>> updated_at = db.Column(db.DateTime, onupdate=datetime.datetime.now)
>>>>>>
>>>>>> I can delete objects of other models without trouble. I've tried to
>>>>>> follow the code in the traceback, but can't really make sense of it.
>>>>>> Could this have something to do with the PasswordType column from
>>>>>> sqlalchemy_utils?
>>>>>>
>>>>>> Help is much appreciated!
>>>>>>
>>>>>> /Hugo
>>>>>>
>>>>>> --
>>>>>> SQLAlchemy -
>>>>>> The Python SQL Toolkit and Object Relational Mapper
>>>>>>
>>>>>> http://www.sqlalchemy.org/
>>>>>>
>>>>>> To post example code, please provide an MCVE: Minimal, Complete, and
>>>>>> Verifiable Example. See http://stackoverflow.com/help/mcve for a
>>>>>> full description.
>>>>>> ---
>>>>>> You received this message because you are subscribed to the Google
>>>>>> Groups "sqlalchemy" group.
>>>>>> To unsubscribe from this group and stop receiving emails from it,
>>>>>> send an email to [email protected].
>>>>>> To post to this group, send email to [email protected].
>>>>>> Visit this group at https://groups.google.com/group/sqlalchemy.
>>>>>> For more options, visit https://groups.google.com/d/optout.
>>>>>>
>>>>> --
>>>>> SQLAlchemy -
>>>>> The Python SQL Toolkit and Object Relational Mapper
>>>>>
>>>>> http://www.sqlalchemy.org/
>>>>>
>>>>> To post example code, please provide an MCVE: Minimal, Complete, and
>>>>> Verifiable Example. See http://stackoverflow.com/help/mcve for a full
>>>>> description.
>>>>> ---
>>>>> You received this message because you are subscribed to a topic in the
>>>>> Google Groups "sqlalchemy" group.
>>>>> To unsubscribe from this topic, visit https://groups.google.com/d/to
>>>>> pic/sqlalchemy/kz47tCpbf-A/unsubscribe.
>>>>> To unsubscribe from this group and all its topics, send an email to
>>>>> [email protected].
>>>>> To post to this group, send email to [email protected].
>>>>> Visit this group at https://groups.google.com/group/sqlalchemy.
>>>>> For more options, visit https://groups.google.com/d/optout.
>>>>>
>>>>
>>>> --
>>>> SQLAlchemy -
>>>> The Python SQL Toolkit and Object Relational Mapper
>>>>
>>>> http://www.sqlalchemy.org/
>>>>
>>>> To post example code, please provide an MCVE: Minimal, Complete, and
>>>> Verifiable Example. See http://stackoverflow.com/help/mcve for a full
>>>> description.
>>>> ---
>>>> You received this message because you are subscribed to the Google
>>>> Groups "sqlalchemy" group.
>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>> an email to [email protected].
>>>> To post to this group, send email to [email protected].
>>>> Visit this group at https://groups.google.com/group/sqlalchemy.
>>>> For more options, visit https://groups.google.com/d/optout.
>>>>
>>> --
>>> SQLAlchemy -
>>> The Python SQL Toolkit and Object Relational Mapper
>>>
>>> http://www.sqlalchemy.org/
>>>
>>> To post example code, please provide an MCVE: Minimal, Complete, and
>>> Verifiable Example. See http://stackoverflow.com/help/mcve for a full
>>> description.
>>> ---
>>> You received this message because you are subscribed to a topic in the
>>> Google Groups "sqlalchemy" group.
>>> To unsubscribe from this topic, visit https://groups.google.com/d/to
>>> pic/sqlalchemy/kz47tCpbf-A/unsubscribe.
>>> To unsubscribe from this group and all its topics, send an email to
>>> [email protected].
>>> To post to this group, send email to [email protected].
>>> Visit this group at https://groups.google.com/group/sqlalchemy.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>> --
>> SQLAlchemy -
>> The Python SQL Toolkit and Object Relational Mapper
>>
>> http://www.sqlalchemy.org/
>>
>> To post example code, please provide an MCVE: Minimal, Complete, and
>> Verifiable Example. See http://stackoverflow.com/help/mcve for a full
>> description.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "sqlalchemy" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to [email protected].
>> To post to this group, send email to [email protected].
>> Visit this group at https://groups.google.com/group/sqlalchemy.
>> For more options, visit https://groups.google.com/d/optout.
>>
> --
> SQLAlchemy -
> The Python SQL Toolkit and Object Relational Mapper
>
> http://www.sqlalchemy.org/
>
> To post example code, please provide an MCVE: Minimal, Complete, and
> Verifiable Example. See http://stackoverflow.com/help/mcve for a full
> description.
> ---
> You received this message because you are subscribed to a topic in the
> Google Groups "sqlalchemy" group.
> To unsubscribe from this topic, visit https://groups.google.com/d/
> topic/sqlalchemy/kz47tCpbf-A/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> [email protected].
> To post to this group, send email to [email protected].
> Visit this group at https://groups.google.com/group/sqlalchemy.
> For more options, visit https://groups.google.com/d/optout.
>
--
SQLAlchemy -
The Python SQL Toolkit and Object Relational Mapper
http://www.sqlalchemy.org/
To post example code, please provide an MCVE: Minimal, Complete, and Verifiable
Example. See http://stackoverflow.com/help/mcve for a full description.
---
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
