[Zapp-cvs-commit] ZApp/leverMethods/PG insertItemLever.plain,1.13,1.14 updateItemLever.plain,1.9,1.10

[Steve S. <ssp...@us...>]

Update of /cvsroot/zapp/ZApp/leverMethods/PG
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv10815/leverMethods/PG

Modified Files:
	insertItemLever.plain updateItemLever.plain 
Log Message:
Ack.. found bad bug in insert/update levers for postgres. Re-run your levers! Sorry! 

Index: insertItemLever.plain
===================================================================
RCS file: /cvsroot/zapp/ZApp/leverMethods/PG/insertItemLever.plain,v
retrieving revision 1.13
retrieving revision 1.14
diff -C2 -d -r1.13 -r1.14
*** insertItemLever.plain	10 Mar 2004 18:30:50 -0000	1.13
--- insertItemLever.plain	18 Mar 2004 19:02:42 -0000	1.14
***************
*** 29,32 ****
--- 29,34 ----
      }
  
+ sizedTypes = ['string','stringRE','stringLK']
+ 
  pm = specialist.ZApp_getPropertyMap()
          
***************
*** 49,57 ****
              itemList.append(fmtString)
          else:
!             if theType == 'string':
                  theSize = item.get('dbSize',item.get('sqlSize',defaultSize))
                  theVal = ('"%s[0:%i]"' % (itemID, theSize))
              else:
                  theVal = itemID
              refList = refLookup.get(itemID,[])
              if len(refList) >= 2:
--- 51,60 ----
              itemList.append(fmtString)
          else:
!             if dbType in sizedTypes:
                  theSize = item.get('dbSize',item.get('sqlSize',defaultSize))
                  theVal = ('"%s[0:%i]"' % (itemID, theSize))
              else:
                  theVal = itemID
+ 
              refList = refLookup.get(itemID,[])
              if len(refList) >= 2:

Index: updateItemLever.plain
===================================================================
RCS file: /cvsroot/zapp/ZApp/leverMethods/PG/updateItemLever.plain,v
retrieving revision 1.9
retrieving revision 1.10
diff -C2 -d -r1.9 -r1.10
*** updateItemLever.plain	10 Mar 2004 18:30:50 -0000	1.9
--- updateItemLever.plain	18 Mar 2004 19:02:42 -0000	1.10
***************
*** 29,32 ****
--- 29,34 ----
      }
  
+ sizedTypes = ['string','stringRE','stringLK']
+ 
  templateString = ''
  
***************
*** 54,62 ****
              else:
                  theType = typeLookups.get(dbType, dbType)
!                 if theType == 'string':
                      theSize = item.get('dbSize',item.get('sqlSize',defaultSize))
                      theVal = ('"%s[0:%i]"' % (itemID, theSize))
                  else:
                      theVal = itemID
                  refList = refLookup.get(itemID,[])
                  if len(refList) >= 2:
--- 56,65 ----
              else:
                  theType = typeLookups.get(dbType, dbType)
!                 if dbType in sizedTypes:
                      theSize = item.get('dbSize',item.get('sqlSize',defaultSize))
                      theVal = ('"%s[0:%i]"' % (itemID, theSize))
                  else:
                      theVal = itemID
+ 
                  refList = refLookup.get(itemID,[])
                  if len(refList) >= 2: