Mercurial > dive4elements > river
view flys-backend/src/main/java/de/intevation/flys/importer/ImporterSession.java @ 1222:1f21f162bcf3
Fixed OrderBy clause in HYKEntry.
flys-backend/trunk@2348 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
---|---|
date | Mon, 18 Jul 2011 09:06:40 +0000 |
parents | bcc18293a547 |
children | cdb35d96ca09 |
line wrap: on
line source
package de.intevation.flys.importer; import java.util.Iterator; import java.util.Map; import java.util.TreeMap; import java.util.LinkedHashMap; import java.math.BigDecimal; import org.hibernate.SessionFactory; import org.hibernate.Session; import org.hibernate.Query; import org.hibernate.FlushMode; import de.intevation.flys.backend.SessionFactoryProvider; import de.intevation.flys.model.WstColumnValue; import de.intevation.flys.model.WstColumn; import de.intevation.flys.model.DischargeTableValue; import de.intevation.flys.model.DischargeTable; import de.intevation.flys.model.Range; import de.intevation.flys.model.River; import org.apache.log4j.Logger; public class ImporterSession { private static Logger log = Logger.getLogger(ImporterSession.class); public static final int CACHE_SIZE = 25; public static class Cache<K, V> extends LinkedHashMap<K, V> { @Override protected boolean removeEldestEntry(Map.Entry<K, V> eldest) { return size() > CACHE_SIZE; } }; private static final ThreadLocal<ImporterSession> SESSION = new ThreadLocal<ImporterSession>() { @Override protected ImporterSession initialValue() { return new ImporterSession(); } }; protected Session databaseSession; protected Cache<Integer, Map<ValueKey, WstColumnValue>> wstColumnValues; protected Cache<Integer, Map<ValueKey, DischargeTableValue>> dischargeTableValues; protected Cache<Integer, Map<ValueKey, Range>> ranges; public static ImporterSession getInstance() { return SESSION.get(); } public ImporterSession() { SessionFactory sessionFactory = SessionFactoryProvider.createSessionFactory(); databaseSession = sessionFactory.openSession(); //databaseSession.setFlushMode(FlushMode.MANUAL); wstColumnValues = new Cache<Integer, Map<ValueKey, WstColumnValue>>(); dischargeTableValues = new Cache<Integer, Map<ValueKey, DischargeTableValue>>(); ranges = new Cache<Integer, Map<ValueKey, Range>>(); } public Session getDatabaseSession() { return databaseSession; } public WstColumnValue getWstColumnValue( WstColumn column, BigDecimal position, BigDecimal w ) { Integer c = column.getId(); Map<ValueKey, WstColumnValue> map = wstColumnValues.get(c); if (map == null) { map = new TreeMap<ValueKey, WstColumnValue>( ValueKey.EPSILON_COMPARATOR); wstColumnValues.put(c, map); Query query = databaseSession.createQuery( "from WstColumnValue where wstColumn.id=:cid"); query.setParameter("cid", c); for (Iterator iter = query.iterate(); iter.hasNext();) { WstColumnValue wcv = (WstColumnValue)iter.next(); map.put(new ValueKey(wcv.getPosition(), wcv.getW()), wcv); } } ValueKey key = new ValueKey(position, w); WstColumnValue wcv = map.get(key); if (wcv != null) { return wcv; } wcv = new WstColumnValue(column, position, w); databaseSession.save(wcv); map.put(key, wcv); return wcv; } public DischargeTableValue getDischargeTableValue( DischargeTable table, BigDecimal q, BigDecimal w ) { Integer t = table.getId(); Map<ValueKey, DischargeTableValue> map = dischargeTableValues.get(t); if (map == null) { map = new TreeMap<ValueKey, DischargeTableValue>( ValueKey.EPSILON_COMPARATOR); dischargeTableValues.put(t, map); Query query = databaseSession.createQuery( "from DischargeTableValue where dischargeTable.id=:tid"); query.setParameter("tid", t); for (Iterator iter = query.iterate(); iter.hasNext();) { DischargeTableValue dctv = (DischargeTableValue)iter.next(); map.put(new ValueKey(dctv.getQ(), dctv.getW()), dctv); } } ValueKey key = new ValueKey(q, w); DischargeTableValue dctv = map.get(key); if (dctv != null) { return dctv; } dctv = new DischargeTableValue(table, q, w); databaseSession.save(dctv); map.put(key, dctv); return dctv; } public Range getRange(River river, BigDecimal a, BigDecimal b) { Integer r = river.getId(); Map<ValueKey, Range> map = ranges.get(r); if (map == null) { map = new TreeMap<ValueKey, Range>( ValueKey.EPSILON_COMPARATOR); ranges.put(r, map); Query query = databaseSession.createQuery( "from Range where river.id=:rid"); query.setParameter("rid", r); for (Iterator iter = query.iterate(); iter.hasNext();) { Range range = (Range)iter.next(); map.put(new ValueKey(range.getA(), range.getB()), range); } } ValueKey key = new ValueKey(a, b); Range range = map.get(key); if (range != null) { return range; } range = new Range(a, b, river); databaseSession.save(range); map.put(key, range); return range; } } // vim:set ts=4 sw=4 si et sta sts=4 fenc=utf8 :