安装pysqlite

最新推荐文章于 2024-08-19 03:11:42 发布

tina_tian1

最新推荐文章于 2024-08-19 03:11:42 发布

阅读量4.1k

点赞数 1

分类专栏： Python

本文链接：https://blog.csdn.net/tina_tian1/article/details/47660479

版权

Python 专栏收录该内容

12 篇文章 0 订阅

订阅专栏

命令如下，如果有以下错误，请参看以下solution.

[root@localhost bin]# pip install pysqlite

Collecting pysqlite

/usr/local/lib/python2.7/site-packages/pip/_vendor/requests/packages/urllib3/util/ssl_.py:90:InsecurePlatformWarning: A true SSLContext object is not available. Thisprevents urllib3 from configuring SSL appropriately and may cause certain SSLconnections to fail. For more information, see https://urllib3.readthedocs.org/en/latest/security.html#insecureplatformwarning.

InsecurePlatformWarning

Using cached pysqlite-2.6.3.tar.gz

Building wheels for collected packages:pysqlite

Running setup.py bdist_wheel for pysqlite

Complete output from command/usr/local/bin/python2.7 -c "importsetuptools;__file__='/tmp/pip-build-SoLxpO/pysqlite/setup.py';exec(compile(open(__file__).read().replace('\r\n','\n'), __file__, 'exec'))" bdist_wheel -d /tmp/tmp65xKPypip-wheel-:

running bdist_wheel

running build

running build_py

creating build

creating build/lib.linux-x86_64-2.7

creatingbuild/lib.linux-x86_64-2.7/pysqlite2

copying lib/dbapi2.py ->build/lib.linux-x86_64-2.7/pysqlite2

copying lib/__init__.py -> build/lib.linux-x86_64-2.7/pysqlite2

copying lib/dump.py ->build/lib.linux-x86_64-2.7/pysqlite2

creatingbuild/lib.linux-x86_64-2.7/pysqlite2/test

copying lib/test/dbapi.py ->build/lib.linux-x86_64-2.7/pysqlite2/test

copying lib/test/__init__.py ->build/lib.linux-x86_64-2.7/pysqlite2/test

copying lib/test/factory.py ->build/lib.linux-x86_64-2.7/pysqlite2/test

copying lib/test/regression.py ->build/lib.linux-x86_64-2.7/pysqlite2/test

copying lib/test/types.py ->build/lib.linux-x86_64-2.7/pysqlite2/test

copying lib/test/hooks.py ->build/lib.linux-x86_64-2.7/pysqlite2/test

copying lib/test/userfunctions.py-> build/lib.linux-x86_64-2.7/pysqlite2/test

copying lib/test/transactions.py-> build/lib.linux-x86_64-2.7/pysqlite2/test

copying lib/test/dump.py ->build/lib.linux-x86_64-2.7/pysqlite2/test

creatingbuild/lib.linux-x86_64-2.7/pysqlite2/test/py25

copying lib/test/py25/py25tests.py-> build/lib.linux-x86_64-2.7/pysqlite2/test/py25

copying lib/test/py25/__init__.py-> build/lib.linux-x86_64-2.7/pysqlite2/test/py25

running build_ext

building 'pysqlite2._sqlite'extension

creating build/temp.linux-x86_64-2.7

creatingbuild/temp.linux-x86_64-2.7/src

gcc -pthread -fno-strict-aliasing -g-O2 -DNDEBUG -g -fwrapv -O3 -Wall -Wstrict-prototypes -fPIC-DMODULE_NAME="pysqlite2.dbapi2" -DSQLITE_OMIT_LOAD_EXTENSION=1-I/usr/local/include/python2.7 -c src/module.c -obuild/temp.linux-x86_64-2.7/src/module.o

In file included fromsrc/module.c:24:

src/connection.h:33:21: error: sqlite3.h: No such file ordirectory

In file included fromsrc/module.c:24:

src/connection.h:38: error: expectedspecifier-qualifier-list before ‘sqlite3’

In file included fromsrc/module.c:25:

src/statement.h:37: error: expectedspecifier-qualifier-list before ‘sqlite3’

src/module.c: In function‘module_complete’:

src/module.c:103: warning: implicitdeclaration of function ‘sqlite3_complete’

src/module.c: At top level:

src/module.c:269: error: ‘SQLITE_OK’undeclared here (not in a function)

