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')
