File Explorer

1# pysqlite2/dbapi2.py: the DB-API 2.0 interface2#3# Copyright (C) 2004-2005 Gerhard Häring <gh@ghaering.de>4#5# This file is part of pysqlite.6#7# This software is provided 'as-is', without any express or implied8# warranty.  In no event will the authors be held liable for any damages9# arising from the use of this software.10#11# Permission is granted to anyone to use this software for any purpose,12# including commercial applications, and to alter it and redistribute it13# freely, subject to the following restrictions:14#15# 1. The origin of this software must not be misrepresented; you must not16#    claim that you wrote the original software. If you use this software17#    in a product, an acknowledgment in the product documentation would be18#    appreciated but is not required.19# 2. Altered source versions must be plainly marked as such, and must not be20#    misrepresented as being the original software.21# 3. This notice may not be removed or altered from any source distribution.22 23import datetime24import time25import collections.abc26 27from _sqlite3 import *28 29paramstyle = "qmark"30 31threadsafety = 132 33apilevel = "2.0"34 35Date = datetime.date36 37Time = datetime.time38 39Timestamp = datetime.datetime40 41def DateFromTicks(ticks):42    return Date(*time.localtime(ticks)[:3])43 44def TimeFromTicks(ticks):45    return Time(*time.localtime(ticks)[3:6])46 47def TimestampFromTicks(ticks):48    return Timestamp(*time.localtime(ticks)[:6])49 50version_info = tuple([int(x) for x in version.split(".")])51sqlite_version_info = tuple([int(x) for x in sqlite_version.split(".")])52 53Binary = memoryview54collections.abc.Sequence.register(Row)55 56def register_adapters_and_converters():57    def adapt_date(val):58        return val.isoformat()59 60    def adapt_datetime(val):61        return val.isoformat(" ")62 63    def convert_date(val):64        return datetime.date(*map(int, val.split(b"-")))65 66    def convert_timestamp(val):67        datepart, timepart = val.split(b" ")68        year, month, day = map(int, datepart.split(b"-"))69        timepart_full = timepart.split(b".")70        hours, minutes, seconds = map(int, timepart_full[0].split(b":"))71        if len(timepart_full) == 2:72            microseconds = int('{:0<6.6}'.format(timepart_full[1].decode()))73        else:74            microseconds = 075 76        val = datetime.datetime(year, month, day, hours, minutes, seconds, microseconds)77        return val78 79 80    register_adapter(datetime.date, adapt_date)81    register_adapter(datetime.datetime, adapt_datetime)82    register_converter("date", convert_date)83    register_converter("timestamp", convert_timestamp)84 85register_adapters_and_converters()86 87# Clean up namespace88 89del(register_adapters_and_converters)90