Lib/sqlite3/dbapi2.py

   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 import time
  26
  27 from _sqlite3 import *
  28
  29 paramstyle = "qmark"
  30
  31 threadsafety = 1
  32
  33 apilevel = "2.0"
  34
  35 Date = datetime.date
  36
  37 Time = datetime.time
  38
  39 Timestamp = datetime.datetime
  40
  41 def DateFromTicks(ticks):
  42     return Date(*time.localtime(ticks)[:3])
  43
  44 def TimeFromTicks(ticks):
  45     return Time(*time.localtime(ticks)[3:6])
  46
  47 def TimestampFromTicks(ticks):
  48     return Timestamp(*time.localtime(ticks)[:6])
  49
  50 version_info = tuple([int(x) for x in version.split(".")])
  51 sqlite_version_info = tuple([int(x) for x in sqlite_version.split(".")])
  52
  53 Binary = buffer
  54
  55 def register_adapters_and_converters():
  56     def adapt_date(val):
  57         return val.isoformat()
  58
  59     def adapt_datetime(val):
  60         return val.isoformat(" ")
  61
  62     def convert_date(val):
  63         return datetime.date(*map(int, val.split("-")))
  64
  65     def convert_timestamp(val):
  66         datepart, timepart = val.split(" ")
  67         year, month, day = map(int, datepart.split("-"))
  68         timepart_full = timepart.split(".")
  69         hours, minutes, seconds = map(int, timepart_full[0].split(":"))
  70         if len(timepart_full) == 2:
  71             microseconds = int(timepart_full[1])
  72         else:
  73             microseconds = 0
  74
  75         val = datetime.datetime(year, month, day, hours, minutes, seconds, microseconds)
  76         return val
  77
  78
  79     register_adapter(datetime.date, adapt_date)
  80     register_adapter(datetime.datetime, adapt_datetime)
  81     register_converter("date", convert_date)
  82     register_converter("timestamp", convert_timestamp)
  83
  84 register_adapters_and_converters()
  85
  86 # Clean up namespace
  87
  88 del(register_adapters_and_converters)