com.venky.swf.sql.Insert Maven / Gradle / Ivy

Go to download

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

Succinct Web Framework - Db

The newest version!

package com.venky.swf.sql;

import java.util.Iterator;
import java.util.Map;
import java.util.SortedSet;
import java.util.TreeSet;

import com.venky.swf.db.model.Model;
import com.venky.swf.db.model.reflection.ModelReflector;
import com.venky.swf.db.table.BindVariable;

public class Insert extends DataManupulationStatement{
	private String table = null;
	private Map values = null;
	private SortedSet keys = new TreeSet();
	
	public  Insert(ModelReflector ref){
		this(ref.getPool(),ref.getTableName());
	}
	public Insert(String pool,String table){
		super(pool);
		this.table = table;
	}
	
	public Insert values(Map values){
		this.values = values;
		keys.addAll(values.keySet());
		return this;
	}

	@Override
	protected void finalizeParameterizedSQL() {
		StringBuilder q = getQuery();

		q.append("INSERT into ").append(table); 
		q.append(" ( ");
		Iterator ki = keys.iterator();
		
		StringBuilder valueList = new StringBuilder();
		while (ki.hasNext()){
			String key = ki.next();
			q.append(key);
			valueList.append("?");
			getValues().add(values.get(key));
			if (ki.hasNext()){
				q.append(" , ");
				valueList.append(" , ");
			}
		}
		q.append(" ) values (");
		q.append(valueList.toString());
		q.append(" )");
	}

}