Hi Learner,
you must change the driver in your scripts.
Check:
http://docs.sqlalchemy.org/en/latest/core/engines.html?highlight=engine#supported-databases
Stefano.
Il 28/05/12 22.33, Learner ha scritto:
Hi Atsushi,
Thanks. I installed PyMySQL now and modified setup.py to include
pymysql library. But Pyramid is still looking for "MysqlDB" module.
May be I am missing something? Please excuse my novice skills
Log trace
(pyramid) D:\learner\python\pyramid\projects\tutorial>pserve
development.ini --reload
Starting subprocess with file monitor
Traceback (most recent call last):
File "D:\learner\python\pyramid\Scripts\pserve-script.py", line 8,
in<module>
load_entry_point('pyramid==1.3.2', 'console_scripts', 'pserve')()
File "D:\learner\python\pyramid\lib\site-packages\pyramid-1.3.2-
py2.7.egg\pyramid\scripts\pserve.py", line 47, in main
return command.run()
File "D:\learner\python\pyramid\lib\site-packages\pyramid-1.3.2-
py2.7.egg\pyramid\scripts\pserve.py", line 290, in run
relative_to=base, global_conf=vars)
File "D:\learner\python\pyramid\lib\site-packages\pyramid-1.3.2-
py2.7.egg\pyramid\scripts\pserve.py", line 318, in loadapp
return loadapp(app_spec, name=name, relative_to=relative_to, **kw)
File "D:\learner\python\pyramid\lib\site-packages\pastedeploy-1.5.0-
py2.7.egg\paste\deploy\loadwsgi.py", line 247, in loadapp
return loadobj(APP, uri, name=name, **kw)
File "D:\learner\python\pyramid\lib\site-packages\pastedeploy-1.5.0-
py2.7.egg\paste\deploy\loadwsgi.py", line 272, in loadobj
return context.create()
File "D:\learner\python\pyramid\lib\site-packages\pastedeploy-1.5.0-
py2.7.egg\paste\deploy\loadwsgi.py", line 710, in create
return self.object_type.invoke(self)
File "D:\learner\python\pyramid\lib\site-packages\pastedeploy-1.5.0-
py2.7.egg\paste\deploy\loadwsgi.py", line 146, in invoke
return fix_call(context.object, context.global_conf,
**context.local_conf)
File "D:\learner\python\pyramid\lib\site-packages\pastedeploy-1.5.0-
py2.7.egg\paste\deploy\util.py", line 56, in fix_call
val = callable(*args, **kw)
File "d:\learner\python\pyramid\projects\tutorial\tutorial
\__init__.py", line 9, in main
engine = engine_from_config(settings, 'sqlalchemy.')
File "build\bdist.win32\egg\sqlalchemy\engine\__init__.py", line
354, in engine_from_config
File "build\bdist.win32\egg\sqlalchemy\engine\__init__.py", line
336, in create_engine
File "build\bdist.win32\egg\sqlalchemy\engine\strategies.py", line
64, in create
File "build\bdist.win32\egg\sqlalchemy\connectors\mysqldb.py", line
52, in dbapi
ImportError: No module named MySQLdb
Any response is much appreciated
cheers
-bkumar
On May 28, 7:29 am, Atsushi Odagiri<[email protected]> wrote:
Hi
I'm using PyMySQL for MySQL Driver.
It's pure python, so you don't need compile that.
Cheers
2012/5/28 Chris Lambacher<[email protected]>
It looks like it is going to try to build MySQL-python from c source. The
error may be because of a missing compiler or maybe the MySQL header file
or .lib file is missing.
Seehttp://stackoverflow.com/questions/645943/mysql-for-python-in-windowsforinstructions
on getting MySQL-python for windows installed on your
system. Note, if you are working against a virtualenv (you are if you are
following the tutorial), you can easy_install the downloaded exe installer
to get it in your virtualenv.
-Chris
On Sunday, May 27, 2012, Learner wrote:
Hello All,
I just started learning Pyramid& Python together. Pyramid
documentation is amazing, step by step instructions are really
helpful for a basic learner like me.
I created a simple Pyramid (SqlAlchemy) application using
http://docs.pylonsproject.org/projects/pyramid/en/1.3-branch/tutorial...
documentation. Now I want to switch from SqlLite to MySql. So I made
below changes to my application
development.ini
----------------------
sqlalchemy.url = mysql://root:welcome@localhost/deals
Added python-mysql to setup.py
-----------------------------------------------
requires = [
'pyramid',
'mysql-python',
'SQLAlchemy',
'transaction',
'pyramid_tm',
'pyramid_debugtoolbar',
'zope.sqlalchemy',
'waitress',
]
Now when I try to install the application using "python setup.py
develop", I get "error: The system cannot find the file specified"
error.
I tried copying mysql dll file to python bin directory thinking mysql
is not accessible from python& searched on the web but no luck.
Any help is much appreciated. Thanks for your time.
Complete execution details
(pyramid) D:\learner\python\pyramid\projects\tutorial>python setup.py
develop
running develop
running egg_info
writing requirements to tutorial.egg-info\requires.txt
writing tutorial.egg-info\PKG-INFO
writing top-level names to tutorial.egg-info\top_level.txt
writing dependency_links to tutorial.egg-info\dependency_links.txt
writing entry points to tutorial.egg-info\entry_points.txt
reading manifest file 'tutorial.egg-info\SOURCES.txt'
reading manifest template 'MANIFEST.in'
warning: no files found matching '*.rst'
warning: no files found matching '*.jpg' under directory 'tutorial'
warning: no files found matching '*.txt' under directory 'tutorial'
warning: no files found matching '*.mak' under directory 'tutorial'
warning: no files found matching '*.mako' under directory 'tutorial'
warning: no files found matching '*.js' under directory 'tutorial'
warning: no files found matching '*.html' under directory 'tutorial'
warning: no files found matching '*.xml' under directory 'tutorial'
writing manifest file 'tutorial.egg-info\SOURCES.txt'
running build_ext
Creating d:\learner\python\pyramid\lib\site-packages\tutorial.egg-link
(link to .)
tutorial 0.0 is already the active version in easy-install.pth
Installing initialize_tutorial_db-script.py script to D:\learner\python
\pyramid\Scripts
Installing initialize_tutorial_db.exe script to D:\learner\python
\pyramid\Scripts
Installing initialize_tutorial_db.exe.manifest script to D:\learner
\python\pyramid\Scripts
Installed d:\learner\python\pyramid\projects\tutorial
Processing dependencies for tutorial==0.0
Searching for mysql-python
Readinghttp://pypi.python.org/simple/mysql-python/
Readinghttp://sourceforge.net/projects/mysql-python/
Readinghttp://sourceforge.net/projects/mysql-python
Best match: MySQL-python 1.2.3
Downloading
http://download.sourceforge.net/sourceforge/mysql-python/MySQL-python...
Processing MySQL-python-1.2.3.tar.gz
Running MySQL-python-1.2.3\setup.py -q bdist_egg --dist-dir c:\users
\learner\appdata\local\temp\easy_install-klhsdv\MySQL-python-1.2.3\egg-
dist-tmp-whnjbg
error: The system cannot find the file specified
cheers
Completed
--
You received this message because you are subscribed to the Google Groups
"pylons-discuss" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/pylons-discuss?hl=en.
--
Christopher Lambacher
[email protected]
--
You received this message because you are subscribed to the Google Groups
"pylons-discuss" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/pylons-discuss?hl=en.
--
/*
Atsushi Odagirihttp://blog.aodag.jp
mailto:[email protected]
*/
--
Stefano Fontanelli
Asidev S.r.l.
Viale Rinaldo Piaggio, 32 - 56025 Pontedera (Pisa)
Tel. (+39) 333 36 53 294
Fax. (+39) 0587 97 01 20
E-mail: [email protected]
Skype: stefanofontanelli
Twitter: @stefontanelli
LinkedIn: http://it.linkedin.com/in/stefanofontanelli
--
You received this message because you are subscribed to the Google Groups
"pylons-discuss" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/pylons-discuss?hl=en.
