gnue/common/src/dbdrivers/_pgsql DBdriver.py

[Arturas Kriukovas]

CVSROOT:        /cvsroot/gnue
Module name:    gnue
Changes by:     Arturas Kriukovas <address@hidden>      02/07/15 10:53:59

Modified files:
        common/src/dbdrivers/_pgsql: DBdriver.py 

Log message:
        Added _dateTimeFormat='%Y-%m-%d %H:%M:%S'.
        Added time\date datatype formatting (from '2002-12-31 23:59:59,99' to
        '2002-12-31 23:59:59').

CVSWeb URLs:
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue/common/src/dbdrivers/_pgsql/DBdriver.py.diff?tr1=1.18&tr2=1.19&r1=text&r2=text

Patches:
Index: gnue/common/src/dbdrivers/_pgsql/DBdriver.py
diff -c gnue/common/src/dbdrivers/_pgsql/DBdriver.py:1.18 
gnue/common/src/dbdrivers/_pgsql/DBdriver.py:1.19
*** gnue/common/src/dbdrivers/_pgsql/DBdriver.py:1.18   Wed Jul 10 09:31:22 2002
--- gnue/common/src/dbdrivers/_pgsql/DBdriver.py        Mon Jul 15 10:53:59 2002
***************
*** 28,34 ****
  # NOTES:
  #
  
! 
  from string import lower, join, split
  import sys
  from gnue.common import GDebug, GDataObjects
--- 28,34 ----
  # NOTES:
  #
  
! import string
  from string import lower, join, split
  import sys
  from gnue.common import GDebug, GDataObjects
***************
*** 38,45 ****
  from gnue.common.dbdrivers._dbsig.DBdriver import DBSIG_DataObject_Object as 
PGSQL_DataObject_Object
  from gnue.common.dbdrivers._dbsig.DBdriver import DBSIG_DataObject_SQL as 
PGSQL_DataObject_SQL
  
  class PGSQL_RecordSet(DBSIG_RecordSet):
!   pass
  
  class PGSQL_ResultSet(DBSIG_ResultSet):
    def __init__(self, dataObject, cursor=None, defaultValues={}, 
masterRecordSet=None):
--- 38,77 ----
  from gnue.common.dbdrivers._dbsig.DBdriver import DBSIG_DataObject_Object as 
PGSQL_DataObject_Object
  from gnue.common.dbdrivers._dbsig.DBdriver import DBSIG_DataObject_SQL as 
PGSQL_DataObject_SQL
  
+ 
  class PGSQL_RecordSet(DBSIG_RecordSet):
!   def _buildUpdateStatement(self):
!     updates = []
!     for field in self._modifiedFlags.keys():
!     # To convert date from format '2002-12-31 23:59:59,99'
!     # into '2002-12-31 23:59:59' format.
!     # We have to determine whether given string is date\time
!     # maybe it's the most stupid way, but it should work.
!     # TODO: if in ANY other field data of this format and comma in
!     # place will exist, the remaining string from first ',' will be
!     # eaten.
!     # If you know better decision - please, modify this code.
!       tmpDate = self._fields[field]
!       if ((len(tmpDate)==22) and (tmpDate[-3]==',')):
!         tmpDate = tmpDate.split(',')
!         tmpDate = tmpDate[0]
!       updates.append ("%s=%s" % (field,
!         self._parent._dataObject._toSqlString(tmpDate)))
! 
!     if self._parent._dataObject._primaryIdField:
!       where = [self._parent._dataObject._primaryIdFormat % \
!           self._initialData[self._parent._dataObject._primaryIdField]  ]
!     else:
!       where = []
!       for field in self._initialData.keys():
!         if self._initialData[field] == None:
!           where.append ("%s IS NULL" % field)
!         else:
!           where.append ("%s=%s" % (field, 
self._parent._dataObject._toSqlString(self._initialData[field])))
!     return "UPDATE %s SET %s WHERE %s" % \
!        (self._parent._dataObject.table, string.join(updates,','), \
!         string.join(where,' AND ') )
! 
  
  class PGSQL_ResultSet(DBSIG_ResultSet):
    def __init__(self, dataObject, cursor=None, defaultValues={}, 
masterRecordSet=None):
***************
*** 52,57 ****
--- 84,92 ----
      DBSIG_DataObject.__init__(self)
      self._connectString = 'host=%s dbname=%s user=%s password=%s port=%s'
      self._escapeSingleQuote = '\\'
+     # date/time format
+     self._dateTimeFormat = "'%Y-%m-%d %H:%M:%S'"
+ 
      if pgdriver:
        self._pgdriver = pgdriver
        self._DatabaseError = self._pgdriver.DatabaseError