Step-by-Step Guide: Setting Up Python Web Development with webpy on Windows

Python Installation

On Windows, download the appropriate Python installer from the official website; choose Python 2.7 if you plan to use webpy, which requires Python 2.x. After installation, add the Python directory to the system PATH so you can run python from the command line.

Modify the system environment variables via My Computer → Properties → Advanced system settings → Environment Variables → Path and append the Python directory (e.g., C:\Python27).

Eclipse Python Plugin Installation

Install the PyDev plugin in Eclipse: Help → Install New Software → Add, then provide the update site URL for PyDev and follow the prompts. After installation, restart Eclipse, open Window → Preferences → PyDev → Interpreters → Python Interpreter , and point it to your python.exe.

webpy Installation

Download webpy from its official site, extract it into the Python installation directory, and run python setup.py install. If you encounter an ImportError: model utils not exist, edit the generated __init__.py in the web folder to add the package path:

import sys
sys.path.append(yourpath)  # yourpath is the directory where webpy resides

MySQLdb Installation

Download the MySQLdb MSI installer (compatible with Python 2.7 and the same CPU architecture). Ensure the system PATH includes the Python directory; otherwise the installer cannot locate Python. Also match the 32‑bit/64‑bit versions of Python and MySQLdb to avoid the “DLL load failed” error.

SQLAlchemy Installation

Download SQLAlchemy from its website, extract, and install with python setup.py install. It supports both Python 2 and 3. After installation, configure the connection string, for example:

"mysql+mysqldb://" + Const.USERNAME + ":" + Const.PASSWD + "@" + Const.HOST + "/" + Const.DBNAME + "?charset=utf8&use_unicode=0&unix_socket=/tmp/mysql.sock"

Code Example

A minimal webpy application:

Running the script starts a server on port 8080; visiting http://localhost:8080 displays “Hello world”.

The tutorial also covers using webpy's form module, noting that the $def with form line must be the first line in the template, and that the form’s validate() method must be called in the POST handler.

Common Issues

Typical problems include version mismatches between Python, webpy, and MySQLdb; missing PATH entries; permission errors on Linux (solved with sudo); missing mysql_config (resolved by installing libmysqlclient-dev); and SQLAlchemy connection errors caused by an incorrect MySQL socket path, which can be fixed by adjusting the connection string’s unix_socket parameter.

By following the steps above and addressing these pitfalls, you can set up a functional Python web development environment with webpy on Windows.