type DMLResult
A DML result for a field annotated with @dbquery
.
When a field annotated with @dbquery has type DMLResult
then its SQL statement is assumed to be a data-change
statement (e.g. INSERT
, UPDATE
, DELETE
) that does not return a result set.
Fields
lastInsertId: ID
value generated by the database in response to a SQL statement execution. Typically this will be from an "auto increment" column when inserting a new row. Not all database types this field, and the syntax of such SQL statements varies.
rowsAffected: Int
number of rows affected by an data-change statement (UPDATE, INSERT, or DELETE). Not every database type may support this.