import sqlite3 import html import datetime from song_tools import * from DBtools import * from callAPI import * file_path = "./song-export/" def writeSong(song, arr): song_title = song['attributes']['title'] song_id = song['id'] arrangment_id = arr['id'] song_url = "https://services.planningcenteronline.com/songs/"+song_id+"/arrangements/" + arrangment_id arrangement_name = arr['attributes']['name'] filename = song_title if arrangement_name != "Default Arrangement": filename += " (" + arrangement_name + ")" filename = sanitize_filename(filename) author = song['attributes']['author'] verseOrder = (' '.join(arr['attributes']['sequence_short'])).lower() lyrics = parse_lyrics(arr['attributes']['lyrics'], "") now = datetime.datetime.now() s = "%Y-%m-%dT%H:%M+04:00" time_exported = now.strftime(s) with open(file_path + filename + ".xml", 'w') as file: # Write the text to the file #file.write(arrangment['attributes']['lyrics']) #songcheck_result['uniqe_verse_elements'] if author is None or len(author) == 0: author = "" author = sanitize_filename(author) arrangement_name = sanitize_filename(arrangement_name) output = "\n" output += "\n" \ "\t\n\t\t\n\t\t\t" + filename + "\n\t\t" output += "\n\t\t" + verseOrder + "" output += "\n\t\t" + author + "" output += "\n\t\t" + arrangement_name + "" output += "\n\t\t" + song_url + "" output += "\n\t" output += "\n\t" for verse in lyrics: #for part in verse: output += "\n\t\t " output += "\n\t\t\t" + (verse['verse_text']).replace("\n", "
") + "" #output += "\n\t\t\t" + verse['verse_text'] + "" output += "\n\t\t " output += "\n\t" output += "\n" file.write(output) def sanitize_filename(filename): # List of disallowed characters (for both Windows and Unix/Linux) disallowed_chars = '<>:"/\\|?*&' # Replace each disallowed character with an empty string for char in disallowed_chars: filename = filename.replace(char, '') return filename def write_songs_to_open_lyrics(): arrangment_list = json.loads(return_arrangments_which_are_ok()) counter = 0 for arr in arrangment_list: counter=counter+1 print (f"{counter} - Arrangementnavn: {arr['song_id']}") song_data = request_song(arr['song_id']) arrangement_data = request_arrangment(arr['song_id'], arr['arrangement_id']) writeSong(song_data['data'], arrangement_data['data']) # def create_html_with_check_all_song_result_json(song_data): # #song_data = json.load(data) # # Starting the HTML document # html_table = ''' # # # # # Song Table # # # # # # # # # # # # # # # ''' # # Adding each song to the table # for song in song_data: # if(song['all_ok'] == "False"): # verse_result = " ".join(song['verse_result']) # trimmed_verse_result = verse_result[:100] # html_table += f''' # # # # # # # # # # # # ''' # # End of the HTML table # html_table += ''' #
Song titleArrangement nameHas LyricsLyrics formattingVerse check resultunike vers elementslinjelengdeAdded byCreated at
{song['song_title']}{song['arrangment_name']}{song['has_lyrics']}{song['verse_start']}{trimmed_verse_result}{song['uniqe_verse_elements']}{song['line_lenght']}{song['created_by']}{song['created_at']}
# # # ''' # # Writing the HTML content to a file # with open('song_list.html', 'w') as file: # file.write(html_table) # print("HTML file created successfully.") # #def fix_verse(lyrics): # #not in use # def createHTMLfileFromDB(): # # Connect to the SQLite database # conn = sqlite3.connect("song_check_data.db") # cursor = conn.cursor() # # Query the data from the 'songs' table # cursor.execute("SELECT * FROM songs") # data = cursor.fetchall() # # Create an HTML file and write the table to it # with open("songs_table_from_db.html", "w") as html_file: # html_file.write("Songs Table") # html_file.write("") # # Write table headers # headers = [description[0] for description in cursor.description] # html_file.write("") # for header in headers: # html_file.write(f"") # html_file.write("") # # Write table rows # for row in data: # html_file.write("") # for cell in row: # html_file.write(f"") # html_file.write("") # html_file.write("
{html.escape(header)}
{html.escape(str(cell))}
") # # Close the database connection # conn.close() # print("HTML table has been created in songs_table.html")