Home | History | Annotate | Download | only in sqlite3 
      1 # -*- coding: iso-8859-1 -*-
      2 # pysqlite2/dbapi2.py: the DB-API 2.0 interface
      3 #
      4 # Copyright (C) 2004-2005 Gerhard Hring <gh (at] 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 collections
     25 import datetime
     26 import time
     27 
     28 from _sqlite3 import *
     29 
     30 paramstyle = "qmark"
     31 
     32 threadsafety = 1
     33 
     34 apilevel = "2.0"
     35 
     36 Date = datetime.date
     37 
     38 Time = datetime.time
     39 
     40 Timestamp = datetime.datetime
     41 
     42 def DateFromTicks(ticks):
     43     return Date(*time.localtime(ticks)[:3])
     44 
     45 def TimeFromTicks(ticks):
     46     return Time(*time.localtime(ticks)[3:6])
     47 
     48 def TimestampFromTicks(ticks):
     49     return Timestamp(*time.localtime(ticks)[:6])
     50 
     51 version_info = tuple([int(x) for x in version.split(".")])
     52 sqlite_version_info = tuple([int(x) for x in sqlite_version.split(".")])
     53 
     54 Binary = buffer
     55 collections.Sequence.register(Row)
     56 
     57 def 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 
     86 register_adapters_and_converters()
     87 
     88 # Clean up namespace
     89 
     90 del(register_adapters_and_converters)
     91