package frame.file;

import frame.data.Entity;
import frame.data.EntitySet;
import frame.persist.NamedSQL;
import frame.persist.SQLRunner;


public class ActivePeriodLoader extends Preloader {

	@Override
	public void load() throws Exception {
		NamedSQL namedSQL = NamedSQL.getInstance("getDataSet");
		namedSQL.setTableName("workperiod");

		EntitySet entitySet = SQLRunner.getEntitySet(namedSQL);

		if (entitySet.isEmpty()) {
			throw new Exception("empty active period");
		}

		Entity entity = entitySet.next();

		String id = entity.getString("id");
		int year = entity.getInt("year");
		int month = entity.getInt("month");

		ActivePeriod.getInstance().init(id, year, month);
	}

}