## Create HTML files for main Vikings Web page. ### NOTE: IMPORTANT ### ### Add your own database name in Line: 42 ### ### (no need for full path if running 'htmlbuilder.py' in same folder) ### from datetime import datetime import sqlite3 from sqlite3 import Error ### HTML BUILDER Creates HTML files from MASTER Database Tables. (22/10/22) print('INDEX BUILDER v1.0.0') now = datetime.now() date_time = now.strftime('%d-%m-%y @ %H:%M') ## Format HTML for HEADER, BODY, CSS, TABLE and basic layout details. title = "Endless Playlist Management System" style = "" head = "" base = b0 + b1 + b2 + b3 + b4 footer = "
" banner = "

ENDLESS PLAYLIST MANAGEMENT SYSTEM

" menu = "" menu0 = "" menu1 = "" menu2 = "" menu3 = "" menu4 = "" menu5 = "" menu6 = "" menu7 = "
MAINADDEDDELETEDDUPLICATESURI CHANGESQUEUE ERRORSPLAYED [EPM]PLAYED [EXT]
" main = title + style + head + banner + menu + menu0 + menu1 + menu2 + menu3 + menu4 + menu5 + menu6 + menu7 b0 = "" b1 = "" b2 = "" b3 = "" b4 = "
PYTHONSQLITE3SPOTIFY WEB APIHTML
© Viking Utilities ~ 2022
" conn = None ### filename = "MASTER.db" ### CHANGE HERE ### filename = "C:\Spotty Main\Vi&Cyn Test\Endless Feed.db" ### <== Als db path ### try: conn = sqlite3.connect(filename) ## NOTE: Re-build index.html. sql = ("SELECT COUNT (*) FROM Track_List WHERE QUEUED = 0") curr = conn.cursor() curr.execute(sql) rows = curr.fetchall() ## Replicate HTML Header plus data Table for: table = "Unplayed tracks: " + date_time html = main + "" tr = 1 ## html = html + "" for row in rows: html = html + "" tr = tr + 1 html = html + base + footer file = open("index.html", "w") file.write(html) file.close except Error as e: print(e) finally: if conn: conn.close() print('Finished.')
" + table + "
" + str(row[0]) + "