/*
 * Copyright 2010 Research Studios Austria Forschungsgesellschaft mBH
 *
 * This file is part of easyrec.
 *
 * easyrec is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * easyrec is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with easyrec.  If not, see <http://www.gnu.org/licenses/>.
 */

package org.easyrec.plugin.itemitem.store.dao.impl;

import org.easyrec.plugin.itemitem.model.UserAssoc;
import org.easyrec.plugin.itemitem.store.dao.UserAssocDAO;
import org.easyrec.utils.spring.store.dao.impl.AbstractTableCreatingDroppingDAOImpl;
import org.easyrec.utils.spring.store.service.sqlscript.SqlScriptService;

import javax.sql.DataSource;
import java.sql.Types;
import java.util.Date;

/**
 * MySQL implementation of @see{org.easyrec.plugin.itemitem.store.dao.UserAssocDAO} <p/> <p> <b>Company: </b> SAT,
 * Research Studios Austria </p> <p/> <p> <b>Copyright: </b> (c) 2007 </p> <p/> <p> <b>last modified:</b><br/>
 * $Author$<br/> $Date$<br/> $Revision$ </p>
 *
 * @author Patrick Marschik
 */
public class UserAssocDAOMysqlImpl extends AbstractTableCreatingDroppingDAOImpl implements UserAssocDAO {
    // ------------------------------ FIELDS ------------------------------

    public static final String QUERY_INSERT;
    public static final int[] ARGT_INSERT;
    private final static String TABLE_CREATING_SQL_SCRIPT_NAME = "classpath:sql/plugins/itemitem/ItemItemUserAssoc.sql";

    // -------------------------- STATIC METHODS --------------------------

    static {
        final StringBuilder query = new StringBuilder("INSERT INTO ");
        query.append(TABLE_NAME).append(" SET ");
        query.append(COLUMN_TENANT).append("=?, ");
        query.append(COLUMN_USERFROM).append("=?, ");
        query.append(COLUMN_ASSOCVALUE).append("=?, ");
        query.append(COLUMN_ITEMTO).append("=?, ");
        query.append(COLUMN_ITEMTOTYPE).append("=?, ");
        query.append(COLUMN_SOURCETYPE).append("=?, ");
        query.append(COLUMN_CHANGEDATE).append("=?");
        query.append(" ON DUPLICATE KEY UPDATE ");
        query.append(COLUMN_ASSOCVALUE).append("=VALUES(").append(COLUMN_ASSOCVALUE).append("), ");
        query.append(COLUMN_CHANGEDATE).append("=VALUES(").append(COLUMN_CHANGEDATE).append(")");

        QUERY_INSERT = query.toString();
        ARGT_INSERT = new int[]{Types.INTEGER, Types.INTEGER, Types.DOUBLE, Types.INTEGER, Types.INTEGER, Types.INTEGER,
                Types.TIMESTAMP};
    }

    // --------------------------- CONSTRUCTORS ---------------------------

    public UserAssocDAOMysqlImpl(final DataSource dataSource, final SqlScriptService sqlScriptService) {
        super(sqlScriptService);
        setDataSource(dataSource);
    }

    // ------------------------ INTERFACE METHODS ------------------------


    // --------------------- Interface TableCreatingDAO ---------------------

    @Override
    public String getDefaultTableName() {
        return TABLE_NAME;
    }

    @Override
    public String getTableCreatingSQLScriptName() {
        return TABLE_CREATING_SQL_SCRIPT_NAME;
    }

    // --------------------- Interface UserAssocDAO ---------------------

    public int insertOrUpdateUserAssoc(final UserAssoc userAssoc) {
        final Object[] args = new Object[]{userAssoc.getTenantId(), userAssoc.getUserFrom(), userAssoc.getAssocValue(),
                userAssoc.getItemTo().getItem(), userAssoc.getItemTo().getType(), userAssoc.getSourceTypeId(),
                new Date()};

        return getJdbcTemplate().update(QUERY_INSERT, args, ARGT_INSERT);
    }
}