EncounterTable.java

/*
 * The contents of this file are subject to the OpenMRS Public License
 * Version 1.0 (the "License"); you may not use this file except in
 * compliance with the License. You may obtain a copy of the License at
 * http://license.openmrs.org
 *
 * Software distributed under the License is distributed on an "AS IS"
 * basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
 * License for the specific language governing rights and limitations
 * under the License.
 *
 * Copyright (C) OpenMRS, LLC.  All Rights Reserved.
 */

package org.openmrs.mobile.databases.tables;

import org.openmrs.mobile.databases.DBOpenHelper;
import org.openmrs.mobile.databases.OpenMRSDBOpenHelper;
import org.openmrs.mobile.models.Encounter;

public class EncounterTable extends Table<Encounter> {
    public static final String TABLE_NAME = "encounters";

    /**
     * Number of columns without ID column
     * use as a param to
     *
     * @see org.openmrs.mobile.databases.tables.Table#values(int)
     */
    private static final int INSERT_COLUMNS_COUNT = 7;

    @Override
    public String createTableDefinition() {
        return CREATE_TABLE + TABLE_NAME + "("
                + Column.ID + PRIMARY_KEY
                + Column.VISIT_KEY_ID + Column.Type.INT_TYPE_WITH_COMMA
                + Column.UUID + Column.Type.TEXT_TYPE_NOT_NULL
                + Column.DISPLAY + Column.Type.TEXT_TYPE_WITH_COMMA
                + Column.ENCOUNTER_DATETIME + Column.Type.DATE_TYPE_NOT_NULL
                + Column.ENCOUNTER_TYPE + Column.Type.DATE_TYPE_WITH_COMMA
                + Column.PATIENT_UUID + Column.Type.TEXT_TYPE + Column.COMMA
                + Column.FORM_UUID + Column.Type.TEXT_TYPE
                + ");";
    }

    @Override
    public String insertIntoTableDefinition() {
        return INSERT_INTO + TABLE_NAME + "("
                + Column.VISIT_KEY_ID + Column.COMMA
                + Column.UUID + Column.COMMA
                + Column.DISPLAY + Column.COMMA
                + Column.ENCOUNTER_DATETIME + Column.COMMA
                + Column.ENCOUNTER_TYPE + Column.COMMA
                + Column.PATIENT_UUID + Column.COMMA
                + Column.FORM_UUID + ")"
                + values(INSERT_COLUMNS_COUNT);
    }

    @Override
    public String dropTableDefinition() {
        return DROP_TABLE_IF_EXISTS + TABLE_NAME;
    }

    @Override
    public Long insert(Encounter tableObject) {
        DBOpenHelper helper = OpenMRSDBOpenHelper.getInstance().getDBOpenHelper();
        return helper.insertEncounter(helper.getWritableDatabase(), tableObject);
    }

    @Override
    public int update(long tableObjectID, Encounter tableObject) {
        DBOpenHelper helper = OpenMRSDBOpenHelper.getInstance().getDBOpenHelper();
        return helper.updateEncounter(helper.getWritableDatabase(), tableObjectID, tableObject);
    }

    @Override
    public void delete(long tableObjectID) {
        DBOpenHelper openHelper = OpenMRSDBOpenHelper.getInstance().getDBOpenHelper();
        openHelper.getWritableDatabase().delete(TABLE_NAME, MasterColumn.ID + MasterColumn.EQUALS + tableObjectID, null);
    }

    public class Column extends MasterColumn {
        public static final String VISIT_KEY_ID = "visit_id";
        public static final String ENCOUNTER_DATETIME = "encounterDatetime";
        public static final String ENCOUNTER_TYPE = "type";
        public static final String PATIENT_UUID = "patient_uuid";
        public static final String FORM_UUID = "form_uuid";
    }

    @Override
    public String toString() {
        return TABLE_NAME + createTableDefinition();
    }
}