1 # pysqlite2/dbapi2.py: the DB-API 2.0 interface
2 #
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 implied
8 # warranty.  In no event will the authors be held liable for any damages
9 # 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 it
13 # freely, subject to the following restrictions:
14 #
15 # 1. The origin of this software must not be misrepresented; you must not
16 #    claim that you wrote the original software. If you use this software
17 #    in a product, an acknowledgment in the product documentation would be
18 #    appreciated but is not required.
19 # 2. Altered source versions must be plainly marked as such, and must not be
20 #    misrepresented as being the original software.
21 # 3. This notice may not be removed or altered from any source distribution.
22 
23 import datetime
24 import time
25 import collections.abc
26 
27 from _sqlite3 import *
28 
29 paramstyle = "qmark"
30 
31 apilevel = "2.0"
32 
33 Date = datetime.date
34 
35 Time = datetime.time
36 
37 Timestamp = datetime.datetime
38 
39 def DateFromTicks(ticks):
40     return Date(*time.localtime(ticks)[:3])
41 
42 def TimeFromTicks(ticks):
43     return Time(*time.localtime(ticks)[3:6])
44 
45 def TimestampFromTicks(ticks):
46     return Timestamp(*time.localtime(ticks)[:6])
47 
48 version_info = tuple([int(x) for x in version.split(".")])
49 sqlite_version_info = tuple([int(x) for x in sqlite_version.split(".")])
50 
51 Binary = memoryview
52 collections.abc.Sequence.register(Row)
53 
54 def register_adapters_and_converters():
55     def adapt_date(val):
56         return val.isoformat()
57 
58     def adapt_datetime(val):
59         return val.isoformat(" ")
60 
61     def convert_date(val):
62         return datetime.date(*map(int, val.split(b"-")))
63 
64     def convert_timestamp(val):
65         datepart, timepart = val.split(b" ")
66         year, month, day = map(int, datepart.split(b"-"))
67         timepart_full = timepart.split(b".")
68         hours, minutes, seconds = map(int, timepart_full[0].split(b":"))
69         if len(timepart_full) == 2:
70             microseconds = int('{:0<6.6}'.format(timepart_full[1].decode()))
71         else:
72             microseconds = 0
73 
74         val = datetime.datetime(year, month, day, hours, minutes, seconds, microseconds)
75         return val
76 
77 
78     register_adapter(datetime.date, adapt_date)
79     register_adapter(datetime.datetime, adapt_datetime)
80     register_converter("date", convert_date)
81     register_converter("timestamp", convert_timestamp)
82 
83 register_adapters_and_converters()
84 
85 # bpo-24464: enable_shared_cache was deprecated in Python 3.10.  It's
86 # scheduled for removal in Python 3.12.
87 def enable_shared_cache(enable):
88     from _sqlite3 import enable_shared_cache as _old_enable_shared_cache
89     import warnings
90     msg = (
91         "enable_shared_cache is deprecated and will be removed in Python 3.12. "
92         "Shared cache is strongly discouraged by the SQLite 3 documentation. "
93         "If shared cache must be used, open the database in URI mode using"
94         "the cache=shared query parameter."
95     )
96     warnings.warn(msg, DeprecationWarning, stacklevel=2)
97     return _old_enable_shared_cache(enable)
98 
99 # Clean up namespace
100 
101 del(register_adapters_and_converters)
102