@Override
    public List<Shop> getAll() throws SQLException {
        Cursor cursor;
        int numberOfRows;
        List<Shop> shopList;
        SQLiteDatabase db = getHelper().getReadableDatabase();
        cursor = db.rawQuery(SQLQuery.queryAllShops(), null);
        numberOfRows = cursor.getCount();
        shopList = new ArrayList<>(numberOfRows);
        try {
            if (cursor.moveToFirst()) {
                do {
                    int indexId;
                    int indexName;
                    int indexServer;
                    int indexDatabase;
                    int indexDbUsername;
                    int indexDbPassword;
                    int indexCompanyName;
                    int indexFavourite;
                    int indexLoginNo;

                    int id; //shopNumber
                    String name;
                    String server;
                    String database;
                    String databaseUsername;
                    String databasePassword;
                    String companyName;
                    String image;
                    int loginNo;
                    boolean isFavourite;

                    // Read column indices
                    indexId = cursor.getColumnIndex(SHOP.ID.toString());
                    indexName = cursor.getColumnIndex(SHOP.NAME.toString());
                    indexServer = cursor.getColumnIndex(SHOP.SERVER.toString());
                    indexDatabase = cursor.getColumnIndex(SHOP.DB_NAME.toString());
                    indexDbUsername = cursor.getColumnIndex(SHOP.DB_USERNAME.toString());
                    indexDbPassword = cursor.getColumnIndex(SHOP.DB_PASSWORD.toString());
                    indexCompanyName = cursor.getColumnIndex(SHOP.COMPANY_NAME.toString());
                    indexFavourite = cursor.getColumnIndex(SHOP.FAVOURITE.toString());
                    indexLoginNo = cursor.getColumnIndex(SHOP.LOGIN_NUMBER.toString());

                    // Read data from database
                    id = cursor.getInt(indexId);
                    name = cursor.getString(indexName);
                    server = cursor.getString(indexServer);
                    database = cursor.getString(indexDatabase);
                    databaseUsername = cursor.getString(indexDbUsername);
                    databasePassword = cursor.getString(indexDbPassword);
                    companyName = cursor.getString(indexCompanyName);
                    isFavourite = cursor.getInt(indexFavourite) == 1 ? true : false;
                    loginNo = cursor.getInt(indexLoginNo);

                    // Instantiate shop object
                    Shop shop = new Shop();
                    shop.setId(id);
                    shop.setName(name);
                    shop.setServer(server);
                    shop.setDb(database);
                    shop.setDbUsername(databaseUsername);
                    shop.setDbPassword(databasePassword);
                    shop.setCompanyName(companyName);
                    shop.setFavourite(isFavourite);
                    shop.setLoginId(loginNo);

                    shopList.add(shop);
                } while (cursor.moveToNext());
            }
        } finally {
            if (cursor != null && !cursor.isClosed()) {
                cursor.close();
            }
        }
        return shopList;
    }