test.googlecode.genericdao.databaseinitializer.SqlInsertStatementBuilder Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of test-base Show documentation

The newest version!

package test.googlecode.genericdao.databaseinitializer;

import java.util.ArrayList;
import java.util.List;
import java.util.Map.Entry;

public class SqlInsertStatementBuilder extends SqlStatementBuilder {
	
	@Override
	protected void buildSql() {
		beginSql();
		appendTableName();
		appendColumnNames();
		appendColumnValues();
	}

	protected void beginSql() {
		sql.append("INSERT INTO ");
	}

	protected void appendColumnNames() {
		List names = new ArrayList();
		
		for (Entry nameValuePair : columnValues) {
			names.add(nameValuePair.getKey());
		}
		
		sql.append("(");
		appendCommaDelimitedList(names);
		sql.append(")");
	}

	protected void appendColumnValues() {
		List values = new ArrayList();
		
		for (Entry nameValuePair : columnValues) {
			values.add(parameterPlaceholderOrNULL(nameValuePair.getValue()));
		}
		
		sql.append(" values (");
		appendCommaDelimitedList(values);
		sql.append(")");
	}
}