Windows 64位安装SQLObject

最新推荐文章于 2021-03-27 01:46:25 发布

Bob Liu

最新推荐文章于 2021-03-27 01:46:25 发布

阅读量1.3k

点赞数 1

分类专栏： Python 文章标签： SQLObject installation

本文链接：https://blog.csdn.net/jinguangliu/article/details/44059907

版权

Python 专栏收录该内容

35 篇文章 1 订阅

订阅专栏

简介

SQLObject是一款对象关系映射器，用来将数据库表封装成Python的类，列封装为Python对象实例。目前支持MySQL、PostgreSQL，SQLite，Firebird，MaxDB(SAP DB)，MS SQL Sybase和Rdbhost等数据库。

SQLObject最新的发布版本为2.1.0版本，支持Python 2.6，2.7；开发中的3.0版本开始支持Python 3.4+。本文介绍在Win7 64位系统上基于源码安装SQLObject 2.1.0。

安装

SQLObject依赖MySQLdb包，所以需要首先安装MySQLdb

安装MySQLdb

1. 安装Microsoft Visual C++ Compiler for Python 2.7： http://www.microsoft.com/en-us/download/details.aspx?id=44266

2. 安装MySQL Connector/C： http://dev.mysql.com/downloads/connector/c/6.0.html

如果是64位的Windows系统，需要将MySQL Connector C 6.0.2从C:\Program Files\MySQL拷贝到C:\Program Files (x86)\MySQL目录下

3. 下载MySQLdb： https://github.com/farcepest/MySQLdb1/releases/tag/MySQLdb-1.2.5，解压后进入对应的跟目录，运行"python setup.py install"。安装成功的提示信息如下：

copying MySQL_python.egg-info\top_level.txt -> build\bdist.win-amd64\egg\EGG-INF
O
writing build\bdist.win-amd64\egg\EGG-INFO\native_libs.txt
zip_safe flag not set; analyzing archive contents...
creating dist
creating 'dist\MySQL_python-1.2.5-py2.7-win-amd64.egg' and adding 'build\bdist.w
in-amd64\egg' to it
removing 'build\bdist.win-amd64\egg' (and everything under it)
Processing MySQL_python-1.2.5-py2.7-win-amd64.egg
Copying MySQL_python-1.2.5-py2.7-win-amd64.egg to c:\python27\lib\site-packages
Adding MySQL-python 1.2.5 to easy-install.pth file

Installed c:\python27\lib\site-packages\mysql_python-1.2.5-py2.7-win-amd64.egg
Processing dependencies for MySQL-python==1.2.5
Finished processing dependencies for MySQL-python==1.2.5

安装SQLObject

目前供下载release版本，可以从下面的链接地址 https://github.com/sqlobject/sqlobject/releases查看并下载。下载2.1.0版本可以从地址 https://github.com/sqlobject/sqlobject/releases/tag/2.1.0直接下载zip源码包。

解压下载的源码包，进入对应的根目录，执行"python setup.py install"命令，最终显示下面信息时，表示安装成功：

Extracting SQLObject-2.1.0-py2.7.egg to c:\python27\lib\site-packages
SQLObject 2.1.0 is already the active version in easy-install.pth
Installing sqlobject-admin script to C:\Python27\Scripts
Installing sqlobject-convertOldURI script to C:\Python27\Scripts

Installed c:\python27\lib\site-packages\sqlobject-2.1.0-py2.7.egg
Processing dependencies for SQLObject==2.1.0
Searching for formencode==1.3.0
Best match: formencode 1.3.0
Processing formencode-1.3.0-py2.7.egg
formencode 1.3.0 is already the active version in easy-install.pth

Using c:\python27\lib\site-packages\formencode-1.3.0-py2.7.egg
Finished processing dependencies for SQLObject==2.1.0