package org.aegee.runanddine.feedback;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;

import org.aegee.runanddine.util.data.ModelNotExistingException;
import org.aegee.runanddine.util.model.MySQLModelManager;

/**
 * Manages persistent SingleRegistration models
 */
public class GracefulMailOfThanksMailTemplateManager extends MySQLModelManager<GracefulMailOfThanksMailTemplate> {

    /**
     * Singleton instance of GracefulMailOfThanksMailTemplateManager
     */
    private static GracefulMailOfThanksMailTemplateManager instance = null;

    /**
     * Init GracefulMailOfThanksMailTemplateManager
     * (private because of singleton pattern)
     */
    private GracefulMailOfThanksMailTemplateManager() {
        super();
        this.table = "single_classes";
    }

    /**
     * Return singleton instance of GracefulMailOfThanksMailTemplateManager
     *
     * @return Singleton instance of GracefulMailOfThanksMailTemplateManager
     */
    public static GracefulMailOfThanksMailTemplateManager getInstance() {
        // create singleton instance if it does not exist
        if (GracefulMailOfThanksMailTemplateManager.instance == null) {
            GracefulMailOfThanksMailTemplateManager.instance = new GracefulMailOfThanksMailTemplateManager();
        }

        return GracefulMailOfThanksMailTemplateManager.instance;
    }

    /**
     * Get GracefulMailOfThanksMailTemplate
     *
     * @return GracefulMailOfThanksMailTemplate
     * @throws ModelNotExistingException
     */
    public GracefulMailOfThanksMailTemplate get() throws ModelNotExistingException {
        try {
            PreparedStatement stmt = this.con.prepareStatement("SELECT id, serialized_object FROM " + this.table + " WHERE class_name=?");
            // bind name
            stmt.setString(1, GracefulMailOfThanksMailTemplate.class.getName());
            // search for model
            ResultSet rs = stmt.executeQuery();
            // check if model exists
            if (rs.next()) {
                // deserialize model
                GracefulMailOfThanksMailTemplate model = this.readObject(rs.getBytes("serialized_object"));
                model.setId(rs.getInt("id"));
                rs.close();
                stmt.close();

                return model;
            } else {
                throw new ModelNotExistingException();
            }
        } catch (SQLException e) {
            e.printStackTrace(System.err);
            return null;
        }
    }

    /**
     * Not supported because there can only be one GracefulMailOfThanksMailTemplate
     */
    @Override
    public List<GracefulMailOfThanksMailTemplate> getAll() {
        throw new UnsupportedOperationException();
    }

    /**
     * Stores new model or updates existing one
     *
     * @param model Model to be saved/updated
     */
    @Override
    public void save(GracefulMailOfThanksMailTemplate model) {
        try {
            // update model
            if (this.hasModel(model.getId())) {
                PreparedStatement stmt = this.con.prepareStatement("UPDATE " + this.table + " SET serialized_object=?, class_name=? WHERE id=?");
                // bind values
                stmt.setObject(1, model);
                stmt.setString(2, model.getClass().getName());
                stmt.setInt(3, model.getId());
                // execute update
                stmt.executeUpdate();
                stmt.close();
                // save new model
            } else {
                PreparedStatement stmt = this.con.prepareStatement("INSERT INTO " + this.table + " (serialized_object, class_name) VALUES (?, ?)");
                // bind values to statement
                stmt.setObject(1, model);
                stmt.setString(2, model.getClass().getName());
                // execute insert
                stmt.executeUpdate();
                // retrieve auto increment id
                ResultSet rs = stmt.getGeneratedKeys();
                rs.next();
                model.setId(rs.getInt(1));
                rs.close();
                stmt.close();
            }
        } catch (SQLException e) {
            e.printStackTrace(System.err);
        }
    }

    /**
     * Create empty GracefulMailOfThanksMailTemplatte
     *
     * @return Empty GracefulMailOfThanksMailTemplate
     */
    public GracefulMailOfThanksMailTemplate newObject() {
        GracefulMailOfThanksMailTemplate model = new GracefulMailOfThanksMailTemplate();

        return model;
    }
}