src/module.c:270: error:‘SQLITE_DENY’ undeclared here (not in a function)

src/module.c:271: error:‘SQLITE_IGNORE’ undeclared here (not in a function)

src/module.c:272: error:‘SQLITE_CREATE_INDEX’ undeclared here (not in a function)

src/module.c:273: error:‘SQLITE_CREATE_TABLE’ undeclared here (not in a function)

src/module.c:274: error:‘SQLITE_CREATE_TEMP_INDEX’ undeclared here (not in a function)

src/module.c:275: error:‘SQLITE_CREATE_TEMP_TABLE’ undeclared here (not in a function)

src/module.c:276: error:‘SQLITE_CREATE_TEMP_TRIGGER’ undeclared here (not in a function)

src/module.c:277: error:‘SQLITE_CREATE_TEMP_VIEW’ undeclared here (not in a function)

src/module.c:278: error:‘SQLITE_CREATE_TRIGGER’ undeclared here (not in a function)

src/module.c:279: error:‘SQLITE_CREATE_VIEW’ undeclared here (not in a function)

src/module.c:280: error:‘SQLITE_DELETE’ undeclared here (not in a function)

src/module.c:281: error:‘SQLITE_DROP_INDEX’ undeclared here (not in a function)

src/module.c:282: error:‘SQLITE_DROP_TABLE’ undeclared here (not in a function)

src/module.c:283: error:‘SQLITE_DROP_TEMP_INDEX’ undeclared here (not in a function)

src/module.c:284: error:‘SQLITE_DROP_TEMP_TABLE’ undeclared here (not in a function)

src/module.c:285: error:‘SQLITE_DROP_TEMP_TRIGGER’ undeclared here (not in a function)

src/module.c:286: error:‘SQLITE_DROP_TEMP_VIEW’ undeclared here (not in a function)

src/module.c:287: error:‘SQLITE_DROP_TRIGGER’ undeclared here (not in a function)

src/module.c:288: error:‘SQLITE_DROP_VIEW’ undeclared here (not in a function)

src/module.c:289: error:‘SQLITE_INSERT’ undeclared here (not in a function)

src/module.c:290: error:‘SQLITE_PRAGMA’ undeclared here (not in a function)

src/module.c:291: error:‘SQLITE_READ’ undeclared here (not in a function)

src/module.c:292: error:‘SQLITE_SELECT’ undeclared here (not in a function)

src/module.c:293: error:‘SQLITE_TRANSACTION’ undeclared here (not in a function)

src/module.c:294: error: ‘SQLITE_UPDATE’undeclared here (not in a function)

src/module.c:295: error:‘SQLITE_ATTACH’ undeclared here (not in a function)

src/module.c:296: error:‘SQLITE_DETACH’ undeclared here (not in a function)

src/module.c: In function‘init_sqlite’:

src/module.c:426: warning: implicitdeclaration of function ‘sqlite3_libversion’

src/module.c:426: warning: passingargument 1 of ‘PyString_FromString’ makes pointer from integer without a cast

/usr/local/include/python2.7/stringobject.h:63: note: expected ‘const char *’but argument is of type ‘int’

error: command 'gcc' failed withexit status 1

solution:

[root@localhost /]# yum installsqlite-devel

Loaded plugins: fastestmirror,refresh-packagekit, security

Setting up Install Process

Loading mirror speeds from cached hostfile

* base: mirrors.btte.net

* extras: ftp.sjtu.edu.cn

* updates: mirrors.pubyun.com

Resolving Dependencies

--> Running transaction check

---> Package sqlite-devel.x86_640:3.6.20-1.el6 will be installed

--> Finished Dependency Resolution

Dependencies Resolved

===========================================================================================================================================================================================

Package Arch Version Repository Size

===========================================================================================================================================================================================

Installing:

sqlite-devel x86_64 3.6.20-1.el6 base 81 k

Transaction Summary

===========================================================================================================================================================================================

Install 1 Package(s)

Total download size: 81 k

Installed size: 283 k

Is this ok [y/N]: y

Downloading Packages:

sqlite-devel-3.6.20-1.el6.x86_64.rpm | 81 kB 00:00

Running rpm_check_debug

Running Transaction Test

Transaction Test Succeeded

Running Transaction

Installing :sqlite-devel-3.6.20-1.el6.x86_64 1/1

Verifying :sqlite-devel-3.6.20-1.el6.x86_64 1/1