blob: 6b15bb9b164e360be85f244b0b7347717a17930c [file] [log] [blame]
/*
* Copyright (C) 2009 The Android Open Source Project
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package android.provider.cts;
import dalvik.annotation.BrokenTest;
import dalvik.annotation.TestLevel;
import dalvik.annotation.TestTargetClass;
import dalvik.annotation.TestTargetNew;
import dalvik.annotation.ToBeFixed;
import android.content.ContentResolver;
import android.content.ContentValues;
import android.database.Cursor;
import android.database.SQLException;
import android.net.Uri;
import android.provider.MediaStore.Audio.Media;
import android.provider.MediaStore.Audio.Playlists;
import android.provider.MediaStore.Audio.Playlists.Members;
import android.provider.cts.MediaStoreAudioTestHelper.Audio1;
import android.provider.cts.MediaStoreAudioTestHelper.Audio2;
import android.test.InstrumentationTestCase;
@TestTargetClass(Members.class)
public class MediaStore_Audio_Playlists_MembersTest extends InstrumentationTestCase {
private String[] mAudioProjection = {
Members._ID,
Members.ALBUM,
Members.ALBUM_ID,
Members.ALBUM_KEY,
Members.ARTIST,
Members.ARTIST_ID,
Members.ARTIST_KEY,
Members.COMPOSER,
Members.DATA,
Members.DATE_ADDED,
Members.DATE_MODIFIED,
Members.DISPLAY_NAME,
Members.DURATION,
Members.IS_ALARM,
Members.IS_MUSIC,
Members.IS_NOTIFICATION,
Members.IS_RINGTONE,
Members.MIME_TYPE,
Members.SIZE,
Members.TITLE,
Members.TITLE_KEY,
Members.TRACK,
Members.YEAR,
};
private String[] mMembersProjection = {
Members._ID,
Members.AUDIO_ID,
Members.PLAYLIST_ID,
Members.PLAY_ORDER,
Members.ALBUM,
Members.ALBUM_ID,
Members.ALBUM_KEY,
Members.ARTIST,
Members.ARTIST_ID,
Members.ARTIST_KEY,
Members.COMPOSER,
Members.DATA,
Members.DATE_ADDED,
Members.DATE_MODIFIED,
Members.DISPLAY_NAME,
Members.DURATION,
Members.IS_ALARM,
Members.IS_MUSIC,
Members.IS_NOTIFICATION,
Members.IS_RINGTONE,
Members.MIME_TYPE,
Members.SIZE,
Members.TITLE,
Members.TITLE_KEY,
Members.TRACK,
Members.YEAR,
};
private ContentResolver mContentResolver;
private long mIdOfAudio1;
private long mIdOfAudio2;
@Override
protected void setUp() throws Exception {
super.setUp();
mContentResolver = getInstrumentation().getContext().getContentResolver();
Uri uri = Audio1.getInstance().insertToExternal(mContentResolver);
Cursor c = mContentResolver.query(uri, null, null, null, null);
c.moveToFirst();
mIdOfAudio1 = c.getLong(c.getColumnIndex(Media._ID));
c.close();
uri = Audio2.getInstance().insertToExternal(mContentResolver);
c = mContentResolver.query(uri, null, null, null, null);
c.moveToFirst();
mIdOfAudio2 = c.getLong(c.getColumnIndex(Media._ID));
c.close();
}
@Override
protected void tearDown() throws Exception {
mContentResolver.delete(Media.EXTERNAL_CONTENT_URI, Media._ID + "=" + mIdOfAudio1, null);
mContentResolver.delete(Media.EXTERNAL_CONTENT_URI, Media._ID + "=" + mIdOfAudio2, null);
super.tearDown();
}
@TestTargetNew(
level = TestLevel.COMPLETE,
method = "getContentUri",
args = {String.class, long.class}
)
@BrokenTest("brittle test")
public void testGetContentUri() {
// this verification seems brittle - will break if there happens to be a playlist with Id 1
// present in external volume
// setUp should create a playlist which this method should verify can be queried
Cursor c = mContentResolver.query(
Members.getContentUri(MediaStoreAudioTestHelper.EXTERNAL_VOLUME_NAME, 1),
mMembersProjection, null, null, Members.DEFAULT_SORT_ORDER);
assertEquals(0, c.getCount());
c.close();
// test querying media provider with null projection, should return all columns
c = mContentResolver.query(
Members.getContentUri(MediaStoreAudioTestHelper.EXTERNAL_VOLUME_NAME, 1), null,
Members.ALBUM + "=?", new String[] { Audio1.ALBUM },
Members.DEFAULT_SORT_ORDER);
assertEquals(0, c.getCount());
// TODO: need a way to verify all expected columns are returned. Purely testing for number
// of columns returned is brittle
assertEquals(31, c.getColumnCount());
c.close();
try {
mContentResolver.query(
Members.getContentUri(MediaStoreAudioTestHelper.INTERNAL_VOLUME_NAME, 1),
mMembersProjection, null, null, Members.DEFAULT_SORT_ORDER);
fail("Should throw SQLException as the internal datatbase has no playlist");
} catch (SQLException e) {
// expected
}
String volume = "fakeVolume";
assertNull(mContentResolver.query(Members.getContentUri(volume, 1), null, null, null,
null));
}
@BrokenTest("needs investigation")
public void testStoreAudioPlaylistsMembersExternal() {
ContentValues values = new ContentValues();
values.put(Playlists.NAME, "My favourites");
values.put(Playlists.DATA, "");
long dateAdded = System.currentTimeMillis();
values.put(Playlists.DATE_ADDED, dateAdded);
long dateModified = System.currentTimeMillis();
values.put(Playlists.DATE_MODIFIED, dateModified);
// insert
Uri uri = mContentResolver.insert(Playlists.EXTERNAL_CONTENT_URI, values);
assertNotNull(uri);
Cursor c = mContentResolver.query(uri, null, null, null, null);
c.moveToFirst();
long playlistId = c.getLong(c.getColumnIndex(Playlists._ID));
// insert audio as the member of the playlist
values.clear();
values.put(Members.AUDIO_ID, mIdOfAudio1);
values.put(Members.PLAY_ORDER, 1);
Uri membersUri = Members.getContentUri(MediaStoreAudioTestHelper.EXTERNAL_VOLUME_NAME,
playlistId);
Uri audioUri = mContentResolver.insert(membersUri, values);
assertNotNull(audioUri);
assertEquals(Uri.withAppendedPath(membersUri, Long.toString(mIdOfAudio1)), audioUri);
try {
// query the audio info
c = mContentResolver.query(audioUri, mAudioProjection, null, null, null);
assertEquals(1, c.getCount());
c.moveToFirst();
long memberId = c.getLong(c.getColumnIndex(Members._ID));
assertTrue(memberId > 0);
assertEquals(Audio1.EXTERNAL_DATA, c.getString(c.getColumnIndex(Members.DATA)));
assertTrue(c.getLong(c.getColumnIndex(Members.DATE_ADDED)) > 0);
assertEquals(Audio1.DATE_MODIFIED, c.getLong(c.getColumnIndex(Members.DATE_MODIFIED)));
assertEquals(Audio1.FILE_NAME, c.getString(c.getColumnIndex(Members.DISPLAY_NAME)));
assertEquals(Audio1.MIME_TYPE, c.getString(c.getColumnIndex(Members.MIME_TYPE)));
assertEquals(Audio1.SIZE, c.getInt(c.getColumnIndex(Members.SIZE)));
assertEquals(Audio1.TITLE, c.getString(c.getColumnIndex(Members.TITLE)));
assertEquals(Audio1.ALBUM, c.getString(c.getColumnIndex(Members.ALBUM)));
assertNotNull(c.getString(c.getColumnIndex(Members.ALBUM_KEY)));
assertTrue(c.getLong(c.getColumnIndex(Members.ALBUM_ID)) > 0);
assertEquals(Audio1.ARTIST, c.getString(c.getColumnIndex(Members.ARTIST)));
assertNotNull(c.getString(c.getColumnIndex(Members.ARTIST_KEY)));
assertTrue(c.getLong(c.getColumnIndex(Members.ARTIST_ID)) > 0);
assertEquals(Audio1.COMPOSER, c.getString(c.getColumnIndex(Members.COMPOSER)));
assertEquals(Audio1.DURATION, c.getLong(c.getColumnIndex(Members.DURATION)));
assertEquals(Audio1.IS_ALARM, c.getInt(c.getColumnIndex(Members.IS_ALARM)));
assertEquals(Audio1.IS_MUSIC, c.getInt(c.getColumnIndex(Members.IS_MUSIC)));
assertEquals(Audio1.IS_NOTIFICATION,
c.getInt(c.getColumnIndex(Members.IS_NOTIFICATION)));
assertEquals(Audio1.IS_RINGTONE, c.getInt(c.getColumnIndex(Members.IS_RINGTONE)));
assertEquals(Audio1.TRACK, c.getInt(c.getColumnIndex(Members.TRACK)));
assertEquals(Audio1.YEAR, c.getInt(c.getColumnIndex(Members.YEAR)));
assertNotNull(c.getString(c.getColumnIndex(Members.TITLE_KEY)));
c.close();
// query the play order of the audio
c = mContentResolver.query(membersUri, new String[] { Members.PLAY_ORDER },
Members.AUDIO_ID + "=" + mIdOfAudio1, null, null);
assertEquals(1, c.getCount());
c.moveToFirst();
assertEquals(1, c.getInt(c.getColumnIndex(Members.PLAY_ORDER)));
c.close();
// update the member
values.clear();
values.put(Members.PLAY_ORDER, 2);
values.put(Members.AUDIO_ID, mIdOfAudio2);
int result = mContentResolver.update(membersUri, values, Members.AUDIO_ID + "="
+ mIdOfAudio1, null);
assertEquals(1, result);
// query all info
c = mContentResolver.query(membersUri, mMembersProjection, null, null,
Members.DEFAULT_SORT_ORDER);
assertEquals(1, c.getCount());
c.moveToFirst();
assertEquals(2, c.getInt(c.getColumnIndex(Members.PLAY_ORDER)));
assertEquals(memberId, c.getLong(c.getColumnIndex(Members._ID)));
assertEquals(Audio2.EXTERNAL_DATA, c.getString(c.getColumnIndex(Members.DATA)));
assertTrue(c.getLong(c.getColumnIndex(Members.DATE_ADDED)) > 0);
assertEquals(Audio2.DATE_MODIFIED, c.getLong(c.getColumnIndex(Members.DATE_MODIFIED)));
assertEquals(Audio2.FILE_NAME, c.getString(c.getColumnIndex(Members.DISPLAY_NAME)));
assertEquals(Audio2.MIME_TYPE, c.getString(c.getColumnIndex(Members.MIME_TYPE)));
assertEquals(Audio2.SIZE, c.getInt(c.getColumnIndex(Members.SIZE)));
assertEquals(Audio2.TITLE, c.getString(c.getColumnIndex(Members.TITLE)));
assertEquals(Audio2.ALBUM, c.getString(c.getColumnIndex(Members.ALBUM)));
assertNotNull(c.getString(c.getColumnIndex(Members.ALBUM_KEY)));
assertTrue(c.getLong(c.getColumnIndex(Members.ALBUM_ID)) > 0);
assertEquals(Audio2.ARTIST, c.getString(c.getColumnIndex(Members.ARTIST)));
assertNotNull(c.getString(c.getColumnIndex(Members.ARTIST_KEY)));
assertTrue(c.getLong(c.getColumnIndex(Members.ARTIST_ID)) > 0);
assertEquals(Audio2.COMPOSER, c.getString(c.getColumnIndex(Members.COMPOSER)));
assertEquals(Audio2.DURATION, c.getLong(c.getColumnIndex(Members.DURATION)));
assertEquals(Audio2.IS_ALARM, c.getInt(c.getColumnIndex(Members.IS_ALARM)));
assertEquals(Audio2.IS_MUSIC, c.getInt(c.getColumnIndex(Members.IS_MUSIC)));
assertEquals(Audio2.IS_NOTIFICATION,
c.getInt(c.getColumnIndex(Members.IS_NOTIFICATION)));
assertEquals(Audio2.IS_RINGTONE, c.getInt(c.getColumnIndex(Members.IS_RINGTONE)));
assertEquals(Audio2.TRACK, c.getInt(c.getColumnIndex(Members.TRACK)));
assertEquals(Audio2.YEAR, c.getInt(c.getColumnIndex(Members.YEAR)));
assertNotNull(c.getString(c.getColumnIndex(Members.TITLE_KEY)));
c.close();
// delete the member
result = mContentResolver.delete(membersUri, null, null);
assertEquals(1, result);
} finally {
// delete the playlist
mContentResolver.delete(Playlists.EXTERNAL_CONTENT_URI,
Playlists._ID + "=" + playlistId, null);
}
}
public void testStoreAudioPlaylistsMembersInternal() {
// the internal database does not have play lists
ContentValues values = new ContentValues();
values.put(Playlists.NAME, "My favourites");
values.put(Playlists.DATA, "/data/data/com.android.cts.stub/files/my_favorites.pl");
long dateAdded = System.currentTimeMillis();
values.put(Playlists.DATE_ADDED, dateAdded);
long dateModified = System.currentTimeMillis();
values.put(Playlists.DATE_MODIFIED, dateModified);
Uri uri = mContentResolver.insert(Playlists.INTERNAL_CONTENT_URI, values);
assertNull(uri);
}
}