Search in sources :

Example 6 with Treatment

use of org.eyeseetea.malariacare.data.database.model.Treatment in project pictureapp by EyeSeeTea.

the class PopulateRow method populateTreatments.

/**
     * Method to populate each row of Treatment.csv, execute after populateOrganisations.
     *
     * @param line The row of the csv to populate.
     * @param stringKeyList
     */
static Treatment populateTreatments(String[] line, HashMap<Long, Organisation> organisationFK, HashMap<Long, StringKey> stringKeyList, @Nullable Treatment treatment) {
    if (treatment == null) {
        treatment = new Treatment();
    }
    treatment.setOrganisation(organisationFK.get(Long.parseLong(line[1])));
    treatment.setDiagnosis(stringKeyList.get(Long.valueOf(line[2])).getId_string_key());
    treatment.setMessage(stringKeyList.get(Long.valueOf(line[3])).getId_string_key());
    treatment.setType(Integer.parseInt(line[4]));
    return treatment;
}
Also used : Treatment(org.eyeseetea.malariacare.data.database.model.Treatment)

Example 7 with Treatment

use of org.eyeseetea.malariacare.data.database.model.Treatment in project pictureapp by EyeSeeTea.

the class UpdateDB method updateDrugCombination.

/**
 * Method to Update drugCombination from csvs.
 *
 * @param context Needed to open the csvs.
 * @throws IOException If there is a problem opening the csv.
 */
public static void updateDrugCombination(Context context, boolean updateCSV) throws IOException {
    if (updateCSV) {
        FileCsvs fileCsvs = new FileCsvs();
        fileCsvs.saveCsvFromAssetsToFile(PopulateDB.DRUG_COMBINATIONS_CSV);
    }
    List<DrugCombination> drugCombinations = DrugCombination.getAllDrugCombination();
    HashMap<Long, Drug> drugIds = RelationsIdCsvDB.getDrugIdRelationCsvDB(context);
    HashMap<Long, Treatment> treatmentIds = RelationsIdCsvDB.getTreatmentIdRelationCsvDB(context);
    CSVReader reader = new CSVReader(new InputStreamReader(context.openFileInput(PopulateDB.DRUG_COMBINATIONS_CSV)), SEPARATOR, QUOTECHAR);
    String[] line;
    int i = 0;
    while ((line = reader.readNext()) != null) {
        if (i < drugCombinations.size()) {
            PopulateRow.populateDrugCombinations(line, drugIds, treatmentIds, drugCombinations.get(i)).save();
        } else {
            PopulateRow.populateDrugCombinations(line, drugIds, treatmentIds, null).insert();
        }
    }
}
Also used : Drug(org.eyeseetea.malariacare.data.database.model.Drug) InputStreamReader(java.io.InputStreamReader) CSVReader(com.opencsv.CSVReader) DrugCombination(org.eyeseetea.malariacare.data.database.model.DrugCombination) Treatment(org.eyeseetea.malariacare.data.database.model.Treatment)

Example 8 with Treatment

use of org.eyeseetea.malariacare.data.database.model.Treatment in project pictureapp by EyeSeeTea.

the class UpdateDB method updateTreatmentMatches.

/**
 * Method to update treatmentMatches from csvs.
 *
 * @param context Needed to open the csvs.
 * @throws IOException If there is a problem opening the csv.
 */
