Traceback (most recent call last):
File "/home/bastian/workspace/avernus/avernus/gui/threads.py", line 36, in run
for ret in self.generator(self.args):
File "/home/bastian/workspace/avernus/avernus/controller/chart_controller.py", line 427, in calculate_values
Traceback (most recent call last):
File "/home/bastian/workspace/avernus/avernus/gui/threads.py", line 36, in run
for ret in self.generator(self.args):
File "/home/bastian/workspace/avernus/avernus/controller/chart_controller.py", line 362, in calculate_values
self.items = pf.get_transactions() + pf.get_dividends()
data[item] = pf.get_current_value()
File "/home/bastian/workspace/avernus/avernus/objects/container.py", line 144, in get_current_value
File "/home/bastian/workspace/avernus/avernus/objects/container.py", line 119, in get_transactions
for pos in self:
File "/home/bastian/workspace/avernus/avernus/objects/container.py", line 244, in __iter__
return self.positions.__iter__()
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/attributes.py", line 168, in __get__
return self.impl.get(instance_state(instance),dict_)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/attributes.py", line 453, in get
value = self.callable_(state, passive)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/strategies.py", line 508, in _load_for_state
return self._emit_lazyload(session, state, ident_key)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/strategies.py", line 574, in _emit_lazyload
result = q.all()
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2115, in all
for pos in self:
File "/home/bastian/workspace/avernus/avernus/objects/container.py", line 244, in __iter__
return self.positions.__iter__()
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/attributes.py", line 168, in __get__
return self.impl.get(instance_state(instance),dict_)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/attributes.py", line 453, in get
value = self.callable_(state, passive)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/strategies.py", line 508, in _load_for_state
return self._emit_lazyload(session, state, ident_key)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/strategies.py", line 574, in _emit_lazyload
result = q.all()
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2115, in all
return list(self)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2348, in instances
rows = [process[0](row, None) for row in fetch]
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/mapper.py", line 2123, in _instance
return list(self)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2348, in instances
state.manager.dispatch.load(state, context)
rows = [process[0](row, None) for row in fetch]
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/event.py", line 377, in __call__
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/mapper.py", line 2123, in _instance
fn(*args, **kw)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/mapper.py", line 2334, in _event_on_load
instrumenting_mapper._reconstructor(state.obj())
File "/home/bastian/workspace/avernus/avernus/objects/position.py", line 115, in _init
state.manager.dispatch.load(state, context)
self.recalculate()
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/event.py", line 377, in __call__
File "/home/bastian/workspace/avernus/avernus/objects/position.py", line 130, in recalculate
fn(*args, **kw)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/mapper.py", line 2334, in _event_on_load
instrumenting_mapper._reconstructor(state.obj())
File "/home/bastian/workspace/avernus/avernus/objects/position.py", line 115, in _init
self.recalculate()
File "/home/bastian/workspace/avernus/avernus/objects/position.py", line 130, in recalculate
for buy_ta in self.get_buy_transactions():
File "/home/bastian/workspace/avernus/avernus/objects/position.py", line 147, in get_buy_transactions
.order_by(asc(portfolio_transaction.BuyTransaction.date)).all()
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2115, in all
return list(self)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2227, in __iter__
return self._execute_and_instances(context)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2242, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1449, in execute
for buy_ta in self.get_buy_transactions():
File "/home/bastian/workspace/avernus/avernus/objects/position.py", line 147, in get_buy_transactions
.order_by(asc(portfolio_transaction.BuyTransaction.date)).all()
params)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2115, in all
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1584, in _execute_clauseelement
return list(self)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2227, in __iter__
compiled_sql, distilled_params
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1651, in _execute_context
return self._execute_and_instances(context)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2242, in _execute_and_instances
None, None)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1647, in _execute_context
result = conn.execute(querycontext.statement, self._params)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1449, in execute
context = constructor(dialect, self, conn, *args)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 446, in _init_compiled
params)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1584, in _execute_clauseelement
compiled_sql, distilled_params
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1651, in _execute_context
None, None)
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1647, in _execute_context
context = constructor(dialect, self, conn, *args)
self.cursor = self.create_cursor()
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 446, in _init_compiled
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 606, in create_cursor
self.cursor = self.create_cursor()
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 606, in create_cursor
return self._dbapi_connection.cursor()
return self._dbapi_connection.cursor()
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 455, in cursor
File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/pool.py", line 455, in cursor
return self.connection.cursor(*args, **kwargs)
return self.connection.cursor(*args, **kwargs)
ProgrammingError: (ProgrammingError) SQLite objects created in a thread can only be used in that same thread.The object was created in thread id 139901510010624 and this is thread id 139900955772672 'SELECT portfolio_transaction.type AS portfolio_transaction_type, portfolio_buy_transaction.id AS portfolio_buy_transaction_id, portfolio_transaction.id AS portfolio_transaction_id, portfolio_transaction.date AS portfolio_transaction_date, portfolio_transaction.quantity AS portfolio_transaction_quantity, portfolio_transaction.price AS portfolio_transaction_price, portfolio_transaction.cost AS portfolio_transaction_cost, portfolio_transaction.position_id AS portfolio_transaction_position_id \nFROM portfolio_transaction JOIN portfolio_buy_transaction ON portfolio_transaction.id = portfolio_buy_transaction.id \nWHERE ? = portfolio_transaction.position_id ORDER BY portfolio_transaction.date ASC' [immutabledict({})]
ProgrammingError: (ProgrammingError) SQLite objects created in a thread can only be used in that same thread.The object was created in thread id 139901510010624 and this is thread id 139900947379968 'SELECT portfolio_transaction.type AS portfolio_transaction_type, portfolio_buy_transaction.id AS portfolio_buy_transaction_id, portfolio_transaction.id AS portfolio_transaction_id, portfolio_transaction.date AS portfolio_transaction_date, portfolio_transaction.quantity AS portfolio_transaction_quantity, portfolio_transaction.price AS portfolio_transaction_price, portfolio_transaction.cost AS portfolio_transaction_cost, portfolio_transaction.position_id AS portfolio_transaction_position_id \nFROM portfolio_transaction JOIN portfolio_buy_transaction ON portfolio_transaction.id = portfolio_buy_transaction.id \nWHERE ? = portfolio_transaction.position_id ORDER BY portfolio_transaction.date ASC' [immutabledict({})]