#172

Committed 01 Aug 2024 07:53PM UTC coverage: 94.146% (-1.3%) from 95.478%

Build # #172

Build Type

push

Committed by

Commit Message

DatabaseUpdatable.setField with expression allows to insert and update rows with calculated column values

Run Details

41 of 45 new or added lines in 7 files covered. (91.11%)

32 existing lines in 12 files now uncovered.

1174 of 1247 relevant lines covered (94.15%)

0.94 hits per line

Source File
Press 'n' to go to next uncovered line, 'b' for previous

81.82

/src/main/java/org/fluentjdbc/DbContextUpdateBuilder.java

package org.fluentjdbc;

import java.util.Collection;
import java.util.List;
import java.util.Map;

/**
 * Generate <code>UPDATE</code> insert statements by collecting field names and parameters. Support
 * autogeneration of primary keys. Example:
 *
 * <pre>
 * {@link DbContextTable} table = context.table("database_test_table");
 * try (DbContextConnection ignored = context.startConnection(dataSource)) {
 *      int count = table
 *          .where("id", id)
 *          .update()
 *          .setField("name", "Something")
 *          .setField("code", 102)
 *          .execute(connection);
 * }
 * </pre>
 */
public class DbContextUpdateBuilder implements DatabaseUpdatable<DbContextUpdateBuilder> {

    private final DbContextTable table;
    private DatabaseUpdateBuilder builder;

    public DbContextUpdateBuilder(DbContextTable table, DatabaseUpdateBuilder builder) {
        this.table = table;
        this.builder = builder;
    }

    /**
     * Calls {@link #setField(String, Object)} for each fieldName and parameter
     */
    @Override
    public DbContextUpdateBuilder setFields(List<String> fields, List<?> values) {
        return build(builder.setFields(fields, values));
    }

    /**
     * Calls {@link #setField(String, Object)} for each key and value in the parameter map
     */
    @Override
    public DbContextUpdateBuilder setFields(Map<String, ?> fields) {
        return build(builder.setFields(fields));
    }

    /**
     * Adds the fieldName to the SQL statement and the value to the parameter list
     */
    @Override
    public DbContextUpdateBuilder setField(String field, Object value) {
        return build(builder.setField(field, value));
    }

    @Override
    public DbContextUpdateBuilder setField(String field, String expression, Collection<?> values) {
        return build(builder.setField(field, expression, values));
    }

    /**
     * Will execute the UPDATE statement to the database
     */
    public int execute() {
        return builder.execute(table.getConnection());
    }

    private DbContextUpdateBuilder build(DatabaseUpdateBuilder builder) {
        this.builder = builder;
        return this;
    }
}

1	package org.fluentjdbc;
2
3	import java.util.Collection;
4	import java.util.List;
5	import java.util.Map;
6
7	/**
8	* Generate <code>UPDATE</code> insert statements by collecting field names and parameters. Support
9	* autogeneration of primary keys. Example:
10	*
11	* <pre>
12	* {@link DbContextTable} table = context.table("database_test_table");
13	* try (DbContextConnection ignored = context.startConnection(dataSource)) {
14	* int count = table
15	* .where("id", id)
16	* .update()
17	* .setField("name", "Something")
18	* .setField("code", 102)
19	* .execute(connection);
20	* }
21	* </pre>
22	*/
23	public class DbContextUpdateBuilder implements DatabaseUpdatable<DbContextUpdateBuilder> {
24
25	private final DbContextTable table;
26	private DatabaseUpdateBuilder builder;
27
28	public DbContextUpdateBuilder(DbContextTable table, DatabaseUpdateBuilder builder) {	1✔
29	this.table = table;	1✔
30	this.builder = builder;	1✔
31	}	1✔
32
33	/**
34	* Calls {@link #setField(String, Object)} for each fieldName and parameter
35	*/
36	@Override
37	public DbContextUpdateBuilder setFields(List<String> fields, List<?> values) {
38	return build(builder.setFields(fields, values));	1✔
39	}
40
41	/**
42	* Calls {@link #setField(String, Object)} for each key and value in the parameter map
43	*/
44	@Override
45	public DbContextUpdateBuilder setFields(Map<String, ?> fields) {
UNCOV 46	return build(builder.setFields(fields));	×
47	}
48
49	/**
50	* Adds the fieldName to the SQL statement and the value to the parameter list
51	*/
52	@Override
53	public DbContextUpdateBuilder setField(String field, Object value) {
54	return build(builder.setField(field, value));	1✔
55	}
56
57	@Override
58	public DbContextUpdateBuilder setField(String field, String expression, Collection<?> values) {
NEW 59	return build(builder.setField(field, expression, values));	×
60	}
61
62	/**
63	* Will execute the UPDATE statement to the database
64	*/
65	public int execute() {
66	return builder.execute(table.getConnection());	1✔
67	}
68
69	private DbContextUpdateBuilder build(DatabaseUpdateBuilder builder) {
70	this.builder = builder;	1✔
71	return this;	1✔
72	}
73	}

jhannes / fluent-jdbc / #172

Source File Press 'n' to go to next uncovered line, 'b' for previous

Source File
Press 'n' to go to next uncovered line, 'b' for previous