public static void updateTreatmentMatches(Context context, boolean updateCSV) throws IOException {
    if (updateCSV) {
        FileCsvs fileCsvs = new FileCsvs();
        fileCsvs.saveCsvFromAssetsToFile(PopulateDB.TREATMENT_MATCHES_CSV);
    }
    List<TreatmentMatch> treatmentMatches = TreatmentMatch.getAllTreatmentMatches();
    HashMap<Long, Treatment> treatmentIds = RelationsIdCsvDB.getTreatmentIdRelationCsvDB(context);
    HashMap<Long, Match> matchIds = RelationsIdCsvDB.getMatchIdRelationCsvDB(context);
    CSVReader reader = new CSVReader(new InputStreamReader(context.openFileInput(PopulateDB.TREATMENT_MATCHES_CSV)), SEPARATOR, QUOTECHAR);
    String[] line;
    int i = 0;
    while ((line = reader.readNext()) != null) {
        if (i < treatmentMatches.size()) {
            PopulateRow.populateTreatmentMatches(line, treatmentIds, matchIds, treatmentMatches.get(i)).save();
        } else {
            PopulateRow.populateTreatmentMatches(line, treatmentIds, matchIds, null).insert();
        }
        i++;
    }
}
Also used : InputStreamReader(java.io.InputStreamReader) TreatmentMatch(org.eyeseetea.malariacare.data.database.model.TreatmentMatch) CSVReader(com.opencsv.CSVReader) PopulateRow.populateMatch(org.eyeseetea.malariacare.data.database.utils.populatedb.PopulateRow.populateMatch) Match(org.eyeseetea.malariacare.data.database.model.Match) TreatmentMatch(org.eyeseetea.malariacare.data.database.model.TreatmentMatch) Treatment(org.eyeseetea.malariacare.data.database.model.Treatment)

Example 9 with Treatment

use of org.eyeseetea.malariacare.data.database.model.Treatment in project pictureapp by EyeSeeTea.

the class TreatmentTableOperations method deleteOldTreatmentTable.

private void deleteOldTreatmentTable() throws IOException {
    List<TreatmentMatch> treatmentMatches = TreatmentMatch.getAllTreatmentMatches();
    for (TreatmentMatch treatmentMatch : treatmentMatches) {
        deleteRelatedTablesLines(treatmentMatch);
        treatmentMatch.delete();
    }
    List<Treatment> treatments = Treatment.getAllTreatments();
    for (Treatment treatment : treatments) {
        treatment.delete();
    }
    List<DrugCombination> drugCombinations = DrugCombination.getAllDrugCombination();
    for (DrugCombination drugCombination : drugCombinations) {
        drugCombination.delete();
    }
    List<StringKey> stringKeys = StringKey.getAllStringKeys();
    for (StringKey stringKey : stringKeys) {
        stringKey.delete();
    }
    List<Translation> translations = Translation.getAllTranslations();
    for (Translation translation : translations) {
        translation.delete();
    }
}
Also used : Translation(org.eyeseetea.malariacare.data.database.model.Translation) Treatment(org.eyeseetea.malariacare.data.database.model.Treatment) TreatmentMatch(org.eyeseetea.malariacare.data.database.model.TreatmentMatch) StringKey(org.eyeseetea.malariacare.data.database.model.StringKey) DrugCombination(org.eyeseetea.malariacare.data.database.model.DrugCombination)

Aggregations

Treatment (org.eyeseetea.malariacare.data.database.model.Treatment)9 CSVReader (com.opencsv.CSVReader)5 InputStreamReader (java.io.InputStreamReader)5 StringKey (org.eyeseetea.malariacare.data.database.model.StringKey)4 TreatmentMatch (org.eyeseetea.malariacare.data.database.model.TreatmentMatch)4 DrugCombination (org.eyeseetea.malariacare.data.database.model.DrugCombination)3 Drug (org.eyeseetea.malariacare.data.database.model.Drug)2 Match (org.eyeseetea.malariacare.data.database.model.Match)2 Partner (org.eyeseetea.malariacare.data.database.model.Partner)2 Translation (org.eyeseetea.malariacare.data.database.model.Translation)2 FileNotFoundException (java.io.FileNotFoundException)1 IOException (java.io.IOException)1 ArrayList (java.util.ArrayList)1 HashMap (java.util.HashMap)1 Answer (org.eyeseetea.malariacare.data.database.model.Answer)1 Header (org.eyeseetea.malariacare.data.database.model.Header)1 Option (org.eyeseetea.malariacare.data.database.model.Option)1 OptionAttribute (org.eyeseetea.malariacare.data.database.model.OptionAttribute)1 Program (org.eyeseetea.malariacare.data.database.model.Program)1 Question (org.eyeseetea.malariacare.data.database.model.Question)1