/*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package org.jdbi.v3.sqlobject.customizer;
import java.lang.annotation.Documented;
import java.lang.annotation.ElementType;
import java.lang.annotation.Retention;
import java.lang.annotation.RetentionPolicy;
import java.lang.annotation.Target;
import java.time.OffsetDateTime;
import org.jdbi.v3.sqlobject.customizer.internal.TimestampedFactory;
Binds the named parameter :now
or a custom named parameter with the current DateTime as an OffsetDateTime
. Common use cases:
public interface PersonDAO {
@SqlUpdate("INSERT INTO people(id, firstName, lastName, email, created, modified) VALUES (:p.id, :p.firstName, :p.lastName, :p.email, :now, :now)")
@Timestamped
@GetGeneratedKeys
int insert(@BindBean("p") Person person);
@SqlUpdate("UPDATE people SET modified = :now, firstName = :p.firstName, lastName = :p.lastName, email = :p.email WHERE id = :p.id")
@Timestamped
void update(@BindBean("p") Person person);
}
See Also:
/**
* Binds the named parameter <code>:now</code> or a custom named parameter with
* the current DateTime as an {@link OffsetDateTime}.
* Common use cases:
* <pre>
* <code>
* public interface PersonDAO {
* @SqlUpdate("INSERT INTO people(id, firstName, lastName, email, created, modified) VALUES (:p.id, :p.firstName, :p.lastName, :p.email, :now, :now)")
* @Timestamped
* @GetGeneratedKeys
* int insert(@BindBean("p") Person person);
*
* @SqlUpdate("UPDATE people SET modified = :now, firstName = :p.firstName, lastName = :p.lastName, email = :p.email WHERE id = :p.id")
* @Timestamped
* void update(@BindBean("p") Person person);
* }
* </code>
* </pre>
*
* @see TimestampedConfig
*/
@Target({ElementType.METHOD})
@Retention(RetentionPolicy.RUNTIME)
@SqlStatementCustomizingAnnotation(TimestampedFactory.class)
@Documented
public @interface Timestamped {
The parameter to bind in the SQL query. If omitted, defaults to now
and can be changed to customize the parameter bound to the current DateTime.
Returns: the parameter name
/**
* The parameter to bind in the SQL query. If omitted, defaults to <code>now</code>
* and can be changed to customize the parameter bound to the current DateTime.
*
* @return the parameter name
*/
String value() default "now";
}