Debian Codegraph @

Lib/sqlite3/dbapi2.py

raw
1 # pysqlite2/dbapi2.py: the DB-API 2.0 interface
2 #
3 # Copyright (C) 2004-2005 Gerhard Häring <[email protected]>
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
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 from warnings import warn
56
57 msg = ("The default {what} is deprecated as of Python 3.12; "
58 "see the sqlite3 documentation for suggested replacement recipes")
59
60 def adapt_date(val):
61 warn(msg.format(what="date adapter"), DeprecationWarning, stacklevel=2)
62 return val.isoformat()
63
64 def adapt_datetime(val):
65 warn(msg.format(what="datetime adapter"), DeprecationWarning, stacklevel=2)
66 return val.isoformat(" ")
67
68 def convert_date(val):
69 warn(msg.format(what="date converter"), DeprecationWarning, stacklevel=2)
70 return datetime.date(*map(int, val.split(b"-")))
71
72 def convert_timestamp(val):
73 warn(msg.format(what="timestamp converter"), DeprecationWarning, stacklevel=2)
74 datepart, timepart = val.split(b" ")
75 year, month, day = map(int, datepart.split(b"-"))
76 timepart_full = timepart.split(b".")
77 hours, minutes, seconds = map(int, timepart_full[0].split(b":"))
78 if len(timepart_full) == 2:
79 microseconds = int('{:0<6.6}'.format(timepart_full[1].decode()))
80 else:
81 microseconds = 0
82
83 val = datetime.datetime(year, month, day, hours, minutes, seconds, microseconds)
84 return val
85
86
87 register_adapter(datetime.date, adapt_date)
88 register_adapter(datetime.datetime, adapt_datetime)
89 register_converter("date", convert_date)
90 register_converter("timestamp", convert_timestamp)
91
92 register_adapters_and_converters()
93
94 # Clean up namespace
95
96 del(register_adapters_and_converters)