Update

Updates an existing row.

root@turing:/examples/dbo# java examples.dbo.Test -test examples.dbo.Update -conf postgres.cnf -uid 2

INFO     New log level set to: LogLevel [3,INFO]
INFO     fc.util.FilePropertyMgrLoaded properties from file: postgres.cnf
>>> Updated successfully
Class Name: [mollytest] [isDiscarded=true] [isNew=false] [isModified=true]
Note: IsNullInDB only meaningful for existing rows (i.e., isNew=false)
 PK FK Field      Value           isModified isNullinDB isSerial/AutoInc 
 x  -  uid        2               -          -          x                
 -  -  name       Lupus Yonderboy -          -          -                
 -  -  email      lup@moderns.net -          -          -                
 -  -  password   wintermute      x          -          - 
 -  -  created_on 2007-04-10      -          -          -                
 -  -  is_active  false           x          -          - 

JVM shutdown: fc.io.Log - closing all logs...

test=# select * from mollytest;
 uid |      name       |       email        |  password  | created_on | is_active 
-----+-----------------+--------------------+------------+------------+-----------
   1 | Molly Kolodny   | mol@holografix.net | blue9      | 2007-04-10 | t
   2 | Lupus Yonderboy | lup@moderns.net    | wintermute | 2007-04-10 | f
(2 rows)
root@turing:/examples/dbo# java examples.dbo.Test -test examples.dbo.Update -conf mysql.cnf -uid 2

INFO     New log level set to: LogLevel [3,INFO]
INFO     fc.util.FilePropertyMgrLoaded properties from file: mysql.cnf
>>> Updated successfully
Class Name: [mollytest] [isDiscarded=true] [isNew=false] [isModified=true]
Note: IsNullInDB only meaningful for existing rows (i.e., isNew=false)
 PK FK Field      Value           isModified isNullinDB isSerial/AutoInc 
 x  -  uid        2               -          -          x                
 -  -  name       Lupus Yonderboy -          -          -                
 -  -  email      lup@moderns.net -          -          -            
 -  -  password   wintermute      x          -          -
 -  -  created_on 2007-04-08      -          -          -                
 -  -  is_active  false           x          -          -

JVM shutdown: fc.io.Log - closing all logs...

mysql> select * from mollytest;
+-----+-----------------+--------------------+------------+------------+-----------+
| uid | name            | email              | password   | created_on | is_active |
+-----+-----------------+--------------------+------------+------------+-----------+
|   1 | Molly Kolodny   | mol@holografix.net | blue9      | 2007-04-08 |         1 | 
|   2 | Lupus Yonderboy | lup@moderns.net    | wintermute | 2007-04-08 |         0 | 
+-----+-----------------+--------------------+------------+------------+-----------+
2 rows in set (0.01 sec)