logo

oasis-root

Compiled tree of Oasis Linux based on own branch at <https://hacktivis.me/git/oasis/> git clone https://anongit.hacktivis.me/git/oasis-root.git

dbapi2.py (3323B)

    

  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.
  23. import datetime
  24. import time
  25. import collections.abc
  27. from _sqlite3 import *
  29. paramstyle = "qmark"
  31. threadsafety = 1
  33. apilevel = "2.0"
  35. Date = datetime.date
  37. Time = datetime.time
  39. Timestamp = datetime.datetime
  41. def DateFromTicks(ticks):
  42.     return Date(*time.localtime(ticks)[:3])
  44. def TimeFromTicks(ticks):
  45.     return Time(*time.localtime(ticks)[3:6])
  47. def TimestampFromTicks(ticks):
  48.     return Timestamp(*time.localtime(ticks)[:6])
  50. version_info = tuple([int(x) for x in version.split(".")])
  51. sqlite_version_info = tuple([int(x) for x in sqlite_version.split(".")])
  53. Binary = memoryview
  54. collections.abc.Sequence.register(Row)
  56. def register_adapters_and_converters():
  57.     def adapt_date(val):
  58.         return val.isoformat()
  60.     def adapt_datetime(val):
  61.         return val.isoformat(" ")
  63.     def convert_date(val):
  64.         return datetime.date(*map(int, val.split(b"-")))
  66.     def convert_timestamp(val):
  67.         datepart, timepart = val.split(b" ")
  68.         year, month, day = map(int, datepart.split(b"-"))
  69.         timepart_full = timepart.split(b".")
  70.         hours, minutes, seconds = map(int, timepart_full[0].split(b":"))
  71.         if len(timepart_full) == 2:
  72.             microseconds = int('{:0<6.6}'.format(timepart_full[1].decode()))
  73.         else:
  74.             microseconds = 0
  76.         val = datetime.datetime(year, month, day, hours, minutes, seconds, microseconds)
  77.         return val
  80.     register_adapter(datetime.date, adapt_date)
  81.     register_adapter(datetime.datetime, adapt_datetime)
  82.     register_converter("date", convert_date)
  83.     register_converter("timestamp", convert_timestamp)
  85. register_adapters_and_converters()
  87. # bpo-24464: enable_shared_cache was deprecated in Python 3.10.  It's
  88. # scheduled for removal in Python 3.12.
  89. def enable_shared_cache(enable):
  90.     from _sqlite3 import enable_shared_cache as _old_enable_shared_cache
  91.     import warnings
  92.     msg = (
  93.         "enable_shared_cache is deprecated and will be removed in Python 3.12. "
  94.         "Shared cache is strongly discouraged by the SQLite 3 documentation. "
  95.         "If shared cache must be used, open the database in URI mode using"
  96.         "the cache=shared query parameter."
  97.     )
  98.     warnings.warn(msg, DeprecationWarning, stacklevel=2)
  99.     return _old_enable_shared_cache(enable)
  101. # Clean up namespace
  103. del(register_adapters_and_converters)