com.github.napp.database.impl.InsertQuery Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of notbed-db Show documentation

database

There is a newer version: 1.1.8

/**
 *
 */
package com.github.napp.database.impl;

import java.sql.PreparedStatement;
import java.sql.SQLException;

import com.github.napp.database.IInsertQuery;
import com.github.napp.util.UString;

/**
 * @author Alexandru Bledea
 * @since Sep 27, 2013
 */
class InsertQuery extends SetQuery implements IInsertQuery {

	/**
	 * @param dao
	 */
	InsertQuery(DAO dao) {
		super(dao, "INSERT INTO ");
	}

	/**
	 * @param sb
	 */
	private void addSetClause(StringBuilder sb) {
		if (set.isEmpty()) {
			throw new IllegalStateException("Empty Set Arguments!");
		}
		String table = UString.join(set.keySet(), ", ");
		sb.append(pad(table)).append(" VALUES ");
		String elem = UString.join(PLACEHOLDER, set.size(), ", ");
		sb.append(pad(elem));
	}

	/**
	 * @param s
	 * @return
	 */
	private String pad(String s) {
		return UString.pad(s, "(", ")");
	}

	/* (non-Javadoc)
	 * @see com.github.napp.database.impl.Query#addToQuery(java.lang.StringBuilder)
	 */
	@Override
	protected void addToQuery(StringBuilder sb) {
		addSetClause(sb);
	}

	/* (non-Javadoc)
	 * @see com.github.napp.database.impl.WhereQuery#setArguments(java.sql.PreparedStatement)
	 */
	@Override
	protected void setArguments(PreparedStatement ps) throws SQLException {
		addAll(ps, set.values());
	}

}