Closed arianmaykon closed 8 years ago
ergo
commented
8 years ago I don't think wiki tutorial uses ziggurat? I will be looking into this issue as soon as possible, also @arianmaykon can you check if this happens on trunk version? I've been correcting some problems directly related to mysql.
ergo
commented
8 years ago @arianmaykon - I've released 0.6.3 on pypi - I ran all tests from this version on mysql and they all passed so I'm closing this.
Feel free to reopen if you still have problems on latest release.
arianmaykon
commented
8 years ago @ergo Ok, thanks a lot. I know the Wiki2 tutorial dont use ziggurat, but i was trying out with it. Thanks.
arianmaykon
commented
8 years ago @ergo sorry, i've upgraded zigurat but the error persists, i've made some fixes on the migrations (i know its not a good practice, but what can we do? I'm not very experienced with Python and its tools, maybe its my environment or my alembic version?
Here's the output of my pip list:
$VENV/bin/pip list
alembic (0.8.6)
anykeystore (0.2)
bcrypt (2.0.0)
beautifulsoup4 (4.4.1)
cffi (1.5.2)
Chameleon (2.24)
coverage (4.0.3)
defusedxml (0.4.1)
docutils (0.12)
Jinja2 (2.8)
Mako (1.0.4)
MarkupSafe (0.23)
mysqlclient (1.3.7)
oauthlib (1.0.3)
paginate (0.5.3)
paginate-sqlalchemy (0.2.0)
passlib (1.6.5)
PasteDeploy (1.5.2)
pip (8.1.1)
py (1.4.31)
pycparser (2.14)
Pygments (2.1.3)
pymlconf (0.3.21)
pyramid (1.6.1)
pyramid-basemodel (0.3.4)
pyramid-chameleon (0.3)
pyramid-debugtoolbar (2.4.2)
pyramid-fullauth (0.5.0)
pyramid-jinja2 (2.6.2)
pyramid-localize (0.1.0)
pyramid-mako (1.0.2)
pyramid-tm (0.12.1)
pytest (2.9.1)
pytest-cov (2.2.1)
python-editor (1.0)
python3-openid (3.0.10)
PyYAML (3.11)
repoze.lru (0.6)
requests (2.9.1)
requests-oauthlib (0.6.1)
setuptools (20.9.0)
six (1.10.0)
slugify (0.0.1)
SQLAlchemy (1.0.12)
transaction (1.4.4)
translationstring (1.3)
tzf.pyramid-yml (1.0.1)
velruse (1.1.1)
venusian (1.0)
waitress (0.9.0)
WebOb (1.6.0)
WebTest (2.0.21)
ziggurat-foundations (0.6.3)
zope.deprecation (4.1.2)
zope.interface (4.1.3)
zope.sqlalchemy (0.7.6)I'll make a PR with the migrations fixes if you decide its a good idea to merge them. Let me know if you need anything.
ergo
commented
8 years ago What happens if you do:
DB_STRING="mysql+mysqlconnector://user:pass@127.0.0.1:3306/dbname" py.test ziggurat_foundations/tests.py
Are the tests passing for you?
ergo
commented
8 years ago I tried running the testsuite on Mysql 5.6.28 and all tests passed - including migrations.
arianmaykon
commented
8 years ago Sorry for this, but how do i run the tests? Did not find instructions on the repo files.
Here's what i have tryied:
cd ziggurat_foundations
pyenv shell 3.5.1
python -m venv .venv
.venv/bin/python setup.py develop
DB_STRING="mysql+mysqlconnector://root@127.0.0.1:3306/ziggurat" py.test ziggurat_foundations/tests.pybut it gives me:
zsh: command not found: py.testits not in .venv/bin too.
I have tried that too:
./test.shbut it returns:
find: -printf: unknown primary or operator
./test.sh: line 9: rstcheck: command not found
RST_CHECK: ./test.sh: line 9: rstcheck: command not found
FLAKE8: OKYou almost got it.
after you run the command:
venv/bin/python setup.py develop
run this:
source venv/bin/activate
this should active the virtual environment in your shell,
then you need to install
pip install http://cdn.mysql.com/Downloads/Connector-Python/mysql-connector-python-2.0.4.zip#md5=3df394d89300db95163f17c843ef49df
to get the mysql driver from Oracle.
DB_STRING="mysql+mysqlconnector://root@127.0.0.1:3306/ziggurat" py.test ziggurat_foundations/tests.py
should work then.
ergo
commented
8 years ago Ok... I replicated the problem on 5.7.12, the tests stopped working.
ergo
commented
8 years ago @arianmaykon I've merged your fix, can you make a PR and update AUTHORS file with your name? If you do this I will release 0.6.4 to pypi. Thank you very much. I would still advise to use postgresql, they don't have that kind of weird changes across versions :-)
arianmaykon
commented
8 years ago @ergo i did run source venv/bin/activate but forgot to mention, sorry.
Ok, ill make the change, thanks a lot.
ergo
commented
8 years ago @arianmaykon 0.6.4 is now released to pypi. Thank you.
Following https://ziggurat-foundations.readthedocs.org/en/latest/configuration.html#configure-ziggurat-with-pyramid-framework on the Wiki2 Pyramid Tutorial gives some errors on the initial migration step ($VENV/bin/alembic upgrade head).
I'm using Python 3.5.1 and Pyramid 1.6.1, here's the output: