web_app/backend/app/models.py

#from flask_sqlalchemy import SQLAlchemy
#from app import app

#Connect to the database
#app.config["SQLALCHEMY_DATABASE_URI"] = ("postgresql://luminlab:Lumin#adapt2023@194.29.101.181:5433/luminlab_db")

#db = SQLAlchemy(app)

"""class User(db.Model):
    __tablename__ = 'user'
    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    first_name = db.Column(db.String(50), nullable=False)
    last_name = db.Column(db.String(50), nullable=False)
    phone_number = db.Column(db.String(20), nullable=True)
    email = db.Column(db.String(100), nullable=False)
    eircode = db.Column(db.String(10), nullable=True)
    square_meterage = db.Column(db.Integer, nullable=False)

    def __repr__(self):
        return f"User('{self.first_name}', '{self.last_name}', '{self.phone_number}', '{self.email}', '{self.eircode}', '{self.square_meterage}')"
    
    def __init__(self, first_name, last_name, phone_number, email, eircode, square_meterage):
        self.first_name = first_name
        self.last_name = last_name
        self.phone_number = phone_number
        self.email = email
        self.eircode = eircode
        self.square_meterage = square_meterage

# create an application context
with app.app_context():
    db.create_all()"""