python操作数据库真方便

〇〇

〇〇 发表于 2017-2-7 16:05
windows版本
    paramstyle = 'qmark'
    sqlite_version = '3.8.11'

android版本
sqlite_version = '3.7.5'

〇〇

〇〇 发表于 2017-2-7 16:09
android版本
sqlite_version = '3.7.5'

https://github.com/qpython-android/qpython/releases

〇〇

qpyhton3 https://github.com/qpython-android/qpython3/releases

〇〇

pypy带的sqlite版本更低
sqlite_version = '3.6.21'
sqlite_version_info = (3, 6, 21)

Python 2.7.10 (c95650101a99, Sep 06 2016, 15:44:55)
[PyPy 5.4.1 with MSC v.1500 32 bit] on win32

〇〇

〇〇 发表于 2017-2-7 20:32
pypy带的sqlite版本更低
sqlite_version = '3.6.21'
sqlite_version_info = (3, 6, 21)

只要把最新版本sqlite替换到pypy根目录，就可以了
    sqlite_version = '3.16.2'
    sqlite_version_info = (3, 16, 2)
    symbol = 'SQLITE_UPDATE'
    threadsafety = 1
    version = '2.6.0'
    version_info = (2, 6, 0)
    x = '2'


>>>> import sqlite3
>>>> conn = sqlite3.connect("mydb")
>>>> cur = conn.cursor()
>>>>
>>>> for row in cur.execute("with t as(select 1 union select 2)select * from t"):
....  print (row)
....
(1,)
(2,)