Package org.fluentjdbc

Class DbContextSaveBuilder<T>

java.lang.Object

org.fluentjdbc.DbContextSaveBuilder<T>

public class DbContextSaveBuilder<T>
extends Object

Generate INSERT or UPDATE statements on DbContextTable by collecting field names and parameters. Support autogeneration of primary keys and unique natural keys. Example:

 DbContextTable table = context.table("database_test_table");
 try (DbContextConnection ignored = context.startConnection(dataSource)) {
     DatabaseSaveResult<Long> result = table.newSaveBuilder("id", object.getId())
         .uniqueKey("name", object.getName())
         .setField("value", object.getValue())
         .execute();
     object.setId(result.getId());
 }
 

See Also:

DatabaseInsertBuilder

Constructor Summary

Constructors

Constructor	Description
DbContextSaveBuilder(DbContextTable table, DatabaseSaveBuilder<T> saveBuilder)

Method Summary

Modifier and Type	Method	Description
DatabaseSaveResult<T>	execute()	Executes the UPDATE or INSERT statement and returns a DatabaseSaveResult which explains what operation was executed.
DbContextSaveBuilder<T>	setField(String fieldName, Object fieldValue)	Specify a column name to be saved
DbContextSaveBuilder<T>	uniqueKey(String fieldName, Object fieldValue)	Specify a natural key for this table.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

DbContextSaveBuilder

public DbContextSaveBuilder(DbContextTable table,
                            DatabaseSaveBuilder<T> saveBuilder)

Method Detail

uniqueKey

@CheckReturnValue
public DbContextSaveBuilder<T> uniqueKey(String fieldName,
                                         Object fieldValue)

Specify a natural key for this table. If the id is null and there is a unique key match, UPDATE is called with this row and the existing primary key is returned, instead of INSERT. If more than one uniqueKey, fluent-jdbc assumes a composite unique constraint, that is all fields must match

setField

@CheckReturnValue
public DbContextSaveBuilder<T> setField(String fieldName,
                                        Object fieldValue)

Specify a column name to be saved

execute

public DatabaseSaveResult<T> execute()

Executes the UPDATE or INSERT statement and returns a DatabaseSaveResult which explains what operation was executed. See DatabaseSaveBuilder.execute(Connection)