@Override
public int remove(DownloadJob job) {
if (mDb == null) return 0;
DownloadEntry entry = job.getEntry();
String whereClause = COLUMN_AID + "=? and " + COLUMN_VID + "=?";
String[] args = new String[] {entry.aid, entry.part.vid};
int delete = mDb.delete(DOWNLOAD_TABLE, whereClause, args);
return delete;
}
@Override
// TODO 这个方法似乎没有用了
public int updateDownload(DownloadJob job) {
if (mDb == null || job == null) {
return 0;
}
DownloadEntry entry = job.getEntry();
if (entry == null || entry.part == null || entry.part.segments == null)
throw new IllegalEntryException("check your entry data!");
ContentValues values = new ContentValues();
values.put(COLUMN_STATUS, STATUS_PENDING);
values.put(COLUMN_CURRENT, 0);
values.put(COLUMN_AID, entry.aid);
values.put(COLUMN_TITLE, entry.title);
values.put(COLUMN_DEST, entry.destination);
values.put(COLUMN_VID, entry.part.vid);
values.put(COLUMN_VTYPE, entry.part.vtype);
values.put(COLUMN_SUBTITLE, entry.part.subtitle);
String whereClause = COLUMN_AID + "=? and " + COLUMN_VID + "=? and " + COLUMN_NUM + "=?";
int rowCount = 0;
for (int i = 0; i < entry.part.segments.size(); i++) {
VideoSegment s = entry.part.segments.get(i);
values.put(COLUMN_TOTAL, s.size);
values.put(COLUMN_NUM, s.num);
values.put(COLUMN_URL, s.stream);
rowCount =
mDb.update(
DOWNLOAD_TABLE,
values,
whereClause,
new String[] {entry.aid, entry.part.vid, String.valueOf(s.num)});
}
return rowCount;
}
@Override
public List<DownloadJob> getAllDownloads() {
List<DownloadJob> all = new ArrayList<DownloadJob>();
if (mDb != null) {
Cursor query = mDb.query(DOWNLOAD_TABLE, null, null, null, null, null, null);
DownloadJob job = null;
try {
for (query.moveToFirst(); !query.isAfterLast(); query.moveToNext()) {
String aid = query.getString(query.getColumnIndex(COLUMN_AID));
String vid = query.getString(query.getColumnIndex(COLUMN_VID));
// 是否同一个part
if (job == null
|| !job.getEntry().aid.equals(aid)
|| !job.getEntry().part.vid.equals(vid)) {
job = buildJob(query);
all.add(job);
}
VideoSegment s = new VideoSegment();
s.num = query.getInt(query.getColumnIndex(COLUMN_NUM));
s.size = query.getLong(query.getColumnIndex(COLUMN_TOTAL));
s.stream = query.getString(query.getColumnIndex(COLUMN_URL));
s.etag = query.getString(query.getColumnIndex(COLUMN_ETAG));
s.fileName = query.getString(query.getColumnIndex(COLUMN_DATA));
s.duration = query.getLong(query.getColumnIndex(COLUMN_DURATION));
job.getEntry().part.segments.add(s);
if (AcApp.isExternalStorageAvailable()) {
if (!TextUtils.isEmpty(job.getEntry().destination) && !TextUtils.isEmpty(s.fileName)) {
// 设置segment的播放路径为本地文件uri
// 实现边下边播的功能
File file = new File(job.getEntry().destination, s.fileName);
if (file.exists()) {
s.url = Uri.fromFile(file).toString();
} else s.url = s.stream;
int downloadedSize = (int) file.length();
job.addDownloadedSize(downloadedSize);
if (query.getInt(query.getColumnIndex(COLUMN_CURRENT)) != downloadedSize) {
// 数据库中的数据有误！
// 写入正确的数据
// XXX: 也许根本就不需要current_bytes这个字段...
ContentValues values = new ContentValues();
values.put(COLUMN_CURRENT, downloadedSize);
updateDownload(job.getEntry().part.vid, s.num, values);
}
}
}
// 真实的下载进度由file.length来确定比较好。
// @see downloadTask.setupDestinationFile()
// int downloadedSize = query.getInt(query.getColumnIndex(COLUMN_CURRENT));
// job.addDownloadedSize(downloadedSize);
int totalSize = query.getInt(query.getColumnIndex(COLUMN_TOTAL));
if (totalSize != -1) job.addTotalSize(totalSize);
}
} catch (Exception e) {
} finally {
query.close();
}
}
return all;
}