#python-mysql

[softshareblog-blog]

Python3 之操作主流資料庫MySQL/MongoDB

課程簡介

教大家使用PyMySQL，SQLAlchemy，PyMongoDB, MongoEngine等知名Python 程式庫

(more…)

View On WordPress

[fixerror-blog]

Fix "Unable to find vcvarsall.bat" on Windows

I found the answer to resolve it from Stackoverflow, here is how to Fix it:

For Windows installations:

While running setup.py for package installations Python 2.7 searches for an installed Visual Studio 2008. You can trick Python to use a newer Visual Studio by setting the correct path in VS90COMNTOOLS environment variable before calling setup.py.

If you have Visual Studio 2010 installed, execute

SET VS90COMNTOOLS=%VS100COMNTOOLS%

or with Visual Studio 2012 installed

SET VS90COMNTOOLS=%VS110COMNTOOLS%

Another way to resolve this problem

I found the solution. I had the exact same problem, and error, installing 'amara'. I had mingw32 installed, but distutils needed to be configured.

I have Python 2.6 that was already installed.

I installed mingw32 toC:\programs\mingw\

Add mingw32's bin directory to your environment variable: appendc:\programs\MinGW\bin;to thePATH

Edit (create if not existing)distutils.cfgfile located atC:\Python26\Lib\distutils\distutils.cfgto be:

[build] compiler=mingw32

Now runeasy_install.exe amara.

Make sure environment is set by opening a newcmd.exe.

Link

[criticus-ua]

Setting up Django with Mysql on Mac OS X Lion

Three days and I finally were able to set it up on my mac. I tried tons different ways, installed tons different versions of everything, almost gave up and went to take a drink with a good friend of mine somewhere in the Cobble Hill, Brooklyn.

- Are you still use macports to install software? Try HomeBrew, - she advised

- Home what?

- HomeBrew is the new way to install everything on the mac

Well, I was too skeptic after all this time fighting with mysql and python but decided to give homebrew a try. I searched (can't say googled as I use duckduckgo and it's not the easiest word to create a verb) it and loved their ads "MacPorts driving you to drink? Try Homebrew!". This was so true. And I tried.

Here is my steps.

install Homebrew

ruby -e "$(curl -fsSkL raw.github.com/mxcl/homebrew/go)"

check if there are any software that homebrew needs to work

brew doctor

I had to upgrade my Xcode to 4.5. Then update homebrew itself

brew update

Check is anything is outdated

brew outdated

Upgrade everything with

brew upgrade

Install git

brew install git

Install python. First run the following

brew install readline sqlite gdbm

Then python itself

brew install python --universal --framework 

Install pip. You would need it to install python packages

 easy_install pip

Install virtualenv. It's just better to have your python environments isolated for the development.

 pip install virtualenv

Now we need to create a virtual environment for our django project. Create a folder (I created my_django_project)

mkdir my_django_project

Go inside the folder

cd my_django_project

And start a virtual environment (I named it my_env, you can use any names)

virtualenv my_env --no-site-packages

Run your environment

source my_env/bin/activate 

What next? Yeah, Django. We already have pip so we can use it install django

pip install django

And we still have to install mysql

brew install mysql

And python connector to mysql

pip install http://downloads.sourceforge.net/project/mysql-python/mysql-python-test/1.2.3c1/MySQL-python-1.2.3c1.tar.gz?use_mirror=cdnetworks-us-2

To start using mysql we have to setup our systems databases

unset TMPDIR

mysql_install_db --verbose --user=`whoami` --basedir="$(brew --prefix mysql)" --datadir=/usr/local/var/mysql --tmpdir=/tmp

To test if it has been setup correctly try to start mysql server

mysql.server start

It didn't want to start for me until I rebooted the mac. After reboot it started successfully. I go to python shell to check that mysql connector is working

python

>>>import MySQLdb()

>>>

That's it! Activate virtual environment 

source my_env/bin/activate

And create your django project

django-admin.py startproject my_project

Many thanks to seanlin.me for the instructions!

[tomomoi]

virtualenv: Getting error when installing python-mysql

Here's a possible way on fixing the error you encounter when installing python-mysql inside the virtualenv.

Error:

   ... metadata, options = get_config()

  File "setup_posix.py", line 43, in get_config

    libs = mysql_config("libs_r")

  File "setup_posix.py", line 24, in mysql_config

    raise EnvironmentError("%s not found" % (mysql_config.path,))

EnvironmentError: mysql_config not found

Solution:

(Install the following packages)

sudo apt-get install python-mysqldb

sudo apt-get install libmysqlclient16

sudo apt-get install libmysqlclient-dev