from flask import Flask
from flask_sqlalchemy import SQLAlchemy
 
db = SQLAlchemy()
 
 
class Warehouse(db.Model):
    __tablename__ = 'warehouse'
    id = db.Column(db.Integer, primary_key=True, index=True)
    name = db.Column(db.String(80), unique=True, index=True)
 

 
class Packet(db.Model):
    __tablename__ = 'packet'
    id = db.Column(db.Integer, primary_key=True, index=True)
    sender = db.Column(db.String(80))
    recipient = db.Column(db.String(80))
    warehouse_id = db.Column(db.Integer, db.ForeignKey('warehouse.id'), unique=False, nullable=True)
    warehouse = db.relationship("Warehouse", backref="packets")
 

app = Flask(__name__)
 
# Le chemin vers la base SQLite est relatif au dossier de l'application flask
app.config["SQLALCHEMY_DATABASE_URI"] = "sqlite:///database.db"
 
# Initialiser l'application Flask par l'intermédiaire de l'extension
db.init_app(app)