Source Code for Module sqlite3.dbapi2

 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 apply(Date, time.localtime(ticks)[:3]) 
43   
44 -def TimeFromTicks(ticks): 
45      return apply(Time, time.localtime(ticks)[3:6]) 
46   
47 -def TimestampFromTicks(ticks): 
48      return apply(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(float("0." + timepart_full[1]) * 1000000) 
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) 
89