注册 登录
编程论坛 Python论坛

关于python源码实现sqlite API 的问题

sssschenyi 发布于 2019-10-23 20:24, 2177 次点击
我想查看sqlite3 的连接是怎么实现的。可是源码只有 1 行
__init.py__
from sqlite3.dbapi2 import *
4 回复
#2
fall_bernana2019-10-24 09:10
以下是引用sssschenyi在2019-10-23 20:24:09的发言:

我想查看sqlite3 的连接是怎么实现的。可是源码只有 1 行
__init.py__
from sqlite3.dbapi2 import *


这说明他使用的方法都引用的sqlite3.dbapi2  你直接看sqlite3/dbapi2.py
#3
sssschenyi2019-10-24 17:52
回复 2楼 fall_bernana
程序代码:
import datetime
import time
import collections.abc

from _sqlite3 import *

paramstyle = "qmark"

threadsafety = 1

apilevel = "2.0"

Date = datetime.date

Time = datetime.time

Timestamp = datetime.datetime

def DateFromTicks(ticks):
    return Date(*time.localtime(ticks)[:3])

def TimeFromTicks(ticks):
    return Time(*time.localtime(ticks)[3:6])

def TimestampFromTicks(ticks):
    return Timestamp(*time.localtime(ticks)[:6])

version_info = tuple([int(x) for x in version.split(".")])
sqlite_version_info = tuple([int(x) for x in sqlite_version.split(".")])

Binary = memoryview
collections.abc.Sequence.register(Row)

def register_adapters_and_converters():
    def adapt_date(val):
        return val.isoformat()

    def adapt_datetime(val):
        return val.isoformat(" ")

    def convert_date(val):
        return datetime.date(*map(int, val.split(b"-")))

    def convert_timestamp(val):
        datepart, timepart = val.split(b" ")
        year, month, day = map(int, datepart.split(b"-"))
        timepart_full = timepart.split(b".")
        hours, minutes, seconds = map(int, timepart_full[0].split(b":"))
        if len(timepart_full) == 2:
            microseconds = int('{:0<6.6}'.format(timepart_full[1].decode()))
        else:
            microseconds = 0

        val = datetime.datetime(year, month, day, hours, minutes, seconds, microseconds)
        return val


    register_adapter(datetime.date, adapt_date)
    register_adapter(datetime.datetime, adapt_datetime)
    register_converter("date", convert_date)
    register_converter("timestamp", convert_timestamp)

register_adapters_and_converters()

# Clean up namespace

del(register_adapters_and_converters)


这是dpapi2 的代码。找了半天找不到sqlite3 api 是怎么的实现的
#4
fall_bernana2019-10-25 09:10
回复 3楼 sssschenyi
同样的原理.他这个里面有from _sqlite3 import * ,如果没有.那么你需要的东西会在_sqlite3里.
具体可以百度

[此贴子已经被作者于2019-10-25 14:07编辑过]

#5
sssschenyi2019-10-25 14:00
回复 4楼 fall_bernana
python3 默认不支持 sqlite3 ????
你用过python3 没有?难道我的python3是假的?
1