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