Help with sqlalchemy error

[meraki-analytics]

Help with sqlalchemy error

[robrua]

Based on this code block store.__sa_bound = True is almost certainly your problem. The sqlalchemy bindings aren't getting set up because you're telling it that's already been done when it hasn't yet. If you remove that it'll hopefully work properly.

In general in Python you should treat attributes that begin with underscores as "for internal use", and never change them from outside the defining class/module without knowing exactly how they work (and having a good reason). You can read more about this in PEP 8.

[dantedog]

Ah, right. I had tried toggling that in order to get around

/home/devin/.virtualenvs/lol/bin/python /home/devin/PycharmProjects/lol/store_test.py
Traceback (most recent call last):
  File "/home/devin/PycharmProjects/lol/store_test.py", line 12, in <module>
    password="password")
  File "/home/devin/.virtualenvs/lol/lib/python3.4/site-packages/cassiopeia/type/api/store.py", line 211, in __init__
    _sa_bind_typesystem()
  File "/home/devin/.virtualenvs/lol/lib/python3.4/site-packages/cassiopeia/type/api/store.py", line 301, in _sa_bind_typesystem
    cassiopeia.type.dto.championmastery._sa_bind_all()
  File "/home/devin/.virtualenvs/lol/lib/python3.4/site-packages/cassiopeia/type/dto/championmastery.py", line 56, in _sa_bind_all
    _sa_bind_champion_mastery()
  File "/home/devin/.virtualenvs/lol/lib/python3.4/site-packages/cassiopeia/type/dto/championmastery.py", line 42, in _sa_bind_champion_mastery
    class ChampionMastery(ChampionMastery, cassiopeia.type.dto.common.BaseDB):
  File "/home/devin/.virtualenvs/lol/lib/python3.4/site-packages/cassiopeia/type/dto/championmastery.py", line 52, in ChampionMastery
    playerId = sqlalchemy.Column(sqlalchemy.sqlalchemy.Integer, primary_key=True)
AttributeError: 'module' object has no attribute 'sqlalchemy'

Process finished with exit code 1

Is there something specific required to have it import sqlalchemy?

[robrua]

Ah, you have a version of the code w/a typo in it (the sqlalchemy.sqlalchemy.Integer). This has been fixed and if you pull the latest version off this repo it should work. The change will also be in the next release.

[dantedog]

Thank you so much. One problem down, a lot of learning to go :)

I really appreciate the quick response.