package com.neidetcher.petunia.service;

 import java.util.HashMap;

 import java.util.List;

 import java.util.Map;

 import org.apache.commons.logging.Log;

 import org.apache.commons.logging.LogFactory;

 import org.springframework.dao.OptimisticLockingFailureException;

 import org.springframework.jdbc.JdbcUpdateAffectedIncorrectNumberOfRowsException;

 import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;

 public class KnowledgeDaoImpl extends SqlMapClientDaoSupport implements KnowledgeDao

 {

    protected Log log = LogFactory.getLog(KnowledgeDaoImpl.class);

    @Override

    public Knowledge save(Knowledge knowledge)

    {

       log.debug(knowledge.toString());

       if (knowledge.isNew())

       {

          log.debug("create");

          knowledge.setVersion(0);

          Integer newId;

          newId = (Integer) getSqlMapClientTemplate().insert("Knowledge.insert", knowledge);

          knowledge.setId(newId);

          return knowledge;

       }

       log.debug("update");

       try

       {

          getSqlMapClientTemplate().update("Knowledge.update", knowledge, 1);

          knowledge.setVersion(knowledge.getVersion() + 1);

          return knowledge;

       }

       catch (JdbcUpdateAffectedIncorrectNumberOfRowsException exception)

       {

          log.warn(exception.getMessage());

          throw new OptimisticLockingFailureException(

                "Provided you have given an object with a valid ID, someone has written underneath you.  "

                      + "Do another find and save.", exception);

       }

    }

    public Knowledge find(Integer id)

    {

       return (Knowledge) getSqlMapClientTemplate().queryForObject("Knowledge.findById", id);

    }

    @Override

    public List<Knowledge> findByTagName(String tagName)

    {

       return getSqlMapClientTemplate().queryForList("Knowledge.findByTagName", tagName);

    }

    @Override

    public List<Knowledge> findByCategoryId(Integer categoryId)

    {

       return getSqlMapClientTemplate().queryForList("Knowledge.findByCategoryId", categoryId);

    }

    @Override

    public List<String> findTags(Integer knowledgeId)

    {

       return getSqlMapClientTemplate().queryForList("Knowledge.findTags", knowledgeId);

    }

    @Override

    public void addTag(Integer knowledgeId, String tagName)

    {

       Map<String, String> parameterMap = new HashMap<String, String>();

       parameterMap.put("knowledgeId", knowledgeId.toString());

       parameterMap.put("tagName", tagName);

       getSqlMapClientTemplate().insert("Knowledge.addTag", parameterMap);

    }

    public void removeTag(Integer knowledgeId, String tagName)

    {

       Map<String, String> parameterMap = new HashMap<String, String>();

       parameterMap.put("knowledgeId", knowledgeId.toString());

       parameterMap.put("tagName", tagName);

       getSqlMapClientTemplate().delete("Knowledge.removeTag", parameterMap);

    }

 }