python2.7安装sqlite3模块

python2.7安装sqlite3模块

 

安装sqlite3

 

尝试使用pip安装，安装失败：

 

[root@uouo123 src]# pip install sqlite3

 

Collecting sqlite3

 

  Using cached sqlite3-99.0.tar.gz

 

    Complete output from command python setup.py egg_info:

 

    Traceback (most recent call last):

 

      File "<string>", line 1, in <module>

 

      File "/tmp/pip-build-GKbPwN/sqlite3/setup.py", line 2, in <module>

 

        raise RuntimeError("Package 'sqlite3' must not be downloaded from pypi")

 

    RuntimeError: Package 'sqlite3' must not be downloaded from pypi

 

    

 

    ----------------------------------------

 

Command "python setup.py egg_info" failed with error code 1 in /tmp/pip-build-GKbPwN/sqlite3/

 

 

 

 

 

下载安装sqlite3

 

[root@uouo123 src]# wget https://sqlite.org/2017/sqlite-autoconf-3190300.tar.gz

 

[root@uouo123 src]# tar -xvf sqlite-autoconf-3190300.tar.gz 

 

[root@uouo123 sqlite-autoconf-3190300]# ./configure --prefix=/usr/local/lib/python2.7/dist-packages/sqlite3

 

[root@uouo123 sqlite-autoconf-3190300]# make && make install

 

安装完毕后发现导入sqlite3仍然失败，只能重装python了

 

>>> import sqlite3

 

Traceback (most recent call last):

 

  File "<stdin>", line 1, in <module>

 

  File "/usr/local/lib/python2.7/sqlite3/__init__.py", line 24, in <module>

 

    from dbapi2 import *

 

  File "/usr/local/lib/python2.7/sqlite3/dbapi2.py", line 28, in <module>

 

    from _sqlite3 import *

 

ImportError: No module named _sqlite3

 

>>> exit()

 

 

 

 

 

修改python安装源文件setup.py

 

[root@uouo123 src]# tar -xvf Python-2.7.14.tgz 

 

[root@uouo123 src]# cd Python-2.7.14    

 

[root@uouo123 Python-2.7.14]# vi setup.py 

 

搜索sqlite3找到第1105行，在其下面加入一行上面我们安装的sqlite3的路径：

 

   1097         # We hunt for #define SQLITE_VERSION "n.n.n"

 

   1098         # We need to find >= sqlite version 3.0.8

 

   1099         sqlite_incdir = sqlite_libdir = None

 

   1100         sqlite_inc_paths = [ '/usr/include',

 

   1101                              '/usr/include/sqlite',

 

   1102                              '/usr/include/sqlite3',

 

   1103                              '/usr/local/include',

 

   1104                              '/usr/local/include/sqlite',

 

   1105                              '/usr/local/include/sqlite3',

 

   1106                              '/usr/local/lib/python2.7/dist-packages/sqlite3',  #新增此行

 

   1107                            ]

 

保存退出。

 

 

 

 

 

 

 

重新编译python2.7

 

 

 

[root@uouo123 Python-2.7.14]# ./configure 

 

[root@uouo123 Python-2.7.14]# make && make install

 

 

 

检查lib文件是否生成

 

 

 

[root@uouo123 Python-2.7.14]# ll /usr/local/lib/python2.7/lib-dynload/_sqlite3.so 

 

-rwxr-xr-x 1 root root 243444 May 30 01:15 /usr/local/lib/python2.7/lib-dynload/_sqlite3.so

 

 

验证sqlite3模块导入是否成功

 

 

 

[root@uouo123 Python-2.7.14]# python

 

Python 2.7.14 (default, May 30 2017, 01:14:38) 

 

[GCC 4.4.7 20120313 (Red Hat 4.4.7-16)] on linux2

 

Type "help", "copyright", "credits" or "license" for more information.

 

>>> import sqlite3

 

>>> exit()

 

[root@uouo123 Python-2.7.14]#