Menu ▾ ▴

[756088]: / FoxTunes.DB / Resources / MovePlaylistItem.sql  Maximize  Restore  History

Download this file

32 lines (30 with data), 602 Bytes 

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
WITH "CurrentSequence"

AS

(	

		SELECT "Sequence" 

		FROM "PlaylistItems"

		WHERE "Id" = @id

)



UPDATE "PlaylistItems"

SET "Sequence" = 

(

	CASE WHEN (SELECT "Sequence" FROM "CurrentSequence") < @sequence THEN

		"Sequence" - 1

	ELSE

		"Sequence" + 1

	END

)

WHERE 

(

	(SELECT "Sequence" FROM "CurrentSequence") < @sequence 

		AND "Sequence" BETWEEN (SELECT "Sequence" FROM "CurrentSequence") 

			AND @sequence

) 

OR 

(

	"Sequence" BETWEEN @sequence 

		AND (SELECT "Sequence" FROM "CurrentSequence")

);



UPDATE "PlaylistItems"

SET "Sequence" = @sequence

WHERE "Id" = @id;