def kino(): conn = connect_to_db('cinemas_db') cur = conn.cursor() if request.method == 'POST': if request.form['submit'] == 'cinema': name = request.form['name'] adres = request.form['address'] seats = request.form['seats'] sql_insert_into_kino = 'INSERT INTO Kino VALUES(default, %s, %s, %s)' cur.execute(sql_insert_into_kino, ( name, adres, seats, )) if request.form['submit'] == 'usun': name_cin = request.form['del_cinema'] sql_del_kino = 'DELETE FROM Kino WHERE id=%s;' cur.execute(sql_del_kino, (name_cin, )) if request.form['submit'] == 'znajdz': name_find = request.form['find_cinema'] sql_find_cinema = 'SELECT * FROM Kino Where name like "%{}%";'.format( name_find) cur.execute(sql_find_cinema) if request.form['submit'] == 'show': sql_find_cinema = 'SELECT * FROM Kino' cur.execute(sql_find_cinema) html = {} for row in cur: html[row[0]] = row[1] cur.close() conn.close() return render_template('kino.html', html=html, nawigation=nawigation)
def add_ticket(): conn = connect_to_db('cinemas_db') cur = conn.cursor() if request.method == 'POST': if request.form['submit'] == 'ticket': try: quantity = int(request.form['quantity']) price = float(request.form['price']) sql_insert_to_bilet = 'INSERT INTO Bilet VALUES(default, %s, %s)' cur.execute(sql_insert_to_bilet, ( quantity, price, )) except ValueError: pass if request.form['submit'] == 'show': sql_show_ticket = 'SELECT * FROM Bilet;' cur.execute(sql_show_ticket) if request.form['submit'] == 'usun': del_ticket = request.form['del_ticket'] sql_del_ticket = 'DELETE FROM Bilet WHERE id=%s;' cur.execute(sql_del_ticket, (del_ticket, )) html = [] for row in cur: linia = 'ID. {}. Ilość: {}, cena: {}'.format(row[0], row[1], row[2]) html.append(linia) cur.close() conn.close() return render_template('bilet.html', html=html, nawigation=nawigation)
def kino_site(id): select_id = id conn = connect_to_db('cinemas_db') cur = conn.cursor() sql_info_kino = 'SELECT Film.name as name FROM Seans JOIN Film ON Seans.movie_id=Film.id ' \ 'JOIN Kino ON Seans.cinema_id=Kino.id where Kino.id={}'.format(select_id) cur.execute(sql_info_kino) html = '' film = [] for row in cur: film_pom = '{}'.format(row[0]) film.append(film_pom) html = '{}'.format(film) cur.close() conn.close() return render_template('kino_site.html', html=html, nawigation=nawigation)
def film_site(id): select_id = id conn = connect_to_db('cinemas_db') cur = conn.cursor() sql_info_film = 'SELECT description, rating, Kino.name as kino from Seans JOIN Film ON Seans.movie_id=Film.id ' \ 'JOIN Kino ON Seans.cinema_id=Kino.id where Film.id = {}'.format(select_id) cur.execute(sql_info_film) html = '' kina = [] for row in cur: kina_pom = '{}'.format(row[2]) kina.append(kina_pom) html = '{} -- {}pkt. {}'.format(row[0], row[1], kina) cur.close() conn.close() return render_template('film_site.html', html=html, nawigation=nawigation)
def add_movie(): conn = connect_to_db('cinemas_db') cur = conn.cursor() if request.method == 'POST': if request.form['submit'] == 'movie': name = request.form['name'] desc = request.form['desc'] try: rating = int(request.form['rating']) if rating in range(1, 11): sql_insert_into_film = 'INSERT INTO Film VALUES(default, %s, %s, %s)' cur.execute(sql_insert_into_film, ( name, desc, rating, )) else: return render_template('error.html') except ValueError: pass if request.form['submit'] == 'show': sql_show_movie = 'SELECT *FROM Film;' cur.execute(sql_show_movie) if request.form['submit'] == 'znajdz': title_find = request.form['mov_find'] sql_find_movie_title = 'SELECT * FROM Film Where name LIKE "%{}%";'.format( title_find) cur.execute(sql_find_movie_title) if request.form['submit'] == 'rating_f': try: rat_find_min = int(request.form['rat_find']) rat_find_max = rat_find_min + 1 sql_find_movie_rating = 'SELECT *FROM Film Where rating>={} and rating<{};'.format( rat_find_min, rat_find_max) cur.execute(sql_find_movie_rating) except ValueError: pass if request.form['submit'] == 'usun': del_movie = request.form['del_movie'] sql_del_movie = 'DELETE FROM Film WHERE id = %s;' cur.execute(sql_del_movie, (del_movie, )) html = {} for row in cur: html[row[0]] = row[1] cur.close() conn.close() return render_template('film.html', html=html, nawigation=nawigation)
def seans(): conn = connect_to_db('cinemas_db') cur = conn.cursor() movies = {} cinemas = {} query = "SELECT id, name FROM Film" cur.execute(query) for row in cur: movies[row[0]] = row[1] query = "SELECT id, name FROM Kino" cur.execute(query) for row in cur: cinemas[row[0]] = row[1] if request.method == 'POST': if request.form['submit'] == 'send': movie_id = request.form.get('movie_id') cinema_id = request.form.get('cinema_id') sql_insert_seans = 'INSERT INTO Seans(movie_id,cinema_id) VALUES({},{})'.format( movie_id, cinema_id) cur.execute(sql_insert_seans) if request.form['submit'] == 'show': sql_show_seans = 'SELECT seans_id, Kino.name as kino, Film.name as film, description,' \ 'rating from Seans JOIN Kino ON Seans.cinema_id=Kino.id ' \ 'JOIN Film ON Seans.movie_id=Film.id' cur.execute(sql_show_seans) if request.form['submit'] == 'usun': del_seans = request.form['del_seans'] sql_del_seans = 'DELETE FROM Seans where seans_id = {}'.format( del_seans) cur.execute(sql_del_seans) html = [] for row in cur: linia = 'ID.{}. {}: {} ----- {} - [{}pkt.]'.format( row[0], row[1], row[2], row[3], row[4]) html.append(linia) cur.close() conn.close() return render_template('seans.html', movies=movies, cinemas=cinemas, nawigation=nawigation, html=html)
def add_payment(): conn = connect_to_db('cinemas_db') cur = conn.cursor() result = '' if request.method == 'POST': if request.form['submit'] == 'payment': option = request.form['payment_type'] if option == 'transfer': result = 'przelew' if option == 'cash': result = 'gotowka' if option == 'card': result = 'karta' dataa = request.form['payment_date'] matches = re.match(regex, dataa) if matches: sql_insert_into_platnosc = 'INSERT INTO Platnosc VALUE(default, %s, %s)' cur.execute(sql_insert_into_platnosc, (result, matches.group())) else: return render_template('error.html') if request.form['submit'] == 'show': sql_show_payment = 'SELECT * FROM Platnosc' cur.execute(sql_show_payment) if request.form['submit'] == 'show_option': option1 = request.form['variant'] data_find_1 = request.form['day_payment'] matches_find_1 = re.match(regex, data_find_1) if matches_find_1: if option1 == 'before': sql_find_payment = 'SELECT * FROM Platnosc WHERE data <= "{}"'.format( matches_find_1.group()) cur.execute(sql_find_payment) if option1 == 'after': sql_find_payment = 'SELECT * FROM Platnosc WHERE data >= "{}"'.format( matches_find_1.group()) cur.execute(sql_find_payment) if option1 == 'in_day': sql_find_payment = 'SELECT * FROM Platnosc WHERE data = "{}"'.format( matches_find_1.group()) cur.execute(sql_find_payment) else: return render_template('error.html') if request.form['submit'] == 'show_betw': data_find_2 = request.form['from_day'] data_find_3 = request.form['to_day'] matches_find_2 = re.match(regex, data_find_2) matches_find_3 = re.match(regex, data_find_3) if matches_find_2 and matches_find_3: sql_find_payment = 'SELECT * FROM Platnosc WHERE data BETWEEN "{}" AND "{}"'.\ format(matches_find_2.group(), matches_find_3.group()) cur.execute(sql_find_payment) else: return render_template('error.html') if request.form['submit'] == 'usun': del_payment = request.form['del_payment'] sql_del_payment = 'DELETE FROM Platnosc WHERE id = {}'.format( del_payment) cur.execute(sql_del_payment) html = [] for row in cur: linia = 'ID. {}. Typ płatności : {}, data płatności: {}'.format( row[0], row[1], row[2]) html.append(linia) cur.close() conn.close() return render_template('platnosc.html', html=html, nawigation=nawigation)