In some cases, you will need to make changes to or delete all or some records in a tables. ActiveJDBC provides a couple of convenience methods for this.
Updating all records in table
The static method
Model.updateAll() provides a way to update all records in a corresponding table:
Person.updateAll("last_name = ?", "Smith");
In the example above, all records in a table PEOPLE will be updates such, that the
last_name column will be set to value "Smith".
Updating selected records in table
The static method
Model.update() will do the job:
Person.update("name = ?, last_name = ?", "name like ?", "Steve", "Johnson", "%J%");
In the example above, all records
where name like '%J%' will be updated to have name = Steve and last name = "Johnson". In other words, the first argument to the method is what to update to, the second is conditions for selection, followed by a list of replacement arguments for both.
Updating of updated_at
Both batch methods described above will respect ActiveJDBC conventions and will also update the
updated_at column to the current system time for all updated records.
Following the same pattern,
Model.delete() is a convenient way to delete selected records:
Person.delete("age > ?", "10");
Here, all records will be deleted where column
age has a value greater than 10. This is self-explanatory
Deleting all records
This does not require explanation.
Complex batch operations
ActiveJDBC provides a way to actually batch destructive operations into a single batch. In some cases it can provide significant performance improvements
1 2 3 4 5
How to comment
The comment section below is to discuss documentation on this page.
If you have an issue, or discover bug, please follow instructions on the Support page