Homec4science
Diffusion Genome Privacy - SHCS App (mobile_app) Browse

genopri-shcs/project/PPPClientMobile/src/ch/epfl/pharma/database/contract/DatabaseContract.java
9913a583c025mobile_app

Last Change
Raw File

DatabaseContract.java
View Options

package ch.epfl.pharma.database.contract;
import android.database.Cursor;
public abstract class DatabaseContract {
public static final String COMMA_SEP = ",";
public static final String TYPE_INT = " INTEGER";
public static final String TYPE_DOUBLE = " DOUBLE";
public static final String TYPE_TEXT = " TEXT";
public static final String TYPE_BLOB = " BLOB";
public static final String PRIMARY_KEY = " PRIMARY KEY";
public static final String AUTOINC = " AUTOINCREMENT";
public static final String NOTNULL = " NOT NULL";
public static final String alias(String table, String col) {
return table + "_" + col;
}
public static final String relId(String table, String col) {
return table + "." + col;
}
public static final String selectAlias(String table, String col) {
return relId(table, col) + " AS " + alias(table, col);
}
public static final String foreignKey(String col, String foreignTable, String foreignCol) {
return "FOREIGN KEY(" + col + ") REFERENCES " + foreignTable + "(" + foreignCol + ")";
}
public static final String unique(String id) {
return "UNIQUE(" + id + ")";
}
public static final String unique(String id1, String id2) {
return "UNIQUE(" + id1 + COMMA_SEP + id2 + ")";
}
/* Alias */
public static int getIntCol(Cursor c, String id) {
return c.getInt(c.getColumnIndexOrThrow(id));
}
/* Alias */
public static String getStringCol(Cursor c, String id) {
return c.getString(c.getColumnIndexOrThrow(id));
}
/* Alias */
public static double getDoubleCol(Cursor c, String id) {
return c.getDouble(c.getColumnIndexOrThrow(id));
}
}
c4science · Help