• Home
  • Line#
  • Scopes#
  • Navigate#
  • Raw
  • Download
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