gt: 	db = helper.getReadableDatabase();
context: package com.energyeye.salesperson.test.unitTest.sqllite;
  
  import android.database.Cursor;
  import android.database.sqlite.SQLiteDatabase;
  import android.test.AndroidTestCase;
  import android.test.RenamingDelegatingContext;
  import android.test.suitebuilder.annotation.LargeTest;
  import android.test.suitebuilder.annotation.MediumTest;
  import android.test.suitebuilder.annotation.SmallTest;
  
  import com.energyeye.salesperson.dbComponents.DBHelper;
  import com.energyeye.salesperson.properties.Constants;
  import com.energyeye.salesperson.properties.CustomerInformationDataSource;
  import com.energyeye.salesperson.properties.ProjectImplementationTypeDataSource;
  
  public class CustomerInformationUnitTest extends AndroidTestCase {
  
      private static final String TEST_FILE_PREFIX = "test_";
      private DBHelper helper;
      private SQLiteDatabase db;
      private CustomerInformationDataSource dataSource = CustomerInformationDataSource
  	    .getCustomerInformationDataSource();
  
      @Override
      protected void setUp() throws Exception {
  	super.setUp();
  
  	RenamingDelegatingContext context = new RenamingDelegatingContext(
  		getContext(), TEST_FILE_PREFIX);
  
  	helper = new DBHelper(context, 1, Constants.DB_NAME,
  		Constants.CUSTOMER_INFORMATION_CREATE_QUERY);
  
  	assertNotNull(helper);
  
      }
  
      @Override
      protected void tearDown() throws Exception {
  
  	super.tearDown();
      }
  
      public void testPreConditions() {
  	assertNotNull(helper);
      }
  
      private void InsertSmallData() {
  
  	System.out
  		.println("################### insert samll #########################");
  	db = helper.getWritableDatabase();
  	dataSource.setName("Nikhil");
  	db.insert(Constants.CUSTOMER_INFOEMATION_TABLE_NAME, null,
  		dataSource.customerInformationListToContentValue());
  	db.close();
      }
  
      private void selectAllSmall() {
  	db = helper.getReadableDatabase();
  	Cursor c = db.query(Constants.CUSTOMER_INFOEMATION_TABLE_NAME, null,
  		null, null, null, null, null);
  	System.out.println("################### Small selctall count"
  		+ c.getCount());
  	db.close();
      }
  
      private void deletesmall() {
  	System.out
  		.println("################### delete small ######################");
  	db = helper.getWritableDatabase();
  	db.delete(Constants.CUSTOMER_INFOEMATION_TABLE_NAME, null, null);
  	db.close();
      }
  
      private void updateSmall() {
  	db = helper.getWritableDatabase();
  	System.out
  		.println("################## update small ######################");
  	dataSource.setName("Nikhil V");
  	db.update(Constants.CUSTOMER_INFOEMATION_TABLE_NAME,
  		dataSource.customerInformationListToContentValue(), "_id = ?",
  		new String[] { "1" });
  
  	db.close();
      }
  
      @SmallTest
      public void testSmall() {
  
  	InsertSmallData();
  	selectAllSmall();
  	updateSmall();
  	selectAllSmall();
  
  	deletesmall();
  	selectAllSmall();
  
      }
  
      public void MediumInsert() {
  
  	System.out
  		.println("################### Insert Medium ##########################3");
  	db = helper.getWritableDatabase();
  	for (int i = 0; i < 10; i++) {
  	    dataSource.setName("Nikhil" + String.valueOf(i));
  	    db.insert(Constants.CUSTOMER_INFOEMATION_TABLE_NAME, null,
  		    dataSource.customerInformationListToContentValue());
  	}
  
  	db.close();
  
      }
  
      public void MediumSelectAll() {
  
  	db = helper.getReadableDatabase();
  	Cursor c = db.query(Constants.CUSTOMER_INFOEMATION_TABLE_NAME, null,
  		null, null, null, null, null);
  	System.out.println("##########selectAll Medium count" + c.getCount());
  	db.close();
  
      }
  
      public void MediumUpdate() {
  
  	System.out
  		.println("#########################@ Medium update ####################3");
  	db = helper.getWritableDatabase();
  
  	for (int i = 0; i < 10; i++) {
  	    dataSource.setName("Nikhil V " + String.valueOf(i));
  	    db.update(Constants.CUSTOMER_INFOEMATION_TABLE_NAME,
  		    dataSource.customerInformationListToContentValue(),
  		    "_id = ?", new String[] { String.valueOf(i) });
  	}
  
  	db.close();
  
      }
  
      public void MediumSelectOne() {
  
  	db = helper.getReadableDatabase();
  	Cursor c = db.query(Constants.CUSTOMER_INFOEMATION_TABLE_NAME, null,
  		"_id = ?", new String[] { "7" }, null, null, null);
  	c.moveToFirst();
  	System.out.println("############# Select one" + c.getString(1));
  	db.close();
  
      }
  
      public void MediumDeleteOne() {
  
  	System.out
  		.println("#################### Medium Delete one ##################");
  	db = helper.getWritableDatabase();
  	db.delete(Constants.CUSTOMER_INFOEMATION_TABLE_NAME, "_id = ?",
  		new String[] { "7" });
  	db.close();
  
      }
  
      public void MediumDeleteAll() {
  
  	System.out
  		.println("################### Medium delete all ###################");
  	db = helper.getWritableDatabase();
  	db.delete(Constants.CUSTOMER_INFOEMATION_TABLE_NAME, null, null);
  	db.close();
  
      }
  
      @MediumTest
      public void testMedium() {
  	MediumInsert();
  	MediumSelectAll();
  	MediumUpdate();
  	MediumSelectOne();
  	MediumDeleteOne();
  	MediumSelectAll();
  	MediumDeleteAll();
  	MediumSelectAll();
  
      }
  
      public void InsertLarge() {
  
  	System.out
  		.println("#################################Insert Large#####################");
  	db = helper.getWritableDatabase();
  	for (int i = 0; i < 100; i++) {
  	    dataSource.setName("Nikhil" + String.valueOf(i));
  	    db.insert(Constants.CUSTOMER_INFOEMATION_TABLE_NAME, null,
  		    dataSource.customerInformationListToContentValue());
  	}
  
  	db.close();
      }
  
      public void LargeSelectAll() {
  
  