HTML和Python以及SQL实现一个唱片公司的唱片管理网站

import logging from os import error, name import sqlite3 from flask import Flask, request, redirect, render_template, url_for import sqlite3 app = Flask(__name__) @app.route('/') def index(): return render_template('index.html') @app.route('/search/') def search(): conn = sqlite3.connect('iMusic.db') conn.row_factory = sqlite3.Row cur = conn.cursor() cur.execute("SELECT Name FROM Genre ORDER BY Name ASC;") rows = cur.fetchall() return render_template('search.html', genres=rows) @app.route('/search/genre',methods=['GET','POST']) def search_results(): if request.method =='POST': genre=request.form['genre'] conn = sqlite3.connect('iMusic.db') conn.row_factory = sqlite3.Row cur = conn.cursor() cur.execute("select Album.AlbumId, Title AS 'AlbumTitle', Artist.Name AS 'ArtistName', sum(Milliseconds/1000) AS 'AlbumDuration', ROUND(sum(UnitPrice),2) AS 'AlbumValue' FROM Genre INNER JOIN Track ON Genre.GenreId=Track.GenreId INNER JOIN Album ON Track.AlbumId=Album.AlbumId INNER JOIN Artist ON Artist.ArtistId=Album.ArtistId GROUP BY Album.AlbumId HAVING Genre.Name=?;",(genre,)) number = cur.fetchall() return render_template('results.html',albums=number,genre=genre) @app.route('/tracks/<string:album_id>') def tracks(album_id): sql_query = """ SELECT TrackId, Name, Composer, Milliseconds AS Duration, UnitPrice as Price FROM Track WHERE AlbumId = ? ORDER BY AlbumId; """ con = sqlite3.connect("iMusic.db") con.row_factory = sqlite3.Row cur = con.cursor() cur.execute(sql_query, (album_id,)) album_tracks = cur.fetchall() print([a[0] for a in album_tracks]) return render_template('track_list.html', tracks=album_tracks) @app.route('/add/') def add(): return render_template('add_genre.html') @app.route('/add/genre',methods=['GET','POST']) def add_genre(): if request.method =='POST': new=request.form['genre'] cnt=0 boolen=0 hint=[""] conn = sqlite3.connect('iMusic.db') conn.row_factory = sqlite3.Row cur = conn.cursor() cur.execute("SELECT Name FROM Genre") rows = cur.fetchall() for i in rows: if new == i[0]: boolen = 1 cnt = cnt + 1 if boolen==1: hint[0] = "The specified Genre is already present in the DB." elif len(new) == 0: hint[0] = "A Genre name must be provided." boolen = 1 else: try: cur.execute("INSERT INTO Genre (GenreId,Name) VALUES (?,?);",(cnt+1,new)) conn.commit() hint[0] = 'Successfully added '+new+' to the DB.' except sqlite3.Error as er: hint[0] = "Unable to insert specified values into the database." boolen=1 return render_template('add_genre.html',messages = hint,error = boolen) if __name__ == "__main__": app.run(debug=True, port=5000)