def updateCollege(): college = request.form id = college['id'] name = college['collegeName'] cur = mysql.get_db().cursor() cur.execute("UPDATE colleges SET name=%s WHERE CollegeID=%s",(name, id)) mysql.get_db().commit() return redirect('/read')
def createBook(): # Fetch form data book = request.form name = book['name'] genre = book['genre'] cur = mysql.get_db().cursor() cur.execute("INSERT INTO books(BookTitle, Genre) VALUES(%s, %s)", (name, genre)) mysql.get_db().commit() return redirect('/read')
def createCollege(): # Fetch form data college = request.form name = college['name'] students = college['students'] cur = mysql.get_db().cursor() cur.execute("INSERT INTO colleges(Name, Students) VALUES(%s, %s)", (name, students)) mysql.get_db().commit() return redirect('/read')
def updateAuthor(): author = request.form id = author['id'] fname = author['fname'] lname = author['lname'] country = author['country'] cur = mysql.get_db().cursor() cur.execute( "UPDATE authors SET FirstName=%s, LastName=%s, Country=%s WHERE AuthorID=%s", (fname, lname, country, id)) mysql.get_db().commit() return redirect('/authors')
def createAuthor(): # Fetch form data author = request.form fname = author['fname'] lname = author['lname'] country = author['country'] cur = mysql.get_db().cursor() cur.execute( "INSERT INTO authors(FirstName, LastName, Country) VALUES(%s, %s, %s)", (fname, lname, country)) mysql.get_db().commit() return redirect('/authors')
def updatePublisher(): publisher = request.form id = publisher['id'] pname = publisher['pname'] city = publisher['city'] region = publisher['region'] country = publisher['country'] cur = mysql.get_db().cursor() cur.execute( "UPDATE publishers SET PublisherName=%s, City=%s, Region=%s, Country=%s WHERE PublisherID=%s", (pname, city, region, country, id)) mysql.get_db().commit() return redirect('/publishers')
def createPublisher(): # Fetch form data publisher = request.form pname = publisher['pname'] city = publisher['city'] region = publisher['region'] country = publisher['country'] cur = mysql.get_db().cursor() cur.execute( "INSERT INTO publishers(PublisherName, City, Region, Country) VALUES(%s, %s, %s, %s)", (pname, city, region, country)) mysql.get_db().commit() return redirect('/publishers')
def updateBook(): book = request.form id = book['id'] title = book['title'] genre = book['genre'] pubyear = book['pubyear'] price = book['price'] royalty = book['royalty'] cur = mysql.get_db().cursor() cur.execute( "UPDATE books SET BookTitle=%s, Genre=%s, PublicationYear=%s, Price=%s, RoyaltyPayment=%s WHERE BookID=%s", (title, genre, pubyear, price, royalty, id)) mysql.get_db().commit() return redirect('/read')
def createBook(): # Fetch form data book = request.form title = book['title'] genre = book['genre'] pubyear = book['pubyear'] price = book['price'] royalty = book['royalty'] cur = mysql.get_db().cursor() cur.execute( "INSERT INTO books(BookTitle, Genre, PublicationYear, Price, RoyaltyPayment) VALUES(%s, %s, %s, %s, %s)", (title, genre, pubyear, price, royalty)) mysql.get_db().commit() return redirect('/read')
def default(): cursor = mysql.get_db().cursor() query = "SELECT BookID, BookTitle, Genre, PublicationYear, Price, RoyaltyPayment, concat(FirstName, ' ', LastName) as Author, PublisherName FROM Books b LEFT JOIN Authors a ON b.authorID = a.authorID LEFT JOIN Publishers p ON b.PublisherID = p.PublisherID" response = cursor.execute(query) if response > 0: books = cursor.fetchall() return render_template('read/index.html', list=books)
def publishers(): cursor = mysql.get_db().cursor() query = query = "SELECT * FROM Publishers" response = cursor.execute(query) if response > 0: publishers = cursor.fetchall() return render_template('read/publisher.html', list=publishers)
def authors(): cursor = mysql.get_db().cursor() query = query = "SELECT * FROM Authors" response = cursor.execute(query) if response > 0: authors = cursor.fetchall() return render_template('read/author.html', list=authors)
def create(): db = mysql.get_db() cursor = db.cursor() statement = f"INSERT INTO fletes(CITY,name,AGE) VALUES('{request.json['city']}','{request.json['name']}',{request.json['age']})" cursor.execute(statement) response = db.commit() print(cursor.lastrowid) return "añañay"
def default(): cursor = mysql.get_db().cursor() response = cursor.execute("SELECT * FROM books") if response > 0: books = cursor.fetchall() return render_template('index.html', list=books)
def default(): cursor = mysql.get_db().cursor() response = cursor.execute("SELECT * FROM fletes") if response > 0: colleges = cursor.fetchall() return render_template('index.html', list=colleges)
def delete_publisher(): id = request.args.get('id') cur = mysql.get_db().cursor() cur.execute("DELETE FROM publishers WHERE PublisherID=%s",id) mysql.get_db().commit() return redirect('/publishers')
def delete_author(): id = request.args.get('id') cur = mysql.get_db().cursor() cur.execute("DELETE FROM authors WHERE AuthorID=%s",id) mysql.get_db().commit() return redirect('/authors')
def default(): id = request.args.get('id') cur = mysql.get_db().cursor() cur.execute("DELETE FROM books WHERE BookID=%s",id) mysql.get_db().commit() return redirect('/read')