com.venky.swf.plugins.collab.db.model.config.State Maven / Gradle / Ivy

Go to download

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

swf-plugin-collab

There is a newer version: 2.12

package com.venky.swf.plugins.collab.db.model.config;

import java.util.List;

import com.venky.swf.db.Database;
import com.venky.swf.db.annotations.column.COLUMN_DEF;
import com.venky.swf.db.annotations.column.IS_NULLABLE;
import com.venky.swf.db.annotations.column.UNIQUE_KEY;
import com.venky.swf.db.annotations.column.defaulting.StandardDefault;
import com.venky.swf.db.annotations.column.indexing.Index;
import com.venky.swf.db.annotations.model.CONFIGURATION;
import com.venky.swf.db.model.Model;
import com.venky.swf.sql.Conjunction;
import com.venky.swf.sql.Expression;
import com.venky.swf.sql.Operator;
import com.venky.swf.sql.Select;
@CONFIGURATION
public interface State extends Model{
	@UNIQUE_KEY
	@Index
	public String getName();
	public void setName(String name);

	@UNIQUE_KEY
	@IS_NULLABLE(false)
	@COLUMN_DEF(StandardDefault.ONE)
	public Integer getCountryId();
	public void setCountryId(Integer iCountryId);
	public Country getCountry();
	
	public List getCities(); 
	
	public static State findByCountryAndName(String  countryName , String stateName) { 
		return findByCountryAndName(Country.findByName(countryName).getId(), stateName);
	}
	
	public static State findByCountryAndName(Integer countryId , String stateName) { 
		Select s = new Select().from(State.class);
		Expression where = new Expression(s.getPool(), Conjunction.AND);
		where.add(new Expression(s.getPool(),"NAME",Operator.EQ,stateName));
		where.add(new Expression(s.getPool(),"COUNTRY_ID",Operator.EQ,countryId));
		
		List states = s.where(where).execute(); 
		if (states.size() == 1) {
			return states.get(0);
		}else {
			State state = Database.getTable(State.class).newRecord(); 
			state.setCountryId(countryId);
			state.setName(stateName);
			state.save();
			return state;
		}
	}
}