import connection
conn = connection.db_connection()
cursor = conn.cursor()
sql_database = """ DROP DATABASE beers; """
sql_database1 = """ CREATE DATABASE beers; """
sql_database2 = """ USE beers; """
sql_code= """CREATE table code (
id INT PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(100) NOT NULL,
expiration_date DATETIME NOT NULL,
image VARCHAR(300) NOT NULL,
description TEXT NOT NULL,
value INT NOT NULL,
identifiant_QRCode VARCHAR(200) NOT NULL,
is_unique BOOLEAN NOT NULL,
category VARCHAR(300) NOT NULL);"""
sql_user = """ CREATE table `user` (
id INT PRIMARY KEY AUTO_INCREMENT,
pseudo VARCHAR(100) NOT NULL,
mail VARCHAR(300) NOT NULL,
password VARCHAR(100) NOT NULL,
telephone VARCHAR(15) NOT NULL,
genre VARCHAR(50) NOT NULL,
codeP VARCHAR(20) NOT NULL,
ville VARCHAR(100) NOT NULL,
adresse VARCHAR(100) NOT NULL,
complementAdresse VARCHAR(100),
import mariadb
from connection import db_connection
conn = db_connection()
cursor = conn.cursor()
sql_database = """ DROP DATABASE beers; """
sql_database1 = """ CREATE DATABASE beers; """
sql_database2 = """ USE beers; """
sql_query = """ CREATE table `beer` (
id INT PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(100) NOT NULL,
percentageAlcohol VARCHAR(5) NOT NULL,
category VARCHAR(100) NOT NULL);"""
sql_querybis = """ CREATE table `user` (
id INT PRIMARY KEY AUTO_INCREMENT,
pseudo VARCHAR(100) NOT NULL,
mail VARCHAR(300) NOT NULL,
password VARCHAR(100) NOT NULL);"""
sql_querybis_bis = """ CREATE table `beerlist` (
id INT PRIMARY KEY AUTO_INCREMENT,
user_id INT NOT NULL,
beer_id INT NOT NULL,
FOREIGN KEY (user_id) REFERENCES user(id),
FOREIGN KEY (beer_id) REFERENCES beer(id));"""
sql_beer = """ INSERT INTO beer (name,percentageAlcohol,category) VALUES