/*
 *  Radiozentrale - Webradio App
 *  Copyright (C) 2018 Ulrich Hilger, http://uhilger.de
 *
 *  This program 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.
 *
 *  This program 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 this program.  If not, see http://www.gnu.org/licenses/
 */

package de.uhilger.radiozentrale.api;

import de.uhilger.baselink.GenericRecord;
import de.uhilger.baselink.PersistenceManager;
import de.uhilger.radiozentrale.daten.Sender;
import de.uhilger.radiozentrale.web.Initialiser;
import java.sql.Connection;
import java.util.List;

/**
 *
 */
public class SenderApi extends Api {
  
  public static final String SQL_GET_SENDER = "getSender";
  public static final String SQL_GET_NEXT_KEY = "getNextKey";
  public static final String SQL_INCREMENT_KEY = "incrementKey";
  
  public static final String KEY_SENDER_ID = "sender_id";
  
  
  public Sender neuerSender(Sender sender) {
    Sender neuerSender = null;
    PersistenceManager db = getDb();
    Connection c = db.getConnection();
    db.startTransaction(c);
    int nextKey = getNextId(db, KEY_SENDER_ID);
    if(nextKey > -1) {
      sender.setId(nextKey);
      Object o = getDb().insert(sender, getMapper(Initialiser.MP_SENDER));
      if(o instanceof Sender) {
        neuerSender = (Sender) o;
        db.commit(c);
      } else {
        db.rollback(c);
      } 
    }
    return neuerSender;  
  }
  
  public List senderliste() {
    return getDb().select(getSql(SQL_GET_SENDER), getMapper(Initialiser.MP_SENDER));
  }
  
  private int getNextId(PersistenceManager db, String key) {
    int nextKey = -1;
    List<List<String>> list = db.select(getSql(SQL_GET_NEXT_KEY), GenericRecord.WITHOUT_BLOBS, key);
    if(list != null && list.size() > 1) {
      nextKey = Integer.parseInt(list.get(1).get(0)); // erster Datensatz ist Ueberschrift
      if(nextKey > -1) {
        db.execute(getSql(SQL_INCREMENT_KEY), nextKey+1, key, nextKey);
      }
    }
    return nextKey;
  }
}