Homec4science
Diffusion Genome Privacy - SHCS App (master) Browse

genopri-shcs/project/PPPClientMobile/src/ch/epfl/pharma/database/contract/PatientsContract.java
ad4eb06adc79master

Last Change
Raw File

PatientsContract.java
View Options

package ch.epfl.pharma.database.contract;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import ch.epfl.pharma.database.contract.entry.DatabaseEntry.PatientEntry;
import ch.epfl.pharma.framework.Patient;
public class PatientsContract extends DatabaseContract {
public static final String SQL_TABLE_CREATE =
"CREATE TABLE " + PatientEntry.TABLE_NAME +
" (" +
PatientEntry.COL_ID_PATIENT + TYPE_INT + NOTNULL + PRIMARY_KEY + COMMA_SEP +
PatientEntry.COL_FIRSTNAME + TYPE_TEXT + COMMA_SEP +
PatientEntry.COL_LASTNAME + TYPE_TEXT + COMMA_SEP +
PatientEntry.COL_SEX + TYPE_TEXT + COMMA_SEP +
PatientEntry.COL_BIRTHDAY + TYPE_TEXT + COMMA_SEP +
PatientEntry.COL_PICTURE + TYPE_TEXT +
")";
public static Cursor getPatients(SQLiteDatabase db) {
String[] projection = {
PatientEntry.COL_ID_PATIENT,
PatientEntry.COL_FIRSTNAME,
PatientEntry.COL_LASTNAME,
PatientEntry.COL_SEX,
PatientEntry.COL_BIRTHDAY,
PatientEntry.COL_PICTURE};
// sort by lastname, then firstname
String sortOrder =
PatientEntry.COL_LASTNAME + " ASC, " +
PatientEntry.COL_FIRSTNAME + " ASC";
Cursor c = db.query(
PatientEntry.TABLE_NAME,
projection,
null, null, // no selection
null, // no grouping
null, // no filtering
sortOrder);
return c;
}
public static Patient getPatient(Cursor c) {
int patientId = getIntCol(c, PatientEntry.COL_ID_PATIENT);
String firstname = getStringCol(c, PatientEntry.COL_FIRSTNAME);
String lastname = getStringCol(c, PatientEntry.COL_LASTNAME);
String sex = getStringCol(c, PatientEntry.COL_SEX);
String birthday = getStringCol(c, PatientEntry.COL_BIRTHDAY);
String picture = getStringCol(c, PatientEntry.COL_PICTURE);
Patient patient = new Patient(patientId, firstname, lastname, sex, birthday, picture);
return patient;
}
public static Cursor getPatient(SQLiteDatabase db, long patientId) {
String[] projection = {
PatientEntry.COL_ID_PATIENT,
PatientEntry.COL_FIRSTNAME,
PatientEntry.COL_LASTNAME,
PatientEntry.COL_SEX,
PatientEntry.COL_BIRTHDAY,
PatientEntry.COL_PICTURE};
String selection = PatientEntry.COL_ID_PATIENT + "=?";
String[] selectionArgs = {
Long.toString(patientId) };
Cursor c = db.query(
PatientEntry.TABLE_NAME,
projection,
selection, selectionArgs,
null, // no grouping
null, // no filtering
null);
return c;
}
}
c4science · Help