Remove picasa repository and portfolio from core

Setup

The following steps should be run on a Moodle site without the patch. For instance, you can run "git checkout 0d0e66d37c6271657d76f948db9eeb10c139e7ae".

1. Login as admin.
2. Go to "Site administration > Advanced features" and "Enable portfolios".
3. Access to "Site administration > Plugins > Portfolios > Manage portfolios".
4. Select "Enable and visible" for "Picasa". You can use some silly text (such as "xxxx"), for Client ID and Secret.
5. Select "Enable and visible" for "File download".
6. Check the following SQL query return 1 row. Annotate the id.

   SELECT * FROM mdl_portfolio_instance WHERE plugin = 'picasa'

7. Check the following SQL query return 2 (you'll need to replace the id that you've annotated previously): 

   SELECT count(*) FROM mdl_portfolio_instance_config WHERE instance = <PORTFOLIOID>

8. Go to "Site administration > Plugins > Repositories > Manage repositories".
9. Select "Enable and visible" for the "Picasa web album" repository. You'll need to add some silly text (such as "xxxx"), for Client ID and Secret.
10. Check the following SQL query return 1 row. Annotate the id.

    SELECT * FROM mdl_repository WHERE type = 'picasa'

11. Check the following SQL query return 1 (you'll need to replace the id that you've annotated previously): 

    SELECT count(*) FROM mdl_repository_instances WHERE typeid = <REPOSITORYID>

12. Check the following SQL query is not empty: 

    SELECT * FROM mdl_config_plugins WHERE plugin = 'picasa'

13. Apply the patch and run the upgrade process.

Testing scenario 1: Portfolio

1. Access to "Site administration > Plugins > Portfolios > Manage portfolios".
2. Check "Picasa" is no longer displayed there.
3. Check the following SQL query is empty:

   SELECT * FROM mdl_portfolio_instance WHERE plugin = 'picasa'

4. Check the following SQL query is empty too (you'll need to replace the id that you've annotated previously): 

   SELECT count(*) FROM mdl_portfolio_instance_config WHERE instance = <PORTFOLIOID>

Testing scenario 2: Repository

1. Access to "Site administration > Plugins > Repositories > Manage repositories".
2. Check "Picasa web album" is no longer displayed there.
3. Check the following SQL query is empty:

   SELECT * FROM mdl_repository WHERE type = 'picasa'

4. Check the following SQL query is empty too (you'll need to replace the id that you've annotated previously): 

   SELECT count(*) FROM mdl_repository_instances WHERE typeid = <REPOSITORYID>

5. Check the following SQL query is empty:

   SELECT * FROM mdl_config_plugins WHERE plugin = 'picasa'