android_sqlite

public class AndroidDbHelper extends SQLiteOpenHelper {
    public AndroidDbHelper(Context context) {
            super(context, DatabaseProvider.DATABASE_NAME, null, DatabaseProvider.DATABASE_VERSION);

    }

    @Override
    public void onCreate(SQLiteDatabase database) {
        database.execSQL(ExpensesTable.CREATE_TABLE_SQL);
        database.execSQL(IncomesTable.CREATE_TABLE_SQL);
        database.execSQL(CategoriesTable.CREATE_TABLE_SQL);
        database.execSQL(PaymentsTable.CREATE_TABLE_SQL);
        database.execSQL(IncomeSourcesTable.CREATE_TABLE_SQL);
    }

    @Override
    public void onUpgrade(SQLiteDatabase database, int oldVersion, int newVersion) {
        /* database.execSQL("DROP TABLE IF EXISTS " + ExpensesTable.TABLE_NAME);
        database.execSQL("DROP TABLE IF EXISTS " + IncomesTable.TABLE_NAME);
        database.execSQL("DROP TABLE IF EXISTS " + PaymentsTable.TABLE_NAME);
        database.execSQL("DROP TABLE IF EXISTS " + IncomeSourcesTable.TABLE_NAME);
        database.execSQL("DROP TABLE IF EXISTS " + CategoriesTable.TABLE_NAME); */
    }
}

public class PaymentsDataSource {
    private SQLiteDatabase database;
    private AndroidDbHelper dbHelper;

    public PaymentsDataSource(Context context){
        dbHelper = new AndroidDbHelper(context);
    }

    public void open() throws SQLException {
        database = dbHelper.getWritableDatabase();
    }

    public void close() {
        dbHelper.close();
    }

    public List<PaymentModel> getPayments(){
        // ...
        String query = "SELECT * FROM " + PaymentsTable.TABLE_NAME;
        Cursor cursor = database.rawQuery(query , null);

        // ...
    }
}