db9010 / com.jovial.db9010 / InsertStatement

InsertStatement

class InsertStatement : ColumnSetter

An SQL insert statement. See Database.insertInto.

Note that this statement type doesn't have a getReusable() method, like SelectQuery.Builder.getReusable. That's because, for an insert statment, the lambda that identifies the columns also sets their values. The overhead of establishing a mapping if those functions were to be separated exceeds the slight overhead of looking up the statement in the cache.

Types

Builder

A builder for an insert statement where the client code is interested in the ResultSet generated by the PreparedStatement. See Database.insertInto.

class Builder : StatementBuilder<Key>

BuilderNoResults

A builder for an insert statement where the client code is not interested in the ResultSet generated by the PreparedStatement. See Database.insertInto.

class BuilderNoResults

Key

Key used for caching insert statements by Database.

data class Key

Result

A holder for the ResultSet created by PreparedStatement.getGeneratedKeys after an insert statement is run.

class Result : ResultsHolder