1 # -*- coding: iso-8859-1 -*- 2 # pysqlite2/dbapi2.py: the DB-API 2.0 interface 3 # 4 # Copyright (C) 2004-2005 Gerhard Hring <gh (at] 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 24 import collections 25 import datetime 26 import time 27 28 from _sqlite3 import * 29 30 paramstyle = "qmark" 31 32 threadsafety = 1 33 34 apilevel = "2.0" 35 36 Date = datetime.date 37 38 Time = datetime.time 39 40 Timestamp = datetime.datetime 41 42 def DateFromTicks(ticks): 43 return Date(*time.localtime(ticks)[:3]) 44 45 def TimeFromTicks(ticks): 46 return Time(*time.localtime(ticks)[3:6]) 47 48 def TimestampFromTicks(ticks): 49 return Timestamp(*time.localtime(ticks)[:6]) 50 51 version_info = tuple([int(x) for x in version.split(".")]) 52 sqlite_version_info = tuple([int(x) for x in sqlite_version.split(".")]) 53 54 Binary = buffer 55 collections.Sequence.register(Row) 56 57 def 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 86 register_adapters_and_converters() 87 88 # Clean up namespace 89 90 del(register_adapters_and_converters) 91