package org.paneris.jammyjoes.model;

 import java.sql.ResultSet;

 import java.util.Hashtable;

 import java.util.Locale;

 import org.melati.poem.Database;

 import org.melati.poem.DefinitionSource;

 import org.melati.poem.PoemException;

 import org.melati.poem.PoemThread;

 import org.paneris.jammyjoes.model.generated.ShopCurrencyTableBase;

 public class ShopCurrencyTable extends ShopCurrencyTableBase {

   public ShopCurrencyTable(

       Database database, String name,

       DefinitionSource definitionSource) throws PoemException {

     super(database, name, definitionSource);

   }

   private ShopCurrency UK,US,Euro;

   public synchronized void unifyWithDB(ResultSet colDescs)

       throws PoemException {

     super.unifyWithDB(colDescs);

     UK = ensure("UK Pound Sterling", 1d, Locale.UK);

     US = ensure("US Dollar", 1.473, Locale.US);

     Euro = ensure("Euro", 1.606, Locale.US);

   }

   public ShopCurrency ensure(String name, double conversionrate, Locale locale) {

     ShopCurrency c = (ShopCurrency)newPersistent();

     c.setName(name);

     c.setConversionrate(conversionrate);

     c.setLocale(locale.toString());

     return (ShopCurrency)getNameColumn().ensure(c);

   }

   public ShopCurrency getCurrency(Locale locale) {

     return getCurrency(locale.toString());

   }

   private Hashtable cache = null;

   private long cacheSerial = 0L;

   private static final Object nullEntry = new Object();

   public ShopCurrency getCurrency(String name) {

     if (cache == null || cacheSerial != serial(PoemThread.transaction()))

       cache = new Hashtable();

     Object value = cache.get(name);

     if (value == nullEntry)

       return null;

     else if (value != null)

       return (ShopCurrency)value;

     else {

       ShopCurrency prop =

           (ShopCurrency)getLocaleColumn().firstWhereEq(name);

       if (prop == null) {

         cache.put(name, nullEntry);

         return null;

       }

       else {

         cache.put(name, prop);

         return prop;

       }

     }

   }

 }