r5946 - trunk/gnue-common/src/datasources/drivers/sqlite/sqlite

[johannes]

Author: johannes
Date: 2004-07-06 09:53:09 -0500 (Tue, 06 Jul 2004)
New Revision: 5946

Modified:
   trunk/gnue-common/src/datasources/drivers/sqlite/sqlite/Connection.py
   trunk/gnue-common/src/datasources/drivers/sqlite/sqlite/DataObject.py
   trunk/gnue-common/src/datasources/drivers/sqlite/sqlite/Info.py
   trunk/gnue-common/src/datasources/drivers/sqlite/sqlite/RecordSet.py
   trunk/gnue-common/src/datasources/drivers/sqlite/sqlite/ResultSet.py
   trunk/gnue-common/src/datasources/drivers/sqlite/sqlite/__init__.py
Log:
Updated sqlite driver (datetime issues)


Modified: trunk/gnue-common/src/datasources/drivers/sqlite/sqlite/Connection.py
===================================================================
--- trunk/gnue-common/src/datasources/drivers/sqlite/sqlite/Connection.py       
2004-07-06 14:08:15 UTC (rev 5945)
+++ trunk/gnue-common/src/datasources/drivers/sqlite/sqlite/Connection.py       
2004-07-06 14:53:09 UTC (rev 5946)
@@ -18,9 +18,6 @@
 #
 # Copyright 2000-2004 Free Software Foundation
 #
-# FILE:
-# SQLitedb/DBdriver.py
-#
 # DESCRIPTION:
 # Driver to provide access to data via SQLite's Python Driver.
 # Requires PySQLite (http://pysqlite.sf.net/)
@@ -29,9 +26,9 @@
 #
 #   Supported attributes (via connections.conf or <database> tag)
 #
-#     dbname=    This is the SQLite database to use (required)
+#     dbname = This is the SQLite database to use (required)
 #
-# $Id: $
+# $Id$
 
 __all__ = ['Connection']
 
@@ -71,35 +68,49 @@
     import Creation
 
 
-######################################################################
-#
-#  GConnection object for PostgreSQL-based drivers
-#
+# =============================================================================
+# GConnection object for SQLite driver
+# =============================================================================
+
 class Connection (DBSIG2.Connection):
 
   _driver         = SIG2api
   _DatabaseError  = SIG2api.DatabaseError
   defaultBehavior = Introspection
   defaultCreator  = Creation
+
   supportedDataObjects = {
     'object': DataObject_Object,
     'sql':    DataObject_SQL
   }
 
+
+  # ---------------------------------------------------------------------------
+  # Constructor
+  # ---------------------------------------------------------------------------
+
   def __init__ (self, connections, name, parameters):
+    """
+    This constructor extends the inherited object by the 'noTransactions' flag
+    """
     DBSIG2.Connection.__init__ (self, connections, name, parameters)
     self.noTransactions = False
 
+
   # ---------------------------------------------------------------------------
   # Connect to a given database according to the connectData dictionary
   # ---------------------------------------------------------------------------
 
   def connect (self, connectData):
     """
+    This function creates and returns a new database connection using
+    parameters from the given connectData dictionary.
+
+    @param connectData: dictionary with parameters used for the connection
     """
-    GDebug.printMesg(1,"SQLite database driver initializing <%s>" \
-        % hex (id (self)))
 
+    GDebug.printMesg (1, "SQLite database driver initializing <%s>")
+
     if not hasattr (self, '_DatabaseError'):
       try:
         self._DatabaseError = self._driver.Error
@@ -108,23 +119,36 @@
 
     try:
       self.noTransactions = connectData.get ('appserver', False)
