All Downloads are FREE. Search and download functionalities are using the official Maven repository.

com.github.vlachenal.sql.UpdateBuilder Maven / Gradle / Ivy

Go to download

Dynamic SQL request builder

There is a newer version: 0.14
Show newest version
/*
  SQL request builder:  Dynamic SQL request builder for java
  Copyright (C) 2018 Vincent Lachenal

  This file is part of SQL request builder.

  SQL request builder is free software: you can redistribute it and/or modify
  it under the terms of the GNU Lesser General Public License as published by
  the Free Software Foundation, either version 3 of the License, or
  (at your option) any later version.

  SQL request builder is distributed in the hope that it will be useful,
  but WITHOUT ANY WARRANTY; without even the implied warranty of
  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  GNU Lesser General Public License for more details.

  You should have received a copy of the GNU Lesser General Public License
  along with SQL request builder. If not, see .
*/
package com.github.vlachenal.sql;

import java.util.ArrayList;
import java.util.List;
import java.util.Optional;


/**
 * SQL {@code UPDATE} request builder.

 * This class should be instantiated through {@link SQL} static method.
 *
 * @since 0.5
 *
 * @author Vincent Lachenal
 */
public class UpdateBuilder {

  // Attributes +
  /** SQL request string buffer */
  final StringBuilder buffer;

  /** Clauses values */
  final List values;
  // Attributes -


  // Constructors +
  /**
   * {@link UpdateBuilder} constructor
   *
   * @param table the table to update
   */
  public UpdateBuilder(final String table) {
    buffer = new StringBuilder("UPDATE ").append(table).append(" SET ");
    values = new ArrayList<>();
  }
  // Constructors -


  // Methods +
  /**
   * Add field to update.

   * Value will be added as prepared statement value (with '?' wildcard).
   *
   * @param column the column
   * @param value the value
   *
   * @return {@code this}
   */
  public UpdateBuilder field(final String column, final Object value) {
    if(!values.isEmpty()) {
      buffer.append(", ");
    }
    buffer.append(column).append(" = ?");
    values.add(value);
    return this;
  }

  /**
   * Add field to update.

   * Value will be added as prepared statement value (with '?' wildcard).
   *
   * @param column the column
   * @param value the value
   *
   * @return {@code this}
   */
  public UpdateBuilder field(final String column, final Optional value) {
  	value.ifPresent(o -> field(column, o));
    return this;
  }

  /**
   * Add 'WHERE' and clauses
   *
   * @param clauses the clauses to add
   *
   * @return the {@link UpdateBuilder}
   */
  public UpdateBuilder where(final ClausesBuilder clauses) {
    if(!clauses.firstClause) { // which means that at least one clause has been added
      buffer.append(" WHERE ").append(clauses.buffer);
      values.addAll(clauses.values);
    }
    return this;
  }

  /**
   * Build SQL query
   *
   * @return the query and its prepared statement values
   */
  public SQLQuery build() {
    return new SQLQuery(buffer.toString(), values);
  }
  // Methods -

}
    

    

    
            
    
            







    
© 2015 - 2024 Weber Informatics LLC | Privacy Policy