DataChecker.java

Go to the documentation of this file.

/*
 * Turró i Cutiller Foundation. License notice.
 * Copyright (C) 2011 Lluis Turró Cutiller <http://www.turro.org/>
 *
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU Affero 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 Affero General Public License for more details.
 *
 * You should have received a copy of the GNU Affero General Public License
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
 */
package org.turro.financials.db;
 
public class DataChecker {
 
//  public static void checkMajors(Application app) {
//    Dao dao = new FinancialsPU();
//    if(dao.getResultList("select book from BookDefinition as book"
//            ).isEmpty()) {
//      BufferedReader br = null;
//      try {
//        br = new BufferedReader(new InputStreamReader(new FileInputStream(app.getRealPath("/WEB-INF/elephant/sql/financials/book_ca.data"))));
//        String s;
//        while ((s = br.readLine()) != null) {
//          String v[] = s.split("\\|");
//          BookDefinition bd = new BookDefinition();
//          bd.setId(Long.valueOf(v[0]));
//          bd.setDescription(v[1]);
//          dao.saveObject(bd);
//        }
//      } catch (IOException ex) {
//        Logger.getLogger(DataChecker.class.getName()).log(Level.SEVERE, ElephantContext.logMsg(null), ex);
//      } finally {
//        try {
//          br.close();
//        } catch (IOException ex) {
//          Logger.getLogger(DataChecker.class.getName()).log(Level.SEVERE, ElephantContext.logMsg(null), ex);
//        }
//      }
//    }
//    if(dao.getResultList(
//            "select major from MajorAccount as major"
//            ).isEmpty()) {
//      BufferedReader br = null;
//      try {
//        br = new BufferedReader(new InputStreamReader(new FileInputStream(app.getRealPath("/WEB-INF/elephant/sql/financials/major_ca.data"))));
//        String s;
//        while ((s = br.readLine()) != null) {
//          String v[] = s.split("\\|");
//          MajorAccount ma = new MajorAccount();
//          ma.setAccount(v[0]);
//          ma.setDescription(v[1]);
//          ma.setBookDefinition(dao.find(BookDefinition.class, Long.valueOf(v[2])));
//          dao.saveObject(ma);
//        }
//      } catch (IOException ex) {
//        Logger.getLogger(DataChecker.class.getName()).log(Level.SEVERE, ElephantContext.logMsg(null), ex);
//      } finally {
//        try {
//          br.close();
//        } catch (IOException ex) {
//          Logger.getLogger(DataChecker.class.getName()).log(Level.SEVERE, ElephantContext.logMsg(null), ex);
//        }
//      }
//    }
//  }
//
//  public static void checkLineTypes(Application app) {
//    Dao dao = new FinancialsPU();
//    if(dao.getResultList("select lineType from LineType as lineType"
//            ).isEmpty()) {
//      BufferedReader br = null;
//      try {
//        br = new BufferedReader(new InputStreamReader(new FileInputStream(app.getRealPath("/WEB-INF/elephant/sql/financials/role_ca.data"))));
//        String s;
//        while ((s = br.readLine()) != null) {
//          String v[] = s.split("\\|");
//          LineType lt = new LineType();
//          lt.setId(Long.valueOf(v[0]));
//          lt.setName(v[1]);
//          dao.saveObject(lt);
//        }
//      } catch (IOException ex) {
//        Logger.getLogger(DataChecker.class.getName()).log(Level.SEVERE, ElephantContext.logMsg(null), ex);
//      } finally {
//        try {
//          br.close();
//        } catch (IOException ex) {
//          Logger.getLogger(DataChecker.class.getName()).log(Level.SEVERE, ElephantContext.logMsg(null), ex);
//        }
//      }
//    }
//    if(dao.getResultList(
//            "select ltAccount from LineTypeAccount as ltAccount"
//            ).isEmpty()) {
//      BufferedReader br = null;
//      try {
//        br = new BufferedReader(new InputStreamReader(new FileInputStream(app.getRealPath("/WEB-INF/elephant/sql/financials/roleAccount_ca.data"))));
//        String s;
//        while ((s = br.readLine()) != null) {
//          String v[] = s.split("\\|");
//          LineTypeAccount lta = new LineTypeAccount();
//          lta.setLineType(dao.find(LineType.class, Long.valueOf(v[0])));
//          int type = Integer.valueOf(v[1]);
//          switch(type) {
//            case 0 :
//              lta.setType(LineTypeAccountType.LTAT_TOTAL);
//              break;
//            case 1 :
//              lta.setType(LineTypeAccountType.LTAT_TAX_BASE);
//              break;
//            case 2 :
//              lta.setType(LineTypeAccountType.LTAT_TAX);
//              break;
//            case 3 :
//              lta.setType(LineTypeAccountType.LTAT_DISCOUNT);
//              break;
//          }
//          lta.setTypeValue(Double.valueOf(v[2]));
//          lta.setPattern(v[3]);
//          int pos = Integer.valueOf(v[4]);
//          if(pos == 0)
//            lta.setPosition(AccountPosition.ACC_DEBIT);
//          else
//            lta.setPosition(AccountPosition.ACC_CREDIT);
//          lta.setView(dao.find(RegisterView.class, Long.valueOf(v[5])));
//          lta.setCoefficient(Double.valueOf(v[7]));
//          dao.saveObject(lta);
//        }
//      } catch (IOException ex) {
//        Logger.getLogger(DataChecker.class.getName()).log(Level.SEVERE, ElephantContext.logMsg(null), ex);
//      } finally {
//        try {
//          br.close();
//        } catch (IOException ex) {
//          Logger.getLogger(DataChecker.class.getName()).log(Level.SEVERE, ElephantContext.logMsg(null), ex);
//        }
//      }
//    }
//  }
//
}