|
| 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 | + |
| 24 | +import datetime |
| 25 | + |
| 26 | +paramstyle = "qmark" |
| 27 | + |
| 28 | +threadsafety = 1 |
| 29 | + |
| 30 | +apilevel = "2.0" |
| 31 | + |
| 32 | +from _sqlite3 import * |
| 33 | + |
| 34 | +import datetime, time |
| 35 | + |
| 36 | +Date = datetime.date |
| 37 | + |
| 38 | +Time = datetime.time |
| 39 | + |
| 40 | +Timestamp = datetime.datetime |
| 41 | + |
| 42 | +def DateFromTicks(ticks): |
| 43 | + return apply(Date,time.localtime(ticks)[:3]) |
| 44 | + |
| 45 | +def TimeFromTicks(ticks): |
| 46 | + return apply(Time,time.localtime(ticks)[3:6]) |
| 47 | + |
| 48 | +def TimestampFromTicks(ticks): |
| 49 | + return apply(Timestamp,time.localtime(ticks)[:6]) |
| 50 | + |
| 51 | +_major, _minor, _micro = version.split(".") |
| 52 | +version_info = (int(_major), int(_minor), _micro) |
| 53 | +_major, _minor, _micro = sqlite_version.split(".") |
| 54 | +sqlite_version_info = (int(_major), int(_minor), _micro) |
| 55 | + |
| 56 | +Binary = buffer |
| 57 | + |
| 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(float("0." + timepart_full[1]) * 1000000) |
| 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) |
0 commit comments