Viking Utilities

## MASTER DATABASE TABLES ## ## Erroneous_Data ## Last_Played_Tracks ## Last Run_Additions ## Last-Run_Deletions ## New_Dupe_Tracks ## Reviewed_Dupe_Tracks ## Track_List ## URI_Change ## tmp_played ## Create Simple HTML files from MASTER Database Tables ## 1. Last_Run_Additions ## 2. Last_Run_Deletions ## 3. New_Dupe_Tracks ## 4. URI_Change ## 5. Last_Played_Tracks import sqlite3 from sqlite3 import Error print('Create Simple HTML files from MASTER Database Tables:') print('Version 2.0 ~ 05-10-22') ## Add your own database name (no need for full path if running 'xxxx.py' in same folder ## ## Format HTML for HEADER, BODY, CSS, TABLE and basic layout details. head = "Viking Utilities" extcss = "" body = "

ENDLESS PLAYLIST MANAGEMENT SYSTEM

" main = "" menu0 = "" menu1 = "" menu2 = "" menu3 = "" menu4 = "" menu5 = "

MAIN

" bulk = head + extcss + body + main + menu0 + menu1 + menu2 + menu3 + menu4 + menu5 footer = "

VIKING UTILITIES ~ 2022" conn = None filename = "Endless Feed.db" try: conn = sqlite3.connect(filename) print("Create Database Connection:") ## 1) Last Run Additions: sql = ("SELECT * FROM Last_Run_Additions") curr = conn.cursor() curr.execute(sql) rows = curr.fetchall() ## Replicate HTML Header plus data Table for "Last Run Additions": html = bulk + "" ## Header Row Labels: html = html + "" tr = 1 for row in rows: html = html + "" html = html + "" tr = tr + 1 html = html + footer file = open("additions.html", "w") file.write(html) file.close ##========================================================================== ## 2) Last Run Deletions: sql = ("SELECT * FROM Last_Run_Deletions") curr = conn.cursor() curr.execute(sql) rows = curr.fetchall() ## Replicate HTML Header plus data Table for "Last Run Deletions": html = bulk + "

#	URI	TRACK	ARTIST	REVIEWED
Last Run Additions:
" + str(tr) + "	" + str(row[0]) + "	" + str(row[1]) + "	" + str(row[2]) + "	" + str(row[3]) + "

" ## Header Row Labels: html = html + "" tr = 1 for row in rows: html = html + "" html = html + "" tr = tr + 1 html = html + footer file = open("deletions.html", "w") file.write(html) file.close ##========================================================================== ## 3. Duplicated tracks: sql = ("SELECT * FROM New_Dupe_Tracks") curr = conn.cursor() curr.execute(sql) rows = curr.fetchall() ## Replicate HTML Header plus data Table for "Duplicated tracks": html = bulk + "

#	URI	TRACK	ARTIST	ALBUM
Last Run Deletions:
" + str(tr) + "	" + str(row[0]) + "	" + str(row[1]) + "	" + str(row[2]) + "	" + str(row[3]) + "

" ## Header Row Labels: html = html + "" tr = 1 for row in rows: html = html + "" html = html + "" tr = tr + 1 html = html + footer file = open("duplicates.html", "w") file.write(html) file.close ##========================================================================== ## 4) URI Changes: sql = ("SELECT * FROM URI_Change") curr = conn.cursor() curr.execute(sql) rows = curr.fetchall() ## Replicate HTML Header plus data Table for "URI Changes": html = bulk + "

#	URI	TRACK	ARTIST	REVIEWED
Duplicate Track List:
" + str(tr) + "	" + str(row[0]) + "	" + str(row[1]) + "	" + str(row[2]) + "	" + str(row[3]) + "

" ## Header Row Labels: html = html + "" tr = 1 for row in rows: html = html + "" html = html + "" html = html + "" tr = tr + 1 html = html + footer file = open("urichanges.html", "w") file.write(html) file.close ##========================================================================== ## 5).Last_Played_Tracks sql = ("SELECT * FROM Last_Played_Tracks ORDER BY LAST_PLAYED DESC") ### sql = ("SELECT * FROM Last_Played_Tracks WHERE PLAY_COUNT = 0 ORDER BY LAST_PLAYED DESC") curr = conn.cursor() curr.execute(sql) rows = curr.fetchall() ## Replicate HTML Header plus data Table for "Last Played": html = bulk + "

#	CHANGED	OLD URI	NEW URI	TRACK	ARTIST
URI Changes:
" + str(tr) + "	" + str(row[0]) + "	" + str(row[1]) + "	" + str(row[2]) + "	" + str(row[3]) + "	" + str(row[4]) + "

" ## Header Row Labels: html = html + "" tr = 1 for row in rows: html = html + "" html = html + "" tr = tr + 1 html = html + footer file = open("last-played.html", "w") file.write(html) file.close except Error as e: print(e) finally: if conn: conn.close() print('All done...')

#	URI	TRACK	ARTIST	PLAYED	COUNT
Last Played:
" + str(tr) + "	" + str(row[0]) + "	" + str(row[1]) + "	" + str(row[2]) + "	" + str(row[3]) + "	" + str(row[4]) + "