pypgsql-checkins

[Billy G. A. <bal...@us...>]

Update of /cvsroot/pypgsql/pypgsql/test
In directory usw-pr-cvs1:/tmp/cvs-serv13641/test

Modified Files:
	PgSQLTestCases.py 
Log Message:
11AUG2002 bga	Added additional tests for the PgNumeric class.


Index: PgSQLTestCases.py
===================================================================
RCS file: /cvsroot/pypgsql/pypgsql/test/PgSQLTestCases.py,v
retrieving revision 1.20
retrieving revision 1.21
diff -C2 -d -r1.20 -r1.21
*** PgSQLTestCases.py	3 Aug 2002 06:03:40 -0000	1.20
--- PgSQLTestCases.py	12 Aug 2002 03:06:36 -0000	1.21
***************
*** 33,36 ****
--- 33,37 ----
  # Date      Ini Description						|
  # --------- --- ------------------------------------------------------- |
+ # 11AUG2002 bga	Added additional tests for the PgNumeric class.		|
  # 03AUG2002 gh  Added test for bug #589370 (wether it is possible to	|
  #		use OID in a query that doesn't return any rows).	|
***************
*** 273,281 ****
  
      def CheckPgNumeric(self):
!         a = PgSQL.PgNumeric('4634.00')
!         self.failUnless(a == 4634, 'PgNumeric comparison to Int failed.')
!         self.failUnless(a == 4634.0, 'PgNumeric comparison to Float failed.')
!         self.failUnless(a == 4634L, 'PgNumeric comparison to Long failed.')
!         self.failUnless(a != None, 'PgNumericcomparison to None failed')
  
  class PgSQLTestCases(unittest.TestCase):
--- 274,384 ----
  
      def CheckPgNumeric(self):
! 	try:
!             a = PgSQL.PgNumeric('1234.00')
!             self.failUnless(a.getPrecision() == 6,
!                             'PgNumeric from string failed')
!             self.failUnless(a.getScale() == 2, 'PgNumeric from string failed')
!             self.failUnless(a == 1234, 'PgNumeric comparison to string failed.')
!             self.failUnless(a == 1234.0,
! 			    'PgNumeric comparison to Float failed.')
!             self.failUnless(a == 1234L, 'PgNumeric comparison to Long failed.')
!             self.failUnless(a != None, 'PgNumeric comparison to None failed')
! 	except StandardError, msg:
! 	    self.fail(msg)
! 
! 	try:
!             a = PgSQL.PgNumeric(2345.00)
!             self.failUnless(a.getPrecision() == 5,
!                             'PgNumeric from float failed')
!             self.failUnless(a.getScale() == 1, 'PgNumeric from float failed')
!             self.failUnless(a == 2345, 'PgNumeric from float failed.')
! 	except StandardError, msg:
! 	    self.fail(msg)
! 
! 	try:
!             a = PgSQL.PgNumeric(345600, 6, 2)
!             self.failUnless(a == 3456, 'PgNumeric from int failed.')
!             self.failUnless(a.getPrecision() == 6, 'PgNumeric from int failed')
!             self.failUnless(a.getScale() == 2, 'PgNumeric from int failed')
! 	except StandardError, msg:
! 	    self.fail(msg)
! 
! 	try:
!             a = PgSQL.PgNumeric(456700L, 6, 2)
!             self.failUnless(a == 4567, 'PgNumeric from long failed.')
!             self.failUnless(a.getPrecision() == 6, 'PgNumeric from long failed')
!             self.failUnless(a.getScale() == 2, 'PgNumeric from long failed')
! 	except StandardError, msg:
! 	    self.fail(msg)
! 
!         try: # Test the casting of PgNumeric -> PgNumeric to change prec/scale
!             a = PgSQL.PgNumeric('123456.78')
!             b = PgSQL.PgNumeric(a, 10, 4)
!             c = PgSQL.PgNumeric(a, 7, 1)
!             self.failUnless(b.getPrecision() == 10, 'PgNumeric cast failed')
!             self.failUnless(b.getScale() == 4, 'PgNumeric cast failed')
!             self.failUnless(c.getPrecision() == 7, 'PgNumeric cast failed')
!             self.failUnless(c.getScale() == 1, 'PgNumeric cast failed')
!             self.failUnless(a == b, 'PgNumeric cast failed')
!             self.failUnless(a != c, 'PgNumeric cast failed')
!             self.failUnless(str(c) == '123456.8', 'PgNumeric cast failed.')
! 	except StandardError, msg:
! 	    self.fail(msg)
! 
!         try: # Test the basic math functions.
!             a = PgSQL.PgNumeric('1234.567')
!             b = PgSQL.PgNumeric('12.3456789')
!             c = a + b
!             self.failUnless(c.getPrecision() == 11, 'PgNumeric addition failed')
!             self.failUnless(c.getScale() == 7, 'PgNumeric addition failed')
!             self.failUnless(str(c) == '1246.9126789',
!                             'PgNumeric addition failed.')
!             c = a - b
!             self.failUnless(c.getPrecision() == 11,
!                             'PgNumeric subtraction failed')
!             self.failUnless(c.getScale() == 7, 'PgNumeric subtraction failed')
!             self.failUnless(str(c) == '1222.2213211',
!                             'PgNumeric subtraction failed.')
!             c = a * b
!             self.failUnless(c.getPrecision() == 16,
!                             'PgNumeric multiplication failed')
!             self.failUnless(c.getScale() == 10,
!                             'PgNumeric mulitplication failed')
!             self.failUnless(str(c) == '15241.5677625363',
!                             'PgNumeric multiplication failed.')
!             c = a / b
!             self.failUnless(c.getPrecision() == 7, 'PgNumeric division failed')
!             self.failUnless(c.getScale() == 3, 'PgNumeric divisioncast failed')
!             self.failUnless(str(c) == '100.000',
!                             'PgNumeric divisioncast failed.')
!             c = PgSQL.PgNumeric(a)
!             c += b
!             self.failUnless(c.getPrecision() == 11, 'PgNumeric addition failed')
!             self.failUnless(c.getScale() == 7, 'PgNumeric addition failed')
!             self.failUnless(str(c) == '1246.9126789',
!                             'PgNumeric addition failed.')
!             c = PgSQL.PgNumeric(a)
!             c -= b
!             self.failUnless(c.getPrecision() == 11,
!                             'PgNumeric subtraction failed')
!             self.failUnless(c.getScale() == 7, 'PgNumeric subtraction failed')
!             self.failUnless(str(c) == '1222.2213211',
!                             'PgNumeric subtraction failed.')
!             c = PgSQL.PgNumeric(a)
!             c *= b
!             self.failUnless(c.getPrecision() == 16,
!                             'PgNumeric multiplication failed')
!             self.failUnless(c.getScale() == 10,
!                             'PgNumeric mulitplication failed')
!             self.failUnless(str(c) == '15241.5677625363',
!                             'PgNumeric multiplication failed.')
!             c = PgSQL.PgNumeric(a)
!             c /= b
!             self.failUnless(c.getPrecision() == 7, 'PgNumeric division failed')
!             self.failUnless(c.getScale() == 3, 'PgNumeric divisioncast failed')
!             self.failUnless(str(c) == '100.000',
!                             'PgNumeric divisioncast failed.')
! 	except StandardError, msg:
! 	    self.fail(msg)
  
  class PgSQLTestCases(unittest.TestCase):