TestsContract.java
9913a583c025master

TestsContract.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.TestEntry;
			import ch.epfl.pharma.framework.Test;

			public class TestsContract extends DatabaseContract {

			public static Cursor getTests(SQLiteDatabase db) {
			String [] projection = {
			TestEntry.ID_TEST,
			TestEntry.NAME,
			TestEntry.DESC,
			TestEntry.GRP};

			String sortOrder = TestEntry.ID_TEST + " ASC";

			Cursor c = db.query(
			TestEntry.TABLE,
			projection,
			null, null, // no selection
			null, // no grouping
			null, // no filtering
			sortOrder);

			return c;
			}

			public static Test getTest(Cursor c) {
			int testId = getIntCol(c, TestEntry.ID_TEST);
			String name = getStringCol(c, TestEntry.NAME);
			String desc = getStringCol(c, TestEntry.DESC);
			String grp = getStringCol(c, TestEntry.GRP);

			Test test = new Test(testId, name, desc, grp);
			return test;
			}

			}