GetWhere

Get the rows specified by a SQL where clause.

root@turing:/examples/dbo# java examples.dbo.Test -conf postgres.cnf -test examples.dbo.Getwhere 
  -where "lower(name) like '%kolo%'"

INFO     New log level set to: LogLevel [3,INFO]
INFO     fc.util.FilePropertyMgrLoaded properties from file: postgres.cnf
>>> Retrieved 1 rows
[Class Name: [mollytest] [isDiscarded=false] [isNew=false] [isModified=false]
Note: IsNullInDB only meaningful for existing rows (i.e., isNew=false)
 PK FK Field      Value              isModified isNullinDB isSerial/AutoInc 
 x  -  uid        1                  -          -          x                
 -  -  name       Molly Kolodny      -          -          -                
 -  -  email      mol@holografix.net -          -          -                
 -  -  password   blue9              -          -          -                
 -  -  created_on 2007-04-10         -          -          -                
 -  -  is_active  true               -          -          -                
]
JVM shutdown: fc.io.Log - closing all logs...

test=# select * from mollytest where lower(name) like '%kolo%';
 uid |     name      |       email        | password | created_on | is_active 
-----+---------------+--------------------+----------+------------+-----------
   1 | Molly Kolodny | mol@holografix.net | blue9    | 2007-04-10 | t
(1 row)
root@turing:/examples/dbo# java examples.dbo.Test -conf mysql.cnf -test examples.dbo.Getwhere 
  -where "lower(name) like '%kolo%'"

INFO     New log level set to: LogLevel [3,INFO]
INFO     fc.util.FilePropertyMgrLoaded properties from file: mysql.cnf
>>> Retrieved 1 rows
[Class Name: [mollytest] [isDiscarded=false] [isNew=false] [isModified=false]
Note: IsNullInDB only meaningful for existing rows (i.e., isNew=false)
 PK FK Field      Value              isModified isNullinDB isSerial/AutoInc 
 x  -  uid        1                  -          -          x                
 -  -  name       Molly Kolodny      -          -          -                
 -  -  email      mol@holografix.net -          -          -                
 -  -  password   blue9              -          -          -                
 -  -  created_on 2007-04-08         -          -          -                
 -  -  is_active  true               -          -          -                
]
JVM shutdown: fc.io.Log - closing all logs...

mysql> select * from mollytest where lower(name) like '%kolo%';
+-----+---------------+--------------------+----------+------------+-----------+
| uid | name          | email              | password | created_on | is_active |
+-----+---------------+--------------------+----------+------------+-----------+
|   1 | Molly Kolodny | mol@holografix.net | blue9    | 2007-04-08 |         1 | 
+-----+---------------+--------------------+----------+------------+-----------+
1 row in set (0.00 sec)