OCA\Music\Utility\Helper::cleanUp()

Complexity

Conditions	2
Paths	2

Size

Total Lines	43
Code Lines	9

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
	public function cleanUp() {
		$sqls = array(
			'UPDATE `*PREFIX*music_albums` SET `cover_file_id` = NULL
				WHERE `cover_file_id` IS NOT NULL AND `cover_file_id` IN (
					SELECT `cover_file_id` FROM (
						SELECT `cover_file_id` FROM `*PREFIX*music_albums`
						LEFT JOIN `*PREFIX*filecache`
							ON `cover_file_id`=`fileid`
						WHERE `fileid` IS NULL
					) mysqlhack
				);',
			'DELETE FROM `*PREFIX*music_tracks` WHERE `file_id` IN (
				SELECT `file_id` FROM (
					SELECT `file_id` FROM `*PREFIX*music_tracks`
					LEFT JOIN `*PREFIX*filecache`
						ON `file_id`=`fileid`
					WHERE `fileid` IS NULL
					) mysqlhack
				);',
			'DELETE FROM `*PREFIX*music_albums` WHERE `id` IN (
				SELECT `id` FROM (
					SELECT `*PREFIX*music_albums`.`id`
					FROM `*PREFIX*music_albums`
					LEFT JOIN `*PREFIX*music_tracks`
						ON `*PREFIX*music_tracks`.`album_id` = `*PREFIX*music_albums`.`id`
					WHERE `*PREFIX*music_tracks`.`album_id` IS NULL
				) as tmp
			);',
			'DELETE FROM `*PREFIX*music_artists` WHERE `id` NOT IN (
				SELECT DISTINCT * FROM (
					SELECT `artist`.`id` FROM `*PREFIX*music_artists` `artist`
					JOIN `*PREFIX*music_albums` `album` ON
					`artist`.`id` = `album`.`album_artist_id` UNION SELECT `track`.`artist_id`
					FROM `*PREFIX*music_tracks` `track`
				) as tmp
			);'
		);

		foreach ($sqls as $sql) {
			$query = $this->db->prepare($sql);
			$query->execute();
		}
	}
}