Xdxzsd4i

1import sqlite3
2
3sql_config = sqlite3.connect('Tunes.db')
4sql_con = sql_config.cursor()
5
6sql_con.execute("CREATE TABLE IF NOT EXISTS 'temp' (Title TEXT, Length TEXT)")  # Create temp table
7sql_con.execute("DELETE FROM 'temp'")  # Clean temp
8# sql_con.execute("vacuum")  # Commit clea
9sql_con.execute("INSERT INTO 'temp' SELECT * FROM Tunes")  # Copy Data to temp
10sql_con.execute("DELETE FROM 'Tunes'")  # Clean Tunes
11sql_con.execute("INSERT INTO 'Tunes' SELECT * FROM temp ORDER BY RANDOM()")  # Copy Randomized data to Tunes
12sql_con.execute("DROP TABLE IF EXISTS 'temp'")
13
14sql_config.commit()