models.py

from flask_sqlalchemy import SQLAlchemy
 
db = SQLAlchemy()
 
class Benutzer(db.Model):
    
    __tablename__ = 'benutzer'
 
    customerid = db.Column(db.Integer, primary_key = True)
    vorname = db.Column(db.String())
    nachname = db.Column(db.Integer())
    email = db.Column(db.String(20))
 
    def __init__(self, vorname, nachname, email):
        self.vorname = vorname
        self.nachname = nachname
        self.email = email
 
    def __repr__(self):
        return f"{self.customerID}:{self.vorname}:{self.nachname}:{self.email}"