-      self.native = SIG2api.connect (db = connectData['dbname'],
-                                     mode = 0777,
-                                     encoding = self._encoding,
+      self.native = SIG2api.connect (db         = connectData['dbname'],
+                                     encoding   = self._encoding,
                                      autocommit = self.noTransactions)
 
     except self._DatabaseError, value:
       GDebug.printMesg (1, "Exception %s" % value)
-      raise Exceptions.LoginError, u_("The SQLite driver returned the "
-          "following error:\n\t%s") % value
+      raise Exceptions.LoginError, \
+           u_("The SQLite driver returned the following error:\n\t%s") % value
 
 
+  # ---------------------------------------------------------------------------
+  # Commit a pending transactiona pending transaction
+  # ---------------------------------------------------------------------------
+
   def commit (self):
+    """
+    This function performs a commit depending on the current transaction-flag.
+    """
     if not self.noTransactions:
       DBSIG2.Connection.commit (self)
 
 
-  # Return a list of necessary login fields (e.g., user/pass).
-  # Each list item is another list of ["field label", isPassword?]
-  def getLoginFields(self):
+
+  # ---------------------------------------------------------------------------
+  # Return a sequence of required login fields
+  # ---------------------------------------------------------------------------
+
+  def getLoginFields (self):
+    """
+    This function returns an empty sequence since SQLite doesn't use any user
+    authentication.
+    """
     return []


Property changes on: 
trunk/gnue-common/src/datasources/drivers/sqlite/sqlite/Connection.py
___________________________________________________________________
Name: svn:keywords
   - +Id
   + Id

Modified: trunk/gnue-common/src/datasources/drivers/sqlite/sqlite/DataObject.py
===================================================================
--- trunk/gnue-common/src/datasources/drivers/sqlite/sqlite/DataObject.py       
2004-07-06 14:08:15 UTC (rev 5945)
+++ trunk/gnue-common/src/datasources/drivers/sqlite/sqlite/DataObject.py       
2004-07-06 14:53:09 UTC (rev 5946)
@@ -18,14 +18,7 @@
 #
 # Copyright 2000-2004 Free Software Foundation
 #
-# FILE:
-# SQLitedb/DBdriver.py
-#
-# DESCRIPTION:
-# Driver to provide access to data via SQLite's Python Driver.
-# Requires PySQLite (http://pysqlite.sf.net/)
-#
-# $Id: $
+# $Id$
 
 __all__ = ['DataObject_SQL', 'DataObject_Object']
 
@@ -33,7 +26,7 @@
 
 
 class _Base:
-  pass
+  _dateTimeFormat = "'%Y-%m-%d %H:%M:%S.00'"
 
 class DataObject_SQL (_Base, DBSIG2.DataObject_SQL):
   pass


Property changes on: 
trunk/gnue-common/src/datasources/drivers/sqlite/sqlite/DataObject.py
___________________________________________________________________
Name: svn:keywords
   - +Id
   + Id


Property changes on: 
trunk/gnue-common/src/datasources/drivers/sqlite/sqlite/Info.py
___________________________________________________________________
Name: svn:keywords
   - +Id
   + Id

Modified: trunk/gnue-common/src/datasources/drivers/sqlite/sqlite/RecordSet.py
===================================================================
--- trunk/gnue-common/src/datasources/drivers/sqlite/sqlite/RecordSet.py        
2004-07-06 14:08:15 UTC (rev 5945)
+++ trunk/gnue-common/src/datasources/drivers/sqlite/sqlite/RecordSet.py        
2004-07-06 14:53:09 UTC (rev 5946)
@@ -18,18 +18,9 @@
 #
 # Copyright 2000-2004 Free Software Foundation
 #
-# FILE:
-# SQLitedb/DBdriver.py
-#
-# DESCRIPTION:
-# Driver to provide access to data via SQLite's Python Driver.
-# Requires PySQLite (http://pysqlite.sf.net/)
-#
-# $Id: $
+# $Id$
 
-
 from gnue.common.datasources.drivers import DBSIG2
 
-
 class RecordSet (DBSIG2.RecordSet):
   pass


Property changes on: 
trunk/gnue-common/src/datasources/drivers/sqlite/sqlite/RecordSet.py
___________________________________________________________________
Name: svn:keywords
   - +Id
   + Id

Modified: trunk/gnue-common/src/datasources/drivers/sqlite/sqlite/ResultSet.py
===================================================================
--- trunk/gnue-common/src/datasources/drivers/sqlite/sqlite/ResultSet.py        
2004-07-06 14:08:15 UTC (rev 5945)
+++ trunk/gnue-common/src/datasources/drivers/sqlite/sqlite/ResultSet.py        
2004-07-06 14:53:09 UTC (rev 5946)
@@ -18,16 +18,8 @@
 #
 # Copyright 2000-2004 Free Software Foundation
 #
-# FILE:
-# SQLitedb/DBdriver.py
-#
-# DESCRIPTION:
-# Driver to provide access to data via SQLite's Python Driver.
-# Requires PySQLite (http://pysqlite.sf.net/)
-#
-# $Id: $
+# $Id$
 
-
 from gnue.common.datasources.drivers import DBSIG2
 from RecordSet import RecordSet
 


Property changes on: 
trunk/gnue-common/src/datasources/drivers/sqlite/sqlite/ResultSet.py
___________________________________________________________________
Name: svn:keywords
   - +Id
   + Id


Property changes on: 
trunk/gnue-common/src/datasources/drivers/sqlite/sqlite/__init__.py
___________________________________________________________________
Name: svn:keywords
   - +Id
   + Id