DeleteUsing

Deletes a row or rows using the fields set in a template (or prototype) object.

root@turing:/examples/dbo# java examples.dbo.Test -test examples.dbo.Deleteusing 
  -conf postgres.cnf -email 'nowhere'

INFO     New log level set to: LogLevel [3,INFO]
INFO     fc.util.FilePropertyMgrLoaded properties from file: postgres.cnf
0 row(s) deleted
JVM shutdown: fc.io.Log - closing all logs...

root@turing:/examples/dbo# java examples.dbo.Test -test examples.dbo.Deleteusing 
  -conf postgres.cnf -email 'mol@holografix.net'

INFO     New log level set to: LogLevel [3,INFO]
INFO     fc.util.FilePropertyMgrLoaded properties from file: postgres.cnf
1 row(s) deleted
JVM shutdown: fc.io.Log - closing all logs...

test=# select * from mollytest;
 uid |      name       |      email      |  password  | created_on | is_active 
-----+-----------------+-----------------+------------+------------+-----------
   2 | Lupus Yonderboy | lup@moderns.net | wintermute | 2007-04-10 | f
(1 row)
root@turing:/examples/dbo# java examples.dbo.Test -test examples.dbo.Deleteusing -conf mysql.cnf 
  -email 'nowhere'

INFO     New log level set to: LogLevel [3,INFO]
INFO     fc.util.FilePropertyMgrLoaded properties from file: mysql.cnf
0 row(s) deleted
JVM shutdown: fc.io.Log - closing all logs...

root@turing:/examples/dbo# java examples.dbo.Test -test examples.dbo.Deleteusing -conf mysql.cnf 
  -email 'mol@holografix.net'

INFO     New log level set to: LogLevel [3,INFO]
INFO     fc.util.FilePropertyMgrLoaded properties from file: mysql.cnf
1 row(s) deleted
JVM shutdown: fc.io.Log - closing all logs...

mysql> select * from mollytest;
+-----+-----------------+-----------------+----------+------------+-----------+
| uid | name            | email           | password | created_on | is_active |
+-----+-----------------+-----------------+----------+------------+-----------+
|   2 | Lupus Yonderboy | lup@moderns.net | chaos    | 2007-04-09 |         1 | 
+-----+-----------------+-----------------+----------+------------+-----------+
1 row in set (0.00 sec)